[syslog-ng] syslog-ng and oracle

[Andreas Sartori]

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/linuxx86_64soft.html)
- 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!
___________________________________________