ports/144855: [patch] syslog-ng3 port Makefile lacks sql-enable support

[Yavuz GOKIRMAK]

>Number:         144855
>Category:       ports
>Synopsis:       [patch] syslog-ng3 port Makefile lacks sql-enable support
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Thu Mar 18 13:40:06 UTC 2010
>Closed-Date:
>Last-Modified:
>Originator:     Yavuz GOKIRMAK
>Release:        FreeBSD 8.0-RELEASE #0
>Organization:
-
>Environment:
FreeBSD XXX 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Tue Feb 16 08:40:03 EET 2010     root at xxx.xxx.com.tr:/usr/src/sys/i386/compile/VIMAGE  i386
>Description:
syslog-ng3 gives support for inserting logs directly into a sql database. But this option is disabled in default:

#syslog-ng --version
syslog-ng 3.0.3
Revision: ssh+git://bazsi@git.balabit//var/scm/git/syslog-ng/syslog-ng-ose--mainline--3.0#master#08c9bf9d98e4e021756adc12c42605840140ba8b
Compile-Date: Mar 18 2010 15:24:50
Enable-Threads: off
Enable-Debug: off
Enable-GProf: off
Enable-Memtrace: off
Enable-Sun-STREAMS: off
Enable-Sun-Door: off
Enable-IPv6: on
Enable-Spoof-Source: on
Enable-TCP-Wrapper: on
Enable-SSL: on
Enable-SQL: off
Enable-Linux-Caps: off
Enable-Pcre: off

To enable sql /usr/ports/sysutils/syslog-ng3/Makefile should be modified.

>How-To-Repeat:
# cd /usr/ports/sysutils/syslog-ng3
# make config

There is no option to enable sql.
>Fix:
A patch file is attached.

1. WITH_SQL option is defined
2. If sql is enabled, libdbi is added as LIB_DEPENDS


Patch attached with submission follows:

--- /usr/ports/sysutils/syslog-ng3/Makefile	2010-01-25 08:16:52.000000000 +0200
+++ /usr/ports/sysutils/syslog-ng3/Makefile.patched	2010-03-18 15:15:47.000000000 +0200
@@ -17,7 +17,8 @@
 COMMENT=	A powerful syslogd replacement
 
 OPTIONS=	SSL "Build with OpenSSL support (requires >= 7.x)" on \
-		TCP_WRAPPERS "Build with TCP Wrappers" off 
+		TCP_WRAPPERS "Build with TCP Wrappers" off \
+		SQL "Build with Sql support" off
 
 BUILD_DEPENDS=	${LIBNET_CONFIG}:${PORTSDIR}/net/libnet
 LIB_DEPENDS=	evtlog.0:${PORTSDIR}/sysutils/eventlog
@@ -40,6 +41,8 @@
 CONFIGURE_ENV=	CFLAGS="`${LIBNET_CONFIG} --cflags` ${CFLAGS}" \
 		LDFLAGS="`${LIBNET_CONFIG} --libs` ${LDFLAGS}" 
 
+.include <bsd.port.options.mk>
+
 .if defined (WITH_SSL)
 CONFIGURE_ENV+=	OPENSSL_CFLAGS="${OPENSSL_CFLAGS}" \
 		OPENSSL_LIBS="${OPENSSL_LDFLAGS} -lcrypto -lssl"
@@ -49,6 +52,13 @@
 CONFIGURE_ARGS+=--enable-tcp-wrapper
 .endif
 
+.if defined(WITH_SQL)
+CONFIGURE_ARGS+=--enable-sql
+LIB_DEPENDS+= dbi.0:${PORTSDIR}/databases/libdbi
+CONFIGURE_ENV+= LIBDBI_CFLAGS="-I/usr/local/include" \
+		LIBDBI_LIBS=" -ldbi"
+.endif
+
 .include <bsd.port.pre.mk>
 
 post-patch:


>Release-Note:
>Audit-Trail:
>Unformatted: