[syslog-ng] Syslog-NG/MySQL question

[Gergely Nagy]

James McDonald <jmcdonald at LCE.com> writes:

> [root at ustc-syslog2 ~]# /opt/syslog-ng/sbin/syslog-ng -V
[...]
> Available-Modules:
> afsql,license,afsocket-tls,afuser,tfjson,csvparser,affile,dbparser,rltp-prot
> o,afsocket-notls,dummy,confgen,aflogstore,basicfuncs,basic-proto,afsqlsource
> ,snmp,afsocket,syslogformat,disk-buffer,afprog,convertfuncs
[...]

> Does anyone know what needs to be edited/installed to have the line
> "Enable-SQL: on" be included in that output?

"Enable-SQL: on" will never appear there, because SQL support is done
entirely by the 'afsql' module (which is listed in the
Available-Modules, all versions of syslog-ng PE ship with it). The
"Enable-*" flags in that output are all things that modify the behaviour
or feature-set of either the core program, or of a module. None of them
are completely independently implemented, therefore they're displayed.

SQL support is a separate module, so it is not. syslog-ng PE binaries
ship with everything needed (on the syslog-ng side) for SQL support.

In previous versions of syslog-ng PE (4.0 and before), where SQL support
was not a module, but part of the core application like everything else,
the Enable-SQL thing made sense. With 4.1, this was removed, and
replaced by the afsql module.

If you have further questions regarding PE's SQL support, the guys at
support at balabit.com will gladly help ;)

-- 
|8]