Hi, Can you provide a debug log that contains an occurrence of this error? This helps us understand what happens.
Best regards, Andre > -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Sandeep Sukhija > Sent: Donnerstag, 18. August 2011 12:56 > To: [email protected] > Subject: [rsyslog] Problem with ompgsql component in 5.8.3 version > > 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 _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
