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