- Thread Starter
- #26
Abriel said:It looks, like you have something missconfigured. I don't have postfix with mysql. I think you should first try setup postfx without mysql, and after everything will be alright add configuration to mysql.
And here is setup for mysql http://www.purplehat.org/?page_id=11
I think your right. I just restarted my computer/server and now see errors in my mailog log.
it shows this:
Code:
Oct 12 00:00:00 hostname newsyslog[72979]: logfile turned over
Oct 12 00:00:04 hostname postfix/proxymap[70318]: warning: mysql query failed: Table 'Mail.domain' doesn't exist
Oct 12 00:00:04 hostname postfix/trivial-rewrite[72996]: fatal: proxy:mysql:/usr/local/etc/postfix/mysql_relay_domains_maps.cf(0,lock|fold_fix): table lookup problem
Oct 12 00:00:05 hostname postfix/qmgr[72218]: warning: problem talking to service rewrite: Unknown error: 0
Oct 12 00:00:05 hostname postfix/master[1123]: warning: process /usr/local/libexec/postfix/trivial-rewrite pid 72996 exit status 1
Oct 12 00:00:05 hostname postfix/master[1123]: warning: /usr/local/libexec/postfix/trivial-rewrite: bad command startup -- throttling
Oct 12 00:01:05 hostname postfix/proxymap[70318]: warning: mysql query failed: Table 'Mail.domain' doesn't exist
Oct 12 00:01:05 hostname postfix/trivial-rewrite[73050]: fatal: proxy:mysql:/usr/local/etc/postfix/mysql_relay_domains_maps.cf(0,lock|fold_fix): table lookup problem
Oct 12 00:01:06 hostname postfix/qmgr[72218]: warning: problem talking to service rewrite: Unknown error: 0
Oct 12 00:01:06 hostname postfix/master[1123]: warning: process /usr/local/libexec/postfix/trivial-rewrite pid 73050 exit status 1
Oct 12 00:01:06 hostname postfix/master[1123]: warning: /usr/local/libexec/postfix/trivial-rewrite: bad command startup -- throttling
Oct 12 00:02:06 hostname postfix/proxymap[70318]: warning: mysql query failed: Table 'Mail.domain' doesn't exist
Oct 12 00:02:06 hostname postfix/trivial-rewrite[73102]: fatal: proxy:mysql:/usr/local/etc/postfix/mysql_relay_domains_maps.cf(0,lock|fold_fix): table lookup problem
Oct 12 00:02:07 hostname postfix/qmgr[72218]: warning: problem talking to service rewrite: Unknown error: 0
Oct 12 00:02:07 hostname postfix/master[1123]: warning: process /usr/local/libexec/postfix/trivial-rewrite pid 73102 exit status 1
Oct 12 00:02:07 hostname postfix/master[1123]: warning: /usr/local/libexec/postfix/trivial-rewrite: bad command startup -- throttling
Oct 12 00:03:07 hostname postfix/proxymap[70318]: warning: mysql query failed: Table 'Mail.domain' doesn't exist
Oct 12 00:03:07 hostname postfix/trivial-rewrite[73153]: fatal: proxy:mysql:/usr/local/etc/postfix/mysql_relay_domains_maps.cf(0,lock|fold_fix): table lookup problem
Oct 12 00:03:08 hostname postfix/qmgr[72218]: warning: problem talking to service rewrite: Unknown error: 0
Oct 12 00:03:08 hostname postfix/master[1123]: warning: process /usr/local/libexec/postfix/trivial-rewrite pid 73153 exit status 1
Oct 12 00:03:08 hostname postfix/master[1123]: warning: /usr/local/libexec/postfix/trivial-rewrite: bad command startup -- throttling
Oct 12 00:03:28 hostname postfix/qmgr[72218]: fatal: watchdog timeout
Oct 12 00:03:29 hostname postfix/master[1123]: warning: process /usr/local/libexec/postfix/qmgr pid 72218 exit status 1
Oct 12 00:03:29 hostname postfix/qmgr[73171]: 83FD3F0102C: from=<root@localhost.localhost>, size=3297, nrcpt=1 (queue active)
Oct 12 00:04:08 hostname postfix/proxymap[70318]: warning: mysql query failed: Table 'Mail.domain' doesn't exist
Oct 12 00:04:08 hostname postfix/trivial-rewrite[73204]: fatal: proxy:mysql:/usr/local/etc/postfix/mysql_relay_domains_maps.cf(0,lock|fold_fix): table lookup problem
the weird thing is that I can actually see the database and the fields and they do exist.