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