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

[Balazs Scheidler]

On Fri, 2010-04-30 at 19:07 +0400, Dmitry Sedov wrote:
> 	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.
> 

Well, the reason that Oracle driver is not supported is that we only
support free database engines in our OSE binary packages.

But the sources for our libdbi version are available here:

http://git.balabit.hu/

I have also sent our patches upstream, but I haven't tracked if they got
integrated or not. (some of them were, but I'm not sure if all of them).

Also, like Patrick H. said, the upcoming 3.2 has much better support for
transactions, thus should perform _way_ better.


-- 
Bazsi