$ModLoad imudp.so # provides UDP syslog reception
$UDPServerRun 514 # start a UDP syslog server at standard port 514
$ModLoad imuxsock.so
$ModLoad omoracle.so
$omoracledbuser gao
$omoracledbpassword gao
$omoracledb (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.53)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
$omoraclebatchsize 1
$omoraclebatchitemsize 4096
$omoraclestatementtemplate OmoracleStatement
$template OmoracleStatement,"insert into T_RSYSLOG_MSG_TMP(MESSAGE,HOSTNAME,FACILITY,ID,PRIORITY,SYSNAME,facility_text,RS_ELVEL,PRIO
RITY_TEXT,syslogseverity) values (:message,:hostname,:facility,RSYS_TMP_ID_SEQ.nextval,:pri,:sysname,:ftext,:rsysloglevel,:rsyslogpr
iority,:syslogseverity)"
$template Stmt,"%msg%%hostname%%syslogfacility%%syslogpriority%%programname%%syslogfacility-text%%syslogseverity-text%%syslogpriorit
y-text%%syslogseverity%"
*.* :omoracle:;Stmt
阅读(2650) | 评论(0) | 转发(0) |
