From: Stephen Liu (satimisyahoo.com)
Date: Tue Dec 02 2008 - 03:15:44 CST

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

--- mouss <moussnetoyen.net> 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

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