[syslog-ng] syslog-ng and oracle

Andreas Sartori andreas.sartori at fh-salzburg.ac.at
Wed Aug 12 10:34:04 CEST 2009


hi balazs,

thanks for your response.

i recompiled the centos 5.3 libdbi-drivers package with oracle  support. 
version is libdbi-drivers-0.8.1a-1.2.2

i will try the cvs version.

-andy

>
> the backslash only comes to the console log (to escape the
> starting/ending quotes of the query='' tag of the log message) and is
> not included in the query as posted to Oracle.
>
> Hmm.. hmm, now as I think of it I had to patch the libdbi Oracle driver
> to make that work to auto-commit INSERTs, because by default oracle does
> not commit automatically.
>
> I've submitted those patches to upstream libdbi-drivers and seem to be
> included in the CVS repository, although I'm not sure if there was a
> release since then.
>
> Which libdbi-drivers version are you using? Can you try using their CVS
> version?
>
>    
>> this cant work sind oracle is not accepting \ as escape char, and in this
>> case we do not need an escape at all. the
>> sql syntax is right without the \.
>>
>> since templates are not working when using the sql driver, does anyone has
>> an idea how to fix that?
>> are we missing something?
>>
>> oracle setup is right, tnsnames or works and we can connect to the
>> database with sqlplus. the syslog-ng init script
>> as the environment variables set (ORACLE_HOME, LD_LIBRARY_PATH)
>>
>> thanks for any help
>>
>> -andy
>>
>>
>> ______________________________________________________________________________
>> 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/20090812/1768c56e/attachment-0001.htm 


More information about the syslog-ng mailing list