Hi all,
I'm having a rare problem with MySQL Cluster 7.1.5. I have a mail platform
combining Postfix+Amavisd-new+Spamassassin (3.3.1)+ClamAV+Mysql-Cluster over a
OpenSUSE GNU/Linux 11.2.
The cluster stores the user data to access the mail throw Webmail, and the
bayes database. When everything was working fine, my boss decided to upgrade to
OpenSUSE 11.3, and then the problem started.
All the software was downloaded from the OpenSUSE official repositories, except
the MySQL Cluster. Because the version included in OpenSUSE 11.2 was too old,
we decided to download and install RPM packages from the official MySQL
Webpage, for a SLES 11.
After the upgrade to OpenSUSE 11.3, we started getting this errors from
Spamassassin when it's trying to access the database:
Nov 26 12:12:35.182 [25595] dbg: bayes: tok_get_all: token count: 65
Nov 26 12:12:35.184 [25595] dbg: bayes: tok_get_all: SQL error: Illegal mix of
collations for operation ' IN '
Nov 26 12:12:35.184 [25595] dbg: bayes: cannot use bayes on this message; none
of the tokens were found in the database
Nov 26 12:12:35.185 [25595] dbg: bayes: not scoring message, returning undef
We are doing some test, changing the charset of the database and other things,
but we can't solve the problem. Any ideas??
Here is the Spamassassin version:
# spamassassin --version
SpamAssassin version 3.3.1
running on Perl version 5.12.1
We invoking Spamassassin through Amavisd-new, and the actual platform is
OpenSUSE 11.3 x86_64.
If you need more information about the software versions or system
configuration, please, let us know and we send them.
Thanks in advance, David.
