syslog-ng can not work with oracle backend
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 www.balabit.com. Tell me, please, how I may fix this issue. Regards, Dmitry Sedov.
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/. Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
Oracle driver was added to shared libraryes cache: [root@vm-dc-syslog doc]# ldconfig -p|grep dbi libdbi.so.0 (libc6) => /usr/local/libdbi/lib/libdbi.so.0 libdbi.so (libc6) => /usr/local/libdbi/lib/libdbi.so libdbdoracle.so (libc6) => /usr/local/libdbi-drivers/lib/dbd/libdbdoracle.so [root@vm-dc-syslog doc]# Now I hardlinked oracle driver to /opt/syslog-ng/lib/dbd/, but without success. Is it from difference of libdbi versions - in rpm and 0.8.3 compiled by me? I tried to compile syslog-ng from tarball and with same libdbi as in oracle driver case, but 'configure' cancel his work with strange error: checking for GLIB - version >= 2.10.1... no *** A new enough version of pkg-config was not found. *** See http://www.freedesktop.org/software/pkgconfig/ configure: error: Cannot find GLIB version >= 2.10.1: is pkg-config in path? Regards, Dmitry Sedov. On Fri, Apr 30, 2010 at 09:53:42AM -0600, Patrick H. wrote:
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/.
Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
You wont be able to compile syslog-ng 3 on a rhel4 without ugly changes to the system (like glib). The easiest way is to just download the oracle 0.8.1 driver and compile it instead of 0.8.3. Sent: Friday, April 30, 2010 10:59:16 AM From: Dmitry Sedov <sda@rosenergo.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng] syslog-ng can not work with oracle backend
Oracle driver was added to shared libraryes cache:
[root@vm-dc-syslog doc]# ldconfig -p|grep dbi libdbi.so.0 (libc6) => /usr/local/libdbi/lib/libdbi.so.0 libdbi.so (libc6) => /usr/local/libdbi/lib/libdbi.so libdbdoracle.so (libc6) => /usr/local/libdbi-drivers/lib/dbd/libdbdoracle.so [root@vm-dc-syslog doc]#
Now I hardlinked oracle driver to /opt/syslog-ng/lib/dbd/, but without success. Is it from difference of libdbi versions - in rpm and 0.8.3 compiled by me?
I tried to compile syslog-ng from tarball and with same libdbi as in oracle driver case, but 'configure' cancel his work with strange error:
checking for GLIB - version >= 2.10.1... no *** A new enough version of pkg-config was not found. *** See http://www.freedesktop.org/software/pkgconfig/ configure: error: Cannot find GLIB version >= 2.10.1: is pkg-config in path?
Regards,
Dmitry Sedov.
On Fri, Apr 30, 2010 at 09:53:42AM -0600, Patrick H. wrote:
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/.
Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
We have done workaround by installing syslog-ng and libdbi-drivers on rhel 5, as this described in this link: https://lists.balabit.hu/pipermail/syslog-ng/2009-August/013260.html Thanks for your input, Dmitry Sedov. On Fri, Apr 30, 2010 at 01:06:49PM -0600, Patrick H. wrote:
You wont be able to compile syslog-ng 3 on a rhel4 without ugly changes to the system (like glib). The easiest way is to just download the oracle 0.8.1 driver and compile it instead of 0.8.3.
Sent: Friday, April 30, 2010 10:59:16 AM From: Dmitry Sedov <sda@rosenergo.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng] syslog-ng can not work with oracle backend
Oracle driver was added to shared libraryes cache:
[root@vm-dc-syslog doc]# ldconfig -p|grep dbi libdbi.so.0 (libc6) => /usr/local/libdbi/lib/libdbi.so.0 libdbi.so (libc6) => /usr/local/libdbi/lib/libdbi.so libdbdoracle.so (libc6) => /usr/local/libdbi-drivers/lib/dbd/libdbdoracle.so [root@vm-dc-syslog doc]#
Now I hardlinked oracle driver to /opt/syslog-ng/lib/dbd/, but without success. Is it from difference of libdbi versions - in rpm and 0.8.3 compiled by me?
I tried to compile syslog-ng from tarball and with same libdbi as in oracle driver case, but 'configure' cancel his work with strange error:
checking for GLIB - version >= 2.10.1... no *** A new enough version of pkg-config was not found. *** See http://www.freedesktop.org/software/pkgconfig/ configure: error: Cannot find GLIB version >= 2.10.1: is pkg-config in path?
Regards,
Dmitry Sedov.
On Fri, Apr 30, 2010 at 09:53:42AM -0600, Patrick H. wrote:
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/.
Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
Just FYI, the patches in that post are REALLY bad. They dont use optimized queries and every single insert statement performs a commit. If you will be doing a high amount of transactions, this will devour your database's processing power. Also as that patch is for libdbi, it will affect every single thing that uses libdbi, not just syslog-ng. See https://bugzilla.balabit.com/show_bug.cgi?id=73. Syslog-ng 3.2 will have changes in it that make those patches unnecessary. Sent: Wednesday, May 05, 2010 10:20:21 AM From: Dmitry Sedov <sda@rosenergo.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng] syslog-ng can not work with oracle backend
We have done workaround by installing syslog-ng and libdbi-drivers on rhel 5, as this described in this link:
https://lists.balabit.hu/pipermail/syslog-ng/2009-August/013260.html
Thanks for your input,
Dmitry Sedov.
On Fri, Apr 30, 2010 at 01:06:49PM -0600, Patrick H. wrote:
You wont be able to compile syslog-ng 3 on a rhel4 without ugly changes to the system (like glib). The easiest way is to just download the oracle 0.8.1 driver and compile it instead of 0.8.3.
Sent: Friday, April 30, 2010 10:59:16 AM From: Dmitry Sedov <sda@rosenergo.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng] syslog-ng can not work with oracle backend
Oracle driver was added to shared libraryes cache:
[root@vm-dc-syslog doc]# ldconfig -p|grep dbi libdbi.so.0 (libc6) => /usr/local/libdbi/lib/libdbi.so.0 libdbi.so (libc6) => /usr/local/libdbi/lib/libdbi.so libdbdoracle.so (libc6) => /usr/local/libdbi-drivers/lib/dbd/libdbdoracle.so [root@vm-dc-syslog doc]#
Now I hardlinked oracle driver to /opt/syslog-ng/lib/dbd/, but without success. Is it from difference of libdbi versions - in rpm and 0.8.3 compiled by me?
I tried to compile syslog-ng from tarball and with same libdbi as in oracle driver case, but 'configure' cancel his work with strange error:
checking for GLIB - version >= 2.10.1... no *** A new enough version of pkg-config was not found. *** See http://www.freedesktop.org/software/pkgconfig/ configure: error: Cannot find GLIB version >= 2.10.1: is pkg-config in path?
Regards,
Dmitry Sedov.
On Fri, Apr 30, 2010 at 09:53:42AM -0600, Patrick H. wrote:
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/.
Sent: Friday, April 30, 2010 9:07:09 AM From: Dmitry Sedov <sda@rosenergo.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] syslog-ng can not work with oracle backend
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Regards,
Dmitry Sedov. ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
On Fri, 2010-04-30 at 19:07 +0400, Dmitry Sedov wrote:
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 www.balabit.com.
Tell me, please, how I may fix this issue.
Well, the reason that Oracle driver is not supported is that we only support free database engines in our OSE binary packages. But the sources for our libdbi version are available here: http://git.balabit.hu/ I have also sent our patches upstream, but I haven't tracked if they got integrated or not. (some of them were, but I'm not sure if all of them). Also, like Patrick H. said, the upcoming 3.2 has much better support for transactions, thus should perform _way_ better. -- Bazsi
participants (3)
-
Balazs Scheidler
-
Dmitry Sedov
-
Patrick H.