pam_mysql and cyrus_sasl

[John Alton Tamplin]

Andreas Meyer wrote:

>eta saslauthd[982]: pam_mysql: where clause =
>eta saslauthd[982]: SELECT password FROM accountuser WHERE username='karl'
>eta saslauthd[982]: pam_mysql: select returned more than one result
>eta saslauthd[982]: returning 7 after db_checkpasswd.
>eta saslauthd[982]: AUTHFAIL: user=karl service=imap realm= [PAM auth error] 
>
It looks like you have multiple rows in your accountuser table that have 
username='karl' (you should probably have a unique index on it anyway), 
or else accountuser is a view that is matching more than one row.  The 
error message is telling you exactly what the problem is -- when it 
looks up the username in your mysql table, it is getting more than one 
row so it doesn't know what to use to validate the login.

-- 
John A. Tamplin                               Unix System Administrator
Emory University, School of Public Health     +1 404/727-9931