On Thu, November 9, 2017 12:03 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
... > 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 = And indeed, your SQL query looks truncated to me. What should backupmx be compared to?
