Hello,
Using the latest release of OSSEC (both local and server installs) on Ubuntu
Hardy, I am experiencing errors when trying to log to a PostgreSQL database:
2008/05/27 14:52:30 ossec-dbd(5203): ERROR: Error executing query 'INSERT INTO
data(id, server_id, 'user', full_log) VALUES ('6', '1', '(none)', 'ossec: Ossec
started.') '. Error: 'ERROR: syntax error at or near "'user'"
LINE 1: INSERT INTO data(id, server_id, 'user', full_log) VALUES ('6...
^
'.
2008/05/27 14:52:30 ossec-dbd(5209): INFO: Closing connection to database.
2008/05/27 14:52:30 ossec-dbd(5210): INFO: Attempting to reconnect to database.
2008/05/27 14:52:30 ossec-dbd: Connected to database 'ossecdb' at
'192.168.1.222'.
2008/05/27 14:52:30 ossec-dbd(5204): ERROR: Database error. Unable to run query.
I have read through all issues in the userslist regarding this problem, and
noticed this issue was fixed in a v1.4 snapshot. Did this issue resurface in
the 1.5 release? I also attempted to edit the alert.c source code and
recompile, but couldn't determine how to work around this problem.
Any help/suggestions on what to change would be much appreciated,
.
_________________________________________________________________
Change the world with e-mail. Join the i’m Initiative from Microsoft.
http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld
