[rsyslog] OmoracleStatement format
damjanster at gmail.com
Thu Jul 29 13:24:29 CEST 2010
> I think it would be best to split the RFC3339 date via the property
> (using start and end position) and then feed this to omoracle.
> The full doc on property replacer is here:
I first thought I could replace some strings with regex, but I've got a fix
from coworker to solve the issue like this:
$template OmoracleStatement,"INSERT INTO
(:hostname,to_timestamp_tz(:dategen || ' ' || :timegen, 'YYYY-MM-DD
It works great now.
> > 2. hostname doesn't get written - I only get 127.0.0.1
> It would be useful to write a quick debug file
> *.* /var/log/debug.log;RSYSLOG_DebugFormat
> This shows what exactly is stored in which property and can probably used
> solve the question what exactly happens.
It seems that the issue with timestamp was the cause of all the problems.
The data got displaced for one colon. Not it works like a charm.
Thanks for the help.
More information about the rsyslog