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 30th December 2006, 04:50
BCNW BCNW is offline
Junior Member
 
Join Date: Aug 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier And MySQL Login Problem

Hey there, thanks in advance for any help here. I have followed the guide for Postfix's virtual config exactly, but I am unable to login with any users. The mail.log output is as follows:

Dec 29 21:51:41 localhost imaplogin: Connection, ip=[::ffff:66.206.87.115]
Dec 29 21:51:50 localhost imaplogin: LOGIN FAILED, ip=[::ffff:66.206.87.115]

and netstat -tap:

tcp 0 0 localhost.localdo:60000 *:* LISTEN 875/postgrey.pid --
tcp 0 0 *:imaps *:* LISTEN 6701/couriertcpd
tcp 0 0 *op3s *:* LISTEN 5066/couriertcpd
tcp 0 0 localhost.localdo:10024 *:* LISTEN 9099/amavisd (maste
tcp 0 0 localhost.localdo:10025 *:* LISTEN 8950/master
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6552/mysqld
tcp 0 0 *op3 *:* LISTEN 8243/couriertcpd
tcp 0 0 *:imap2 *:* LISTEN 8226/couriertcpd
tcp 0 0 *:www *:* LISTEN 4937/apache
tcp 0 0 *:ftp *:* LISTEN 1245/proftpd: (acce
tcp 0 0 xen.belmontcompu:domain *:* LISTEN 860/named
tcp 0 0 localhost.locald:domain *:* LISTEN 860/named
tcp 0 0 *:ssh *:* LISTEN 1233/sshd
tcp 0 0 *:smtp *:* LISTEN 8950/master
tcp 0 0 localhost.localdoma:953 *:* LISTEN 860/named
tcp 0 0 xen.belmontcomput:49292 nas01.bridgeband.ne:www CLOSE_WAIT 925/freshclam
tcp 0 0 xen.belmontcomput:45873 soyuz.df.lth.se:www CLOSE_WAIT 925/freshclam
tcp 0 0 xen.belmontcomput:45438 nas01.bridgeband.ne:www CLOSE_WAIT 925/freshclam
tcp 0 0 localhost.localdo:mysql localhost.localdo:44169 ESTABLISHED6552/mysqld
tcp 0 0 xen.belmontcomput:42241 soyuz.df.lth.se:www CLOSE_WAIT 925/freshclam
tcp 0 0 localhost.localdo:52273 localhost.localdo:mysql ESTABLISHED9104/amavisd (child
tcp 0 0 localhost.localdo:44169 localhost.localdo:mysql ESTABLISHED9105/amavisd (child
tcp 0 0 xen.belmontcomput:51611 soyuz.df.lth.se:www CLOSE_WAIT 925/freshclam
tcp 0 0 xen.belmontcomput:35068 clamav-001.mirrors.:www CLOSE_WAIT 925/freshclam
tcp 0 0 localhost.localdo:mysql localhost.localdo:50917 ESTABLISHED6552/mysqld
tcp 0 2360 xen.belmontcomputer:ssh 66.206.87.115:40097 ESTABLISHED8252/sshd: domadmin
tcp 0 0 localhost.localdo:50917 localhost.localdo:mysql ESTABLISHED9106/amavisd (child
tcp 0 0 localhost.localdo:mysql localhost.localdo:50928 ESTABLISHED6552/mysqld
tcp 0 0 localhost.localdo:50928 localhost.localdo:mysql ESTABLISHED9107/amavisd (child
tcp 0 0 localhost.localdo:mysql localhost.localdo:52273 ESTABLISHED6552/mysqld
tcp 0 0 xen.belmontcomput:52612 soyuz.df.lth.se:www CLOSE_WAIT 925/freshclam

The "login failed" error is mighty unhelpful, any way to get more verbose output?
Reply With Quote
Sponsored Links
  #2  
Old 30th December 2006, 20:55
BCNW BCNW is offline
Junior Member
 
Join Date: Aug 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy

So after trolling the forum archives a bit, I discovered a few fixes that had been pointed out by Falko before that I had wrong, namely the "proxy:" prefix in the postfix main.cf file:
http://www.howtoforge.com/forums/sho...52&postcount=4
and also found a similar problem with someone else not using courier for the MTA:
http://www.howtoforge.com/forums/arc...hp/t-1643.html
The only problem (or rather, my CURRENT problem) is that I do have Courier installed, I see that when I try to apt-get the package, and I am not sure where I go to configure that (or even exactly what I would do to configure it).
Reply With Quote
  #3  
Old 31st December 2006, 20:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Did you send an email to that account before you tried to fetch emails? Because Maildir is created when the first email arrives in a new account.

Also, make sure that /etc/courier/authmysqlrc looks like the one from the tutorial. Take care about the formatting (whitespace, etc.) as Courier is very finicky about this.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 3rd January 2007, 23:41
BCNW BCNW is offline
Junior Member
 
Join Date: Aug 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmmm, is this message when opening /etc/courier/authmysqlrc something I should be seeing?:

Quote:
E325: ATTENTION
Found a swap file by the name "/etc/courier/.authmysqlrc.swp"
owned by: root dated: Wed Nov 22 17:11:07 2006
file name: /etc/courier/authmysqlrc
modified: YES
user name: root host name: belmontcomputersnw.com
process ID: 21962
While opening file "/etc/courier/authmysqlrc"
dated: Fri Dec 29 19:56:44 2006
NEWER than swap file!

(1) Another program may be editing the same file.
If this is the case, be careful not to end up with two
different instances of the same file when making changes.
Quit, or continue with caution.

(2) An edit session for this file crashed.
If this is the case, use ":recover" or "vim -r /etc/courier/authmysqlrc"
to recover the changes (see ":help recovery").
If you did this already, delete the swap file "/etc/courier/.authmysqlrc.swp"
to avoid this message.

Swap file "/etc/courier/.authmysqlrc.swp" already exists!
Reply With Quote
  #5  
Old 4th January 2007, 01:02
BCNW BCNW is offline
Junior Member
 
Join Date: Aug 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up

Well, once again I have to smack my forehead on this one. It is kinda amazing how sure I am that I did everything according to Falko at the beginning of travails like this, only to find out that, yep, I didn't COPY AND PASTE properly.

Ahhhh, to be a n00b.

I forgot the trailing " in the MYSQL_HOME_FIELD "/home/vmail" line. The one thing I would share with you all is that it was very helpful to me to change the verbosity of the /etc/courier/authdaemonrc file to DEBUG_LOGIN=2, which gave me enough info to find that everything was correct, but the mysql query for logging in was failing.
Reply With Quote
  #6  
Old 4th January 2007, 01:12
Kyse Kyse is offline
Junior Member
 
Join Date: Jan 2007
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Kyse
Default

Hold up, so just so I can check my settings to yours, what exactly did you forget to add to what file?
Reply With Quote
  #7  
Old 4th January 2007, 02:43
BCNW BCNW is offline
Junior Member
 
Join Date: Aug 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

The file is /etc/courier/authmysqlrc. The thing I missed was the second quotation mark (") in the line
Quote:
MYSQL_HOME_FIELD "/home/vmail"
Should be lin 111 or somewhere near there.

The verbosity thing I was talking about is done by adding the line
Quote:
DEBUG_LOGIN=2
anywhere in the /etc/courier/authdaemonrc file. This gives a much greater level of info to failed login errors in the /var/log/mail.log file. Remember to restart all the courier processes as described at the end of page 2 in the original howto when making any changes to these files.
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 And MySQL wmrwl HOWTO-Related Questions 73 7th October 2006 00:06
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 14:46
Autoreply problem using Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 1 19th May 2006 16:25
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 03:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 02:41


All times are GMT +2. The time now is 06:05.


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