Apologies for the rapid-fire here folks, but I wanted to correct something.
I had these backwards: >> 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 I meant to say that I have *always* had bayes_path /var/lib/amavis/.spamassassin/bayes in local.cf, and using the SQL setup, I added bayes_sql_override_username amavis Sorry for the confusion! -Ben On 4/19/2013 11:02 PM, Ben Johnson wrote: > > > 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 > >
