[Mailman-Users] Wrong Mysql syntax

Mark Sapiro mark at msapiro.net
Wed Nov 8 15:11:21 EST 2017

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 =
> 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

More information about the Mailman-Users mailing list