--- Sam Varshavchik <[EMAIL PROTECTED]> wrote: - snip -
> > 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. Rechecked /etc/courier/authmysqlrc clearing all extra # left behind. # /etc/init.d/courier-authdaemon restart Stopping Courier authentication services: authdaemond. Starting Courier authentication services: authdaemond. Started Evolution. Login to download mails; # tail /var/log/mail.log Nov 20 03:40:38 xen05 imapd: LOGIN: ip=[::ffff:192.168.0.110], command=CAPABILITY Nov 20 03:40:38 xen05 imapd: LOGIN: ip=[::ffff:192.168.0.110], command=LOGIN Nov 20 03:40:38 xen05 imapd: LOGIN: ip=[::ffff:192.168.0.110], [EMAIL PROTECTED] Nov 20 03:40:38 xen05 imapd: LOGIN: ip=[::ffff:192.168.0.110], password=mypassword Nov 20 03:40:38 xen05 authdaemond: received auth request, service=imap, authtype=login Nov 20 03:40:38 xen05 authdaemond: authmysql: trying this module Nov 20 03:40:38 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 03:40:38 xen05 authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, [EMAIL PROTECTED], fullname=Stephen, maildir=/var/spool/mail/virtual/Stephen/, quota=<null>, options=<null> Nov 20 03:40:38 xen05 authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, [EMAIL PROTECTED], fullname=Stephen, maildir=/var/spool/mail/virtual/Stephen/, quota=<null>, options=<null> Nov 20 03:40:38 xen05 imapd: LOGIN, [EMAIL PROTECTED], ip=[::ffff:192.168.0.110], protocol=IMAP This time no warning indicated. I suppose login successful downloading all mails. # ls /var/spool/mail/virtual/Stephen/new/ No printout Before login to download mail # ls /var/spool/mail/virtual/Stephen/new/ 1226896072.V301I7c0f8M999642.xen05.satimis.com:2, 1227145535.V301I7c115M798347.xen05.satimis.com:2, There were mails there. But I can't find the mails on Evolution inbox. On Evolution [tick] check for new messages in all folders Others noted with thanks B.R. Stephen L 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
