Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 6 Jun 2002 21:56:54 +0100 (BST)
From:      Janos Mohacsi <janos.mohacsi@bsd.hu>
To:        FreeBSD-gnats-submit@FreeBSD.org
Subject:   ports/38958: New port: MySQLMan - a web based MySQL database manager written in perl
Message-ID:  <200206062056.g56KusxU088186@budapest.dante.org.uk>

next in thread | raw e-mail | index | archive | help

>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 <janos.mohacsi@bsd.hu>
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 <bsd.port.mk>
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200206062056.g56KusxU088186>