Hello. Thanks for you replay.
I tried to migrate my spam information from DBM to SQL. Im using a MySQl server on a different server from that who's run spamassassin. I installed all the perl packages required, then I backup the spam information of the user 'amavis' whos the parent of amavisd process, then I modify the local.cf file with the following lines: bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:bayes:xxx.xxx.xxx.xxx bayes_sql_username xxxx bayes_sql_password xxxx And Finally I restore the data. But during this process I had may error lines like this: [30510] dbg: bayes: _put_token: SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE spam_count = GREATEST(spam_count + '0', [30510] dbg: bayes: error inserting token for line: t_0_5192_1129292696_908c2d610e [30510] dbg: bayes: _put_token: SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE spam_count = GREATEST(spam_count + '0', [30510] dbg: bayes: error inserting token for line: t_0_1160_1129099982_4e9e2c8e1a What's happened? rocsca ----- Original Message ----- From: "Martin Svensson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, October 11, 2005 4:39 PM Subject: Re: [AMaViS-user] About SA... > Gary V wrote: > > >>Can I share the db for all incoming/outgoing mail, apart > >>from user? > >> > >> > > > >One database is used for all mail that passes through amavisd-new, the > >data belongs to your amavisd-new user (probably 'vscan' or 'amavis'). > > > > > > If you have a fairly high amount if incoming mail, or more than one > mailserver, then I would recommend moving bayes to a MySQL database. > It's fast and reliable. > > http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes?highlight=%28mysql%29 > > //Martin > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > 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/ ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ 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/
