ports/126646: New port: databases/sqlbuddy A web based MySQL administration tool

ChenGuang LI horus.li at gmail.com
Tue Aug 19 02:30:03 UTC 2008 

>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 at 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 at 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 <bsd.port.pre.mk>
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 <bsd.port.post.mk>
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 at dirrm www/sqlbuddy/themes/classic/images
X at dirrm www/sqlbuddy/themes/classic/css
X at dirrm www/sqlbuddy/themes/classic
X at dirrm www/sqlbuddy/themes/bittersweet/images
X at dirrm www/sqlbuddy/themes/bittersweet/css
X at dirrm www/sqlbuddy/themes/bittersweet
X at dirrm www/sqlbuddy/themes
X at dirrm www/sqlbuddy/locale
X at dirrm www/sqlbuddy/js
X at dirrm www/sqlbuddy/includes
X at dirrm www/sqlbuddy/images
X at dirrm www/sqlbuddy/exports
X at dirrm www/sqlbuddy/css
X at 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:

More information about the freebsd-ports-bugs mailing list