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 x86_64 - download latest (0.8.3) libdbi + libdbi-drivers from sourceforge - download instantclient (10.2.0.4) from oracle website (http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linu...) - 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 order) 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/10.2.0.4/client64 export PATH=${PATH}:${ORACLE_HOME}/bin export LD_LIBRARY_PATH=${ORACLE_HOME}/lib 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/ /usr/src/redhat/RPMS/x86_64/libdbi-devel-0.8.3-1.x86_64.rpm 3) rpmbuild --rebuild libdbi-drivers-0.8.3-1.src.rpm 4) rpm -ihv libdbi-drivers-0.8.3-1.x86_64.rpm libdbi-dbd-oracle-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 http://www.users.fh-salzburg.ac.at/~asartori/aconet/syslog-ng/ -- ___________________________________________ FACHHOCHSCHULE SALZBURG GmbH 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 WELCOME TO YOUR FUTURE! ___________________________________________