[AMaViS-user] ERROR: invalid byte sequence for encoding "UTF8"

Hi all

We use amavisd-new 2.5.3 with white/blacklists stored in a PostgreSQL (UTF-8) database.
Mails with a From/To containing german umlauts in latin1 will hang in the postfix
queue forever. The mail-logs contains a lot of the following errors:

.... relay=127.0.0.1[127.0.0.1]:10024, conn_use=2, delay=8955, delays=8955/0/0/0.14, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=22244-16-2, spam-wb-list FAILED: sql exec: err=7, 22021, DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xdf65 451 4.5.0 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". at (eval 69) line 271. (in reply to end of DATA command))
.... lookup_sql: sql exec: err=7, 22021, DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xfc\nHINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding"., 7, ERROR: invalid byte sequence for encoding "UTF8": 0xfc\nHINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".\n

Is there a way to set the postgres "client_encoding" in amavisd-new?
Or if it is a bug: Is there a workaround for this problem?

valli

PS:
I noticed in the amavisd-new-2.5.3 release notes the following point:
....
- sanitize 8-bit characters in In-Reply-To and References header fields
before using them in Pen Pals SQL lookups to avoid UTF-8 errors like:
penpals_check FAILED: sql exec: err=7, 22021, DBD::Pg::st execute failed:
ERROR: invalid byte sequence for encoding "UTF8": 0xd864
....
Should this probably also be fixed for spam-wb-list lookups?



-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216...et/marketplace
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/