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

246590Re: What is table='t'

Expand Messages
  • Stephen Liu
    Dec 2, 2008
    • 0 Attachment
      --- Barney Desmond <barneydesmond@...> wrote:

      > Stephen Liu wrote:
      > > I have a /etc/postfix/mysql_*.cf file with following content;
      >
      > You haven't told us what this file is called. We dunno what it does,
      > we
      > have no way to tell.


      Hi Barney,


      Sorry, it is /etc/postfix/mysql_relay_domains.cf


      > > user=mail
      > > password=mypasswd
      > > dbname=maildb
      > > table='t'
      > > select_field=domains
      > > where_field=domains
      > > hosts=127.0.0.1
      > > additional_conditions = and enabled = 1
      >
      > At a guess, it's going to perform the query:
      > SELECT `domains` FROM `t` WHERE `domains`=%s AND `enabled`=1;


      mysql> SELECT `domains` FROM `t` WHERE `domains`=%s AND `enabled`=1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the
      manual that corresponds to your MySQL server version for the right
      syntax to use near '%s AND `enabled`=1' at line 1


      mysql> SHOW tables;
      +------------------+
      | Tables_in_maildb |
      +------------------+
      | aliases |
      | domains |
      | transport |
      | users |
      +------------------+
      4 rows in set (0.00 sec)


      mysql> SELECT `domains` FROM `trasnport` WHERE `domains`=%s AND
      `enabled`=1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the
      manual that corresponds to your MySQL server version for the right
      syntax to use near '%s AND `enabled`=1' at line 1


      mysql> SELECT * from transport;
      +------+----------------------+--------------------+-----------+---------+
      | pkid | domain | hostname | transport |
      enabled |
      +------+----------------------+--------------------+-----------+---------+
      | 1 | satimis.dnsalias.com | smtp:192.168.0.209 | :[] |
      1 |
      | 2 | satimis.changeip.net | smtp:192.168.0.208 | :[] |
      1 |
      | 3 | satimis.com | smtp:192.168.0.210 | :[] |
      1 |
      +------+----------------------+--------------------+-----------+---------+
      3 rows in set (0.00 sec)


      mysql> SELECT `domain` FROM `trasnport` WHERE `domain`=%s AND
      `enabled`=1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the
      manual that corresponds to your MySQL server version for the right
      syntax to use near '%s AND `enabled`=1' at line 1


      mysql> SELECT `domain` FROM `trasnport` WHERE `domains`=%s AND
      `enabled`=1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the
      manual that corresponds to your MySQL server version for the right
      syntax to use near '%s AND `enabled`=1' at line 1


      Still the same.


      > It could be virtual alias domains, it could be anything.
      > http://www.postfix.org/mysql_table.5.html


      Noted with thanks.



      > > Please help me to understand table='t'. What is 't'?
      >
      >
      > As the file says, 't' is the name of the table it's going to SELECT
      > from.


      But there is no table named 't'. The name of table starts with t is
      'transport'.


      I have changed;

      table='t'

      to;
      query=


      This routing mail server still works without problem.


      B.R.
      Stephen L


      Send instant messages to your online friends http://uk.messenger.yahoo.com
    • Show all 8 messages in this topic