Package: rsyslog-pgsql
Version: 4.6.4-1
Severity: normal
(I use rsyslog from lenny-backports on nearly all of my hosts, but I have
verified the following to be true for 4.6.4-1 from unstable).
After upgrading from 4.4.2~bpo to 4.6.4~bpo, I started getting hourly
messages from logcheck. The Postgres client driver was complaining about
unescaped strings generated by exim's rejectlog; on rare occasions,
other syslog clients generated such warnings, too.
Now I don't know why this suddenly occurred (ompgsql doesn't seem to
have changed between 4.4.2 and 4.6.4), but upon investigating this problem, I
realized the escaping issue at least to be true:
testcase:
$ logger 'backslash in string causes problems \1'
result in DB:
" backslash in string causes problems "
The '\1' is stored as \x01 instead of \x5c\x31 .
The escaping problem is present in 4.4.2~bpo, 4.6.4~bpo ad 4.6.4-1, however
only versions > 4.4.2 cause the Postgres warning messages.
Christian
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages rsyslog-pgsql depends on:
ii dbconfig-common 1.8.46 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.36 Debian configuration management sy
ii libc6 2.11.2-6 Embedded GNU C Library: Shared lib
ii libpq5 9.0.1-1 PostgreSQL C client library
ii rsyslog 4.6.4-1 enhanced multi-threaded syslogd
ii ucf 3.0025+nmu1 Update Configuration File: preserv
Versions of packages rsyslog-pgsql recommends:
pn postgresql-client <none> (no description available)
Versions of packages rsyslog-pgsql suggests:
pn postgresql <none> (no description available)
-- debconf information:
rsyslog-pgsql/db/app-user: rsyslog
rsyslog-pgsql/pgsql/manualconf:
rsyslog-pgsql/remote/host:
rsyslog-pgsql/pgsql/authmethod-user:
rsyslog-pgsql/upgrade-backup: true
rsyslog-pgsql/db/dbname: Syslog
rsyslog-pgsql/dbconfig-reinstall: false
rsyslog-pgsql/passwords-do-not-match:
rsyslog-pgsql/missing-db-package-error: abort
rsyslog-pgsql/pgsql/admin-user: postgres
rsyslog-pgsql/database-type: pgsql
rsyslog-pgsql/purge: false
rsyslog-pgsql/internal/skip-preseed: true
rsyslog-pgsql/install-error: abort
rsyslog-pgsql/upgrade-error: abort
rsyslog-pgsql/pgsql/method: unix socket
rsyslog-pgsql/remove-error: abort
rsyslog-pgsql/internal/reconfiguring: false
rsyslog-pgsql/remote/port:
rsyslog-pgsql/dbconfig-upgrade: true
rsyslog-pgsql/pgsql/changeconf: false
rsyslog-pgsql/pgsql/no-empty-passwords:
rsyslog-pgsql/pgsql/authmethod-admin: ident
rsyslog-pgsql/dbconfig-remove:
* rsyslog-pgsql/dbconfig-install: false
rsyslog-pgsql/remote/newhost:
WARNING: nonstandard use of escape in a string literal
LINE 1: ...dTime, ReceivedAt, InfoUnitID, SysLogTag) values (' [1\17] 2...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of escape in a string literal
LINE 1: ...dTime, ReceivedAt, InfoUnitID, SysLogTag) values (' [2\17] E...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of escape in a string literal
LINE 1: ...dTime, ReceivedAt, InfoUnitID, SysLogTag) values (' [3\17] E...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
