Problem with pam_mysql, saslauthd and ONLY imap

[Dan White]

Egoitz Aurrekoetxea wrote:
> Hi mates!!
>
> Well some days and hours now testing cyrus... lol; well the problem is 
> that I have decided to try auth throgh pam_mysql with saslauthd... it 
> works for postfix smtp auth and for pop3. When you do a testsaslauthd 
> or try to login via IMAP it does't work... it sais :
>
> In auth.log :
> Sep 15 02:27:45 correopiloto imap[1741]: sql_select option missing
> Sep 15 02:27:45 correopiloto imap[1741]: auxpropfunc error no 
> mechanism available
> Sep 15 02:27:45 correopiloto saslauthd[1216]: do_auth         : auth 
> failure: [user=egoitz at ramattack.net <mailto:egoitz at ramattack.net>] 
> [service=imap] [realm=ramattack.net <http://ramattack.net>] [mech=pam] 
> [reason=PAM auth error]
>
> If in the file I set pwcheck to auxprop and uncomment the end sasl_sql 
> lines it works nice!! but if I try to use saslauthd doesn't work and 
> can't loging too through cyradm... Any help is apreciated please....
>
> #sasl_maximum_layer: 256
> #sasl_minimum_layer: 0
> sasl_pwcheck_method: saslauthd
> #sasl_auto_transition: no
> sasl_mech_list: plain
> #sasl_opiekeys: /etc/opiekeys
> virtdomains: on
> defaultdomain: correopiloto.ramattack.net 
> <http://correopiloto.ramattack.net>
>
> # sasl_auxprop_plugin: sql
> # sasl_sql_engine: mysql
> # sasl_sql_user: imapuser
> # sasl_sql_passwd: niu69lqh
> # sasl_sql_hostnames: 127.0.0.1 <http://127.0.0.1>
> # sasl_sql_database: mail
> # sasl_sql_select: select clave from usuarios where email = '%u@%r' 
> and activo=1
> #sasl_sql_verbose: true
>
> I'm running FreeBSD and all is installed though FreeBSD ports...
>
> Thank you very much people :)


Egoitz,

Can you post your Postfix sasl config for comparison (smtpd.conf).

To rule out a client side inconsistency, you can use pop3test, imtest 
and smtptest to test with.

- Dan