On 9.9.2010 17:53, Jason Hollenberg wrote:
> After a new OpenSuSE 11.3 mail server build (SpamAssassin 3.3.1, Postfix
> 2.7.1, invoking SpamAssassin using Amavisd-new) I'm seeing messages getting
> stuck in the Postfix queue with errors similar to this:
>
> host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=24421-02,
> spam_scan FAILED: DBD::mysql::st execute failed: Incorrect string value:
> '\\xC2\\x82\\xC2\\xAC\\xC3\\xA2...' for column 'contents' at row 1 at
> /usr/sbin/amavisd line 3786, <GEN30> line 319. (in reply to end of DATA
> command)
>
> host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=24747-09,
> spam_scan FAILED: DBD::mysql::st execute failed: Incorrect string value:
> '\\xAE Offi...' for column 'subject' at row 1 at /usr/sbin/amavisd line
> 3786, <GEN82> line 252. (in reply to end of DATA command)
>
> The most I could find on this issue is an obscure post referencing Zimbra
> email server (http://bugzilla.zimbra.com/show_bug.cgi?id=43102) mentioning
> problems with the charset detection in SpamAssassin, but I have tried
> enabling the ok_locales and ok_languages settings in my local.cf file to no
> avail. Help!
>
>
> Thanks!
>
>
Columns "contents" and "subject" do not ring a bell here. They
definitely do not belong the SpamAssassin MySQL database.
Do you have SQL quarantine database for amavisd-new? That might be the
key. The answer may lie in the DBD-config for amavisd-new. Amavisd
propably tries to send UTF-characters to an SQL connection which does
not expect it.
--
Never laugh at live dragons.
-- Bilbo Baggins [J.R.R. Tolkien, "The Hobbit"]
