From owner-freebsd-ports Thu Jun 6 14: 0:40 2002 Delivered-To: freebsd-ports@hub.freebsd.org Received: from freefall.freebsd.org (freefall.FreeBSD.org [216.136.204.21]) by hub.freebsd.org (Postfix) with ESMTP id 3CF7237B408 for ; Thu, 6 Jun 2002 14:00:02 -0700 (PDT) Received: (from gnats@localhost) by freefall.freebsd.org (8.11.6/8.11.6) id g56L02d28766; Thu, 6 Jun 2002 14:00:02 -0700 (PDT) (envelope-from gnats) Received: from budapest.dante.org.uk (budapest.dante.org.uk [193.63.211.72]) by hub.freebsd.org (Postfix) with ESMTP id DE15637B408 for ; Thu, 6 Jun 2002 13:56:56 -0700 (PDT) Received: from budapest.dante.org.uk (localhost [127.0.0.1]) by budapest.dante.org.uk (8.12.3/8.12.3) with ESMTP id g56KusLt088187 for ; Thu, 6 Jun 2002 21:56:54 +0100 (BST) (envelope-from janos@budapest.dante.org.uk) Received: (from janos@localhost) by budapest.dante.org.uk (8.12.3/8.12.3/Submit) id g56KusxU088186; Thu, 6 Jun 2002 21:56:54 +0100 (BST) Message-Id: <200206062056.g56KusxU088186@budapest.dante.org.uk> Date: Thu, 6 Jun 2002 21:56:54 +0100 (BST) From: Janos Mohacsi Reply-To: Janos Mohacsi To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/38958: New port: MySQLMan - a web based MySQL database manager written in perl Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org >Number: 38958 >Category: ports >Synopsis: New port: MySQLMan - a web based MySQL database manager written in perl >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu Jun 06 14:00:02 PDT 2002 >Closed-Date: >Last-Modified: >Originator: Janos Mohacsi >Release: FreeBSD 4.6-RC i386 >Organization: DANTE >Environment: System: FreeBSD budapest.dante.org.uk 4.6-RC FreeBSD 4.6-RC #2: Mon Jun 3 09:47:22 BST 2002 janos@budapest.dante.org.uk:/usr/src/sys/compile/BUDAPEST i386 >Description: New port: MySQLMan - a web based MySQL database manager written in perl. This port can be useful those, who have to manage MySQL remotely via web, but they don't want to install php for phpMyAdmin. Unfortunately the license is not complete free: You have to download yourself from the original distribution site then you can freely use it, but you cannot redistribute. >How-To-Repeat: Apply this shar. >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: # # mysqlman # mysqlman/pkg-plist # mysqlman/pkg-descr # mysqlman/pkg-comment # mysqlman/distinfo # mysqlman/Makefile # mysqlman/files # mysqlman/files/patch-mysql.cgi # echo c - mysqlman mkdir -p mysqlman > /dev/null 2>&1 echo x - mysqlman/pkg-plist sed 's/^X//' >mysqlman/pkg-plist << 'END-of-mysqlman/pkg-plist' X%%MYMANDIR%%/GT/Base.pm X%%MYMANDIR%%/GT/CGI/EventLoop.pm X%%MYMANDIR%%/GT/CGI.pm X%%MYMANDIR%%/GT/Template/Editor.pm X%%MYMANDIR%%/GT/Template/Parser.pm X%%MYMANDIR%%/GT/Template.pm X%%MYMANDIR%%/GT/TempFile.pm X%%MYMANDIR%%/GT/Date.pm X%%MYMANDIR%%/GT/Cache.pm X%%MYMANDIR%%/GT/Dumper.pm X%%MYMANDIR%%/bases.pm X%%MYMANDIR%%/README X%%MYMANDIR%%/html.pl X%%MYMANDIR%%/mysql.cgi X%%MYMANDIR%%/mysql.cfg.dist X%%MYMANDIR%%/constants.pm X%%MYMANDIR%%/templates/help/col_def.jpg X%%MYMANDIR%%/templates/help/help_add_col.html X%%MYMANDIR%%/templates/help/help_browse.html X%%MYMANDIR%%/templates/help/help_col_def.html X%%MYMANDIR%%/templates/help/help_col_def_change.html X%%MYMANDIR%%/templates/help/help_confirm.html X%%MYMANDIR%%/templates/help/help_create_db.html X%%MYMANDIR%%/templates/help/help_create_table.html X%%MYMANDIR%%/templates/help/help_db_list.html X%%MYMANDIR%%/templates/help/help_demo.html X%%MYMANDIR%%/templates/help/help_edit.html X%%MYMANDIR%%/templates/help/help_export.html X%%MYMANDIR%%/templates/help/help_home.html X%%MYMANDIR%%/templates/help/help_import.html X%%MYMANDIR%%/templates/help/help_insert.html X%%MYMANDIR%%/templates/help/help_login.html X%%MYMANDIR%%/templates/help/help_login_back.html X%%MYMANDIR%%/templates/help/insert.jpg X%%MYMANDIR%%/templates/help/help_login_dbname.html X%%MYMANDIR%%/templates/help/help_logout.html X%%MYMANDIR%%/templates/help/help_properties.html X%%MYMANDIR%%/templates/help/help_rename.html X%%MYMANDIR%%/templates/help/help_save_search_result.html X%%MYMANDIR%%/templates/help/help_select.html X%%MYMANDIR%%/templates/help/help_sql_dump.html X%%MYMANDIR%%/templates/help/help_sql_monitor.html X%%MYMANDIR%%/templates/help/help_sqlerr.html X%%MYMANDIR%%/templates/help/help_table_list.html X%%MYMANDIR%%/templates/help/help_toolbar.html X%%MYMANDIR%%/templates/alter_col.html X%%MYMANDIR%%/templates/confirm.html X%%MYMANDIR%%/templates/create_field.txt X%%MYMANDIR%%/templates/create_table.html X%%MYMANDIR%%/templates/database.html X%%MYMANDIR%%/templates/demo_prompt.html X%%MYMANDIR%%/templates/edit.html X%%MYMANDIR%%/templates/fields_selection.txt X%%MYMANDIR%%/templates/functions.txt X%%MYMANDIR%%/templates/header.txt X%%MYMANDIR%%/templates/insert.html X%%MYMANDIR%%/templates/login.html X%%MYMANDIR%%/templates/login_back.html X%%MYMANDIR%%/templates/login_dbname.html X%%MYMANDIR%%/templates/logout.html X%%MYMANDIR%%/templates/message.txt X%%MYMANDIR%%/templates/op_add_fields.html X%%MYMANDIR%%/templates/op_create_db.html X%%MYMANDIR%%/templates/op_create_table.html X%%MYMANDIR%%/templates/op_export.html X%%MYMANDIR%%/templates/op_import.html X%%MYMANDIR%%/templates/op_mysqldump.html X%%MYMANDIR%%/templates/op_rename_table.html X%%MYMANDIR%%/templates/op_sql_monitor.html X%%MYMANDIR%%/templates/page_jump.txt X%%MYMANDIR%%/templates/property.html X%%MYMANDIR%%/templates/save_search.html X%%MYMANDIR%%/templates/show_query.html X%%MYMANDIR%%/templates/sqlerr.html X%%MYMANDIR%%/templates/table.html X%%MYMANDIR%%/templates/table_browse.html X%%MYMANDIR%%/templates/table_select.html X@dirrm %%MYMANDIR%%/GT/CGI X@dirrm %%MYMANDIR%%/GT/Template X@dirrm %%MYMANDIR%%/GT X@dirrm %%MYMANDIR%%/templates/help X@dirrm %%MYMANDIR%%/templates/compiled X@dirrm %%MYMANDIR%%/templates X@dirrm %%MYMANDIR%%/ END-of-mysqlman/pkg-plist echo x - mysqlman/pkg-descr sed 's/^X//' >mysqlman/pkg-descr << 'END-of-mysqlman/pkg-descr' XMySQLMan is a web based database manager. It allows you to perform common Xmaintenance and administration tasks in Mysql. MySQLMan was based off of XPHPmyadmin, but written in Perl. It allows you to do common tasks like: X X- browse/create/drop databases X- browse/search/create/drop/alter tables X- import/export data X- add/remove/alter table columns X- add/remove/alter table keys X XWWW: http://www.gossamer-threads.com/scripts/mysqlman/index.htm END-of-mysqlman/pkg-descr echo x - mysqlman/pkg-comment sed 's/^X//' >mysqlman/pkg-comment << 'END-of-mysqlman/pkg-comment' XMySQLMan is a web based MySQL database manager written in perl END-of-mysqlman/pkg-comment echo x - mysqlman/distinfo sed 's/^X//' >mysqlman/distinfo << 'END-of-mysqlman/distinfo' XMD5 (mysqlman.tar.gz) = 73cea1f037691097091aa0f8b56ea7e5 END-of-mysqlman/distinfo echo x - mysqlman/Makefile sed 's/^X//' >mysqlman/Makefile << 'END-of-mysqlman/Makefile' X# New ports collection makefile for: mysqlman X# Date created: 06.06.2002 X# Whom: Janos Mohacsi X# X# $FreeBSD$ X XPORTNAME= mysqlman XPORTVERSION= 1.09 XCATEGORIES= databases www XMASTER_SITES= #http://www.gossamer-threads.com/scripts/mysqlman/index.htm XDISTFILES= mysqlman.tar.gz X XMAINTAINER= Janos.Mohacsi@bsd.hu X XRUN_DEPENDS= ${LOCALBASE}/lib/perl5/site_perl/${PERL_VER}/${PERL_ARCH}/DBI.pm:${PORTSDIR}/databases/p5-DBI \ X ${WWW_DIR}:${PORTSDIR}/www/apache13 X XRESTRICTED= "not redistributable, license agreement required" XNO_CDROM= ${RESTRICTED} XNO_PACKAGE= ${RESTRICTED} XUSE_PERL5= yes XNO_BUILD= yes X X# to determine whether apache installed XWWW_DIR= ${LOCALBASE}/www/ X#install dir of mysqlman XMYMANDIR= www/mysqlman-${PORTVERSION} X X#do the substitution according to the install place XPLIST_SUB+= MYMANDIR=${MYMANDIR} X X#FILES to patch Xf="mysql.cgi" X X#Web user XWEBUSER?= www:www X Xdo-fetch: X @if [ ! -f ${DISTDIR}/${DISTFILES} ]; then \ X ${ECHO} '======================================================='; \ X ${ECHO} 'You need to read the license agreement on '; \ X ${ECHO} 'http://www.gossamer-threads.com/scripts/mysqlman/index.htm'; \ X ${ECHO} 'and download on your own.'; \ X ${ECHO} 'Once ${DISTFILES} has been downloaded, move it to '; \ X ${ECHO} '${DISTDIR} and then restart this build '; \ X ${ECHO} '======================================================='; \ X fi X Xdo-configure: X @${MV} ${WRKSRC}/${f} ${WRKSRC}/${f}.bak && ${SED} <${WRKSRC}/${f}.bak \ X s+%%PATHPERLBIN%%+${PERL5}+g >${WRKSRC}/${f} X Xdo-install: X @${FIND} ${WRKSRC} ! \( -path "*/${f}*" -or -path "*/mysql.cfg" \) | ${XARGS} -n1 ${SH} -c 'if ${TEST} -d $$0; \ X then ${MKDIR} ${PREFIX}/${MYMANDIR}$${0#${WRKSRC}}; \ X else ${INSTALL_DATA} $$0 ${PREFIX}/${MYMANDIR}$${0#${WRKSRC}}; fi' X @${INSTALL_SCRIPT} ${WRKSRC}/mysql.cgi ${PREFIX}/${MYMANDIR} X @if [ -L ${PREFIX}/www/mysqlman ]; then \ X ${ECHO} "Updating ${PREFIX}/www/mysqlman symbolic link" ; \ X ${RM} ${PREFIX}/www/mysqlman ; \ X fi X ${LN} -s ${PREFIX}/${MYMANDIR} ${PREFIX}/www/mysqlman X Xpost-install: X @${CHOWN} ${WEBUSER} ${PREFIX}/${MYMANDIR}/templates/compiled X @${INSTALL_DATA} ${WRKSRC}/mysql.cfg ${PREFIX}/${MYMANDIR}/mysql.cfg.dist X @${ECHO} "" X @${ECHO} "Sample config installed at \ X ${PREFIX}/${MYMANDIR}/mysql.cfg.dist" X @${ECHO} "Modify to your needs!" X @${ECHO} "" X X.include END-of-mysqlman/Makefile echo c - mysqlman/files mkdir -p mysqlman/files > /dev/null 2>&1 echo x - mysqlman/files/patch-mysql.cgi sed 's/^X//' >mysqlman/files/patch-mysql.cgi << 'END-of-mysqlman/files/patch-mysql.cgi' X*** mysql.cgi.orig Thu Jun 6 20:07:24 2002 X--- mysql.cgi Thu Jun 6 20:08:07 2002 X*************** X*** 1,4 **** X! #!/usr/bin/perl X # ================================================================== X # MySQLMan - web based MySQL manager. X # X--- 1,4 ---- X! #!%%PATHPERLBIN%% X # ================================================================== X # MySQLMan - web based MySQL manager. X # END-of-mysqlman/files/patch-mysql.cgi exit >Release-Note: >Audit-Trail: >Unformatted: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message