如何将rsyslog中的日志转发到mysql自己定义的表里

kaede_1

环境 Centos6.4 32bit

安装好rsyslog和mysql，目前通过配置,可以将日志信息发送到Syslog.SystemEvents表中

1. $ModLoad ommysql.so
   
2. *.* :ommysql:localhost,Syslog,root,123456
   
3. 
   
4. $template StdSQLFormat,"insert into SystemEvents(Message, Facility, FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag) values ('%msg%', %syslogfacility%, '%HOSTNAME%', %syslogpriority%, '%timereported:::date-mysql%', '%timegenerated:::date-mysql%', %iut%, '%syslogtag%')",SQL
   
5. :syslogtag, contains, "sb503" StdSQLFormat
   

复制代码

但是我现在想将信息转发到Syslog.logs 表里，却怎么也发送不过去，哪位给指点一下，多谢。

1. [code]$ModLoad ommysql.so
   
2. *.* :ommysql:localhost,Syslog,root,123456
   
3. 
   
4. $template StdSQLFormat,"insert into logs(Message, Facility, FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag) values ('%msg%', %syslogfacility%, '%HOSTNAME%', %syslogpriority%, '%timereported:::date-mysql%', '%timegenerated:::date-mysql%', %iut%, '%syslogtag%')",SQL
   
5. :syslogtag, contains, "sb503" StdSQLFormat

复制代码