View Single Post
  #1  
Old 12th June 2009, 08:33
stanman stanman is offline
Junior Member
 
Join Date: Jul 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Perfect SpamSnake p05, mysql connect

hi,
I'm trying the Perfect SpamSnake how to and everything is looking good.
Exept when I reach :

Now for recovering the bayes_dbm to bayes_sql.

sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --restore sa_bayes_backup.txt

This gives me an error with the restore.

Running it with the -D option gives me:
[32441] dbg: replacetags: done replacing tags
[32441] dbg: bayes: using username: root
[32441] dbg: bayes: unable to connect to database: Access denied for user 'sa_user'@'localhost' (using password: YES)
[32441] dbg: config: score set 1 chosen.
[32441] dbg: bayes: unable to connect to database: Access denied for user 'sa_user'@'localhost' (using password: YES)
[32441] dbg: bayes: unable to connect to database: Access denied for user 'sa_user'@'localhost' (using password: YES)

Looks like i can't connect to the mysql database with sa_user, I've copied the right credentials into spam.assassin.prefs.conf, and can connect to mysql with sa_user from the command line...

spam.assassing.prefs.conf looks like:
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:sa_bayes:localhost
bayes_sql_username sa_user
bayes_sql_password My sa_user's password
bayes_sql_override_username root

Is there some other place i also need to put the mysql credentials in?

Regards
Reply With Quote
Sponsored Links