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

Patrick H. syslogng at feystorm.net
Wed May 5 19:02:40 CEST 2010 

Just FYI, the patches in that post are REALLY bad. They dont use 
optimized queries and every single insert statement performs a commit. 
If you will be doing a high amount of transactions, this will devour 
your database's processing power.
Also as that patch is for libdbi, it will affect every single thing that 
uses libdbi, not just syslog-ng.
See https://bugzilla.balabit.com/show_bug.cgi?id=73. Syslog-ng 3.2 will 
have changes in it that make those patches unnecessary.



Sent: Wednesday, May 05, 2010 10:20:21 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
> 	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
>>
>>     
>
> ______________________________________________________________________________
> 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/20100505/9ffc38c1/attachment.htm

More information about the syslog-ng mailing list