[syslog-ng]Syslog -> Oracle Database

[Rhugga]

--- Shane Presley <shane.presley@gmail.com> wrote:

> So I am considering moving my syslog-ng entries into Oracle.  I've
> found the scripts to do that, but still working with our DBAs on it. 
> One question I had, do we need an Oracle client on the syslog-ng
> server?
> 
> With MySQL you can connect to a remote SQL server using the script
> directly.  The Oracle scripts also seem to reference an Oracle Server
> and port.  But my Oracle DBA's seem to think they have to install the
> Oracle client.
> 
> Anyone done this before to a remote Oracle server?
> 
> Thanks
> Shane
> _______________________________________________
> syslog-ng maillist  -  syslog-ng@lists.balabit.hu
> https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
> 
> 

You will need the libclntsh.so client library at a minimum. If these scripts you are referring to
are perl, you will also need the DBD-Oracle module (and this module will require linking against
the oracle library). (I assume since it works with mysql that you are using perl since the mysql
perl modules normally come default with linux now days)

Personally I use just a plain simple bash script that calls sqlplus (using sqlplus will require a
larger oracle client installation) to load my logs into oracle. Perl and its cludge or modules has
gotten so sloppy these days I tend to use it as a last resort for anything.

CC