rsyslog 的oracle配置
时间：2010-06-11 来源：w1_xiao
$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
$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
相关阅读 更多 +
