From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Aug 19 02:30:03 2008 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 461241065672 for ; Tue, 19 Aug 2008 02:30:03 +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 229C78FC24 for ; Tue, 19 Aug 2008 02:30:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m7J2U3Fq072312 for ; Tue, 19 Aug 2008 02:30:03 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m7J2U2q8072311; Tue, 19 Aug 2008 02:30:02 GMT (envelope-from gnats) Resent-Date: Tue, 19 Aug 2008 02:30:02 GMT Resent-Message-Id: <200808190230.m7J2U2q8072311@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, ChenGuang LI Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id ED4461065674 for ; Tue, 19 Aug 2008 02:24:40 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id DBA1A8FC0C for ; Tue, 19 Aug 2008 02:24:40 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m7J2OeAq051658 for ; Tue, 19 Aug 2008 02:24:40 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m7J2Oeof051651; Tue, 19 Aug 2008 02:24:40 GMT (envelope-from nobody) Message-Id: <200808190224.m7J2Oeof051651@www.freebsd.org> Date: Tue, 19 Aug 2008 02:24:40 GMT From: ChenGuang LI To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/126646: New port: databases/sqlbuddy A web based MySQL administration tool 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: Tue, 19 Aug 2008 02:30:03 -0000 >Number: 126646 >Category: ports >Synopsis: New port: databases/sqlbuddy A web based MySQL administration tool >Confidential: no >Severity: critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Tue Aug 19 02:30:02 UTC 2008 >Closed-Date: >Last-Modified: >Originator: ChenGuang LI >Release: FreeBSD 8.0-CURRENT >Organization: >Environment: FreeBSD hammer.horus.cn 8.0-CURRENT FreeBSD 8.0-CURRENT #1: Wed Aug 13 13:27:55 CST 2008 horus@hammer.horus.cn:/usr/obj/usr/src/sys/GENERIC amd64 >Description: Hi, I saw this nice tool 3 days ago, and decided to try it. After using it, I think its simple, powerful design will help everybody in their daily MySQL maintenance. So I made this port, hope it can do something helpful. It's written in PHP, open source, release under MIT License. Feature: * Attractive design. * No setup. * Complete control of users - Logins are handled directly by the MySQL user table. * Reduced load times - Thanks to Ajax. * Easy to browse, import and export. * Multilanguage Official website: http://www.sqlbuddy.com >How-To-Repeat: N./A. >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: # # sqlbuddy # sqlbuddy/Makefile # sqlbuddy/distinfo # sqlbuddy/pkg-plist # sqlbuddy/pkg-descr # echo c - sqlbuddy mkdir -p sqlbuddy > /dev/null 2>&1 echo x - sqlbuddy/Makefile sed 's/^X//' >sqlbuddy/Makefile << '794abd73ae315ac74a1aa8ec63244ddb' X# New ports collection makefile for: SQL Buddy X# Date created: 17 August 2008 X# Whom: Chenguang LI X# X# $FreeBSD$ X# X XPORTNAME= sqlbuddy XPORTVERSION= 1.2.9 XCATEGORIES= databases www XMASTER_SITES= http://www.sqlbuddy.com/download/ XDISTNAME= ${PORTNAME} X XMAINTAINER= horus.li@gmail.com XCOMMENT= Web based MySQL administration with a set of PHP scripts X XUSE_ZIP= yes XNO_BUILD= yes X XUSE_PHP= ctype mysql pcre session XWANT_PHP_WEB= yes X X.include X Xpre-everything:: X @${ECHO_MSG} "" X @${ECHO_MSG} "NOTE:" X @${ECHO_MSG} "This port suppose you have already installed MySQL, " X @${ECHO_MSG} "and you want to use SQL Buddy to manage the server." X @${ECHO_MSG} "If you are planning to install MySQL on this machine later, " X @${ECHO_MSG} "you can find it at ${PORTSDIR}/databases." X @${ECHO_MSG} "" X Xdo-install: X @${ECHO_MSG} "" X @${ECHO_MSG} "Installing SQL Buddy under ${WWWDIR}/" X @${MKDIR} ${WWWDIR} X @cd ${WRKSRC} && ${CP} -R * ${WWWDIR} X @${CHOWN} -R ${WWWOWN}:${WWWGRP} ${WWWDIR} X Xpost-install: X @${ECHO_MSG} "" X @${ECHO_MSG} "Congratulations!" X @${ECHO_MSG} "You now have SQL Buddy installed." X @${ECHO_MSG} "The configuration file is placed at" X @${ECHO_MSG} "" X @${ECHO_MSG} " ${WWWDIR}/config.php" X @${ECHO_MSG} "" X @${ECHO_MSG} "Edit it to suit your needs. (Basically you don't even need to)" X @${ECHO_MSG} "You might also want to configure your web server before using this tool." X @${ECHO_MSG} "For example, add the following line to your httpd.conf for apache:" X @${ECHO_MSG} "" X @${ECHO_MSG} " Alias /${PORTNAME} \"${WWWDIR}/\"" X @${ECHO_MSG} "" X @${ECHO_MSG} "Do we need more steps?" X @${ECHO_MSG} "(No...Just open the login page and start using SQL Buddy.)" X @${ECHO_MSG} "" X @${ECHO_MSG} "For more information, visit the official website:" X @${ECHO_MSG} "" X @${ECHO_MSG} " http://www.sqlbuddy.com/" X @${ECHO_MSG} "" X @${ECHO_MSG} " Enjoy SQL Buddy!" X @${ECHO_MSG} "" X X.include 794abd73ae315ac74a1aa8ec63244ddb echo x - sqlbuddy/distinfo sed 's/^X//' >sqlbuddy/distinfo << '7d6cfde4bef5f2b5aa9a82e99753cd20' XMD5 (sqlbuddy.zip) = 17f42033a1855ed710ef23ed045d45e1 XSHA256 (sqlbuddy.zip) = c94f59092a7fbc78a5a1ba838b0fadc02c0220f71ed823fd0a5fc80dae65023d XSIZE (sqlbuddy.zip) = 171454 7d6cfde4bef5f2b5aa9a82e99753cd20 echo x - sqlbuddy/pkg-plist sed 's/^X//' >sqlbuddy/pkg-plist << '2a821039ceea3f21f0fbad488038c7d0' Xwww/sqlbuddy/LICENSE Xwww/sqlbuddy/README Xwww/sqlbuddy/ajaxcreatetable.php Xwww/sqlbuddy/ajaxfulltext.php Xwww/sqlbuddy/ajaximportfile.php Xwww/sqlbuddy/ajaxquery.php Xwww/sqlbuddy/ajaxsavecolumnedit.php Xwww/sqlbuddy/ajaxsaveedit.php Xwww/sqlbuddy/ajaxsaveuseredit.php Xwww/sqlbuddy/browse.php Xwww/sqlbuddy/config.php Xwww/sqlbuddy/css/common.css Xwww/sqlbuddy/css/navigation.css Xwww/sqlbuddy/dboverview.php Xwww/sqlbuddy/edit.php Xwww/sqlbuddy/editcolumn.php Xwww/sqlbuddy/edituser.php Xwww/sqlbuddy/export.php Xwww/sqlbuddy/functions.php Xwww/sqlbuddy/home.php Xwww/sqlbuddy/images/button.png Xwww/sqlbuddy/images/close.png Xwww/sqlbuddy/images/closeHover.png Xwww/sqlbuddy/images/closedArrow.png Xwww/sqlbuddy/images/goto.png Xwww/sqlbuddy/images/info.png Xwww/sqlbuddy/images/infoHover.png Xwww/sqlbuddy/images/initLoad.png Xwww/sqlbuddy/images/loading.gif Xwww/sqlbuddy/images/logo.png Xwww/sqlbuddy/images/openArrow.png Xwww/sqlbuddy/images/schemaHeader.png Xwww/sqlbuddy/images/sortasc.gif Xwww/sqlbuddy/images/sortdesc.gif Xwww/sqlbuddy/images/transparent.png Xwww/sqlbuddy/images/window-button.png Xwww/sqlbuddy/images/window-center.png Xwww/sqlbuddy/images/window-close.png Xwww/sqlbuddy/images/window-header-center.png Xwww/sqlbuddy/images/window-header-left.png Xwww/sqlbuddy/images/window-header-right.png Xwww/sqlbuddy/images/window-resize.png Xwww/sqlbuddy/images/window-shadow-bottom-left.png Xwww/sqlbuddy/images/window-shadow-bottom-right.png Xwww/sqlbuddy/images/window-shadow-bottom.png Xwww/sqlbuddy/images/window-shadow-left.png Xwww/sqlbuddy/images/window-shadow-right.png Xwww/sqlbuddy/import.php Xwww/sqlbuddy/includes/browse.php Xwww/sqlbuddy/includes/gettextreader.php Xwww/sqlbuddy/includes/types.php Xwww/sqlbuddy/index.php Xwww/sqlbuddy/insert.php Xwww/sqlbuddy/js/animation.js Xwww/sqlbuddy/js/columnsize.js Xwww/sqlbuddy/js/core.js Xwww/sqlbuddy/js/drag.js Xwww/sqlbuddy/js/helpers.js Xwww/sqlbuddy/js/mootools-1.2-core.js Xwww/sqlbuddy/js/resize.js Xwww/sqlbuddy/locale/de_DE.pot Xwww/sqlbuddy/locale/en_US.pot Xwww/sqlbuddy/locale/es_ES.pot Xwww/sqlbuddy/locale/it_IT.pot Xwww/sqlbuddy/locale/nl_NL.pot Xwww/sqlbuddy/locale/pl_PL.pot Xwww/sqlbuddy/locale/pt_BR.pot Xwww/sqlbuddy/locale/ru_RU.pot Xwww/sqlbuddy/locale/sv_SE.pot Xwww/sqlbuddy/locale/tl_PH.pot Xwww/sqlbuddy/locale/zh_CN.pot Xwww/sqlbuddy/locale/zh_TW.pot Xwww/sqlbuddy/login.php Xwww/sqlbuddy/logout.php Xwww/sqlbuddy/query.php Xwww/sqlbuddy/structure.php Xwww/sqlbuddy/themes/bittersweet/css/ie.css Xwww/sqlbuddy/themes/bittersweet/css/main.css Xwww/sqlbuddy/themes/bittersweet/images/header.png Xwww/sqlbuddy/themes/bittersweet/images/initLoad-dark.png Xwww/sqlbuddy/themes/classic/css/ie.css Xwww/sqlbuddy/themes/classic/css/main.css Xwww/sqlbuddy/themes/classic/images/corner-bl.png Xwww/sqlbuddy/themes/classic/images/corner-br.png Xwww/sqlbuddy/themes/classic/images/corner-tl.png Xwww/sqlbuddy/themes/classic/images/corner-tr.png Xwww/sqlbuddy/themes/classic/images/header.png Xwww/sqlbuddy/themes/classic/images/shading.png Xwww/sqlbuddy/users.php X@dirrm www/sqlbuddy/themes/classic/images X@dirrm www/sqlbuddy/themes/classic/css X@dirrm www/sqlbuddy/themes/classic X@dirrm www/sqlbuddy/themes/bittersweet/images X@dirrm www/sqlbuddy/themes/bittersweet/css X@dirrm www/sqlbuddy/themes/bittersweet X@dirrm www/sqlbuddy/themes X@dirrm www/sqlbuddy/locale X@dirrm www/sqlbuddy/js X@dirrm www/sqlbuddy/includes X@dirrm www/sqlbuddy/images X@dirrm www/sqlbuddy/exports X@dirrm www/sqlbuddy/css X@dirrmtry www/sqlbuddy 2a821039ceea3f21f0fbad488038c7d0 echo x - sqlbuddy/pkg-descr sed 's/^X//' >sqlbuddy/pkg-descr << '99df1f8c60f14f211a0e7b9a856c030d' XLet's be honest - managing a database isn't terribly exciting. XBut you still want to use a product that looks half-decent and is Xintuitive to use. SQL Buddy was designed to meet the demands of Xmodern web developers. Oh, and did I mention that its completely Xopen source and free for everyone to use? X XSome applications look great in a screenshot, but deliver disappointing Xresults when they are actually used. The driving force behind the Xdevelopment of SQL Buddy was not to produce a great-looking screenshot Xbut rather to create a product that would enable developers to enjoy their Xwork and get more done in less time. X XFeatures: X X* No setup X* Complete control of users X* Easy to browse X* Reduced load times X* Bookmark to your hearts content X* Import and export X* Multilanguage X XWWW: http://www.sqlbuddy.com/ 99df1f8c60f14f211a0e7b9a856c030d exit >Release-Note: >Audit-Trail: >Unformatted: