ports/89418: [update] mail/sqlgrey from 1.4.8 to 1.6.7

Tue Nov 22 14:31:18 UTC 2005

>Number:         89418
>Category:       ports
>Synopsis:       [update] mail/sqlgrey from 1.4.8 to 1.6.7
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Tue Nov 22 14:30:20 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Denis Peplin
>Release:        FreeBSD 4.11-STABLE i386
>Organization:
>Environment:
System: FreeBSD freefall.freebsd.org 4.11-STABLE FreeBSD 4.11-STABLE #16: Sat Feb 26 00:02:03 GMT 2005 kensmith at freefall.freebsd.org:/c/src/sys/compile/FREEFALL i386


	
>Description:
	Updating from old stable release to new one.
>How-To-Repeat:
	
>Fix:

diff -urN sqlgrey.old/Makefile sqlgrey/Makefile

--- sqlgrey.old/Makefile	Wed Jul  6 21:05:15 2005
+++ sqlgrey/Makefile	Tue Nov 22 13:49:10 2005
@@ -6,7 +6,7 @@
 #
 
 PORTNAME=	sqlgrey
-PORTVERSION=	1.4.8
+PORTVERSION=	1.6.7
 CATEGORIES=	mail
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
 MASTER_SITE_SUBDIR=	${PORTNAME}
@@ -32,7 +32,7 @@
 NO_BUILD=	yes
 USE_REINPLACE=	yes
 
-ETCFILES=	clients_fqdn_whitelist clients_ip_whitelist sqlgrey.conf
+ETCFILES=	clients_fqdn_whitelist clients_ip_whitelist dyn_fqdn.regexp smtp_server.regexp sqlgrey.conf
 SGY_USERNAME?=	sqlgrey
 SGY_GROUPNAME?=	${SGY_USERNAME}
 ETCDIR?=	etc/sqlgrey
@@ -48,7 +48,7 @@
 MAN1=	sqlgrey.1
 
 .if !defined(NOPORTDOCS)
-PORTDOCS=	Changelog FAQ HOWTO README TODO db_performance_reports
+PORTDOCS=	Changelog FAQ HOWTO README TODO
 .endif
 
 pre-everything::
@@ -59,14 +59,15 @@
 	@${REINPLACE_CMD} -e 's-#!/usr/bin/perl-#!${PERL}-' -e 's!/etc/sqlgrey!${PREFIX}/${ETCDIR}!g' ${WRKSRC}/sqlgrey
 
 do-install:
+	@${INSTALL_SCRIPT} ${WRKSRC}/sqlgrey-logstats.pl ${PREFIX}/bin
 	@${INSTALL_SCRIPT} ${WRKSRC}/sqlgrey ${PREFIX}/sbin
-	@${INSTALL_SCRIPT} ${WRKSRC}/update_sqlgrey_whitelists ${PREFIX}/sbin
+	@${INSTALL_SCRIPT} ${WRKSRC}/update_sqlgrey_config ${PREFIX}/sbin
 	@${INSTALL_SCRIPT} ${WRKDIR}/sqlgrey.sh ${PREFIX}/etc/rc.d
 	@cd ${WRKSRC} && perldoc -u sqlgrey | pod2man sqlgrey > ${MANPREFIX}/man/man1/sqlgrey.1
 	@${MKDIR} ${PREFIX}/${ETCDIR}
 .for i in ${ETCFILES}
 	@${INSTALL_DATA} ${WRKSRC}/etc/${i} ${PREFIX}/${ETCDIR}/${i}.dist
-	@[ "${i}" = "sqlgrey.conf" ] || ${TOUCH} ${PREFIX}/${ETCDIR}/${i}.local
+	@[ "${i}" = "dyn_fqdn.regexp" ] || [ "${i}" = "smtp_server.regexp" ] || [ "${i}" = "sqlgrey.conf" ] || ${TOUCH} ${PREFIX}/${ETCDIR}/${i}.local
 	@[ -f ${PREFIX}/${ETCDIR}/${i} ] || ${INSTALL_DATA} ${WRKSRC}/etc/${i} ${PREFIX}/${ETCDIR}/${i}
 .endfor
 .if !defined(NOPORTDOCS)
diff -urN sqlgrey.old/distinfo sqlgrey/distinfo
--- sqlgrey.old/distinfo	Tue Nov 22 13:26:21 2005
+++ sqlgrey/distinfo	Tue Nov 22 14:04:17 2005
@@ -1,3 +1,3 @@
-MD5 (sqlgrey-1.4.8.tar.bz2) = 09be0d578b7f6ad7099403654441ee49
-SHA256 (sqlgrey-1.4.8.tar.bz2) = 508fb4eb771816c0adcdff27e7e3924a0cb7d89dcefaa65c067e52f5d6b58fac
-SIZE (sqlgrey-1.4.8.tar.bz2) = 31068
+MD5 (sqlgrey-1.6.7.tar.bz2) = 3490567366eee97248eb9416067b79a4
+SHA256 (sqlgrey-1.6.7.tar.bz2) = f67b76799af93617f09a16bd7d5141b607d9952067fbb669f25bc3aa17bd7df5
+SIZE (sqlgrey-1.6.7.tar.bz2) = 42633
diff -urN sqlgrey.old/files/sqlgrey.sh.in sqlgrey/files/sqlgrey.sh.in
--- sqlgrey.old/files/sqlgrey.sh.in	Mon May 23 18:27:20 2005
+++ sqlgrey/files/sqlgrey.sh.in	Tue Nov 22 13:48:01 2005
@@ -18,7 +18,7 @@
 . %%RC_SUBR%%
 
 name=sqlgrey
