On Wed, Sep 09, 2009 at 09:32:27AM +0200, Karel Beneš wrote: > On Tue, Sep 08, 2009 at 09:45:18PM -0400, Matt Kettler wrote: > > Did you set these options in your local.cf?: > > > > user_scores_dsn DBI:driver:connection > > user_scores_*sql*_username dbusername > > user_scores_*sql*_password dbpassword > > > > And what did you set user_scores_dsn to? > > my local.cf settings is: > > user_scores_dsn DBI:mysql:spamassassin:localhost > user_scores_sql_username spamassassin > user_scores_sql_password x
Works fine now. My expectation was wrong. I have expect that new rows will be inserted automatically (in the same way as user_pref file is created) but it is not true. It seems "userpref" table is read-only from spamassassin perspective. When I insert appropriate rows there, they are recognized and considered by spamassassin. Current spamd parameters: "--max-children 2 --nouser-config --sql-config --setuid-with-sql". Maybye, explicit note in readme about this behaviour would avoid confusion like this. Regards, Karel -- Karel Beneš <be...@is.svitavy.cz> RádobyFotoBlog: http://kaaia.rohozna.cz/rfb/