If you used the pre-compiled syslog-ng rpm, it comes with its own location for the libdbi-dbd-drivers files. You need to place the oracle driver in that directory; /opt/syslog-ng/lib/dbd/. Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
Hello!
I took stable binary rpm with open source syslog-ng version 3.0.6 on balabit.hu and install it on rhel 4u7. For some reason it does not want to work with oracle backend. I try next bekend description in syslog-ng.conf:
destination d_oracle_syslog { sql(type(oracle) username("login") password("password") database("database") table("table") columns("DATE varchar2(24)", "facility number(2)", "LEVEL number(1)", "host varchar2(128)", "program varchar2(64)", "pid number(8)", "message varchar2(1024)") indexes( "DATE","facility","host") ); };
And after start syslog-ng post in /var/log/messages notes about failure:
Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle' Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle' Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle'
After this issue appear, I compile libdbi and libdbi-drivers version 0.8.3. But it did not help: syslog-ng continue write "No such DBI driver; type='oracle'". And the same happens with the syslog-ng versions 3.1.1 and 3.1.0.
I install syslog-ng with binary rpm's from www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html