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

[Dmitry Sedov]

	We have done workaround by installing syslog-ng and libdbi-drivers on rhel 5, as this described in this link:

https://lists.balabit.hu/pipermail/syslog-ng/2009-August/013260.html

	Thanks for your input,

	Dmitry Sedov.

On Fri, Apr 30, 2010 at 01:06:49PM -0600, Patrick H. wrote:
> You wont be able to compile syslog-ng 3 on a rhel4 without ugly changes 
> to the system (like glib). The easiest way is to just download the 
> oracle 0.8.1 driver and compile it instead of 0.8.3.
> 
> Sent: Friday, April 30, 2010 10:59:16 AM
> From: Dmitry Sedov <sda at rosenergo.com>
> To: Syslog-ng users' and developers' mailing list 
> <syslog-ng at lists.balabit.hu>
> Subject: Re: [syslog-ng] syslog-ng can not work with oracle backend
> >	Oracle driver was added to shared libraryes cache:
> >
> >[root at 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 at 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 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
> >>>
> >>> 
> >>>      
> >
> >  
> >>______________________________________________________________________________
> >>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
> >
> >  

> ______________________________________________________________________________
> 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
>