Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 12th June 2009, 09: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

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?

Reply With Quote
Sponsored Links


access denied, mysql, sa_bayes, spamsnake

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail not working epicuniversal General 5 13th June 2009 09:24
Mail Question: installed smf forum on centos perfect server setup with ispconfig happz Installation/Configuration 7 22nd August 2008 14:15
SpamSnake SpamAssassin not working? getrav HOWTO-Related Questions 5 24th June 2008 00:02
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Perfect Xen 3.0 setup for Debian gurneyzap HOWTO-Related Questions 4 26th March 2006 12:30

All times are GMT +2. The time now is 11:56.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.