246594Re: What is table='t'
- Dec 2, 2008Stephen Liu wrote:
> Sorry, it is /etc/postfix/mysql_relay_domains.cfYou need to understand what postfix expects to do. You provide it a
>>> 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 query, and it will fill in the blank. Postfix lookups are
key-value pairs, so there is exactly one blank to fill in, represented
As a guess, you should check the other tables, maybe `domains`. You're
looking for a table with a column called "domains".
> I have changed;This probably just means it won't do that lookup any more, so you won't
> This routing mail server still works without problem.
be accepting mail for the relay_domains that you'd expect.
- << Previous post in topic Next post in topic >>