From owner-freebsd-ports-bugs@FreeBSD.ORG Sat May 13 17:20:12 2006 Return-Path: X-Original-To: freebsd-ports-bugs@hub.freebsd.org Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3ADD116A4F8 for ; Sat, 13 May 2006 17:20:12 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4A49F43D5C for ; Sat, 13 May 2006 17:20:10 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id k4DHKAjj099031 for ; Sat, 13 May 2006 17:20:10 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id k4DHKAnJ099030; Sat, 13 May 2006 17:20:10 GMT (envelope-from gnats) Resent-Date: Sat, 13 May 2006 17:20:10 GMT Resent-Message-Id: <200605131720.k4DHKAnJ099030@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Larry Rosenman Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 46F7516A46F for ; Sat, 13 May 2006 17:19:08 +0000 (UTC) (envelope-from root@lerctr.org) Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by mx1.FreeBSD.org (Postfix) with ESMTP id DCA4043D49 for ; Sat, 13 May 2006 17:19:07 +0000 (GMT) (envelope-from root@lerctr.org) Received: from root by thebighonker.lerctr.org with local (Exim 4.62 (FreeBSD)) (envelope-from ) id 1Fexlj-000A3o-LJ for FreeBSD-gnats-submit@freebsd.org; Sat, 13 May 2006 12:19:07 -0500 Message-Id: Date: Sat, 13 May 2006 12:19:07 -0500 From: Larry Rosenman To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/97213: [MAINTAINER] [PATCH] mail/exilog: PG Friendly, portlint X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 13 May 2006 17:20:12 -0000 >Number: 97213 >Category: ports >Synopsis: [MAINTAINER] [PATCH] mail/exilog: PG Friendly, portlint >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: maintainer-update >Submitter-Id: current-users >Arrival-Date: Sat May 13 17:20:09 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Larry Rosenman >Release: FreeBSD 6.1-STABLE amd64 >Organization: >Environment: System: FreeBSD thebighonker.lerctr.org 6.1-STABLE FreeBSD 6.1-STABLE #54: Sat May 13 10:21:24 CDT 2006 >Description: this supercedes ports/97206, as I realized portlint(1) needed petting :) This makes mail/exilog more PostgreSQL friendly, and also handles current portlint(1) complaints. Added file(s): - files/exilog.sh.in - files/patch-exilog_sql.pm Removed file(s): - files/exilog.sh Generated with FreeBSD Port Tools 0.77 >How-To-Repeat: >Fix: --- exilog-0.5_3.patch begins here --- diff -ruN --exclude=CVS /usr/ports/mail/exilog/Makefile /usr/home/ler/ports/exilog/Makefile --- /usr/ports/mail/exilog/Makefile Sat May 13 09:13:02 2006 +++ /usr/home/ler/ports/exilog/Makefile Sat May 13 12:13:44 2006 @@ -7,7 +7,7 @@ PORTNAME= exilog PORTVERSION= 0.5 -PORTREVISION= 2 +PORTREVISION= 3 CATEGORIES= mail MASTER_SITES= http://duncanthrax.net/exilog/ @@ -29,9 +29,9 @@ RUN_DEPENDS+= ${SITE_PERL}/${PERL_ARCH}/DBD/mysql.pm:${PORTSDIR}/databases/p5-DBD-mysql .elif (${WITH_SQL_BACKEND} == "postgresql") WITH_POSTGRESQL= yes -RUN_DEPENDS+= ${SITE_PERL}/${PERL_ARCH}/DBD/pg.pm:${PORTSDIR}/databases/p5-DBD-Pg +RUN_DEPENDS+= ${SITE_PERL}/${PERL_ARCH}/DBD/Pg.pm:${PORTSDIR}/databases/p5-DBD-Pg .else -BROKEN= "You should specify sql backend using WITH_SQL_BACKEND" +BROKEN= You should specify sql backend using WITH_SQL_BACKEND .endif .ifndef WITHOUT_WWWDIR @@ -43,7 +43,7 @@ .if defined(NO_AGENT) PLIST_SUB+= AGENT="@comment " .else -USE_RC_SUBR= yes +USE_RC_SUBR= exilog.sh PLIST_SUB+= AGENT="" .endif @@ -60,15 +60,13 @@ @${REINPLACE_CMD} -e 's,$$RealBin/exilog.conf,${PREFIX}/etc/exilog.conf,' ${WRKSRC}/exilog_config.pm @${REINPLACE_CMD} -e "s,\(use exilog_config\),use lib \'${EXILOGDIR}\'; \1," ${WRKSRC}/exilog_agent.pl @${REINPLACE_CMD} -e "s,\(use exilog_config\),use lib \'${EXILOGDIR}\'; \1," ${WRKSRC}/exilog_cleanup.pl - @${SED} -e 's,%%RC_SUBR%%,${RC_SUBR},' \ - -e 's,%%PREFIX%%,${PREFIX},' ${FILESDIR}/exilog.sh > ${WRKDIR}/exilog.sh do-install: @${MKDIR} ${EXILOGDIR} @${MKDIR} ${EXILOGDIR}/icons @${CP} ${WRKSRC}/*.pm ${WRKSRC}/*.css ${WRKSRC}/*.js ${EXILOGDIR} @${CP} ${WRKSRC}/icons/* ${EXILOGDIR}/icons - + .if !defined(NO_AGENT) @${INSTALL_SCRIPT} ${WRKSRC}/exilog_agent.pl ${PREFIX}/sbin .endif diff -ruN --exclude=CVS /usr/ports/mail/exilog/files/exilog.sh /usr/home/ler/ports/exilog/files/exilog.sh --- /usr/ports/mail/exilog/files/exilog.sh Sat Jan 14 15:01:23 2006 +++ /usr/home/ler/ports/exilog/files/exilog.sh Wed Dec 31 18:00:00 1969 @@ -1,25 +0,0 @@ -#!/bin/sh -# -# $FreeBSD: ports/mail/exilog/files/exilog.sh,v 1.2 2005/11/03 13:43:00 vsevolod Exp $ -# -# Add the following lines to /etc/rc.conf to enable exilog agent: -# -#exilog_enable="YES" -# -# also uncomment 'use_pretty_names' => 'no' in exilog.conf file - -. %%RC_SUBR%% - -name=exilog -rcvar=`set_rcvar` - -command=%%PREFIX%%/sbin/exilog_agent.pl -pidfile=/var/run/exilog.pid -required_files=%%PREFIX%%/etc/exilog.conf -command_interpreter=/usr/bin/perl - -# read settings, set default values -load_rc_config $name -: ${exilog_enable="NO"} - -run_rc_command "$1" diff -ruN --exclude=CVS /usr/ports/mail/exilog/files/exilog.sh.in /usr/home/ler/ports/exilog/files/exilog.sh.in --- /usr/ports/mail/exilog/files/exilog.sh.in Wed Dec 31 18:00:00 1969 +++ /usr/home/ler/ports/exilog/files/exilog.sh.in Sat Jan 14 15:01:23 2006 @@ -0,0 +1,25 @@ +#!/bin/sh +# +# $FreeBSD: ports/mail/exilog/files/exilog.sh,v 1.2 2005/11/03 13:43:00 vsevolod Exp $ +# +# Add the following lines to /etc/rc.conf to enable exilog agent: +# +#exilog_enable="YES" +# +# also uncomment 'use_pretty_names' => 'no' in exilog.conf file + +. %%RC_SUBR%% + +name=exilog +rcvar=`set_rcvar` + +command=%%PREFIX%%/sbin/exilog_agent.pl +pidfile=/var/run/exilog.pid +required_files=%%PREFIX%%/etc/exilog.conf +command_interpreter=/usr/bin/perl + +# read settings, set default values +load_rc_config $name +: ${exilog_enable="NO"} + +run_rc_command "$1" diff -ruN --exclude=CVS /usr/ports/mail/exilog/files/patch-exilog_sql.pm /usr/home/ler/ports/exilog/files/patch-exilog_sql.pm --- /usr/ports/mail/exilog/files/patch-exilog_sql.pm Wed Dec 31 18:00:00 1969 +++ /usr/home/ler/ports/exilog/files/patch-exilog_sql.pm Sat May 13 11:21:22 2006 @@ -0,0 +1,11 @@ +--- /usr/local/www/exilog/exilog_sql.pm Tue Feb 21 16:23:56 2006 ++++ exilog_sql.pm Wed Aug 24 09:22:29 2005 +@@ -208,7 +208,7 @@ + sub _pgsql_sql_optimize { + my $where = shift || "nothing"; + +- my $sql = "OPTIMIZE TABLE ".$where; ++ my $sql = "VACUUM ANALYZE ".$where; + my $sh = $dbh->prepare($sql); + $sh->execute; + $sh->finish; --- exilog-0.5_3.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted: