Public bug reported:
Binary package hint: dsyslog-module-postgresql
The dsyslog module postgresql does exaust wrong sql-statements. Various
SQL-Errors are resulting:
Dec 13 17:56:20 dbsrv dsyslog[3351]: (ERROR) output_postgres.c:72
[output_postgres_handler]: Preparing log statement failed: ERROR: syntax error
at or near "`"
LINE 1: INSERT INTO `log` (logcode, timestamp, datestamp, source, pr...
After removing '`' (editing the binary making '`' to ' ' (space)):
Dec 13 18:10:09 dbsrv dsyslog[13593]: (ERROR) output_postgres.c:72
[output_postgres_handler]: Preparing log statement failed: ERROR: column
"logcode" of relation "log" does not exist
LINE 1: INSERT INTO log (logcode, timestamp, datestamp, source, pr...
ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: dsyslog-module-postgresql 0.6.0build1
ProcVersionSignature: Ubuntu 2.6.32-26.48-generic-pae 2.6.32.24+drm33.11
Uname: Linux 2.6.32-26-generic-pae i686
Architecture: i386
Date: Mon Dec 13 18:10:18 2010
InstallationMedia: Ubuntu-Server 10.04 LTS "Lucid Lynx" - Release i386
(20100427)
ProcEnviron:
LC_CTYPE=en_US.UTF-8
SHELL=/bin/zsh
SourcePackage: dsyslog
** Affects: dsyslog (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386 maverick
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/689757
Title:
column "logcode" of relation "log" does not exist --- and other SQL errors
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs