[rsyslog-notify] Forum Thread: Re: Rsyslog to MySql (UBUNTU) - (Mode 'reply')

[noreply at adiscon.com]

User: cornelp 
Forumlink: http://kb.monitorware.com/viewtopic.php?p=26362#p26362

Message: 
----------
I guess since nobody was able to help, I figured it out on my own. For
those that will need help in the future trying to do the same:
Just edit your rsyslog.conf and remove everything, and put this in:
$ModLoad ommysql # load the output driver (use ompgsql for PostgreSQL)
$ModLoad imudp # network reception
$UDPServerRun 514 # start a udp server at port 514
$ModLoad imuxsock # local message reception
$WorkDirectory /rsyslog/work # default location for work (spool) files
$MainMsgQueueFileName mainq # set file name, also enables disk mode
$ActionResumeRetryCount -1 # infinite retries on insert failure
#for PostgreSQL replace 
*.* :ommysql:DB-Server-IP,Database name,Database user,Database user
password;

Restart your rsyslog
You good to go...