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.
Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12th June 2009, 08:49
stanman stanman is offline
Junior Member
 
Join Date: Jul 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

oh yes: when i connect to the mysql sa_bayes db, I can view the tables (which are empty ofcourse, but they're there and i can connect with the sa_user)
Reply With Quote
Reply

Bookmarks

Tags
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 08:24
Mail Question: installed smf forum on centos perfect server setup with ispconfig happz Installation/Configuration 7 22nd August 2008 13:15
SpamSnake SpamAssassin not working? getrav HOWTO-Related Questions 5 23rd June 2008 23:02
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Perfect Xen 3.0 setup for Debian gurneyzap HOWTO-Related Questions 4 26th March 2006 11:30


All times are GMT +2. The time now is 08:17.


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