On 4/19/2013 1:54 PM, Benny Pedersen wrote: > Ben Johnson skrev den 2013-04-19 18:02: > >> Still stumped here... > > for amavisd-new, put spamassassin sql setup into user_prefs file for the > user amavisd-new runs as might be working better then have insecure sql > settings in /etc/mail/spamassassin :) > > i dont know if this is really that you have another user for amavisd, > and test spamassassin -t msg with another user that uses another sql user ? > > make sure both users is really using same sql user as intended >
Benny, thanks for the suggestion regarding moving the SA SQL setup into user_prefs. I will look into that soon. Yes, I believe that me and the system always execute SA commands as the "amavis" user. When I was using the SQL setup, I had the following in local.cf: bayes_path /var/lib/amavis/.spamassassin/bayes With the DBM setup, I had the following (I have since commented it out, while attempting to debug this Bayes issue): bayes_sql_override_username amavis Is something more required to ensure that my mail system, which runs under the "amavis" user, is always reading from and writing to the same DB? Best regards, -Ben
