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/
