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.pm 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 I tried to load it: sa-learn --restore /var/amavis/db/bayes.bck Can't call method "tie_db_readonly" on an undefined value at /usr/local/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/Bayes.pm line 1122. -- Michael Scheidell, CTO 561-999-5000, ext 1131 SECNAP Network Security Corporation ------------------------------------------------------- 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/
