Infact, Only after I replied, I thought that problem can has been that...
Excuse me, rocsca ----- Original Message ----- From: "Stuart Johnston" <[EMAIL PROTECTED]> To: "Rocco Scappatura" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Friday, October 14, 2005 6:39 PM Subject: Re: [AMaViS-user] About SA... > Mail::SpamAssassin::BayesStore::MySQL requires MySQL 4.1. I believe > this error indicates that you are using an earlier version. > Mail::SpamAssassin::BayesStore::SQL will probably work if you don't want > to upgrade. > > -Stuart > > > Rocco Scappatura wrote: > > 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/ ------------------------------------------------------- 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/
