From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Dec 2 19:20:22 2006 Return-Path: X-Original-To: freebsd-ports-bugs@hub.freebsd.org Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 16D3916A407 for ; Sat, 2 Dec 2006 19:20:22 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [69.147.83.40]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0E05743CBC for ; Sat, 2 Dec 2006 19:19:53 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id kB2JKE5E065130 for ; Sat, 2 Dec 2006 19:20:14 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id kB2JKEXs065126; Sat, 2 Dec 2006 19:20:14 GMT (envelope-from gnats) Resent-Date: Sat, 2 Dec 2006 19:20:14 GMT Resent-Message-Id: <200612021920.kB2JKEXs065126@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, Roy Boerner Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id C45BC16A407 for ; Sat, 2 Dec 2006 19:16:39 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [69.147.83.33]) by mx1.FreeBSD.org (Postfix) with ESMTP id E954943CA6 for ; Sat, 2 Dec 2006 19:16:16 +0000 (GMT) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.13.1/8.13.1) with ESMTP id kB2JGcGT013313 for ; Sat, 2 Dec 2006 19:16:38 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.13.1/8.13.1/Submit) id kB2JGcoF013312; Sat, 2 Dec 2006 19:16:38 GMT (envelope-from nobody) Message-Id: <200612021916.kB2JGcoF013312@www.freebsd.org> Date: Sat, 2 Dec 2006 19:16:38 GMT From: Roy Boerner To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.0 Cc: Subject: ports/106230: [NEW PORT] databases/squirrel-sql A universal SQL Client 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: Sat, 02 Dec 2006 19:20:22 -0000 >Number: 106230 >Category: ports >Synopsis: [NEW PORT] databases/squirrel-sql A universal SQL Client >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: Sat Dec 02 19:20:14 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Roy Boerner >Release: FreeBSD 6.1-RELEASE-p10 amd64 >Organization: >Environment: FreeBSD robowork.internal 6.1-RELEASE-p10 FreeBSD 6.1-RELEASE-p10 #3: Sun Oct 15 19:43:51 CEST 2006 robo@robowork.internal:/usr/obj/usr/src/sys/ROBOWORK amd64 >Description: SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. WWW: http://www.squirrelsql.org/index.php?page=screenshots >How-To-Repeat: >Fix: Patch attached with submission follows: # 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: # # squirrel-sql # squirrel-sql/distinfo # squirrel-sql/Makefile # squirrel-sql/pkg-descr # squirrel-sql/pkg-plist # squirrel-sql/files # squirrel-sql/files/squirrel-sql.sh # squirrel-sql/files/squirrel-sql.in # squirrel-sql/files/squirrel-sql.in~ # echo c - squirrel-sql mkdir -p squirrel-sql > /dev/null 2>&1 echo x - squirrel-sql/distinfo sed 's/^X//' >squirrel-sql/distinfo << 'END-of-squirrel-sql/distinfo' XMD5 (squirrel-sql-2.3.1-standard.tar.gz) = 5a164fcfdae270365fbe1b34e7b215a6 XSHA256 (squirrel-sql-2.3.1-standard.tar.gz) = d3b8bcaee4b72d0108e692f7e6d6fb08544ab303f7738e02b05e43e51a0bb1f9 XSIZE (squirrel-sql-2.3.1-standard.tar.gz) = 7404592 END-of-squirrel-sql/distinfo echo x - squirrel-sql/Makefile sed 's/^X//' >squirrel-sql/Makefile << 'END-of-squirrel-sql/Makefile' X# New ports collection makefile for: squirrel-sql X# Date created: 2006/11/06 X# Whom: Roy Boerner X# X# $FreeBSD$ X# X XPORTNAME=squirrel-sql XPORTVERSION=2.3.1 XCATEGORIES=java databases XMASTER_SITES=${MASTER_SITE_SOURCEFORGE_EXTENDED} XMASTER_SITE_SUBDIR=${PORTNAME} XDISTNAME=squirrel-sql-2.3.1-standard X XMAINTAINER=roy.boerner@bsd-crew.de XCOMMENT=A universal SQL Client X XNO_BUILD=yes XUSE_JAVA=yes XJAVA_VERSION=1.4+ XWRKSRC=${WRKDIR}/SQuirreL SQL Client XDSTDIR=${JAVASHAREDIR}/${PORTNAME} X XSUB_FILES=squirrel-sql X XDESKTOP_ENTRIES="Squirrel-SQL" \ X "${COMMENT}" \ X "${DSTDIR}/icons/acorn.png" \ X "squirrel-sql" \ X "Application;" \ X false X Xpost-extract: X ${RM} -rf "${WRKSRC}"/Uninstaller X ${RM} -rf "${WRKSRC}"/*.bat X ${RM} -rf "${WRKSRC}"/*.sh X Xdo-install: X cd "${WRKSRC}" && ${FIND} . -type d -exec ${MKDIR} ${DSTDIR}/{} \; X cd "${WRKSRC}" && ${FIND} . -type f -not -path "\./bin/" -exec ${INSTALL_DATA} {} ${DSTDIR}/{} \; X ${INSTALL_SCRIPT} ${WRKDIR}/squirrel-sql ${PREFIX}/bin X X.include END-of-squirrel-sql/Makefile echo x - squirrel-sql/pkg-descr sed 's/^X//' >squirrel-sql/pkg-descr << 'END-of-squirrel-sql/pkg-descr' XSQuirreL SQL Client is a graphical Java program that will allow you to view the Xstructure of a JDBC compliant database, browse the data in tables, issue SQL Xcommands etc. X XWWW: http://www.squirrelsql.org/index.php?page=screenshots END-of-squirrel-sql/pkg-descr echo x - squirrel-sql/pkg-plist sed 's/^X//' >squirrel-sql/pkg-plist << 'END-of-squirrel-sql/pkg-plist' Xbin/squirrel-sql Xshare/java/squirrel-sql/doc/changes.txt Xshare/java/squirrel-sql/doc/faq.html Xshare/java/squirrel-sql/doc/images/add_alias_1.png Xshare/java/squirrel-sql/doc/images/aliases_tool_window_1.png Xshare/java/squirrel-sql/doc/images/chg_driver_1.png Xshare/java/squirrel-sql/doc/images/chg_driver_2.png Xshare/java/squirrel-sql/doc/images/connect_window.png Xshare/java/squirrel-sql/doc/images/createresultwindow.gif Xshare/java/squirrel-sql/doc/images/drivers_tool_window_1.png Xshare/java/squirrel-sql/doc/images/error_st_obj.gif Xshare/java/squirrel-sql/doc/images/global_data_types_1.png Xshare/java/squirrel-sql/doc/images/global_data_types_2.png Xshare/java/squirrel-sql/doc/images/global_general.png Xshare/java/squirrel-sql/doc/images/global_proxy.png Xshare/java/squirrel-sql/doc/images/global_sql.png Xshare/java/squirrel-sql/doc/images/logo.jpg Xshare/java/squirrel-sql/doc/images/logo_1.jpg Xshare/java/squirrel-sql/doc/images/ok_st_obj.gif Xshare/java/squirrel-sql/doc/images/plugins_1.png Xshare/java/squirrel-sql/doc/images/session_1.png Xshare/java/squirrel-sql/doc/images/session_2.png Xshare/java/squirrel-sql/doc/images/session_props_general.png Xshare/java/squirrel-sql/doc/images/session_props_object.png Xshare/java/squirrel-sql/doc/images/session_props_sql.png Xshare/java/squirrel-sql/doc/images/sql_1.png Xshare/java/squirrel-sql/doc/images/sql_2.png Xshare/java/squirrel-sql/doc/images/toolspopup.jpg Xshare/java/squirrel-sql/doc/licences/dean_jones_icons_licence.txt Xshare/java/squirrel-sql/doc/licences/eclipse-icons-licence.html Xshare/java/squirrel-sql/doc/licences/eclipse-icons-licence.txt Xshare/java/squirrel-sql/doc/licences/log4j-licence.txt Xshare/java/squirrel-sql/doc/licences/nano_xml_licence.txt Xshare/java/squirrel-sql/doc/licences/squirrel_licence.txt Xshare/java/squirrel-sql/doc/licences/sun_icons_licence.txt Xshare/java/squirrel-sql/doc/news.txt Xshare/java/squirrel-sql/doc/plugins.html Xshare/java/squirrel-sql/doc/quick_start.html Xshare/java/squirrel-sql/doc/readme.html Xshare/java/squirrel-sql/doc/readme.txt Xshare/java/squirrel-sql/doc/style.css Xshare/java/squirrel-sql/doc/welcome.html Xshare/java/squirrel-sql/icons/acorn.ico Xshare/java/squirrel-sql/icons/acorn.png Xshare/java/squirrel-sql/icons/acorn.xpm Xshare/java/squirrel-sql/lib/commons-cli.jar Xshare/java/squirrel-sql/lib/forms.jar Xshare/java/squirrel-sql/lib/fw.jar Xshare/java/squirrel-sql/lib/log4j.jar Xshare/java/squirrel-sql/lib/nanoxml-2.1.jar Xshare/java/squirrel-sql/log4j.properties Xshare/java/squirrel-sql/plugins/codecompletion.jar Xshare/java/squirrel-sql/plugins/codecompletion/changes.txt Xshare/java/squirrel-sql/plugins/codecompletion/completionpopup.jpg Xshare/java/squirrel-sql/plugins/codecompletion/graph.jpg Xshare/java/squirrel-sql/plugins/codecompletion/licence.txt Xshare/java/squirrel-sql/plugins/codecompletion/readme.html Xshare/java/squirrel-sql/plugins/codecompletion/readme.txt Xshare/java/squirrel-sql/plugins/codecompletion/src.jar Xshare/java/squirrel-sql/plugins/editextras.jar Xshare/java/squirrel-sql/plugins/editextras/changes.txt Xshare/java/squirrel-sql/plugins/editextras/licence.txt Xshare/java/squirrel-sql/plugins/editextras/readme.html Xshare/java/squirrel-sql/plugins/editextras/readme.txt Xshare/java/squirrel-sql/plugins/editextras/src.jar Xshare/java/squirrel-sql/plugins/editextras/toolspopup.jpg Xshare/java/squirrel-sql/plugins/graph.jar Xshare/java/squirrel-sql/plugins/graph/changes.txt Xshare/java/squirrel-sql/plugins/graph/graph.jpg Xshare/java/squirrel-sql/plugins/graph/licence.txt Xshare/java/squirrel-sql/plugins/graph/readme.html Xshare/java/squirrel-sql/plugins/graph/readme.txt Xshare/java/squirrel-sql/plugins/graph/src.jar Xshare/java/squirrel-sql/plugins/graph/zoomprint.jpg Xshare/java/squirrel-sql/plugins/laf.jar Xshare/java/squirrel-sql/plugins/laf/OYOAHA-licence.html Xshare/java/squirrel-sql/plugins/laf/changes.txt Xshare/java/squirrel-sql/plugins/laf/jgoodies-looks-licence.txt Xshare/java/squirrel-sql/plugins/laf/kunststoff_Licence.txt Xshare/java/squirrel-sql/plugins/laf/laf-plugin-licence.txt Xshare/java/squirrel-sql/plugins/laf/lafs/kunststoff.jar Xshare/java/squirrel-sql/plugins/laf/lafs/looks-1.3.1.jar Xshare/java/squirrel-sql/plugins/laf/lafs/metouia.jar Xshare/java/squirrel-sql/plugins/laf/lafs/oalnf.jar Xshare/java/squirrel-sql/plugins/laf/lafs/readme.txt Xshare/java/squirrel-sql/plugins/laf/lafs/skinlf.jar Xshare/java/squirrel-sql/plugins/laf/lafs/swingsetthemes.jar Xshare/java/squirrel-sql/plugins/laf/licences.html Xshare/java/squirrel-sql/plugins/laf/metouia-licence.txt Xshare/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/gradient.otm Xshare/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/readme.txt Xshare/java/squirrel-sql/plugins/laf/readme.html Xshare/java/squirrel-sql/plugins/laf/readme.txt Xshare/java/squirrel-sql/plugins/laf/skin_look_and_feel_licence.txt Xshare/java/squirrel-sql/plugins/laf/skinlf-theme-packs/readme.txt Xshare/java/squirrel-sql/plugins/laf/skinlf-theme-packs/whistlerthemepack.zip Xshare/java/squirrel-sql/plugins/laf/src.jar Xshare/java/squirrel-sql/plugins/readme.txt Xshare/java/squirrel-sql/plugins/sqlbookmark.jar Xshare/java/squirrel-sql/plugins/sqlbookmark/bookmarkspopup.jpg Xshare/java/squirrel-sql/plugins/sqlbookmark/changes.txt Xshare/java/squirrel-sql/plugins/sqlbookmark/licence.txt Xshare/java/squirrel-sql/plugins/sqlbookmark/prefs.jpg Xshare/java/squirrel-sql/plugins/sqlbookmark/readme.html Xshare/java/squirrel-sql/plugins/sqlbookmark/src.jar Xshare/java/squirrel-sql/plugins/sqlbookmark/toolspopup.jpg Xshare/java/squirrel-sql/plugins/sqlscript.jar Xshare/java/squirrel-sql/plugins/sqlscript/changes.txt Xshare/java/squirrel-sql/plugins/sqlscript/creattable.jpg Xshare/java/squirrel-sql/plugins/sqlscript/licence.txt Xshare/java/squirrel-sql/plugins/sqlscript/readme.html Xshare/java/squirrel-sql/plugins/sqlscript/readme.txt Xshare/java/squirrel-sql/plugins/sqlscript/src.jar Xshare/java/squirrel-sql/plugins/sqlscript/toolspopup.jpg Xshare/java/squirrel-sql/plugins/syntax.jar Xshare/java/squirrel-sql/plugins/syntax/changes.txt Xshare/java/squirrel-sql/plugins/syntax/configdlg.jpg Xshare/java/squirrel-sql/plugins/syntax/corrabrev.jpg Xshare/java/squirrel-sql/plugins/syntax/lib/openide-loaders.jar Xshare/java/squirrel-sql/plugins/syntax/lib/openide.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-fold.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-lib.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-util.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor.jar Xshare/java/squirrel-sql/plugins/syntax/lib/syntax.jar Xshare/java/squirrel-sql/plugins/syntax/licence.txt Xshare/java/squirrel-sql/plugins/syntax/readme.html Xshare/java/squirrel-sql/plugins/syntax/src.jar Xshare/java/squirrel-sql/plugins/syntax/standard-nbm-license.txt Xshare/java/squirrel-sql/plugins/syntax/toolspopup.jpg Xshare/java/squirrel-sql/squirrel-sql.jar X@dirrm share/java/squirrel-sql/plugins/syntax/lib X@dirrm share/java/squirrel-sql/plugins/syntax X@dirrm share/java/squirrel-sql/plugins/sqlscript X@dirrm share/java/squirrel-sql/plugins/sqlbookmark X@dirrm share/java/squirrel-sql/plugins/laf/skinlf-theme-packs X@dirrm share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs X@dirrm share/java/squirrel-sql/plugins/laf/lafs X@dirrm share/java/squirrel-sql/plugins/laf X@dirrm share/java/squirrel-sql/plugins/graph X@dirrm share/java/squirrel-sql/plugins/editextras X@dirrm share/java/squirrel-sql/plugins/codecompletion X@dirrm share/java/squirrel-sql/plugins X@dirrm share/java/squirrel-sql/lib X@dirrm share/java/squirrel-sql/icons X@dirrm share/java/squirrel-sql/doc/licences X@dirrm share/java/squirrel-sql/doc/images X@dirrm share/java/squirrel-sql/doc X@dirrm share/java/squirrel-sql END-of-squirrel-sql/pkg-plist echo c - squirrel-sql/files mkdir -p squirrel-sql/files > /dev/null 2>&1 echo x - squirrel-sql/files/squirrel-sql.sh sed 's/^X//' >squirrel-sql/files/squirrel-sql.sh << 'END-of-squirrel-sql/files/squirrel-sql.sh' X#! /bin/sh X[ ${JAVA_HOME} ] && JAVA=${JAVA_HOME}/bin/java || JAVA=java X X# Are we running within Cygwin on some version of Windows? Xcygwin=false; Xcase "`uname -s`" in X CYGWIN*) cygwin=true ;; Xesac X X# Squirrel home. XSQUIRREL_SQL_HOME=`dirname "$0"` X X# SQuirreL home in Unix format. Xif $cygwin ; then X UNIX_STYLE_HOME=`cygpath "$SQUIRREL_SQL_HOME"` Xelse X UNIX_STYLE_HOME=$SQUIRREL_SQL_HOME Xfi X X# First entry in classpath is the Squirrel application. XTMP_CP=$UNIX_STYLE_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. XIFS="" Xfor a in $UNIX_STYLE_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. If running X# Cygwin we also need to change the classpath to Windows format. Xif $cygwin ; then X TMP_CP=`cygpath -w -p $TMP_CP` X TMP_CP=$TMP_CP';'$CLASSPATH Xelse X TMP_CP=$TMP_CP:$CLASSPATH Xfi X X#To add translation working directories to your classpath edit and uncomment this line: X#$JAVA -Xmx256m -cp $TMP_CP: net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X X#To change the language edit and uncomment this line: X#$JAVA -Xmx256m -cp $TMP_CP: -Duser.language= net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X X X$JAVA -Xmx256m -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X END-of-squirrel-sql/files/squirrel-sql.sh echo x - squirrel-sql/files/squirrel-sql.in sed 's/^X//' >squirrel-sql/files/squirrel-sql.in << 'END-of-squirrel-sql/files/squirrel-sql.in' X#! /bin/sh X X# Squirrel home. XSQUIRREL_SQL_HOME=%%JAVASHAREDIR%%/squirrel-sql X X# First entry in classpath is the Squirrel application. XTMP_CP=$SQUIRREL_SQL_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. Xfor a in $SQUIRREL_SQL_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. XTMP_CP=$TMP_CP:$CLASSPATH X Xjava -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 END-of-squirrel-sql/files/squirrel-sql.in echo x - squirrel-sql/files/squirrel-sql.in~ sed 's/^X//' >squirrel-sql/files/squirrel-sql.in~ << 'END-of-squirrel-sql/files/squirrel-sql.in~' X#! /bin/sh X X# Squirrel home. XSQUIRREL_SQL_HOME=%%JAVASHAREDIR%%/squirrel-sql X X# First entry in classpath is the Squirrel application. XTMP_CP=$SQUIRREL_SQL_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. Xfor a in $SQUIRREL_SQL_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. XTMP_CP=$TMP_CP:$CLASSPATH X Xjava -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 END-of-squirrel-sql/files/squirrel-sql.in~ exit >Release-Note: >Audit-Trail: >Unformatted: