Cyrus+SASL+PAM+pam_mysql Migration problem

[Simon Matter]

>>>> 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... ?

Hm, I may have been wrong... While it's okay to remove the auxprop lines
from the config, it has likely not been the cause for the logs. Your
config really uses pam_mysql, which then fails (I think to get rid of the
sql plugin errors in the log, you have to remove the plugins from your
system). I can not help you with the mysql stuff because I have never used
it.

Simon