Here it is:
$ModLoad imfile
$ModLoad imuxsock
$ModLoad imklog
$ModLoad ommysql
$ActionOmmysqlServerPort 1234
$MaxMessageSize 8k
$EscapeControlCharactersOnReceive off
$FileOwner root
$FileGroup root
$FileCreateMode 0600
$InputFileName /path/to/log/php-fpm.log
$InputFileTag php-fpm
$InputFileStateFile php-fpm.state
$InputFileSeverity notice
$InputFileFacility local5
$InputRunFileMonitor
$MainMsgQueueType LinkedList
$MainMsgQueueSize 20000
$MainMsgQueueFileName main-spool
$MainMsgQueueMaxDiskSpace 200M
$MainMsgQueueWorkerThreadMinimumMessages 2500
$MainMsgQueueWorkerThreads 1
$MainMsgQueueWorkerTimeoutThreadShutdown 10000
$MainMsgQueueSaveOnShutdown on
$template my-rsyslog-schema,"insert into messages(hostname, sent,
sent_subseconds, received_by_rsyslog, received_subseconds, process,
facility, severity, message) values ('%hostname%',
'%timereported:::date-mysql%', %timereported:::date-subseconds%,
'%timegenerated:::date-mysql%', %timegenerated:::date-subseconds%,
'%programname%', '%syslogfacility-text%', '%syslogseverity-text%',
'%msg%')",sql
*.* :ommysql:127.0.0.1,rsyslog,rsyslog_user,password;my-rsyslog-schema
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
