Mysql

Spamassassin 無法使用 user_scores_custom_query 規則解析配置行

  • September 8, 2013

我正在嘗試通過 MySQL 為每個使用者配置文件設置 spamassassin,但出現此錯誤:

Sep  8 12:09:13.668 [12307] warn: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": user_scores_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC

但是我看不出這個配置行有什麼問題,有人可以幫我嗎?

編輯:這是所有 local.cf。

required_hits 5.0
report_safe 0
required_score 5
rewrite_header Subject [SPAM]

user_scores_dsn DBI:mysql:spamassassin:localhost:3306
user_scores_sql_password db_username
user_scores_sql_username db_pass
user_scores_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC

通過快速查看文件,我推斷這被稱為user_scores_sql_custom_query而不是user_scores_custom_query.

引用自:https://serverfault.com/questions/537270