Hello – I am trying to manage a SpamAssassin implementation with a
MySQL backend for users to manage their own settings. I am running into some
strange problems with this, however. When I do a spamassassin –lint, I receive the
following message: config: SpamAssassin failed to parse line, skipping:
user_scores_sql_table userpref warning: score set for non-existent rule BAYES_90 warning: score set for non-existent rule BAYES_70 warning: score set for non-existent rule HABEAS_SWE The first line is what concerns me – the table definitely
exists, and the SQL user can access it, etc. That line also comes after several
other SQL config lines in the local.cf file, which I am placing below: # Setup db vars to point to the MySQL prefs user_scores_dsn DBI:mysql:mail:localhost user_scores_sql_username mail user_scores_sql_password ************ user_scores_sql_table userpref To add additional strangeness, SpamAssassin seems to be
using the SQL table for some things and not others. For instance, if I modify
bounce-levels or reporting options, SpamAssassin will take them into account.
However, the whitelist_from and blacklist_from options seem to be being
ignored. Debug output from spamc and spamd don’t show any errors relating
to this. I am running spamd at boot time with the following command: spamd_pidfile=${spamd_pidfile:-"/var/run/spamd/spamd.pid"} spamd_flags=${spamd_flags:-"-c -d -Q -r
${spamd_pidfile} "} The server is running SpamAssassin 3.0.3, Perl 5.8.7, MySQL 4.1.15. Any help anyone can provide would be of great assistance.
Thanks! I will gladly provide any additional info (within reason of course –
don’t expect my root passwords or anything) if anyone needs it. Jon |
- SpamAssassin and SQL problems Jon Schulman
- Re: SpamAssassin and SQL problems Dan
- RE: SpamAssassin and SQL problems Matthew.van.Eerde