On 1/8/11, JKL wrote: > 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. >
You are logging in as user spamhamster, so should this: user_scores_sql_username spamassassin not be: user_scores_sql_username spamhamster ?? -- Gary V
