[Mailman-Users] Wrong Mysql syntax

[Mark Sapiro]

On 11/07/2017 07:14 PM, Mathieu R. wrote:
> I try to setup a debian/Mysql/Postfix/dovecot server
> Here is the error i got in mail.log. I checked my mysql_relay_domains
> twice, but i can't find my mistake


Is this a Mailman question?


...
> Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning: mysql
> query failed: You have an error in your SQL syntax; check the manual that
> corresponds to your MariaDB server version for the right syntax to use near
> '' at line 1
...
> Here is the content of my mysql_relay_domains :
> 
> hosts = 127.0.0.1
> user = user
> password = password
> dbname = dbname
> query = SELECT domain FROM domain WHERE domain='%s' and backupmx =


If I had to guess it's complaining that there is nothing following
'backupmx ='

-- 
Mark Sapiro <mark at msapiro.net>        The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan