[COLUG] spamassassin problem

[Duane]

During my server migration I switch distros (to ubuntu) and a new
version of spamassassin was installed 3.1.0, previously I was using
MySQL to store userpref scores, however since the upgrade I'm getting
errors about not being able to use the results returned from MySQL,
below is the config (minus user/pass) + errors (I tried google, however
nothing relevant came up), since spamassassin does get results from
MySQL all I can think of is the tag names have changed or something.

user_scores_dsn                  DBI:mysql:database:localhost:3306
user_scores_sql_password         password
user_scores_sql_username         username
user_scores_sql_custom_query     SELECT preference, value FROM userprefs
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC


Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: auto_white_list_1
Sep  9 22:15:08 hostname spamd[3441]: config: not parsing, administrator
setting: bayes_path_/home/mfilter
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: bayes_path_/home/mfilter
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: use_dcc_1
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: use_razor2_1
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: rewrite_subject_1
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse line,
skipping: auto_learn_1
Sep  9 22:15:08 hostname spamd[3441]: config: failed to parse, now a
plugin, skipping: ok_languages_en de


-- 

Best regards,
 Duane

http://www.cacert.org - Free Security Certificates
http://www.nodedb.com - Think globally, network locally
http://www.sydneywireless.com - Telecommunications Freedom
http://e164.org - Because e164.arpa is a tax on VoIP

"In the long run the pessimist may be proved right,
    but the optimist has a better time on the trip."