From owner-freebsd-ports-bugs@FreeBSD.ORG Thu Nov 23 15:50:38 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 [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E873416A403 for ; Thu, 23 Nov 2006 15:50:38 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [69.147.83.40]) by mx1.FreeBSD.org (Postfix) with ESMTP id A7A1043DCA for ; Thu, 23 Nov 2006 15:49:43 +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 kANFoJ9T007213 for ; Thu, 23 Nov 2006 15:50:19 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id kANFoJ1s007212; Thu, 23 Nov 2006 15:50:19 GMT (envelope-from gnats) Resent-Date: Thu, 23 Nov 2006 15:50:19 GMT Resent-Message-Id: <200611231550.kANFoJ1s007212@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, Alexander Zhuravlev Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A156516A494 for ; Thu, 23 Nov 2006 15:48:06 +0000 (UTC) (envelope-from zaa@zaa.pp.ru) Received: from kernel.ulstu.ru (kernel.ulstu.ru [62.76.34.36]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8321843D97 for ; Thu, 23 Nov 2006 15:47:06 +0000 (GMT) (envelope-from zaa@zaa.pp.ru) Received: from localhost (localhost [127.0.0.1]) by kernel.ulstu.ru (ulstuMail) with ESMTP id DD5794ADBA; Thu, 23 Nov 2006 18:47:33 +0300 (MSK) Received: from kernel.ulstu.ru ([127.0.0.1]) by localhost (kernel.ulstu.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id I1MG2NPIOH-w; Thu, 23 Nov 2006 18:47:26 +0300 (MSK) Received: from wave.zaa.local (zaa.ulstu.ru [62.76.34.17]) by kernel.ulstu.ru (ulstuMail) with ESMTP id 3B7624AC99 for ; Thu, 23 Nov 2006 18:47:24 +0300 (MSK) Received: by wave.zaa.local (Postfix, from userid 3909) id 71352B816; Thu, 23 Nov 2006 18:47:27 +0300 (MSK) Message-Id: <20061123154727.71352B816@wave.zaa.local> Date: Thu, 23 Nov 2006 18:47:27 +0300 (MSK) From: Alexander Zhuravlev To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/105787: [NEW PORT] databases/mysqlreport Mysqlreport makes a friendly report of important MySQL status values X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Alexander Zhuravlev List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Nov 2006 15:50:39 -0000 >Number: 105787 >Category: ports >Synopsis: [NEW PORT] databases/mysqlreport Mysqlreport makes a friendly report of important MySQL status values >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu Nov 23 15:50:12 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Alexander Zhuravlev >Release: FreeBSD 6.2-PRERELEASE i386 >Organization: >Environment: System: FreeBSD wave.zaa.local 6.2-PRERELEASE FreeBSD 6.2-PRERELEASE #34: Thu Nov 23 16:32:08 MSK 2006 root@wave.zaa.local:/usr/obj/usr/src/sys/WAVE i386 >Description: mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides a much more in-depth understanding of how well MySQL is running. For this and many other reasons, mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS. >How-To-Repeat: >Fix: --- mysqlreport.port begins here --- # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # mysqlreport # mysqlreport/Makefile # mysqlreport/distinfo # mysqlreport/pkg-descr # mysqlreport/files # mysqlreport/files/patch-mysqlreport # echo c - mysqlreport mkdir -p mysqlreport > /dev/null 2>&1 echo x - mysqlreport/Makefile sed 's/^X//' >mysqlreport/Makefile << 'END-of-mysqlreport/Makefile' X# New ports collection makefile for: mysqlreport X# Date created: 2006-11-23 X# Whom: Alexander Zhuravlev X# X# $FreeBSD$ X XPORTNAME= mysqlreport XPORTVERSION= 2.7a XCATEGORIES= databases XMASTER_SITES= http://hackmysql.com/scripts/ XEXTRACT_SUFX= .tgz X XMAINTAINER= zaa@zaa.pp.ru XCOMMENT= Mysqlreport makes a friendly report of important MySQL status values X XRUN_DEPENDS= ${SITE_PERL}/${PERL_ARCH}/Term/ReadKey.pm:${PORTSDIR}/devel/p5-Term-ReadKey \ X ${SITE_PERL}/${PERL_ARCH}/DBD/mysql.pm:${PORTSDIR}/databases/p5-DBD-mysql X XUSE_PERL5= yes XNO_BUILD= yes XNO_WRKSUBDIR= yes X XPLIST_FILES= bin/mysqlreport XPORTDOCS= mysqlreportguide.html mysqlreportdoc.html X Xdo-install: X @${INSTALL_SCRIPT} ${WRKSRC}/mysqlreport ${PREFIX}/bin X X.if !defined(NOPORTDOCS) X @${ECHO_MSG} "===> Installing documentation for ${PKGNAME}" X @${MKDIR} ${DOCSDIR} X. for i in ${PORTDOCS} X @${INSTALL_DATA} ${WRKSRC}/${i} ${DOCSDIR} X. endfor X.endif X X.include END-of-mysqlreport/Makefile echo x - mysqlreport/distinfo sed 's/^X//' >mysqlreport/distinfo << 'END-of-mysqlreport/distinfo' XMD5 (mysqlreport-2.7a.tgz) = a1af9e32372cff388b1fe59f595df121 XSHA256 (mysqlreport-2.7a.tgz) = fb77406fa5ce13935e69591c71cda1a539d0959f611796f472e41360586b2cf4 XSIZE (mysqlreport-2.7a.tgz) = 20785 END-of-mysqlreport/distinfo echo x - mysqlreport/pkg-descr sed 's/^X//' >mysqlreport/pkg-descr << 'END-of-mysqlreport/pkg-descr' Xmysqlreport makes a friendly report of important MySQL status values. Xmysqlreport transforms the values from SHOW STATUS into an easy-to-read Xreport that provides a much more in-depth understanding of how well XMySQL is running. For this and many other reasons, mysqlreport is Xa better alternative (and practically the only alternative) to Xmanually interpreting SHOW STATUS. X XWWW: http://hackmysql.com/mysqlreport END-of-mysqlreport/pkg-descr echo c - mysqlreport/files mkdir -p mysqlreport/files > /dev/null 2>&1 echo x - mysqlreport/files/patch-mysqlreport sed 's/^X//' >mysqlreport/files/patch-mysqlreport << 'END-of-mysqlreport/files/patch-mysqlreport' X--- mysqlreport.orig Thu Nov 23 17:56:12 2006 X+++ mysqlreport Thu Nov 23 18:03:54 2006 X@@ -76,7 +76,7 @@ $mycnf{'user'} = $op{'user'} if have X # Default values if nothing else X $mycnf{'host'} ||= 'localhost'; X $mycnf{'port'} ||= 3306; X-$mycnf{'socket'} ||= '/var/run/mysqld/mysqld.sock'; # Debian default X+$mycnf{'socket'} ||= '/tmp/mysql.sock'; X $mycnf{'user'} ||= $ENV{'USER'}; X X if(exists $op{'password'}) END-of-mysqlreport/files/patch-mysqlreport exit --- mysqlreport.port ends here --- >Release-Note: >Audit-Trail: >Unformatted: