[syslog-ng] Encoding provlem when writing to postgres

[ml at bortal.de]

Hi,

where can i get syslog-ng 3.0?

I cant find it on
http://www.balabit.com/downloads/files/syslog-ng/sources/

Thanks,
Mario


Am 15.10.2008 um  Uhr haben Sie geschrieben:
> On Wed, 2008-10-15 at 09:53 +0200, ml at bortal.de wrote:
> > Hello List,
> >
> > How can i fix this? I am running postgresql-8.1 with Debian 4.0.
>
> Probably the syslog client sends non-utf8 characters in its message.
> syslog-ng 2.0 and 2.1 do not really care about the message contents.
>
> 3.0 has support for various encodings and utf8 validation like this:
>
> This assumes that the input is latin1:
>
> source s_net { udp(encoding("iso-8859-1")); };
>
> And this one enforces valid utf8 messages
>
> source s_net { udp(flags(validate-utf8)); };
>
> I was planning to add another flag, but this is not yet implemented:
>
> source s_net { udp(flags(force-utf8)); };
>
> Which would enforce valid utf8 sequences by changing the input.
>
> As an alternative don't use utf8 as the character encoding of your
> database, use latin1, that'll permit any kind of data in the database.
>