Cyrus+SASL+PAM+pam_mysql Migration problem

[Alexandru E. Ungur]

>>> sender: "Simon Matter" date: "Wed, Jun 28, 2006 at 07:59:12PM +0200" <<<EOQ
> Sorry, I can not help you at all with the mysql stuff because I have never
> used it with cyrus. However, you want to use pam_mysql but your
> cyrus-imapd tries to use the mysql auxprop plugin as you can see above. So
> you still have a bad imapd.conf file. Comment out all the auxprop line in
> imapd.conf, they are not used when using saslauthd -> PAM -> pam_mysql.
Oh, yes, indeed. I started it all over again, started from the old
config. Anyway, I cleaned it up once again, restarted cyrus, and run 
the command again.

Here is the imapd.conf:
configdirectory: /cyrus/imap
partition-default: /cyrus/spool
defaultacl: lrswipcd
admins: cyrus at domainZ=com cyrus at domainZ.com
allowanonymouslogin: no
timeout: 400
plaintextloginpause: 0
quotawarn: 90
autocreatequota: 50000
singleinstancestore: yes
drachost: localhost
dracinterval: 600
sasl_pwcheck_method: saslauthd
loginrealms: all
allowplaintext: yes
sasl_mech_list: PLAIN
sieveusehomedir: false
sievedir: /usr/local/sieve
sieve_maxscriptsize: 32
sieve_maxscripts: 5
partition-0: /cyrus/spool/0
partition-1: /cyrus/spool/1
...

And here the command and its results:
[root at mailtx1 etc]# cyradm -user cyrus -auth login localhost
IMAP Password:
              Login failed: authentication failure at
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Cyrus/IMAP/Admin.pm line 118
cyradm: cannot authenticate to server with login as cyrus

excerpt from logfile:
Jun 28 06:10:21 mailtx1 master[15176]: about to exec /usr/lib/cyrus-imapd/imapd
Jun 28 06:10:21 mailtx1 imap[15176]: executed
Jun 28 06:10:21 mailtx1 imap[15176]: sql_select option missing
Jun 28 06:10:21 mailtx1 imap[15176]: auxpropfunc error no mechanism available
Jun 28 06:10:21 mailtx1 imap[15176]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Jun 28 06:10:21 mailtx1 imap[15176]: accepted connection
Jun 28 06:10:25 mailtx1 imap[15176]: badlogin: localhost [127.0.0.1] plaintext cyrus SASL(-13): authentication failure: checkpass failed

So, I completely removed all auxprop lines and sasl_* lines, and still
no luck. Looks like is still looking for auxprofunc... ? 


Thank you once again for your help,
Alex