[syslog-ng] syslog-ng and oracle

Andreas Sartori andreas.sartori at fh-salzburg.ac.at
Wed Aug 12 15:03:15 CEST 2009


hi balazs,

thats fine with me and thanks for the reference :)

-andy

On 08/12/2009 02:27 PM, Balazs Scheidler wrote:
> 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/
>>
>>      

-- 
___________________________________________
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!
___________________________________________



More information about the syslog-ng mailing list