Loading ...
Sorry, an error occurred while loading the content.

246587Re: What is table='t'

Expand Messages
  • Stephen Liu
    Dec 2, 2008
    • 0 Attachment
      --- mouss <mouss@...> 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
    • Show all 8 messages in this topic