View Single Post
  #1  
Old 18th May 2012, 17:31
mlentink mlentink is offline
Junior Member
 
Join Date: Dec 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 12.04

I have followed the howto to the letter (now for the third time), using cut and paste weherever possible, on a freshly installed Ubuntu 12.04 server with only OpenSSH installed, nothing else.
For the third time, about a day-and-a-half after installation and working without problems, e-mailclients can no longer login to courier. Evolution tells me the server has apparently gone gone off-line and Thunderbird uses a similar phrase.
I have looked at the logs, but can see nothing special, only the client trying to login, with nothing else:
May 18 16:59:07 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.101]
May 18 16:59:55 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 17:00:11 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 17:04:14 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]

I can see in the log that Postfix handles incoming mail as it should, pipes it through amavis and passes it on to the maildirs in the home folder of vmail, but the mailclients just can't get to it through some authentication issue.
What should I do to get my mail back up again?

I have increased the loggin level a bit and this is what the courier auth daemon tells me:

May 18 18:23:21 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 18:23:21 saiph authdaemond: received auth request, service=imap, authtype=login
May 18 18:23:21 saiph authdaemond: authmysql: trying this module
May 18 18:23:21 saiph authdaemond: authmysqllib: connected. Versions: header 50517, client 50522, server 50522
May 18 18:23:21 saiph authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM users WHERE email = 'martin@example.tld'
May 18 18:23:21 saiph authdaemond: password matches successfully
May 18 18:23:21 saiph authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:21 saiph authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:29 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 18:23:30 saiph authdaemond: received auth request, service=imap, authtype=login
May 18 18:23:30 saiph authdaemond: authmysql: trying this module
May 18 18:23:30 saiph authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM users WHERE email = 'martin@example.tld'
May 18 18:23:30 saiph authdaemond: password matches successfully
May 18 18:23:30 saiph authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:30 saiph authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:36 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 18:23:36 saiph authdaemond: received auth request, service=imap, authtype=login
May 18 18:23:36 saiph authdaemond: authmysql: trying this module
May 18 18:23:36 saiph authdaemond: authmysqllib: connected. Versions: header 50517, client 50522, server 50522
May 18 18:23:36 saiph authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM users WHERE email = 'martin@example.tld'
May 18 18:23:36 saiph authdaemond: password matches successfully
May 18 18:23:36 saiph authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:36 saiph authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:45 saiph imapd: Connection, ip=[::ffff:xxx.xxx.xxx.106]
May 18 18:23:45 saiph authdaemond: received auth request, service=imap, authtype=login
May 18 18:23:45 saiph authdaemond: authmysql: trying this module
May 18 18:23:45 saiph authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/vmail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM users WHERE email = 'martin@example.tld'
May 18 18:23:45 saiph authdaemond: password matches successfully
May 18 18:23:45 saiph authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>
May 18 18:23:45 saiph authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=martin@example.tld, fullname=<null>, maildir=example.tld/martin/, quota=1048576000, options=<null>

So even though it authenticates succesfully, I still get the message that it's not connected.

Can anybody point me in the right direction? Please keep in mind that this behavior started suddenly almost two days of flawless operation

thx,
Martin

Last edited by mlentink; 18th May 2012 at 18:34.
Reply With Quote
Sponsored Links