大网数据广告活动
服务器运维问答

Why does MySQL reject my postfix virtual domain query as "an error in your SQL syntax"?

· 52CE 我爱测

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…

问题原文

原帖链接 · 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

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2021-09-18)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。