Stephen Liu writes:
--- Sam Varshavchik <[EMAIL PROTECTED]> wrote:Stephen Liu writes:> > --- Sam Varshavchik <[EMAIL PROTECTED]> wrote: > >> Stephen Liu writes: >> >> > Nov 18 14:14:44 xen05 authdaemond: supplied password does notmatch >> > encrypted password>> >> Password doesn't match. Specify the correct password.>> > Nov 18 14:17:35 xen05 authdaemond: zero rows returned >> > Nov 18 14:17:35 xen05 authdaemond: no password available to compare>> >> Invalid login ID. > > > Hi Sam, > > > Thanks for your advice. > > > I can't resolve why. The password and login ID were correct. > > > # grep MYSQL_CLEAR_PWFIELD /etc/courier/authmysqlrc> MYSQL_CLEAR_PWFIELD clear> > "clear" is selected. > > > # grep MYSQL_CRYPT_PWFIELD /etc/courier/authmysqlrc> #MYSQL_CRYPT_PWFIELD crypt> > "crypt" is commented out. > > > Why it uses encrypted password?Did you restart authdaemond, after changing the configuration file?Hi Sam, Sorry NO. I made some other changes on postfix and mysql config files. I rebooted the PC instead. Made following test; # /etc/init.d/courier-authdaemon restart Stopping Courier authentication services: authdaemond. Starting Courier authentication services: authdaemond. Start Evolution. Login to download mails. Fail # tail /var/log/mail.log Nov 20 01:51:28 xen05 imapd: LOGIN: ip=[::ffff:192.168.0.110], password=mypassword Nov 20 01:51:28 xen05 authdaemond: received auth request, service=imap, authtype=login Nov 20 01:51:28 xen05 authdaemond: authmysql: trying this module Nov 20 01:51:28 xen05 authdaemond: SQL query: SELECT id ##, "", clear, uid ##, gid ##, home ##, concat(home,'/',maildir), "", name ##, "" FROM users WHERE id ## = "[EMAIL PROTECTED]" AND (enabled=1) Nov 20 01:51:28 xen05 authdaemond: mysql_query failed, reconnecting: Unknown column 'id' in 'field list' Nov 20 01:51:28 xen05 authdaemond: mysql_query failed second time, giving up: Unknown column 'id' in 'field list'
Something wrong with your query. All those # characters do not belong in there. Check your configurationfile.
Nov 20 02:03:15 xen05 postfix/smtpd[3401]: warning: SASL authentication failure: Password verification failed Nov 20 02:03:15 xen05 postfix/smtpd[3401]: warning: xen0.satimis.com[192.168.0.110]: SASL PLAIN authentication failed: authentication failure Nov 20 02:03:21 xen05 postfix/smtpd[3401]: disconnect from xen0.satimis.com[192.168.0.110] * end * I don't have /etc/sasldb2 file. Nor I can find this file on the system.
Not Courier's problem. The above error message is from Postfix.
pgpavwFnswopV.pgp
Description: PGP signature
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ Courier-imap mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
