问题原文
原帖链接 · Matti Kiviharju · CC BY-SA 4.0
I have problem with MySQL Courier + Postfix Email Server
Here is error log:
warning: mysql:/etc/postfix/mysql-virtual_domains.cf: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'virtual FROM `domains` WHERE domain='domain.example'' at line 1
And code in mysql-virtual_domains.cf:
user = mail_admin
password = mypassword
dbname = mail
query = SELECT domain AS virtual FROM `domains` WHERE domain='%s'
hosts = 127.0.0.1
What to do?
已采纳解答
原帖链接 · anx · CC BY-SA 4.0
VIRTUAL is a keyword in MySQL.
Use a different alias, escape the identifier using backticks.. or just skip the AS [alias] part altogether: maps configured for virtual_alias_domains are only used to check whether there is a result anyway, not what the result is:
a "type:table" lookup table is matched when a table entry matches a lookup string (the lookup result is ignored) -- from man 5 postconf
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
