I was using rsyslog-5.6.5 earlier, where i wanted to make a postgresql db
entry. It worked perfectly with the following entry in rsyslog.conf
$template tpl_DB_raw_data,"insert into raw_data(data) VALUES('%msg%')",SQL
if $msg contains 'smtpstage1' then
:ompgsql:localhost,MAILFLOWREPORTS,root,password;tpl_DB_raw_data
later, i upgraded to latest version 5.8.3 on the same setup, but this rule
doesn't apply. It always throws a database connection exception as follows :
rsyslogd: db error (1): server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Are there any changes to be made to the rules or something is being missed in
all the stuff. Please help.
------
Sandeep Sukhija
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
