From owner-freebsd-ports-bugs@FreeBSD.ORG Wed Nov 24 10:40:11 2010 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 90EDB1065675 for ; Wed, 24 Nov 2010 10:40:11 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 691508FC17 for ; Wed, 24 Nov 2010 10:40:11 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id oAOAeBPu082328 for ; Wed, 24 Nov 2010 10:40:11 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id oAOAeBXU082327; Wed, 24 Nov 2010 10:40:11 GMT (envelope-from gnats) Resent-Date: Wed, 24 Nov 2010 10:40:11 GMT Resent-Message-Id: <201011241040.oAOAeBXU082327@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, Michael Ranner Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D8D411065672 for ; Wed, 24 Nov 2010 10:37:02 +0000 (UTC) (envelope-from mranner@dwarf.jawa.at) Received: from dwarf.jawa.at (chello084115144088.4.graz.surfer.at [84.115.144.88]) by mx1.freebsd.org (Postfix) with ESMTP id 323618FC12 for ; Wed, 24 Nov 2010 10:37:01 +0000 (UTC) Received: from dwarf.jawa.at (localhost.ranner.eu [127.0.0.1]) by dwarf.jawa.at (8.14.4/8.14.4) with ESMTP id oAOAb0IO013137; Wed, 24 Nov 2010 11:37:00 +0100 (CET) (envelope-from mranner@dwarf.jawa.at) Received: (from root@localhost) by dwarf.jawa.at (8.14.4/8.14.4/Submit) id oAOAaxl4013136; Wed, 24 Nov 2010 11:36:59 +0100 (CET) (envelope-from mranner) Message-Id: <201011241036.oAOAaxl4013136@dwarf.jawa.at> Date: Wed, 24 Nov 2010 11:36:59 +0100 (CET) From: Michael Ranner To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: sahil@FreeBSD.org Subject: ports/152540: [PATCH] security/mailzu: [Fix quarantine summary] 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: Wed, 24 Nov 2010 10:40:11 -0000 >Number: 152540 >Category: ports >Synopsis: [PATCH] security/mailzu: [Fix quarantine summary] >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: Wed Nov 24 10:40:11 UTC 2010 >Closed-Date: >Last-Modified: >Originator: Michael Ranner >Release: FreeBSD 8.1-RELEASE amd64 >Organization: >Environment: System: FreeBSD dwarf.jawa.at 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Aug 23 20:22:23 CEST 2010 >Description: Fix quarantine summary in overview Display hint "short_open_tag = on" in pkg-message Remove MD5 from distinfo Added file(s): - files/patch-DBEngine.class.php - pkg-message Port maintainer (sahil@FreeBSD.org) is cc'd. Generated with FreeBSD Port Tools 0.99 >How-To-Repeat: >Fix: --- mailzu-0.8.r3.patch begins here --- diff -ruN --exclude=CVS /usr/ports/security/mailzu/distinfo /usr/ports/security/mailzu.updated/distinfo --- /usr/ports/security/mailzu/distinfo 2009-08-14 21:54:33.000000000 +0200 +++ /usr/ports/security/mailzu.updated/distinfo 2010-11-24 11:34:51.000000000 +0100 @@ -1,3 +1,2 @@ -MD5 (MailZu_0.8RC3.tar.gz) = 9c50ed9d468a4a932b625bfe1f835b3d SHA256 (MailZu_0.8RC3.tar.gz) = aec449f13642e0003eabe9d6a3daa4b8cfebe6d58b8dc9438aee0fec80a1ecc8 SIZE (MailZu_0.8RC3.tar.gz) = 543781 diff -ruN --exclude=CVS /usr/ports/security/mailzu/files/patch-DBEngine.class.php /usr/ports/security/mailzu.updated/files/patch-DBEngine.class.php --- /usr/ports/security/mailzu/files/patch-DBEngine.class.php 1970-01-01 01:00:00.000000000 +0100 +++ /usr/ports/security/mailzu.updated/files/patch-DBEngine.class.php 2010-11-24 11:33:51.000000000 +0100 @@ -0,0 +1,134 @@ +--- lib/DBEngine.class.php.orig 2010-11-24 11:32:33.000000000 +0100 ++++ lib/DBEngine.class.php 2010-11-24 11:32:41.000000000 +0100 +@@ -132,7 +132,7 @@ + MAX(stattable.badheaders) AS badheaders, + MAX(stattable.pending) AS pending + FROM ( +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + COUNT(content) AS spam, + 0 AS banned, + 0 AS viruses, +@@ -141,9 +141,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='S' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + COUNT(content) AS banned, + 0 AS viruses, +@@ -152,9 +152,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='B' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + COUNT(content) AS viruses, +@@ -163,9 +163,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='V' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -174,9 +174,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='H' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -184,7 +184,7 @@ + COUNT(content) AS pending + FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE msgrcpt.rs='p' AND NOT (msgs.quar_type = '') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + ) AS stattable + GROUP BY date + ORDER BY date"; +@@ -253,7 +253,7 @@ + MAX(stattable.badheaders) AS badheaders, + MAX(stattable.pending) AS pending + FROM ( +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + COUNT(content) AS spam, + 0 AS banned, + 0 AS viruses, +@@ -263,9 +263,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='S' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + COUNT(content) AS banned, + 0 AS viruses, +@@ -275,9 +275,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='B' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + COUNT(content) AS viruses, +@@ -287,9 +287,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='V' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -299,9 +299,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='H' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -311,7 +311,7 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE msgrcpt.rs='p' AND NOT (msgs.quar_type = '') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + ) AS stattable + GROUP BY date + ORDER BY date"; diff -ruN --exclude=CVS /usr/ports/security/mailzu/files/pkg-message.in /usr/ports/security/mailzu.updated/files/pkg-message.in --- /usr/ports/security/mailzu/files/pkg-message.in 2009-08-14 21:54:33.000000000 +0200 +++ /usr/ports/security/mailzu.updated/files/pkg-message.in 2010-11-24 10:51:47.000000000 +0100 @@ -9,6 +9,8 @@ Then, create and edit %%WWWDIR%%/config/config.php An example is provided in %%WWWDIR%%/config/config.php.sample +MailZu needs "short_open_tag = On" in %%PREFIX%%/etc/php.ini + Finally, make MailZu available through your web site. An example for httpd.conf: @@ -21,4 +23,3 @@ Deny from all Allow from 127.0.0.1 .example.org - diff -ruN --exclude=CVS /usr/ports/security/mailzu/pkg-message /usr/ports/security/mailzu.updated/pkg-message --- /usr/ports/security/mailzu/pkg-message 1970-01-01 01:00:00.000000000 +0100 +++ /usr/ports/security/mailzu.updated/pkg-message 2010-11-24 10:50:28.000000000 +0100 @@ -0,0 +1,5 @@ +************************************************************************* + +MailZu needs "short_open_tag = On" in %%PREFIX%%/etc/php.ini + +************************************************************************* --- mailzu-0.8.r3.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted: