[Workaround] Strange aMaViS Messages
Nick Hoffman
nick.hoffman at altcall.com
Tue Nov 29 14:18:55 CET 2005
On Fri, 25 Nov 2005 19:19, Nick Hoffman wrote:
> When looking through the logs, I noticed that the following 4 amavis
> messages appear for each email that comes through:
>
> lookup_sql_field(spam_kill_level) (WARNING: no such field in the SQL
> table) lookup_sql_field(spam_tag_level) (WARNING: no such field in the
> SQL table) lookup_sql_field(spam_tag2_level) (WARNING: no such field in
> the SQL table) lookup_sql_field(spam_kill_level) (WARNING: no such field
> in the SQL table)
>
> I followed the guide, which makes little mention of spam_*_level, and no
> mention of hooking up spam_*_level options with MySQL.
>
> I've pasted what gets logged to /var/log/syslog when a single message
> comes through:
> http://www.mypastebin.com/?code=1808689988
>
> Any idea why these messages occur?
>
> -- Nick
> e: nick.hoffman at altcall.com
> p: 07 5591 3588
> f: 07 5591 6588
>
> If you receive this email by mistake, please notify us and do not make
> any use of the email. We do not waive any privilege, confidentiality or
> copyright associated with it.
> _______________________________________________
> Workaround-chitchat mailing list
> Workaround-chitchat at workaround.org
> http://workaround.org/cgi-bin/mailman/listinfo/workaround-chitchat
After watching the mysql logs to see what was going on with those
lookup_sql_field messages Amavis was generating, it turned out that mysql
wasn't logging anything to do with them.
I went through amavisd.conf and found this setting:
$sql_select_policy = 'SELECT "Y" as local FROM domains WHERE
CONCAT("@",domain) IN (%k)';
When I disabled (IE: commented out) $sql_select_policy, the 4
lookup_sql_field messages were replaced by a message saying that the table
postfix.policy didn't exist.
So I googled and found this URL:
http://www.ijs.si/software/amavisd/README.sql.txt
If you scroll ~2/5 of the way down, you'll see the mysql syntax for
creating a users and policy table. I modified my current users table and
added the policy table, and all was fixed. Amavis stopped complaining once
and for all.
Hope that helps someone sometime in the future..
Nick
--
e: nick.hoffman at altcall.com
p: 07 5591 3588
f: 07 5591 6588
If you receive this email by mistake, please notify us and do not make any
use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.
--
e: nick.hoffman at altcall.com
p: 07 5591 3588
f: 07 5591 6588
If you receive this email by mistake, please notify us and do not make any
use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.
--
e: nick.hoffman at altcall.com
p: 07 5591 3588
f: 07 5591 6588
If you receive this email by mistake, please notify us and do not make any
use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.
More information about the Workaround-chitchat
mailing list