Hi,
thanks for the debug log. Unfortunately, it doesn't give any more details on
the error. I would guess that the pgsql server has a problem with the
template somehow.
Have you tried to run the a test sql command manually to see what happens?
Like: "insert into raw_data(data) VALUES('Test mgs')"
Best regards,
Andre Lorbach
> -----Original Message-----
> From: [email protected] [mailto:rsyslog-
> [email protected]] On Behalf Of Sandeep Sukhija
> Sent: Dienstag, 23. August 2011 08:50
> To: [email protected]
> Subject: Re: [rsyslog] Problem with ompgsql component in 5.8.3 version
>
> attached the log file.
>
> --------
> Thanks,
> Sandeep Sukhija
>
>
> 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: rsyslog-bounces at lists.adiscon.com [mailto:rsyslog- bounces at
> > lists.adiscon.com] On Behalf Of Sandeep Sukhija
> > Sent: Donnerstag, 18. August 2011 12:56
> > To: rsyslog at lists.adiscon.com
> > 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
