From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Sep 12 05:20:01 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 22AEA106566B for ; Fri, 12 Sep 2008 05:20:01 +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 ECF398FC12 for ; Fri, 12 Sep 2008 05:20:00 +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 m8C5K0N7097098 for ; Fri, 12 Sep 2008 05:20:00 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m8C5K0Ls097097; Fri, 12 Sep 2008 05:20:00 GMT (envelope-from gnats) Resent-Date: Fri, 12 Sep 2008 05:20:00 GMT Resent-Message-Id: <200809120520.m8C5K0Ls097097@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 3B0A41065687 for ; Fri, 12 Sep 2008 05:18:17 +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 2564F8FC13 for ; Fri, 12 Sep 2008 05:18:16 +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 m8C5IG19072733 for ; Fri, 12 Sep 2008 05:18:16 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m8C5IG9V072732; Fri, 12 Sep 2008 05:18:16 GMT (envelope-from nobody) Message-Id: <200809120518.m8C5IG9V072732@www.freebsd.org> Date: Fri, 12 Sep 2008 05:18:16 GMT From: Chenguang LI To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/127311: [maintainer update] port:database/sqlbuddy update to 1.3.0 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: Fri, 12 Sep 2008 05:20:01 -0000 >Number: 127311 >Category: ports >Synopsis: [maintainer update] port:database/sqlbuddy update to 1.3.0 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: maintainer-update >Submitter-Id: current-users >Arrival-Date: Fri Sep 12 05:20:00 UTC 2008 >Closed-Date: >Last-Modified: >Originator: Chenguang LI >Release: 8.0-CURRENT >Organization: >Environment: FreeBSD header.horus.cn 8.0-CURRENT FreeBSD 8.0-CURRENT #0: Tue Sep 2 17:29:23 CST 2008 horus@header.horus.cn:/usr/obj/usr/src/sys/GENERIC i386 >Description: SQL Buddy 1.3.0 Released: September 9, 2008 port:database/sqlbuddy updates to the latest release 1.3.0. these files have been touched: Makefile - add new version number and options to let users choose type of their database. distinfo - add info about 1.3.0 distfile files/pkg-message.in - alias: /sqlbuddy pkg-plist - to suit current sqlbuddy installation Changes in 1.3.0: - basic support for SQLite has been added - it is possible to view table rows, edit them, insert new rows, create new tables, etc. - when adding/editing users, it is now possible to restrict their access to certain databases - the time that a query takes to execute is now displayed on the query tab - if the login page is accessed over https, then the application will now load in https instead of http - changed the column width on the database overview page to accommodate longer table names - a SET NAMES query is now sent to prevent issues with international characters - text areas now automatically expand depending on the amount of text that is inside them - 12 new translations have been added: Slovenčina, Français, Magyar, 日本語, Lao, Türkçe, Português (Portugal), Slovenski, Suomi, Español (Argentina), Català, Română - improved display of long table names - added the ability to change passwords when editing users >How-To-Repeat: n./a. >Fix: see the patch. Patch attached with submission follows: diff -ruN /usr/ports/databases/sqlbuddy/Makefile ports/databases/sqlbuddy/Makefile --- /usr/ports/databases/sqlbuddy/Makefile 2008-09-02 09:19:17.000000000 +0800 +++ ports/databases/sqlbuddy/Makefile 2008-09-12 12:32:33.000000000 +0800 @@ -6,10 +6,10 @@ # PORTNAME= sqlbuddy -PORTVERSION= 1.2.9 +PORTVERSION= 1.3.0 CATEGORIES= databases www MASTER_SITES= http://www.sqlbuddy.com/download/ -DISTNAME= ${PORTNAME} +DISTNAME= ${PORTNAME}_1_3_0 MAINTAINER= horus.li@gmail.com COMMENT= Web based MySQL administration with a set of PHP scripts @@ -17,20 +17,32 @@ USE_ZIP= yes NO_BUILD= yes -USE_PHP= ctype mysql pcre session +WRKSRC= ${WRKDIR}/${PORTNAME} + +USE_PHP= ctype pcre session WANT_PHP_WEB= yes +OPTIONS+= MYSQL "MySQL support" on \ + SQLITE "SQLite support" off + SUB_FILES= pkg-message .include +.if defined(WITH_MYSQL) +USE_PHP+= mysql +.endif +.if defined(WITH_SQLITE) +USE_PHP+= sqlite +.endif + pre-everything:: @${ECHO_MSG} "" @${ECHO_MSG} "NOTE:" - @${ECHO_MSG} "This port suppose you have already installed MySQL, " + @${ECHO_MSG} "This port suppose you have already installed one or both of these databases supported, " @${ECHO_MSG} "and you want to use SQL Buddy to manage the server." - @${ECHO_MSG} "If you are planning to install MySQL on this machine later, " - @${ECHO_MSG} "you can find it at ${PORTSDIR}/databases." + @${ECHO_MSG} "If you are planning to install it/them on this machine later, " + @${ECHO_MSG} "you can find it/them at ${PORTSDIR}/databases." @${ECHO_MSG} "" do-install: diff -ruN /usr/ports/databases/sqlbuddy/distinfo ports/databases/sqlbuddy/distinfo --- /usr/ports/databases/sqlbuddy/distinfo 2008-09-02 09:19:17.000000000 +0800 +++ ports/databases/sqlbuddy/distinfo 2008-09-11 21:49:33.000000000 +0800 @@ -1,3 +1,3 @@ -MD5 (sqlbuddy.zip) = 17f42033a1855ed710ef23ed045d45e1 -SHA256 (sqlbuddy.zip) = c94f59092a7fbc78a5a1ba838b0fadc02c0220f71ed823fd0a5fc80dae65023d -SIZE (sqlbuddy.zip) = 171454 +MD5 (sqlbuddy_1_3_0.zip) = 46f55698631b8a4c998ccf7ee1315514 +SHA256 (sqlbuddy_1_3_0.zip) = 443d6859c1eb7703338026c4216221e270728c520c7f7c3b613ce69c905ac9d1 +SIZE (sqlbuddy_1_3_0.zip) = 254791 diff -ruN /usr/ports/databases/sqlbuddy/files/pkg-message.in ports/databases/sqlbuddy/files/pkg-message.in --- /usr/ports/databases/sqlbuddy/files/pkg-message.in 2008-09-02 09:19:17.000000000 +0800 +++ ports/databases/sqlbuddy/files/pkg-message.in 2008-09-12 12:29:13.000000000 +0800 @@ -7,7 +7,7 @@ Edit it to suit your needs. Add the following line to your httpd.conf for apache: - Alias /${PORTNAME} "%%WWWDIR%%" + Alias /sqlbuddy "%%WWWDIR%%" Open the login page and start using SQL Buddy. diff -ruN /usr/ports/databases/sqlbuddy/pkg-plist ports/databases/sqlbuddy/pkg-plist --- /usr/ports/databases/sqlbuddy/pkg-plist 2008-09-02 09:19:17.000000000 +0800 +++ ports/databases/sqlbuddy/pkg-plist 2008-09-12 12:25:30.000000000 +0800 @@ -11,6 +11,7 @@ %%WWWDIR%%/config.php %%WWWDIR%%/css/common.css %%WWWDIR%%/css/navigation.css +%%WWWDIR%%/css/print.css %%WWWDIR%%/dboverview.php %%WWWDIR%%/edit.php %%WWWDIR%%/editcolumn.php @@ -47,32 +48,45 @@ %%WWWDIR%%/images/window-shadow-right.png %%WWWDIR%%/import.php %%WWWDIR%%/includes/browse.php -%%WWWDIR%%/includes/gettextreader.php +%%WWWDIR%%/includes/class/GetTextReader.php +%%WWWDIR%%/includes/class/Sql-php4.php +%%WWWDIR%%/includes/class/Sql.php %%WWWDIR%%/includes/types.php %%WWWDIR%%/index.php %%WWWDIR%%/insert.php -%%WWWDIR%%/js/animation.js -%%WWWDIR%%/js/columnsize.js %%WWWDIR%%/js/core.js -%%WWWDIR%%/js/drag.js %%WWWDIR%%/js/helpers.js %%WWWDIR%%/js/mootools-1.2-core.js -%%WWWDIR%%/js/resize.js +%%WWWDIR%%/js/movement.js +%%WWWDIR%%/locale/ca_AD.pot +%%WWWDIR%%/locale/cs_CZ.pot %%WWWDIR%%/locale/de_DE.pot %%WWWDIR%%/locale/en_US.pot +%%WWWDIR%%/locale/es_AR.pot %%WWWDIR%%/locale/es_ES.pot +%%WWWDIR%%/locale/fi_FI.pot +%%WWWDIR%%/locale/fr_FR.pot +%%WWWDIR%%/locale/hu_HU.pot %%WWWDIR%%/locale/it_IT.pot +%%WWWDIR%%/locale/ja_JP.pot +%%WWWDIR%%/locale/lo_LA.pot %%WWWDIR%%/locale/nl_NL.pot %%WWWDIR%%/locale/pl_PL.pot %%WWWDIR%%/locale/pt_BR.pot +%%WWWDIR%%/locale/pt_PT.pot +%%WWWDIR%%/locale/ro_RO.pot %%WWWDIR%%/locale/ru_RU.pot +%%WWWDIR%%/locale/sk_SK.pot +%%WWWDIR%%/locale/sl_SI.pot %%WWWDIR%%/locale/sv_SE.pot %%WWWDIR%%/locale/tl_PH.pot +%%WWWDIR%%/locale/tr_TR.pot %%WWWDIR%%/locale/zh_CN.pot %%WWWDIR%%/locale/zh_TW.pot %%WWWDIR%%/login.php %%WWWDIR%%/logout.php %%WWWDIR%%/query.php +%%WWWDIR%%/serve.php %%WWWDIR%%/structure.php %%WWWDIR%%/themes/bittersweet/css/ie.css %%WWWDIR%%/themes/bittersweet/css/main.css @@ -96,6 +110,7 @@ @dirrm %%WWWDIR%%/themes @dirrm %%WWWDIR%%/locale @dirrm %%WWWDIR%%/js +@dirrm %%WWWDIR%%/includes/class @dirrm %%WWWDIR%%/includes @dirrm %%WWWDIR%%/images @dirrm %%WWWDIR%%/exports >Release-Note: >Audit-Trail: >Unformatted: