[syslog-ng] afsql module error

[Eshan Bhide]

Hi thanks for replying Robert, I did use the --enable-sql switch when
compiling from source, following is the output of syslog-ng --version:

syslog-ng --version
syslog-ng 3.2.2
Installer-Version: 3.2.2
Revision: ssh+git://bazsi@git.balabit
//var/scm/git/syslog-ng/syslog-ng-ose--mainline--3.2#master#1d3f396485eb47b1ff6aa18ac4f1c4cd51c0ea4c
Compile-Date: Mar  7 2011 20:13:29
Enable-Threads: on
Enable-Debug: off
Enable-GProf: off
Enable-Memtrace: off
Enable-Sun-STREAMS: off
Enable-IPv6: on
Enable-Spoof-Source: on
Enable-TCP-Wrapper: on
Enable-SSL: on
Enable-SQL: on
Enable-Linux-Caps: off
Enable-Pcre: off
Enable-Pacct: off


I'm trying the binary of 3.3.0alpha1 from the website and will report back
if it works :)

Cheers,
Eshan



On 8 March 2011 19:23, Fekete Robert <frobert at balabit.hu> wrote:

> Hi, try running the 'syslog-ng --version' command and verify that your
> binary
> was compiled with SQL-support enabled.
> If not, you need to recompile syslog-ng, or use a binary from the balabit
> website:
>
> http://www.balabit.com/network-security/syslog-ng/opensource-logging-system/downloads/upgrade
>
> Regards,
>
> Robert
>
> On 03/08/2011 08:16 AM, Eshan Bhide wrote:
>
> > Hi guys,
> >
> > I'm trying to setup a master syslog-ng server which listens on UDP syslog
> port
> > to incoming squid access log and Cisco syslog messages. It uses a
> db_parser to
> > parse and store these access logs in different variables. I now need to
> store
> > these values in a simple mysql database. I have created the database
> schema and
> > thought of using a pipe and a wrapper script to write the query. But read
> that
> > there are problems sometimes with this approach.
> > I then thought about doing it using libddb and downloaded the
> > package syslog-ng_3.2.2 from the website.
> >
> > So far so good, but when I try to run syslog-ng it gives me an error:
> >
> >   syslog-ng
> > Error opening plugin module; module='afsql',
> > error='/usr/local/lib/syslog-ng/libafsql.so: undefined symbol:
> dbi_result_free'
> > Error opening plugin module; module='afsql',
> > error='/usr/local/lib/syslog-ng/libafsql.so: undefined symbol:
> dbi_result_free'
> > Error parsing destination, destination plugin sql not found in
> > /usr/local/etc/syslog-ng.conf at line 61, column 3:
> >
> >    sql(type(mysql)
> >    ^^^
> >
> > Any pointers on what I'm missing here ? I have commented out the '@module
> afsql'
> >   line in modules.conf, have made sure I've got the latest libdb and
> libdb-devel
> > packages. I'm running CentOS 5.x and just don't know how to proceed :(
> > Appreciate all and any help guys thank you.
> >
> >
> >
> > --
> > Eshan Bhide
> > Engineer, Core Infrastructure and Systems Development
> > Global Gossip
> >
> > 14 Wentworth Ave
> > Surry Hills, NSW 2010 Australia
> >
> > -------------------------------------------------
> >
> > IMPORTANT NOTICE : The information in this email is confidential and may
> also be privileged.
> > If you are not the intended recipient, any use or dissemination of the
> information and any
> > disclosure or copying of this email is unauthorised and strictly
> prohibited. If you have received
> > this email in error, please promptly inform us by reply email or
> telephone. You should also delete
> > this email and destroy any hard copies produced.
> >
> >
> >
> >
> >
> ______________________________________________________________________________
> > 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
>
>

-------------------------------------------------

IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. 
If you are not the intended recipient, any use or dissemination of the information and any
disclosure or copying of this email is unauthorised and strictly prohibited. If you have received
this email in error, please promptly inform us by reply email or telephone. You should also delete
this email and destroy any hard copies produced.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110309/7830147e/attachment-0001.htm