Cyrus is unable to access mysql

[Jean-Gabriel Duquesnoy]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Hi, I have setup my system with Cyrus IMAP and MySQL, but when trying
to test using imtest, I always get an error:
Jul 14 23:03:44 mail master[13859]: about to exec
/usr/lib/cyrus/bin/imapd
Jul 14 23:03:44 mail imap[13859]: executed
Jul 14 23:03:44 mail imap[13859]: sql_select option missing
Jul 14 23:03:44 mail imap[13859]: auxpropfunc error no mechanism
available
Jul 14 23:03:44 mail imap[13859]: _sasl_plugin_load failed on
sasl_auxprop_plug_init for plugin: sql
Jul 14 23:03:45 mail imap[13859]: accepted connection
Jul 14 23:04:05 mail imap[13859]: could not find auxprop plugin, was
searching for '[all]'
Jul 14 23:04:05 mail imap[13859]: could not find auxprop plugin, was
searching for '[all]'
Jul 14 23:04:05 mail saslauthd[4100]: PAM unable to
dlopen(/lib/security/pam_mysql.so)
Jul 14 23:04:05 mail saslauthd[4100]: PAM [error:
/lib/security/pam_mysql.so: cannot open shared object file: No such
file or directory]
Jul 14 23:04:05 mail saslauthd[4100]: PAM adding faulty module:
/lib/security/pam_mysql.so
Jul 14 23:04:06 mail saslauthd[4100]: pam_unix_auth(imap:auth):
authentication failure; logname= uid=0 euid=0 tty= ruser= rhost=
user=username
Jul 14 23:04:08 mail saslauthd[4100]: DEBUG: auth_pam:
pam_authenticate failed: Permission denied
Jul 14 23:04:08 mail saslauthd[4100]: do_auth : auth failure:
[user=username] [service=imap] [realm=] [mech=pam] [reason=PAM auth
error]
Jul 14 23:04:08 mail imap[13859]: badlogin: mail.mydomain.com
[192.168.0.5] plaintext username SASL(-13): authentication failure:
checkpass failed

I have checked everything and cannot find any explanation for this.
web-cyradm is working perfectly and able to access the MySQL database
without any problems. Am I missing anything in my settings. My
imapd.conf looks like:
postmaster: postmaster
configdirectory: /var/lib/imap
partition-default: /var/spool/imap
sievedir: /var/lib/sieve
admins: cyrus
allowanonymouslogin: no
allowplaintext: yes
sasl_mech_list: PLAIN
servername: mail.mydomain.com
autocreatequota: 10000
reject8bit: no
quotawarn: 90
timeout: 30
poptimeout: 10
dracinterval: 0
drachost: 192.168.0.5
sasl_pwcheck_method: saslauthd
#sasl_pwcheck_method: auxprop
lmtp_overquota_perm_failure: no
lmtp_downcase_rcpt: yes
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
autocreateinboxfolders: INBOX | INBOX.Trash | INBOX.Sent | INBOX.Drafts
autosubscribeinboxfolders: INBOX | INBOX.Trash | INBOX.Sent |
INBOX.Drafts
Any idea what is wrong with my settings? I am using:
pam_mysql-0.7RC1
mysql Ver 14.12 Distrib 5.0.18, for suse-linux (i686) using readline 5.1
Cyrus IMAP4 v2.2.12
saslauthd 2.1.21 authentication mechanisms: getpwent kerberos5 pam
rimap shadow ldap

Perhaps incompatibilities between the components integrated.
Any help would be appreciated.
Best regards,
- -- Jean-Gabriel Duquesnoy


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFEuMY714OHHFMk4pwRAtNOAKCTPdRhVhig/1PwFHL96plvc+YGrQCfZeWe
IGTPUqw0iF4OuoB719wK9gI=
=qKmj
-----END PGP SIGNATURE-----