mysql plugin "couldnt connect to any host"

[twebster at daksoft.com]

I am trying to get cyrus-imapd-2.1.14 to work with cyrus-sasl-2.1.12,
RedHat 9, and MySQL mysql-3.23.56.

My goal is to get mysql plugin authentication working with the MD5 patch.
Currently, I am just trying to get the
mysql authentication working without MD5 patch, after clear text works, I
will try MD5 patch.

When I execute "imtest -v -m login -p imap hostname" and try to login I get
the following error:
      "imapd[22356]: mysql plugin couldnt connect to any host"

I have tried changing "mysql_hostnames" to, localhost, 127.0.0.1, system IP
address. (doesn't make any difference)
I can login to the database, using the mysql client with the same username.
(database is setup up correctly)

Why won't the plugin correctly connect to the database?


My imapd.conf file is:

configdirectory: /var/lib/imap
partition-default: /var/spool/imap
admins: cyrus
sievedir: /var/lib/imap/sieve
sendmail: /usr/sbin/sendmail
hashimapspool: true
pwcheck_method: auxprop
auxprop_plugin: mysql
mysql_user: username
mysql_passwd: password
mysql_hostnames: localhost
mysql_database: horde
mysql_statement: select password from accounts where username = '%u'
mysql_verbose: true
tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem
tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem


I configured cyrus-sasl with the following

./configure   --prefix=/usr   --disable-cmulocal   --enable-sample   \
--enable-static=no   --enable-shared=yes   --enable-fast-install=yes  \
--without-gnu-ld   --disable-libtool-lock   --enable-staticdlopen=no  \
--without-purecov   --without-purify   --enable-java=no
--with-javabase=no  \
--with-dbpath=/etc/sasldb2   --with-dblib=berkeley   --with-gdbm=no
--with-pam=no  \
--with-saslauthd=no   --with-pwcheck=no   --with-ipctype=unix
--disable-alwaystrue  \
--disable-checkapop   --disable-cram   --with-des=yes   --disable-digest  \
--with-openssl   --disable-otp   --with-opie=no   --disable-srp
--disable-srp-setpass \
--disable-krb4   --disable-gssapi   --enable-plain   --disable-anon
--disable-login  \
--disable-ntlm   --with-ldap=no   --with-mysql   --with-rc4
--without-dmalloc   --without-sfio


Thanks,
tony