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

30 Apr 2010

      Oracle driver was added to shared libraryes cache:

[root@vm-dc-syslog doc]# ldconfig -p|grep dbi
        libdbi.so.0 (libc6) => /usr/local/libdbi/lib/libdbi.so.0
        libdbi.so (libc6) => /usr/local/libdbi/lib/libdbi.so
        libdbdoracle.so (libc6) => /usr/local/libdbi-drivers/lib/dbd/libdbdoracle.so
[root@vm-dc-syslog doc]#

	Now I hardlinked oracle driver to /opt/syslog-ng/lib/dbd/, but without success. Is it from difference of libdbi versions - in rpm and 0.8.3 compiled by me?

	I tried to compile syslog-ng from tarball and with same libdbi as in oracle driver case, but 'configure' cancel his work with strange error:

checking for GLIB - version >= 2.10.1... no
*** A new enough version of pkg-config was not found.
*** See http://www.freedesktop.org/software/pkgconfig/
configure: error: Cannot find GLIB version >= 2.10.1: is pkg-config in path?

	Regards,

	Dmitry Sedov.

On Fri, Apr 30, 2010 at 09:53:42AM -0600, Patrick H. wrote:
...
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
...
______________________________________________________________________________
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