[Web-cyradm] Pam-mysql authentication problem

[Michael Hsu]

Try to run that select statement directly in mysql to see what's going
on,  your logs are saying that it returns more than one result therefore
it can't check the password against the username.

On Mon, 2004-04-12 at 03:49, prem kannan wrote:
> Hai all,
>         i am n newbie to web-cyradm.i configured
> postfix,openssl,cyrus SASL,cyrus imap as per Luc Howto
> document.when i try to login imap server i got
> following error message.please help me to solve this
> problem.
> 
> log messages
> 
> Apr 12 16:41:17 dns2 saslauthd[22123]:
> pam_sm_authenticate called.
> Apr 12 16:41:17 dns2 saslauthd[22123]: dbuser changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: dbpasswd
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: host changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: database
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: table changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: usercolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: passwdcolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: crypt changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: logtable
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: logmsgcolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: logusercolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: loghostcolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: logtimecolumn
> changed.
> Apr 12 16:41:17 dns2 saslauthd[22123]: db_connect 
> called.
> Apr 12 16:41:17 dns2 saslauthd[22123]: returning 0 .
> Apr 12 16:41:17 dns2 saslauthd[22123]: db_checkpasswd
> called.
> Apr 12 16:41:17 dns2 saslauthd[22123]: SELECT password
> FROM accountuser WHERE
> username='deviinfosys0001 at 100.222'
> Apr 12 16:41:17 dns2 saslauthd[22123]: pam_mysql:
> select returned more than one result
> Apr 12 16:41:17 dns2 saslauthd[22123]: returning 7
> after db_checkpasswd.
> Apr 12 16:41:17 dns2 imap(pam_unix)[22123]: check
> pass; user unknown
> Apr 12 16:41:17 dns2 imap(pam_unix)[22123]:
> authentication failure; logname=
> uid=0 euid=0 tty= ruser= rhost=
> Apr 12 16:41:19 dns2 saslauthd[22123]: do_auth        
> : auth failure: [user=deviinfosys0001 at 100.222]
> [service=imap] [realm=] [mech=pam] [reason=PAM auth
> error]
> Apr 12 16:41:19 dns2 imaplocal[22532]: badlogin:
> localhost.localdomain [127.0.0.1] plaintext
> deviinfosys0001 at 100.222 SASL(-13): authentication
> failure: checkpass failed
>  
> Thanks & Regards
> 
> Premkannan.v
> 
> 
> 
>  
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online by April 15th
> http://taxes.yahoo.com/filing.html
> _______________________________________________
> This mailing list is hosted and supported
> by bit-heads GmbH | http://www.bit-heads.ch
> 
> _______________________________________________
> Web-cyradm mailing list
> Web-cyradm at web-cyradm.org
> http://www.web-cyradm.org/mailman/listinfo/web-cyradm