[syslog-ng] syslog-ng can not work with oracle backend

Dmitry Sedov sda at rosenergo.com
Fri Apr 30 17:07:09 CEST 2010


	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.


More information about the syslog-ng mailing list