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

Reply via email to