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;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
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/
