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.

Reply via email to