[syslog-ng] Encoding provlem when writing to postgres

ml at bortal.de ml at bortal.de
Wed Oct 15 09:53:26 CEST 2008


Hello List,

i get the following error when i try to write to postres:

Error running SQL query; type='pgsql', host='XXX', port='', user='XXX',
database='syslogng', error='ERROR:  invalid byte sequence for encoding
"UTF8": 0xe96461\x0aHINT:  This error can also happen if the byte
sequence does not match the encoding expected by the server, which is
controlled by "client_encoding".\x0a', query='INSERT INTO msg_table
(msg_rcv_time, msg_sent_time, hostname, msg_facility, msg_priority,
msg_text) VALUES (\'2008-10-14T19:59:46+02:00\',
\'2008-10-14T19:59:46+02:00\', \'foo\', \'mail\', \'warning\',
\'mimedefang.pl[3497]: Message contains more than one Subject: header:
Bulletin d\\\'\'info d\\\'\'Enseigner.TV et la fiche p\xffdagogique de
l\\\'\'\xffmission du  mois \xff 14 octobre 208 --> Bulletin d\\\'\'info
d\\\'\'Enseigner.TV et la fiche p\xffdagogique de l\\\'\'\xffmission du 
mois \xff 14 octobre 208\')'


How can i fix this? I am running postgresql-8.1 with Debian 4.0.

Thanks,
Mario





More information about the syslog-ng mailing list