[rsyslog-notify] Forum Thread: omlibdbi with sqlite3 - (Mode 'post')

[noreply at adiscon.com]

User: simontkk 
Forumlink: http://kb.monitorware.com/viewtopic.php?p=25562#p25562

Message: 
----------
Dear All,

I facing a issue to log into sqlite3 database. I have tried "make check:
under build libdbi-drivers, it work`s well, and able connect into my
sqlite3 db.
Somehow i facing this issue under rsyslog.conf.
Please advices me.

Thank You.

rsyslog version rsyslogd 8.9.0.ad1 
libdbi: -0.8.3
libdbi-drivers-0.8.3

[code:1nknpq6e]template(name="stdSQLformat" type="string"
option.sql="on" string="insert into SystemEvents (Message, Facility,
FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag)
values ('%msg%', %syslogfacility%, '%HOSTNAME%', %syslogpriority%,
'%timereported:::date-mysql%',
'%timegenerated:::date-mysql%', %iut%, '%syslogtag%')"
)[/code:1nknpq6e]

[code:1nknpq6e]$ActionLibdbiDriver sqlite3
$ActionLibdbiDriverDirectory /usr/lib64/dbd/
#$ActionLibdbiHost 127.0.0.1
#$ActionLibdbiUserName
#$ActionLibdbiPassword
$ActionLibdbiDBName pfsense
*.* :omlibdbi:;sqlite[/code:1nknpq6e]


Error prompt:

May 12 11:31:12 localhost rsyslogd: db error (-3): -3: libdbi could not
establish a connection  [v8.9.0.ad1]
May 12 11:31:12 localhost rsyslogd-2007: action 'action 8' suspended, next
retry is Tue May 12 11:31:42 2015 [v8.9.0.ad1 try <!-- m --><a
class="postlink"
href="http://www.rsyslog.com/e/2007">http://www.rsyslog.com/e/2007</a><!--
m --> ]