Re: mysql 8 database problem
On 12/8/18 1:20 PM, Csaba Banhalmi wrote: > Hi, > > I upgraded to mysql and since then I can’t use bases db to score my mails. > Spam assassin -D says the following: > > [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations > for operation ' IN ' > [12254] dbg: bayes: cannot use bayes on this message; none of the > tokens were found in the database > [12254] dbg: bayes: not scoring message, returning undef > > Collation is the same as before, moreover I dumped the db and imported in a > mysql 5.6 which works fine, I get my bayes scoring just fine. > I use spamassassin 3.4.2 and mysql 8.0.12 > > Any help is appreciated, thank you! > > Best regards, > Csaba > Can you post on pastebin the bayes table definition (SHOW CREATE TABLE) ? Thanks Giovanni
Re: mysql 8 database problem
On 2018/12/08 21:21, Dave Wreski wrote: I'd also consider changing to mariadb if it's supported by your distribution. Regards, Dave ^ This Regards Brent
Re: mysql 8 database problem
On 12/8/18 1:58 PM, Csaba Banhalmi wrote: Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on this message; none of the tokens were found in the database [12254] dbg: bayes: not scoring message, returning undef Collation is the same as before, moreover I dumped the db and imported in a mysql 5.6 which works fine, I get my bayes scoring just fine. I use spamassassin 3.4.2 and mysql 8.0.12 Any help is appreciated, thank you! Have you run mysql_upgrade after upgrading? I'd also consider changing to mariadb if it's supported by your distribution. Regards, Dave Best regards, Csaba
mysql 8 database problem
Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on this message; none of the tokens were found in the database [12254] dbg: bayes: not scoring message, returning undef Collation is the same as before, moreover I dumped the db and imported in a mysql 5.6 which works fine, I get my bayes scoring just fine. I use spamassassin 3.4.2 and mysql 8.0.12 Any help is appreciated, thank you! Best regards, Csaba
mysql 8 database problem
Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on this message; none of the tokens were found in the database [12254] dbg: bayes: not scoring message, returning undef Collation is the same as before, moreover I dumped the db and imported in a mysql 5.6 which works fine, I get my bayes scoring just fine. I use spamassassin 3.4.2 and mysql 8.0.12 Any help is appreciated, thank you! Best regards, Csaba