Hello, I followed regner's notes to setup rsyslog and omoracle. But even with a test db and two columns it won't work with my installation, see: "rsyslogd: Error message: ORA-01461: can bind a LONG value only for insert into a LONG column".
I created the test table as follows: |create table test (hostname varchar2(100), message varchar2(4000)); |I found out that if I am only writing one syslog property to oracle it succeeds. My configuration: |(...) ################ #### ORACLE #### ################ $ModLoad omoracle $OmoracleDBUser myoracleuser $OmoracleDBPassword ***** $OmoracleDB myoracledb $OmoracleBatchSize 1 $OmoracleBatchItemSize 4096 $OmoracleStatementTemplate OmoracleStatement $template OmoracleStatement,"INSERT INTO TEST(hostname,message) VALUES(:hostname,:msg)" $template TestStmt,"%hostname%%msg%" *.* :omoracle:;TestStmt|i| | Any ideas? _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
