--- mouss <[EMAIL PROTECTED]> wrote: > Stephen Liu a écrit : > > Hi folks, > > > > > > I have a /etc/postfix/mysql_*.cf file with following content; > > user=mail > > password=mypasswd > > dbname=maildb > > table='t' > > select_field=domains > > where_field=domains > > hosts=127.0.0.1 > > additional_conditions = and enabled = 1 > > > > > > Please help me to understand table='t'. What is 't'? > > > > > > there's no 't' in postfix. if you call your table 't', then it's you > problem. > > but it may be time to move to the new syntax (query=)...
Hi mouss, Further to my late posting. Changing; table='t' to query= on /etc/postfix/mysql_relay_domains.cf # postfix reload # postfix check # tail /var/log/mail.log ... ... Dec 2 08:28:27 xen07 postfix/postfix-script: refreshing the Postfix mail system Dec 2 08:28:27 xen07 postfix/master[2932]: reload configuration /etc/postfix Dec 2 08:28:27 xen07 postfix/anvil[3363]: statistics: max connection rate 1/60s for (smtp:209.85.142.188) at Dec 2 08:26:21 Dec 2 08:28:27 xen07 postfix/anvil[3363]: statistics: max connection count 1 for (smtp:209.85.142.188) at Dec 2 08:26:21 Dec 2 08:28:27 xen07 postfix/anvil[3363]: statistics: max cache size 4 at Dec 2 08:26:53 Dec 2 08:28:47 xen07 postfix/smtpd[3444]: connect from host167-240-dynamic.9-79-r.retail.telecomitalia.it[79.9.240.167] No error found. Sent mails to the routing mail server. All mails were delivered to their own mail servers without problem. B.R. Stephen Send instant messages to your online friends http://uk.messenger.yahoo.com