I am trying to get my spamassassin install to use the SQL database for user prefs.
I have in /etc/mail/spamassassin/local.cf
user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username spam
user_scores_sql_password spam
user_scores_sql_table userpref
I then have spamd starting with -d -a -q -x options
Here is what happens when i send data to spamc:
[EMAIL PROTECTED] root]# cat sample-spam.txt | spamc
X-Mail-Format-Warning: Bad RFC2822 header formatting in This is a spam message to see
X-Mail-Format-Warning: Bad RFC2822 header formatting in if spamc/spamd is working.
X-Mail-Format-Warning: Bad RFC2822 header formatting in Lets hope so.
X-Spam-Status: No, hits=2.0 required=3.5
tests=DATE_MISSING,FROM_NO_LOWER
version=2.55
X-Spam-Level: **
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)
I never see the "
retrieving prefs for <username> from SQL server"MessageThanks
