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 3rd June 2009, 23:27
DannyB DannyB is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04)

Hi all,

Hopefully this is me missing something simple but I've been looking for ages and can't find the problem...

Installed a new Ubuntu server following the guides on here, then ran through the install for virtual users+ domains + postfix + courier + mysql + squirrelmail.

No errors encountered on installation, however on testing I cannot send any of the users a mail, if I attempt by telnetting to localhost:25 it accepts the ehlo, then after I have typed the MAIL FROM: command I can type anything I like and although it appears on the screen it's not responding to commands.

I've looked at the mail.log on the ubuntu box and as soon as I've entered the MAIL FROM: Command it get's the following entries.


Jun 3 21:44:46 ernie postfix/smtpd[5356]: connect from localhost[127.0.0.1]
Jun 3 21:45:03 ernie postfix/proxymap[5357]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: NO)
Jun 3 21:45:03 ernie postfix/trivial-rewrite[5359]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 3 21:45:04 ernie postfix/master[5045]: warning: process /usr/lib/postfix/trivial-rewrite pid 5359 exit status 1
Jun 3 21:45:05 ernie postfix/trivial-rewrite[5361]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 3 21:45:06 ernie postfix/smtpd[5356]: warning: problem talking to service rewrite: Success
Jun 3 21:45:06 ernie postfix/master[5045]: warning: process /usr/lib/postfix/trivial-rewrite pid 5361 exit status 1
Jun 3 21:45:06 ernie postfix/master[5045]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling

I suspect the Using Password: NO is a pointer to the error but I can't see where to set it, I have (I think) double checked all the config files for mistypes on passwords etc but have either missed it or it's not there!

I've created a maildir for a user using makemaildir and squirrelmail can connect okay, so I guess the mysql is working okay. However I can't talk SMTP to the machine at all.

Spent the last couple of days tearing my hair out on this one so any pointers to assist would be greatly appreciated!

Many thanks,

Danny

Last edited by DannyB; 3rd June 2009 at 23:36.
Reply With Quote
Sponsored Links
  #2  
Old 4th June 2009, 17:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by DannyB View Post
Jun 3 21:45:03 ernie postfix/proxymap[5357]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: NO)
There is a problem with the MySQL password for the user mail_admin.
Can you connect (using the same password) on the command line?
Code:
mysql -u mail_admin -p
__________________
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
  #3  
Old 4th June 2009, 17:58
DannyB DannyB is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
There is a problem with the MySQL password for the user mail_admin.
Can you connect (using the same password) on the command line?
Code:
mysql -u mail_admin -p
Not tried from command line but can connect using the mail_admin account and password from myphpadmin. It looks to me like it's not trying to use the password rather than refusing it? Could be wrong however I'm fairly new to this!

Edit: Just tried from the command line and it connects fine.

Danny
Reply With Quote
  #4  
Old 5th June 2009, 13:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Does the MySQL password contain any special characters?
__________________
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
  #5  
Old 5th June 2009, 13:59
DannyB DannyB is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko View Post
Does the MySQL password contain any special characters?
Nope, just plain alpha characters.

However have now rebuilt from scratch and all is working, so I guess I mucked something up in the initial build, not sure what however.

Many thanks for the assistance.
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 (Debian Lenny warpengi HOWTO-Related Questions 2 26th May 2009 00:49
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.10) mathie HOWTO-Related Questions 3 14th December 2008 15:02
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail garther HOWTO-Related Questions 54 5th September 2008 12:38
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 mtzcesar HOWTO-Related Questions 3 1st June 2008 10:57
Virtual Users And Domains With Postfix, Courier And MySQL [+ procmail ?] immobilia HOWTO-Related Questions 5 29th June 2006 23:20


All times are GMT +2. The time now is 03:43.


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