Hello list, anybody using omoracle successfully and can help me with my problem?
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 failing configuration: $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 Freundliche Grüße / Best regards Timo Bumke _________________________________________ B&R Unternehmensberatungs- und Vertriebsgesellschaft mbH Amsterdamer Str.230 50735 Köln, Deutschland Vertragspartner der Bayer Schering Pharma AG Im Auftrag der Bayer Schering Pharma AG Gebäude A001, EG, Raum 012 59192 Bergkamen, Deutschland Phone: +49 2307 65-3803 Email: [email protected] Web: http://www.bayerscheringpharma.de _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
