ports/127311: [maintainer update] port:database/sqlbuddy update to 1.3.0

Fri Sep 12 05:20:01 UTC 2008

>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 at 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 at 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 <bsd.port.pre.mk>
 
+.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
+ at dirrm %%WWWDIR%%/includes/class
 @dirrm %%WWWDIR%%/includes
 @dirrm %%WWWDIR%%/images
 @dirrm %%WWWDIR%%/exports


>Release-Note:
>Audit-Trail:
>Unformatted:

