[Tfug] Postfix - MySQL probllem

John E.Morrow johnslists at cox.net
Tue Jul 20 11:39:01 MST 2004


Greetings all,

I am having an issue implementing postfix virtual mail domains with a 
MySQL backend.
The database and config files seem to be okay. For instance, if I type

postmap -q joeblow at virtual.dom mysql:/etc/postfix/database.cf

it responds correctly with the location of the mail directory for 
joeblow.

Furthermore, if I send mail from a local user to joeblow at virtual.dom, 
it goes through just fine. Here's the problem:

If I send mail from the outside, it doesn't work. The mail server sees 
the message, tries to lookup the address in the database, but can't. I 
get some errors in syslog that look like this:

Jul 20 06:43:17 cleverMailMachineName postfix/smtpd[15561]: warning: 
connect to mysql server localhost: Can't connect to local MySQL server 
through socket '/var/run/mysqld/mysqld.sock' (2)
Jul 20 06:43:17 cleverMailMachineName postfix/smtpd[15561]: NOQUEUE: 
reject: RCPT from someguy at someplace: 451 <joeblow at virtual.dom>: 
Temporary lookup failure; from=<someguy at someplace> 
to=<joeblow at virtual.dom> proto=ESMTP helo=<someplace>

well, something like this.

I'm figuring there is a problem with the lookup, but I can't track it 
down. Anybody have any suggestions?

BTW - postifix version 2.1.3, mysql version 4.0.18, debian testing

Thanks,

John Morrow



More information about the tfug mailing list