[syslog-ng] syslog-ng and oracle

Andreas Sartori andreas.sartori at fh-salzburg.ac.at
Wed Aug 12 13:35:54 CEST 2009

problem is solved. at the end of the post there are the spec files 
linked. if you like you can put them on your website.
i didnt want to use the cvs version from libdbi-drivers, but the latest 
stable one. (0.8.3-1).
2 patches are missing in the 0.8.3-1 release: a patch so the oracle 
stuff compiles and your commit patch. (they are included in the src.rpm 
files and on my website). i changed the spec files from libdbi and 
libdbi-drivers so everything compiles smooth under rhel 5.3 and centos 5.3.

compile instructions for syslogng + libdbi + oracle on centos/rhel 5.3 

- download latest (0.8.3) libdbi + libdbi-drivers from sourceforge
- download instantclient ( from oracle website 
- download syslog-ng_3.0.4.tar.gz (http://www.balabit.com/)

1) install oracleinstantclient (basic+sdk).
2) compile libdbi
3) compile libdbi-drivers (./configure 
--with-dbi-incdir=/usr/include/dbi --with-dbi-libdir=/usr/lib64 
--libdir=/usr/lib64 ... oracle, mysql,...)
    patch libdbi with "compile patch" and "oracle commit patch" (in this 
4) compile syslog-ng with --enable-sql (in spec file you can enable the 
--enable-debug for more debug information)
5) put the following into /etc/init.d/syslog-ng (somewhere at the top)
    export ORACLE_HOME=/usr/lib/oracle/
    export PATH=${PATH}:${ORACLE_HOME}/bin
6) you need a tnsnames.ora file (please read the syslog-ng documentation)

source rpm installation method:
1) rpmbuild --rebuild libdbi-0.8.3-1.src.rpm
2) rpm -ihv http://www.users.fh-salzburg.ac.at/~asartori/aconet/ 
3) rpmbuild --rebuild libdbi-drivers-0.8.3-1.src.rpm
4) rpm -ihv libdbi-drivers-0.8.3-1.x86_64.rpm 
5) rpmbuild --rebuild syslog-ng-3.0.4-1.src.rpm
6) rpm -ihv syslog-ng-3.0.4-1_fhs3.x86_64.rpm
7) change your init script and add the environment variables

thanks to balazs for giving me the final hint and for the "commit patch".

src.rpms, patches, and rpms are at 

Salzburg University of Applied Sciences

Andreas Sartori
Systems Engineer
IS - Information Services

Urstein Süd 1 | 5412 Puch/Salzburg | Austria
fon:  +43 (0)50-2211-1655 | fax: -1699
web: www.fh-salzburg.ac.at

Gerichtsstand Salzburg | FN166054y


More information about the syslog-ng mailing list