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 <xxxx...@gmail.com>: Temporary lookup failure; from=<xxxx...@gmail.com> to=<xx...@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.
