path: root/databases/phpmyadmin-devel
diff options
authorJochen Neumeister <joneum@FreeBSD.org>2019-09-18 19:21:47 +0000
committerJochen Neumeister <joneum@FreeBSD.org>2019-09-18 19:21:47 +0000
commit71180f6a5d86dda00ed691c825baf2b825bf6a14 (patch)
treeab93d52e8edc0d9676363517f9960726da227e00 /databases/phpmyadmin-devel
parent59f112ae96ff19a96c4a6dcba49869c2674281ba (diff)
Add phpmyadmin-devel to the ports-tree
Changelog: Welcome to the first public alpha of phpMyAdmin 5.0.0. This release features a great number of new features and bug fixes. With this release, we are removing support of old PHP versions (5.5, 5.6, 7.0, and HHVM). These versions are outdated and are no longer supported by the PHP team. Detailed requirement information is available in the documentation included with the download or at https://docs.phpmyadmin.net/en/latest/require.html. As shown at https://www.phpmyadmin.net/downloads/#support our current branch of 4.9.x is planned to remain supported for some time in an LTS capacity. Some of the changes and new features include: * Enable columns names by default for CSV exports * Add Metro theme * Automatically add the index when creating an auto increment column * Improvements to exporting views * Prompt the user for confirmation before running an UPDATE query with no WHERE clause * Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard) * Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u) * Use charset 'windows-1252' when export format is MS Excel There are several more changes, please refer to the ChangeLog file included with the release for full details. Known shortcomings: Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at https://github.com/phpmyadmin/phpmyadmin/issues/14220. Downloads are available now at https://phpmyadmin.net/downloads/ Our work would not be possible without the donations of our generous sponsor, and this release in particular is brought to you thanks to the hard work of our Google Summer of Code students and many other contributors. For the team, Isaac Sponsored by: Netzkommune GmbH
Notes: svn path=/head/; revision=512284
Diffstat (limited to 'databases/phpmyadmin-devel')
6 files changed, 201 insertions, 0 deletions
diff --git a/databases/phpmyadmin-devel/Makefile b/databases/phpmyadmin-devel/Makefile
new file mode 100644
index 000000000000..316d5f1eaa52
--- /dev/null
+++ b/databases/phpmyadmin-devel/Makefile
@@ -0,0 +1,100 @@
+# Created by: nbm
+# $FreeBSD$
+PORTNAME= phpMyAdmin
+DISTVERSION= 5.0.0-alpha1
+CATEGORIES= databases www
+MASTER_SITES= https://files.phpmyadmin.net/${PORTNAME}/${DISTVERSION}/
+MAINTAINER= joneum@FreeBSD.org
+COMMENT= Set of PHP-scripts to manage MySQL over the web
+USES= cpe php:web,flavors tar:xz
+NO_ARCH= yes
+NO_BUILD= yes
+.if !defined(WITHOUT_PHP_DEPENDS)
+# Note: composer.json files in the source list pcre as a required
+# extension, but pcre is compiled into PHP as standard on FreeBSD.
+# spl, libsodium are only required in the bundled vendor code. PMA
+# could, in principle, also use the PHP dbase extension, but it's not
+# available for PHP >= 7.0 and of only minority interest.
+USE_PHP= ctype filter hash json mysqli session spl xml
+# Note: default settings will pull in X11 client support. If you don't
+# want this, either turn off GD in the config dialog, or else turn off
+# FONTCONFIG in the graphics/gd port options.
+BZ2_DESC= PHP bzip2 library support
+CURL_DESC= PHP curl support
+GD_DESC= PHP GD library support (requires X11)
+GMP_DESC= PHP GMP library support
+MBSTRING_DESC= PHP Multi-byte String support
+OPCACHE_DESC= PHP Opcache support
+PDF_DESC= PHP PDFlib support
+SODIUM_DESC= PHP libsodium support (only available for PHP >= 7.2)
+ZIP_DESC= PHP Zip compression support
+.include <bsd.port.options.mk>
+CFG_FILE= config.inc.php
+PLIST= ${WRKDIR}/plist
+SUB_FILES+= pkg-message
+.if !defined(WITHOUT_PHP_DEPENDS)
+.for opt in ${OPTIONS_DEFINE}
+. if ${PORT_OPTIONS:M${opt}}
+USE_PHP+= ${opt:tl}
+. endif
+ cd ${WRKSRC} ; \
+ ${CP} ${FILESDIR}/${CFG_FILE}.sample ${WRKSRC}/${CFG_FILE}.sample ; \
+ ${FIND} . ! -type d ! -name ${CFG_FILE}.sample ! -name '*.bak' | \
+ ${SORT} | ${SED} -e "s,^\.,%%WWWDIR%%," >${PLIST} ; \
+ ${CAT} ${PKGDIR}/pkg-plist-chunk >>${PLIST} ; \
+ for emptydir in $$( ${FIND} . -type d -empty -print | \
+ ${SED} -e "s,^\.,%%WWWDIR%%," ) ; do \
+ ${ECHO} "@dir $${emptydir}" >>${PLIST} ; \
+ done ; \
+ cd ${WRKSRC} ; \
+ for src in $$( ${FIND} . ! -name .cvsignore ! -name '*.bak' ) ; do \
+ dst=${STAGEDIR}${WWWDIR}$${src#.} ; \
+ if ${TEST} -d "$$src" ; then \
+ ${MKDIR} "$$dst" ; \
+ else \
+ ${INSTALL_DATA} "$$src" "$$dst" ; \
+ fi \
+ done
+.include <bsd.port.mk>
diff --git a/databases/phpmyadmin-devel/distinfo b/databases/phpmyadmin-devel/distinfo
new file mode 100644
index 000000000000..9f82bd892631
--- /dev/null
+++ b/databases/phpmyadmin-devel/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1568833819
+SHA256 (phpMyAdmin-5.0.0-alpha1-all-languages.tar.xz) = b078d07ecaec2571fb0a597dd48b6b7a91f4adc4f8617ddd4017969ae41c03a8
+SIZE (phpMyAdmin-5.0.0-alpha1-all-languages.tar.xz) = 8200540
diff --git a/databases/phpmyadmin-devel/files/config.inc.php.sample b/databases/phpmyadmin-devel/files/config.inc.php.sample
new file mode 100644
index 000000000000..73f35478b952
--- /dev/null
+++ b/databases/phpmyadmin-devel/files/config.inc.php.sample
@@ -0,0 +1,14 @@
+/* $FreeBSD$
+ *
+ * Skeleton configuration file -- this file is empty on a fresh
+ * installaton of phpmyadmin.
+ *
+ * Copy any settings you want to override from
+ * libraries/config.default.php or visit /phpmyadmin/setup/ to generate a
+ * basic configuration file
+ *
+ */
diff --git a/databases/phpmyadmin-devel/files/pkg-message.in b/databases/phpmyadmin-devel/files/pkg-message.in
new file mode 100644
index 000000000000..c59745d76ae7
--- /dev/null
+++ b/databases/phpmyadmin-devel/files/pkg-message.in
@@ -0,0 +1,48 @@
+{ type: install
+ message: <<EOM
+%%PKGNAME%% has been installed into:
+ %%WWWDIR%%
+Please edit config.inc.php to suit your needs.
+To make phpMyAdmin available through your web site, I suggest
+that you add something like the following to httpd.conf:
+For Apache versions earlier than 2.4:
+ Alias /phpmyadmin/ "%%WWWDIR%%/"
+ <Directory "%%WWWDIR%%/">
+ Options none
+ AllowOverride Limit
+ Order Deny,Allow
+ Deny from all
+ Allow from .example.com
+ </Directory>
+For Apache version 2.4.x or above:
+ Alias /phpmyadmin/ "%%WWWDIR%%/"
+ <Directory "%%WWWDIR%%/">
+ Options None
+ AllowOverride Limit
+ Require local
+ Require host .example.com
+ </Directory>
+SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
+remote vulnerabilities discovered in the past, some allowing remote
+attackers to execute arbitrary code with the web server's user credential.
+All known problems have been fixed, but the FreeBSD Security Team strongly
+advises that any instance be protected with an additional protection layer,
+e.g. a different access control mechanism implemented by the web server
+as shown in the example. Do consider enabling phpMyAdmin only when it
+is in use.
diff --git a/databases/phpmyadmin-devel/pkg-descr b/databases/phpmyadmin-devel/pkg-descr
new file mode 100644
index 000000000000..c81c2d88f74d
--- /dev/null
+++ b/databases/phpmyadmin-devel/pkg-descr
@@ -0,0 +1,34 @@
+Currently phpMyAdmin can:
+ * browse and drop databases, tables, views, columns and indexes
+ * display multiple results sets through stored procedures or queries
+ * create, copy, drop, rename and alter databases, tables, columns
+ and indexes
+ * maintain server, databases and tables, with proposals on server
+ configuration
+ * execute, edit and bookmark any SQL-statement, even batch-queries
+ * load text files into tables
+ * create and read dumps of tables
+ * export data to various formats: CSV, XML, PDF, ISO/IEC 26300 -
+ OpenDocument Text and Spreadsheet, Microsoft Word 2000, and
+ LATEX formats
+ * import data and MySQL structures from OpenDocument spreadsheets,
+ as well as XML, CSV, and SQL files
+ * administer multiple servers
+ * manage MySQL users and privileges
+ * check referential integrity in MyISAM tables
+ * using Query-by-example (QBE), create complex queries
+ automatically connecting required tables
+ * create PDF graphics of your database layout
+ * search globally in a database or a subset of it
+ * transform stored data into any format using a set of predefined
+ functions, like displaying BLOB-data as image or download-link
+ * track changes on databases, tables and views
+ * support InnoDB tables and foreign keys
+ * support mysqli, the improved MySQL extension
+ * create, edit, call, export and drop stored procedures and
+ functions
+ * create, edit, export and drop events and triggers
+ * communicate in 62 different languages
+WWW: https://www.phpmyadmin.net/
diff --git a/databases/phpmyadmin-devel/pkg-plist-chunk b/databases/phpmyadmin-devel/pkg-plist-chunk
new file mode 100644
index 000000000000..45a66a99133a
--- /dev/null
+++ b/databases/phpmyadmin-devel/pkg-plist-chunk
@@ -0,0 +1,2 @@
+@sample(,%%PMA_GRP%%,640) %%WWWDIR%%/config.inc.php.sample
+@dir(,%%PMA_GRP%%,770) %%WWWDIR%%/tmp