--- 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 not > match > >> > 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' Nov 20 01:51:28 xen05 authdaemond: authmysql: TEMPFAIL - no more modules will be tried Nov 20 01:51:28 xen05 imapd: LOGIN FAILED, [EMAIL PROTECTED], ip=[::ffff:192.168.0.110] Nov 20 01:51:28 xen05 imapd: authentication error: Input/output error Nov 20 01:51:31 xen05 postfix/smtpd[3302]: disconnect from xen0.satimis.com[192.168.0.110] * end * The password and login are correct. Before test I specifically created "[EMAIL PROTECTED]" as system user. But it can't solve the problem. Send mail on Evolutions. Fail. # tail /var/log/mail.log Nov 20 01:58:21 xen05 postfix/anvil[3306]: statistics: max connection count 1 for (smtp:8.7.218.94) at Nov 20 01:54:24 Nov 20 01:58:21 xen05 postfix/anvil[3306]: statistics: max cache size 1 at Nov 20 01:54:24 Nov 20 02:02:17 xen05 postfix/postfix-script: refreshing the Postfix mail system Nov 20 02:02:17 xen05 postfix/master[2925]: reload configuration /etc/postfix Nov 20 02:03:03 xen05 postfix/smtpd[3401]: connect from xen0.satimis.com[192.168.0.110] Nov 20 02:03:15 xen05 postfix/smtpd[3401]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory Nov 20 02:03:15 xen05 postfix/smtpd[3401]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: No such file or directory 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. I found follows; # locate sasldb /usr/lib/sasl2/libsasldb.a /usr/lib/sasl2/libsasldb.la /usr/lib/sasl2/libsasldb.so /usr/lib/sasl2/libsasldb.so.2 /usr/lib/sasl2/libsasldb.so.2.0.22 # ls -ld /usr/lib/sasl2/libsasldb.so lrwxrwxrwx 1 root root 19 2008-11-07 10:03 /usr/lib/sasl2/libsasldb.so -> libsasldb.so.2.0.22 # ls -ld /usr/lib/sasl2/libsasldb.so.2 lrwxrwxrwx 1 root root 19 2008-11-07 10:03 /usr/lib/sasl2/libsasldb.so.2 -> libsasldb.so.2.0.22 Can I use libsasldb.so/libsasldb.so.2 either of them instead by creating /etc/sasldb2 linked symbolically to either? TIA B.R. Stephen Send instant messages to your online friends http://uk.messenger.yahoo.com ------------------------------------------------------------------------- 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
