From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Dec 25 06:20:05 2009 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 A5CA6106568F for ; Fri, 25 Dec 2009 06:20:05 +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 79D978FC1C for ; Fri, 25 Dec 2009 06:20:05 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id nBP6K5Um036103 for ; Fri, 25 Dec 2009 06:20:05 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id nBP6K5bC036102; Fri, 25 Dec 2009 06:20:05 GMT (envelope-from gnats) Resent-Date: Fri, 25 Dec 2009 06:20:05 GMT Resent-Message-Id: <200912250620.nBP6K5bC036102@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, "Dmitry V. Sukhodoyev" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 157DD1065695 for ; Fri, 25 Dec 2009 06:17:03 +0000 (UTC) (envelope-from raven@supra.i-jet.ru) Received: from wrx.i-jet.ru (wrx.i-jet.ru [208.43.116.166]) by mx1.freebsd.org (Postfix) with ESMTP id C1A088FC13 for ; Fri, 25 Dec 2009 06:17:02 +0000 (UTC) Received: from localhost (wrx.i-jet.ru [208.43.116.166]) by wrx.i-jet.ru (Postfix) with ESMTP id 6C428245DC6B; Fri, 25 Dec 2009 09:08:38 +0300 (MSK) Received: from supra.i-jet.ru (supra.i-jet.ru [174.37.221.177]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by wrx.i-jet.ru (Postfix) with ESMTPSA; Fri, 25 Dec 2009 09:08:38 +0300 (MSK) Received: from supra.i-jet.ru (supra.i-jet.ru [10.24.2.5]) by supra.i-jet.ru (8.14.3/8.14.3) with ESMTP id nBP68cZi099952; Fri, 25 Dec 2009 09:08:38 +0300 (MSK) (envelope-from raven@supra.i-jet.ru) Received: (from raven@localhost) by supra.i-jet.ru (8.14.3/8.14.3/Submit) id nBP68cnF099951; Fri, 25 Dec 2009 09:08:38 +0300 (MSK) (envelope-from raven) Message-Id: <200912250608.nBP68cnF099951@supra.i-jet.ru> Date: Fri, 25 Dec 2009 09:08:38 +0300 (MSK) From: "Dmitry V. Sukhodoyev" To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: raven428@gmail.com Subject: ports/141997: New port: devel/pinba_engine X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: "Dmitry V. Sukhodoyev" List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Dec 2009 06:20:05 -0000 >Number: 141997 >Category: ports >Synopsis: New port: devel/pinba_engine >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: Fri Dec 25 06:20:05 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Dmitry V. Sukhodoyev >Release: FreeBSD 7.2-RELEASE-p4 amd64 >Organization: i-jet >Environment: System: FreeBSD supra.i-jet.ru 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #0: Sat Nov 7 10:50:23 MSK 2009 root@dakota.i-jet.ru:/usr/obj/usr/nfs/src/sys/taran amd64 >Description: New port: devel/pinba_engine Mysql-engine part of statistics server for PHP >How-To-Repeat: >Fix: # 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: # # pinba_engine # pinba_engine/files # pinba_engine/files/patch-aa # pinba_engine/Makefile # pinba_engine/pkg-message # pinba_engine/pkg-descr # pinba_engine/pkg-plist # pinba_engine/distinfo # echo c - pinba_engine mkdir -p pinba_engine > /dev/null 2>&1 echo c - pinba_engine/files mkdir -p pinba_engine/files > /dev/null 2>&1 echo x - pinba_engine/files/patch-aa sed 's/^X//' >pinba_engine/files/patch-aa << '7399c10881cbcfb91083b6d845662d30' Xdiff -ru pinba_engine-200912240755.orig/src/ha_pinba.cc pinba_engine-200912240755/src/ha_pinba.cc X--- src/ha_pinba.cc.orig 2009-12-24 18:25:00.000000000 +0500 X+++ src/ha_pinba.cc 2009-12-24 18:25:41.000000000 +0500 X@@ -283,6 +283,7 @@ X int error = 0; X DBUG_ENTER("pinba_engine_shutdown"); X X+ pthread_detach(collector_thread); X pthread_cancel(collector_thread); X pthread_join(collector_thread, NULL); X 7399c10881cbcfb91083b6d845662d30 echo x - pinba_engine/Makefile sed 's/^X//' >pinba_engine/Makefile << 'cf3470083136ce28f3494af0c3e4a6c0' X# New ports collection makefile for: pinba_engine X# Date created: 24 Dec 2009 X# Whom: raven428 X# X# $FreeBSD$ X# X XPORTNAME= pinba_engine XPORTVERSION= 2009.12.24 XCATEGORIES= devel XMASTER_SITES= http://aston2.com/~raven/unix/pinba/ \ X http://mks-chel.ru/~raven/FreeBSD/pinba/ XDISTNAME= pinba_engine-200912240755 X XMAINTAINER= raven428@gmail.com XCOMMENT= Mysql-engine part of statistics server for PHP X XWRKSRC= ${WRKDIR}/${DISTNAME} XBUILD_DEPENDS= ${LOCALBASE}/include/google/protobuf/descriptor.h:${PORTSDIR}/devel/protobuf \ X ${LOCALBASE}/include/event.h:${PORTSDIR}/devel/libevent \ X ${LOCALBASE}/include/Judy.h:${PORTSDIR}/devel/judy \ X ${LOCALBASE}/lib/mysql/plugin:${MYSQL_PORTDIR} \ X ${NONEXISTENT}:${MYSQL_PORTDIR}:configure XUSE_MYSQL= yes XWANT_MYSQL_VER= 51 XGNU_CONFIGURE= yes XMYSQL_PORTDIR= ${PORTSDIR}/databases/mysql51-server XMYSQL_WRKSRC=`cd ${MYSQL_PORTDIR} && ${MAKE} -V WRKSRC` XCONFIGURE_ARGS+= \ X --with-mysql=${MYSQL_WRKSRC} \ X --libdir=${PREFIX}/lib/mysql/plugin XCFLAGS+= -I${LOCALBASE}/include/mysql XUSE_LDCONFIG= ${PREFIX}/lib/mysql/plugin X Xpost-patch: X @${SED} 's|%%DATADIR%%|${DATADIR}|g' ${PKGDIR}/pkg-message > \ X ${WRKDIR}/pkg-message X Xpost-install: X.if !defined(NOPORTDOCS) X @${MKDIR} ${DOCSDIR} X @${MKDIR} ${DATADIR} X @${INSTALL_MAN} ${WRKSRC}/NEWS ${DOCSDIR} X @${INSTALL_MAN} ${WRKSRC}/TODO ${DOCSDIR} X @${INSTALL_MAN} ${WRKSRC}/README ${DOCSDIR} X @${INSTALL_MAN} ${WRKSRC}/default_tables.sql ${DATADIR} X.endif X @${CAT} ${WRKDIR}/pkg-message X X.include cf3470083136ce28f3494af0c3e4a6c0 echo x - pinba_engine/pkg-message sed 's/^X//' >pinba_engine/pkg-message << '328e5a87515c89c8c7ddb600c3e59b84' XAfter you've installed the plugin, you need to enable it in MySQL. To do this log in to the MySQL console (as root) and execute the following: Xmysql> INSTALL PLUGIN pinba SONAME 'libpinba_engine.so'; X XWe'd also suggest you to create a separate database, this way: Xmysql> CREATE DATABASE pinba; X XAnd then create the default tables: Xmysql -D pinba < %%DATADIR%%/default_tables.sql 328e5a87515c89c8c7ddb600c3e59b84 echo x - pinba_engine/pkg-descr sed 's/^X//' >pinba_engine/pkg-descr << '148b99311a720af4e6ea6745e5f70805' XPinba is a statistics server for PHP using MySQL as a read-only interface. X XIt accumulates and processes data sent over UDP by multiple PHP processes and Xdisplays statistics in a nice human-readable form of simple "reports", also Xproviding read-only interface to the raw data in order to make possible Xgeneration of more sophisticated reports. X XWith Pinba extension users also can measure particular parts of the code using Xtimers with arbitrary tags. X XPinba is not a debugging tool in a common sense, since you're not supposed to Xdo debugging on production servers, but its main goal is to help developers to Xlocate bottlenecks in realtime and direct developers' attention to the code Xthat really needs it. X XWWW: http://pinba.org/ X X- raven428 Xraven428@gmail.com 148b99311a720af4e6ea6745e5f70805 echo x - pinba_engine/pkg-plist sed 's/^X//' >pinba_engine/pkg-plist << 'bf23be381365603718c3dc100eb65019' Xlib/mysql/plugin/libpinba_engine.so Xlib/mysql/plugin/libpinba_engine.so.0 Xlib/mysql/plugin/libpinba_engine.la Xlib/mysql/plugin/libpinba_engine.a X%%PORTDOCS%%%%DOCSDIR%%/NEWS X%%PORTDOCS%%%%DOCSDIR%%/TODO X%%PORTDOCS%%%%DOCSDIR%%/README X%%PORTDATA%%%%DATADIR%%/default_tables.sql X%%PORTDOCS%%@dirrm %%DOCSDIR%% X%%PORTDATA%%@dirrm %%DATADIR%% bf23be381365603718c3dc100eb65019 echo x - pinba_engine/distinfo sed 's/^X//' >pinba_engine/distinfo << '84fc9cace17bd9155f18bfc1d2549997' XMD5 (pinba_engine-200912240755.tar.gz) = 92aa2f0d67f84cd9fb89dc6752a8a4b5 XSHA256 (pinba_engine-200912240755.tar.gz) = 5822a7859e86e24796531a002aa3e866e98a83e6fdf7726356dd5f8ab311f082 XSIZE (pinba_engine-200912240755.tar.gz) = 607588 84fc9cace17bd9155f18bfc1d2549997 exit >Release-Note: >Audit-Trail: >Unformatted: