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