18 lines
723 B
Plaintext
18 lines
723 B
Plaintext
### Configuration file for rsyslog-mysql
|
|
### Changes are preserved
|
|
|
|
module (load="ommysql")
|
|
|
|
# Custom Template for DB
|
|
|
|
$template sqltpl,"insert into SystemEvents (ReceivedAt, DeviceReportedTime, Facility, FacilityText, Priority, PriorityText, FromHost, FromHostIp, Hostname, Message, SysLogTag) values('%timegenerated:::date-mysql%', '%timereported:::date-mysql%', %syslogfacility%, '%syslogfacility-text%', %syslogpriority%, '%syslogpriority-text%', '%fromhost%', '%fromhost-ip%', '%HOSTNAME%', '%msg%', '%syslogtag%')",SQL
|
|
|
|
# Get all logs from imudp to database
|
|
|
|
if $inputname startswith "imudp" then {
|
|
|
|
*.* action(type="ommysql" server="localhost" db="syslog" uid="syslog" pwd="pwd4syslog" template="sqltpl")
|
|
stop
|
|
|
|
}
|