Hi, I have been trying to make spamassassin work aginst SQL user preferences wothout any luck.
My local.cf contains. user_scores_dsn DBI:mysql:spamassassin:mysql_socket=/var/lib/mysql/mysql.sock user_scores_sql_username username user_scores_sql_password password user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '@GLOBAL' ORDER BY username ASC I am running spamd with following switches /usr/bin/spamd -q -x -u spamd -H /home/spamd -d -D -r /var/run/spamassassin/spamd.pid the debug message from spamd says Feb 29 04:47:37 sreedevi spamd[4100]: debug: Conf::SQL: executing SQL: SELECT preference, value FROM userpref WHERE username = 'qscand' OR username = '@GLOBAL' ORDER BY username ASC Feb 29 04:47:37 sreedevi spamd[4100]: debug: retrieving prefs for qscand from SQL server Here it says username='qscand' I am not sure why spamd is not transferring the email account as the username to variable _USERNAME_ Please suggest me on this. Sincerely, Sreedevi. -- View this message in context: http://www.nabble.com/Spamassassin-per-user-blacklisting-is-not-working-tp15752610p15752610.html Sent from the SpamAssassin - Users mailing list archive at Nabble.com.