Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04)
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: connect from localhost[127.0.0.1]
Jun 3 21:45:03 ernie postfix/proxymap: 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: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 3 21:45:04 ernie postfix/master: warning: process /usr/lib/postfix/trivial-rewrite pid 5359 exit status 1
Jun 3 21:45:05 ernie postfix/trivial-rewrite: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 3 21:45:06 ernie postfix/smtpd: warning: problem talking to service rewrite: Success
Jun 3 21:45:06 ernie postfix/master: warning: process /usr/lib/postfix/trivial-rewrite pid 5361 exit status 1
Jun 3 21:45:06 ernie postfix/master: 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!
Last edited by DannyB; 4th June 2009 at 00:36.