Dear List,
Many thanks for SpamAssassin.
Quick question:
I used this guide to configure SA to connect to mysql:-
http://wiki.apache.org/spamassassin/UsingSQL
...And also read this about the mysql connector:
http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.3.x/sql/README
I have this message in the spamd.log:
Sat Jan 8 12:39:37 2011 [9515] info: spamd: connection from localhost
[127.0.0.1] at port 54230
Sat Jan 8 12:39:37 2011 [9515] warn: config: failed to load user
(b...@test.infp) scores from SQL database: config: SQL error: Access
denied for user 'spamassassin'@'localhost' (using password: YES)
Sat Jan 8 12:39:37 2011 [9515] warn: spamd: service unavailable: Error
fetching user preferences via SQL
Sat Jan 8 12:39:37 2011 [9505] info: prefork: child states: II
However, the sql.cf file contains this:
# cat sql.cf
user_scores_dsn DBI:mysql:spamassassin:localhost:3306
user_scores_sql_password Axxxx()xxx!!*-44
user_scores_sql_username spamassassin
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC
(the password is not the same, but it does have many wierd chars in it.)
The user name and password combination can log in and query the database
using:
# mysql -p spamassassin -u spamhamster
Enter password:
Any one know what I can check?
Best regards.
