dovecot - Jan 2007 - "Not connected to database" MySQL errors

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:

Password query failed: Not connected to database

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.

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.

Any insights will be useful,

Thanks!

Cassidy


### Part of my dovecot.conf that might be useful:
  login_process_per_connection = yes
  login_processes_count = 3
  login_max_processes_count = 512

  auth_verbose = yes
  auth_debug = yes
  auth_debug_passwords =yes
  auth_worker_max_count = 400

  auth mail.infowest.com {
    mechanisms = plain

    passdb sql {
      args = /usr/local/etc/dovecot-sql.conf
    }
    userdb static {
      args = uid=5000 gid=5000 home=/dev/null
    }
    user = root
    # Number of authentication processes to create
    count = 10


## dovecot-sql.conf
driver = mysql
connect = host=/tmp/mysql.sock dbname=iwmailsystem user=imap_proxy
password=***** client_flags=65536
default_pass_scheme = MD5
password_query = CALL pop_auth('%u','%l','%r')
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070102/d3c01948/attachment-0002.html>

On 3.1.2007, at 0.28, Cassidy B. Larson wrote:
> 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:
>
> Password query failed: Not connected to database
You could try if the attached patch logs something more useful. I  
doubt it though. I don't really see how to debug this any better  
without looking into what the MySQL library does internally. You  
could see what ktrace shows though. Does the MySQL library close()  
the connection, or does it receive some "connection closed" error?
> 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.
..
> password_query = CALL pop_auth('%u','%l','%r')
Could it be that MySQL just doesn't like having CALL used as a  
replacement for SELECT, and while newer versions directly say that,  
the older versions just go and do random disconnects or whatever?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-debug.diff
Type: application/octet-stream
Size: 564 bytes
Desc: not available
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070103/f4d5c9d0/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070103/f4d5c9d0/attachment.bin>