I've been in the process of moving my pop3 proxy over to the dovecot proxy. I have a ton of users using pop3 still, and am seeing these errors popup within a minute or so of the connection to the database:<br><br>Password query failed: Not connected to database
<br><br>Eventually the auth-worker will reconnect to the database and things will go on normal for another minute or two, then the same issue occurs. I'm runing MySQL 5.0.22 on FreeBSD 6.1. I upgraded to 5.0.27, however I started getting the: "Password query failed: Commands out of sync; you can't run this command now" error instead. So I downgraded until I could figure out this issue first.
<br><br>I've tried connecting to localhost, /tmp/mysql.sock, and a remote server and all exhibit the same problem. The MySQL idle timeouts shouldnt come into play because I'm constantly having users check their accounts.
<br><br>Any insights will be useful,<br><br>Thanks!<br><br>Cassidy<br><br><br>### Part of my dovecot.conf that might be useful:<br> login_process_per_connection = yes<br> login_processes_count = 3<br> login_max_processes_count = 512
<br> <br> auth_verbose = yes<br> auth_debug = yes<br> auth_debug_passwords =yes<br> auth_worker_max_count = 400<br><br> auth <a href="http://mail.infowest.com">mail.infowest.com</a> { <br> mechanisms = plain<br>
<br> passdb sql {<br> args = /usr/local/etc/dovecot-sql.conf<br> }<br> userdb static {<br> args = uid=5000 gid=5000 home=/dev/null<br> }<br> user = root<br> # Number of authentication processes to create
<br> count = 10<br><br><br>## dovecot-sql.conf<br>driver = mysql<br>connect = host=/tmp/mysql.sock dbname=iwmailsystem user=imap_proxy password=***** client_flags=65536<br>default_pass_scheme = MD5<br>password_query = CALL pop_auth('%u','%l','%r')
<br><br>