[syslog-ng] syslog-ng and oracle

[Balazs Scheidler]

Hi,

I'd prefer that you host these files, but can I reference them in a blog
post?

On Wed, 2009-08-12 at 13:35 +0200, Andreas Sartori wrote:
> 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/
> 
-- 
Bazsi