rsyslog 的mysql配置
时间：2010-06-11 来源：w1_xiao
# UDP Syslog Server:
$ModLoad imudp.so # provides UDP syslog reception
$UDPServerRun 514 # start a UDP syslog server at standard port 514
# MySQL log
$ModLoad ommysql.so
$template MySQLInsert,"insert into SystemEvents( ReceivedAt,DeviceReportedTime,message,FromHost,Facility,Priority,InfoUnitID,SysLogT
ag) values('%timegenerated:::date-mysql%','%timereported:::date-mysql%','%msg%','%hostname%','%syslogfacility%','%syslogpriority%','
%iut%','%programname%')",SQL *.* :ommysql:127.0.0.1,Syslog,monitor,admin;MySQLInsert
$ModLoad imudp.so # provides UDP syslog reception
$UDPServerRun 514 # start a UDP syslog server at standard port 514
# MySQL log
$ModLoad ommysql.so
$template MySQLInsert,"insert into SystemEvents( ReceivedAt,DeviceReportedTime,message,FromHost,Facility,Priority,InfoUnitID,SysLogT
ag) values('%timegenerated:::date-mysql%','%timereported:::date-mysql%','%msg%','%hostname%','%syslogfacility%','%syslogpriority%','
%iut%','%programname%')",SQL *.* :ommysql:127.0.0.1,Syslog,monitor,admin;MySQLInsert
相关阅读 更多 +
