Hi, Presently I have these below issues on syslog-ng open source version. I have installed SYSLOG-NG version 3.x on Linux RHEL 4.x and it is working fine and able to send log to text file. Now I like to send the message to oracle database. [oracle@wkwasl02 etc]$ cat syslog-ng.conf @version: 3.0 options{ }; source gateway { unix-stream("/dev/log"); internal(); udp(ip(0.0.0.0)port(514)); }; source tcpgateway { unix-stream("/dev/log"); internal (); tcp(ip(0.0.0.0)port(514) max_connections(1000)); }; destination localhost { file("/var/log/syslog-ng.all"); }; destination tcplocalhost { file("/var/log/tcpsyslog-ng.all"); }; destination d_mysql { pipe("/opt/syslog-ng/var/mysql.pipe" template("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ('$HOST', '$FACILITY', '$PRORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG');\n") template-escape(yes)); }; destination d_oracle {pipe("/dev/ora.pipe"template("exec syslog.log ( '$HOST', '$FACILITY', '$PRIORITY', '$SEVERITY', '$TAG', to_date('$MONTH $DAY $HOUR:$MIN:$SEC', 'mm dd hh24:mi:ss'), '$PROGRAM', substr('$MSG',1,511));\n COMMIT;\n")template-escape(yes)); }; destination d_sql { sql(type(oracle) username("syslog") password("syslog") database("syslogNG") table("msgs_${R_YEAR}${R_MONTH}${R_DAY}") columns("datetime varchar(16)", "host varchar(32)", "program varchar(32)", "pid varchar(8)", "message varchar2") values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY") indexes("datetime", "host", "program", "pid", "message")); }; log { source(gateway);destination(localhost); }; log { source(tcpgateway);destination(tcplocalhost); }; log { source(tcpgateway);destination(d_mysql);destination(d_oracle);destinatio n(d_sql); }; [oracle@wkwasl02 etc]$ [root@wkwasl02 ~]# tail -f /var/log/tcpsyslog-ng.all Sep 29 11:20:01 wkwasl02 syslog-ng[32139]: No such DBI driver; type='oracle' Thanks Anisur Rehman Oman,muscat 0968-99826412