I've been trying to get SA to use a per user settings with Bayes/AWL. I've been having a strange issue where I want to connect to a remote DB server and not a local server but AWL/Bayes doesn't seem to work.
This is my settings: user_scores_dsn DBI:mysql:postfix:10.2.0.54 user_scores_sql_username user user_scores_sql_password pass bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:email:10.2.0.54 bayes_sql_username user bayes_sql_password pass auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:email:10.2.0.54 user_awl_sql_username user user_awl_sql_password pass The weird part is the regular per-user basis works fine with the remote database but the bayes and AWL try to connect to localhost(10.2.0.57). If i setup a local mysql server and use the login/password it has no problems. This is what I get in spamd debug mode: [14577] dbg: auto-whitelist: sql-based unable to connect to database (DBI:mysql:email:10.2.0.54) : Access denied for user 'user'@'10.2.0.57' (using password: YES) This is SpamAssassin Server version 3.1.4 running on Perl 5.8.5 -- View this message in context: http://www.nabble.com/SQL-connection-problems%28remote-vs-local%29-tf2190427.html#a6060567 Sent from the SpamAssassin - Users forum at Nabble.com.