Date: Sat, 13 May 2006 12:19:07 -0500 From: Larry Rosenman <ler@lerctr.org> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/97213: [MAINTAINER] [PATCH] mail/exilog: PG Friendly, portlint Message-ID: <E1Fexlj-000A3o-LJ@thebighonker.lerctr.org> Resent-Message-ID: <200605131720.k4DHKAnJ099030@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E1Fexlj-000A3o-LJ>