From: Magnus Bäck (magnusdsek.lth.se)
Date: Tue Dec 07 2004 - 16:25:31 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Tuesday, December 07, 2004 at 23:03 CET,
     Paul Burkett <paulsource.net> wrote:

> Hey guys/gals. I've been struggling to get my Postfix/Courier/Mysql
> server set up. I've been following Christoph Haas HOWTO
> (http://workaround.org/articles/ispmail-sarge/) word for word. I've
> tripled check all my config files and I'm still getting the following
> problem:
>
> orwell:/home/paul/public_html/discreaderror.org# tail -f /var/log/mail.err
> Dec 7 11:39:39 orwell postfix/trivial-rewrite[24425]: fatal:
> mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
> Dec 7 11:39:41 orwell postfix/trivial-rewrite[24426]: fatal:
> mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem

Surely this is not the only thing being logged? Look in mail.info.
Use postmap(1) to debug lookups before you put them into production.

> I can't figure out what I'm doing wrong, everything seems ok. Does
> anyone have any suggestions? I've read in past that since Postfix runs
> chroot(ed) so that you will need to comment out 'skip-networking' in
> Mysql's my.cnf file. I have done so with no luck. I've restarted
> postfix and mysql many of times with no luck.

I don't know MySQL, but if you are running Postfix chrooted you must
either make sure the connection are made via TCP or that MySQL has a
listening socket in the chroot jail.

[...]

--
Magnus Bäck
magnusdsek.lth.se

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]