Cyrus+SASL+PAM+pam_mysql Migration problem

[Simon Matter]

>>>> sender: "Simon Matter" date: "Wed, Jun 28, 2006 at 07:13:40PM +0200"
>>>> <<<EOQ
>> Make that 'cyradm -user cyrus -auth login localhost'
>
> Thank you! :)
> I did that, here's what happened:
>
> ==== FIRST, I used the old pam_mysql 0.4.5 that was on the old server,
> though it might make a difference. It didn't.
> =============================
> [root at mailtx1 etc]# cyradm -user cyrus -auth login localhost
> IMAP Password:
>               Login failed: generic 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
>
> [root at mailtx1 etc]# tail /var/log/debug
> Jun 28 05:30:56 mailtx1 master[14836]: about to exec
> /usr/lib/cyrus-imapd/imapd
> Jun 28 05:30:56 mailtx1 imap[14836]: executed
> Jun 28 05:30:56 mailtx1 imap[14836]: sql_select option missing
> Jun 28 05:30:56 mailtx1 imap[14836]: auxpropfunc error no mechanism
> available
> Jun 28 05:30:56 mailtx1 imap[14836]: _sasl_plugin_load failed on
> sasl_auxprop_plug_init for plugin: sql

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.

Simon