Don't you hate working on something for a day, posting a question and 5 mins later finally figuring it out? Might put this in amavisd- FAQ for sql readme: (or this will be stored by google, next person looking for answer has it)
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Michael Scheidell > Sent: Sunday, January 15, 2006 10:43 AM > To: [email protected] > Subject: [AMaViS-user] Please help converting bayes from db > to mysql Problem: cant cal method tie_db_readonly > > > I want to move an existing amavisd-new/SA installation to use > msql for bayes. I have mysql enabled and running for > amavisd-new profiles and wblists and all works. > > I get this error with trying to use bayesStore::MySQL > > Can't call method "tie_db_readonly" on an undefined value at > /usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/Bayes.p > m line 1122. > > I backed up original bayes database: > sa-learn --sync > sa-learn --backup > bayes.bak > > I changed > ../share/doc/p5-Mail-Spamassassin/sql/bayes_mysql.sql to use innodb > > I loaded them: > mysql -u amavis -D mail < bayes_mysql.sql > (yes, mail has permissions to read/write mail: > echo "GRANT ALL PRIVILEGES ON mail.* TO [EMAIL PROTECTED] > WITH GRANT OPTION;" | mysql -u root mysql ) > > I edited ../spamassassin/local.cf: > use_bayes 1 > #bayes_path /var/db/spamassassin/bayes > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > bayes_sql_override_username amavis > Also needs: bayes_sql_dsn DBI:mysql:mail:localhost bayes_sql_username amavis user_scores_sql_password password > I tried to load it: > > sa-learn --restore /var/amavis/db/bayes.bck ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
