[OT] Bayes & MySQL Woes

[--[UxBoD]--]

I am trying to move from DBM to MySQL for our Bayes database but have hit a problem :-

[2743] dbg: bayes: database connection established
[2743] dbg: bayes: found bayes db version 3
[2743] dbg: bayes: unable to initialize database for root user, aborting!

I have followed the WiKi exactly and in the top of spam.assassin.prefs.conf I have the following :-

bayes_store_module                Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                         DBI:mysql:sa_bayes:localhost
bayes_sql_username                sabayes
bayes_sql_password                 **********
bayes_sql_override_username  root

I made sure that the override was in place before I ran the sa-learn backup.  Any ideas ? I have googled etc but cannot find a answer :(

--[ UxBoD ]--
// PGP Key: "curl -s http://www.splatnix.net/uxbod.asc | gpg --import"
// Fingerprint:     543A E778 7F2D 98F1 3E50  9C1F F190 93E0 E8E8 0CF8
// Keyserver: www.keyserver.net                     Key-ID: 0xE8E80CF8

-- 
This message has been scanned for viruses and dangerous content
by MailScanner, and is believed to be clean.