Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th May 2012, 18: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 19:34.
Reply With Quote
Sponsored Links
  #2  
Old 19th May 2012, 10:29
mlentink mlentink is offline
Junior Member
 
Join Date: Dec 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I must confess I don't have a clue on what exactly I was doing, but in my desperation I followed the advice in this thread on the Ubuntu forums, which brought my server back up again.

I'll monitor the situation and report back if I get any more issues.

Thx for now,

Martin
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail-Problema jz_ HOWTO-Related Questions 9 14th September 2011 14:31
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.10) superman HOWTO-Related Questions 3 23rd July 2010 14:33
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.10) keyslapper HOWTO-Related Questions 4 20th April 2010 16:46
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.04) Master One HOWTO-Related Questions 4 1st July 2009 16:38
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.10) VTCop HOWTO-Related Questions 9 9th April 2009 17:17


All times are GMT +2. The time now is 17:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.