[syslog-ng] afsql module error

[Balazs Scheidler]

On Wed, 2011-03-09 at 08:04 +0100, Gergely Nagy wrote:
> Eshan Bhide <ebhide at globalgossip.net> writes:
> 
> >
> > 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'
>                                     ^^^^^^^^^^^^^^^
> 
> The problem lies here: while the module has been compiled, the DBI
> version is probably not fresh enough. I'd suggest compiling libdbi from
> CVS.
> 
> Can you tell us the libdbi version you're using? Sadly, there hasn't
> been an official libdbi release for quite some time now, so
> distributions might carry ancient versions.

Hmm. this is not the root cause, at least not in this specific error
message. dbi_result_free() is part of old and new libdbi alike.

It seems that the configure script somehow munged the detection of
libdbi and at the end libafsql.so didn't link against it.

Can you run an ldd on /usr/local/lib/syslog-ng/libafsql.so?

> 
> > Error parsing destination, destination plugin sql not found in
> > /usr/local/etc/syslog-ng.conf at line 61, column 3:
> >
> >   sql(type(mysql)
> >   ^^^
> >
> 
> [...snip...]
> 
> > Further to this, I get an error when trying to compile the 3.3.0alpha1
> > version:
> >
> >
> > make[7]: Entering directory
> > `/tmp/syslog-ng-3.3.0alpha1/lib/ivykis/lib/man3'
> > make[7]: *** No rule to make target `iv_deinit.3', needed by `all-am'.
> >  Stop.
> > make[7]: Leaving directory
> > `/tmp/syslog-ng-3.3.0alpha1/lib/ivykis/lib/man3'
> > make[6]: *** [all-recursive] Error 1
> > make[6]: Leaving directory `/tmp/syslog-ng-3.3.0alpha1/lib/ivykis/lib'
> > make[5]: *** [all-recursive] Error 1
> 
> The 3.3.0alpha1 tarball is sadly broken. This issue has since been fixed
> in git.
> 

-- 
Bazsi