-rcvar=`set_rcvar`
+load_rc_config sqlgrey
 
 command=%%PREFIX%%/sbin/sqlgrey
 extra_commands=reload
@@ -34,14 +34,8 @@
 # set defaults
 
 sqlgrey_enable=${sqlgrey_enable:-"NO"}
-sqlgrey_pidfile=${sqlgrey_pidfile:-"/var/run/sqlgrey.pid"}
-sqlgrey_listen=${sqlgrey_listen:-"2501"}
 sqlgrey_config=${sqlgrey_config:-"/usr/local/%%ETCDIR%%/sqlgrey.conf"}
-sqlgrey_flags=${sqlgrey_flags:-"--pidfile=${sqlgrey_pidfile} \
-	--inet=${sqlgrey_listen} --daemonize --user=sqlgrey --group=sqlgrey \
-	--configfile=${sqlgrey_config}"}
-
-pidfile="${sqlgrey_pidfile}"
+sqlgrey_flags=${sqlgrey_flags:-"--daemonize --configfile=${sqlgrey_config}"}
 
 load_rc_config $name
 run_rc_command "$1"
diff -urN sqlgrey.old/pkg-plist sqlgrey/pkg-plist
--- sqlgrey.old/pkg-plist	Fri Feb 18 14:39:31 2005
+++ sqlgrey/pkg-plist	Tue Nov 22 13:48:01 2005
@@ -2,6 +2,8 @@
 @unexec [ -e %D/%%ETCDIR%%/clients_fqdn_whitelist.local -a ! -s %D/%%ETCDIR%%/clients_fqdn_whitelist.local ] && rm -f %D/%%ETCDIR%%/clients_fqdn_whitelist.local
 @unexec if cmp -s %D/%%ETCDIR%%/clients_ip_whitelist.dist %D/%%ETCDIR%%/clients_ip_whitelist; then rm -f %D/%%ETCDIR%%/clients_ip_whitelist; fi
 @unexec [ -e %D/%%ETCDIR%%/clients_ip_whitelist.local -a ! -s %D/%%ETCDIR%%/clients_ip_whitelist.local ] && rm -f %D/%%ETCDIR%%/clients_ip_whitelist.local
+ at unexec if cmp -s %D/%%ETCDIR%%/dyn_fqdn.regexp.dist %D/%%ETCDIR%%/dyn_fqdn.regexp; then rm -f %D/%%ETCDIR%%/dyn_fqdn.regexp; fi
+ at unexec if cmp -s %D/%%ETCDIR%%/smtp_server.regexp.dist %D/%%ETCDIR%%/smtp_server.regexp; then rm -f %D/%%ETCDIR%%/smtp_server.regexp; fi
 @unexec if cmp -s %D/%%ETCDIR%%/sqlgrey.conf.dist %D/%%ETCDIR%%/sqlgrey.conf; then rm -f %D/%%ETCDIR%%/sqlgrey.conf; fi
 %%ETCDIR%%/clients_fqdn_whitelist.dist
 @exec [ -f %B/clients_fqdn_whitelist ] || cp %B/%f %B/clients_fqdn_whitelist
@@ -9,9 +11,14 @@
 %%ETCDIR%%/clients_ip_whitelist.dist
 @exec [ -f %B/clients_ip_whitelist ] || cp %B/%f %B/clients_ip_whitelist
 @exec [ -f %B/clients_ip_whitelist.local ] || %%TOUCH%% %B/clients_ip_whitelist.local
+%%ETCDIR%%/dyn_fqdn.regexp.dist
+%%ETCDIR%%/smtp_server.regexp.dist
 %%ETCDIR%%/sqlgrey.conf.dist
+ at exec [ -f %B/dyn_fqdn.regexp.dist ] || cp %B/%f %B/dyn_fqdn.regexp.dist
+ at exec [ -f %B/smtp_server.regexp.dist ] || cp %B/%f %B/smtp_server.regexp.dist
 @exec [ -f %B/sqlgrey.conf ] || cp %B/%f %B/sqlgrey.conf
+bin/sqlgrey-logstats.pl
 sbin/sqlgrey
-sbin/update_sqlgrey_whitelists
+sbin/update_sqlgrey_config
 @unexec rmdir %D/%%DATADIR%% 2>/dev/null || true
 @unexec rmdir %D/%%ETCDIR%% 2>/dev/null || true
>Release-Note:
>Audit-Trail:
>Unformatted:

