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

[Patrick H.]

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 at rosenergo.com>
To: syslog-ng at 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
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100430/fb27fac3/attachment.htm