[Mailman-Users] Wrong Mysql syntax

Mathieu R. mathieu at 400iso.net
Tue Nov 7 22:14:14 EST 2017


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:10 vps81550 postfix/postscreen[23904]: CONNECT from
[209.85.215.51]:52679 to [149.56.x.x]:x
Nov  7 22:05:10 vps81550 postfix/postscreen[23904]: cache
btree:/var/lib/postfix/postscreen_cache full cleanup: retained=35 dropped=0
entries
Nov  7 22:05:10 vps81550 postfix/dnsblog[23909]: addr 209.85.215.51 listed
by domain dnsbl.sorbs.net as 127.0.0.6
Nov  7 22:05:10 vps81550 postfix/postscreen[23904]: PASS OLD
[209.85.215.51]:52679
Nov  7 22:05:10 vps81550 postfix/smtpd[23911]: connect from
mail-lf0-f51.google.com[209.85.215.51]
Nov  7 22:05:11 vps81550 postfix/smtpd[23911]: Untrusted TLS connection
established from mail-lf0-f51.google.com[209.85.215.51] TLSv1.2 with cipher
ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)
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
Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning:
relay_domains: mysql:/etc/postfix/mysql_relay_domains.cf: table lookup
problem
Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning:
relay_domains lookup failure
Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning:
relay_domains: mysql:/etc/postfix/mysql_relay_domains.cf: table lookup
problem
Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning:
relay_domains: mysql:/etc/postfix/mysql_relay_domains.cf: table lookup
problem
Nov  7 22:05:11 vps81550 postfix/trivial-rewrite[23471]: warning:
relay_domains lookup failure
Nov  7 22:05:11 vps81550 postfix/smtpd[23911]: NOQUEUE: reject: RCPT from
mail-lf0-f51.google.com[209.85.215.51] 451 4.3.0 <xxxxxxx at gmail.com>:
Temporary lookup failure; from=<xxxxxxx at gmail.com> to=<xxxxx at xxxx.org>
proto=ESMTP helo=<mail-lf0-f51.google.com>

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 =

-- 

Mathieu R.


More information about the Mailman-Users mailing list