<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">If you used
the pre-compiled syslog-ng rpm, it comes with its own location for the
libdbi-dbd-drivers files. You need to place the oracle driver in that
directory; /opt/syslog-ng/lib/dbd/.<br>
<br>
</font></font><br>
Sent: Friday, April 30, 2010 9:07:09 AM<br>
From: Dmitry Sedov <a class="moz-txt-link-rfc2396E" href="mailto:sda@rosenergo.com"><sda@rosenergo.com></a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a> <br>
Subject: [syslog-ng] syslog-ng can not work with oracle backend
<blockquote cite="mid:20100430150709.GB7136@x.rosenergo.com" type="cite">
<pre wrap=""> Hello!
I took stable binary rpm with open source syslog-ng version 3.0.6 on balabit.hu and install it on rhel 4u7. For some reason it does not want to work with oracle backend. I try next bekend description in syslog-ng.conf:
destination d_oracle_syslog {
sql(type(oracle)
username("login")
password("password")
database("database")
table("table")
columns("DATE varchar2(24)",
"facility number(2)",
"LEVEL number(1)",
"host varchar2(128)",
"program varchar2(64)",
"pid number(8)",
"message varchar2(1024)")
indexes( "DATE","facility","host")
);
};
And after start syslog-ng post in /var/log/messages notes about failure:
Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle'
Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle'
Apr 30 18:35:47 vm-dc-syslog syslog-ng[9815]: No such DBI driver; type='oracle'
After this issue appear, I compile libdbi and libdbi-drivers version 0.8.3. But it did not help: syslog-ng continue write "No such DBI driver; type='oracle'". And the same happens with the syslog-ng versions 3.1.1 and 3.1.0.
I install syslog-ng with binary rpm's from <a class="moz-txt-link-abbreviated" href="http://www.balabit.com">www.balabit.com</a>.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov.
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
</body>
</html>