Add pgpoolAdmin 1.0.0, web-based administration tool for pgpool-II.

7 files changed, 295 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 2612ea7ee3c7..60bd5d403574 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -334,6 +334,7 @@
     SUBDIR += pgcluster
     SUBDIR += pgpool
     SUBDIR += pgpool-II
+    SUBDIR += pgpoolAdmin
     SUBDIR += pgtop
     SUBDIR += pgworksheet
     SUBDIR += php-sqlite3
diff --git a/databases/pgpoolAdmin/Makefile b/databases/pgpoolAdmin/Makefile
new file mode 100644
index 000000000000..e5cfff39a5ec
--- /dev/null
+++ b/databases/pgpoolAdmin/Makefile
@@ -0,0 +1,34 @@
+# New ports collection makefile for:	pgpoolAdmin
+# Date created:				Apr 10, 2007
+# Whom:					Jun Kuriyama <kuriyama@FreeBSD.org>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	pgpoolAdmin
+PORTVERSION=	1.0.0
+CATEGORIES=	databases
+MASTER_SITES=	http://pgfoundry.org/frs/download.php/1068/
+
+MAINTAINER=	kuriyama@FreeBSD.org
+COMMENT=	Web-based administration tool for pgpool-II
+
+RUN_DEPENDS=	pgpool:${PORTSDIR}/databases/pgpool-II
+
+USE_APACHE=	1.3+
+USE_PHP=	mbstring pcre pgsql session
+NO_BUILD=	yes
+PLIST_SUB=	WWWOWN=${WWWOWN} WWWGRP=${WWWGRP}
+
+post-extract:
+	${MV} ${WRKSRC}/conf/pgmgt.conf.php ${WRKSRC}/conf/pgmgt.conf.php.sample
+
+pre-install:
+	${FIND} ${WRKSRC} -name '*.orig' | ${XARGS} ${RM}
+
+do-install:
+	${MKDIR} ${WWWDIR}
+	${CP} -R ${WRKSRC}/* ${WWWDIR}/
+	${CHOWN} ${WWWOWN}:${WWWGRP} ${WWWDIR}/templates_c ${WWWDIR}/conf/pgmgt.conf.php
+
+.include <bsd.port.mk>
diff --git a/databases/pgpoolAdmin/distinfo b/databases/pgpoolAdmin/distinfo
new file mode 100644
index 000000000000..3ecc94c3f2c0
--- /dev/null
+++ b/databases/pgpoolAdmin/distinfo
@@ -0,0 +1,3 @@
+MD5 (pgpoolAdmin-1.0.0.tar.gz) = 1a4a69e5fd7941008319d565b1957207
+SHA256 (pgpoolAdmin-1.0.0.tar.gz) = a68c1f9a23a7dd445290704e8b737c9ce67d9bd977e9d059ad435e3882b67a77
+SIZE (pgpoolAdmin-1.0.0.tar.gz) = 853946
diff --git a/databases/pgpoolAdmin/files/patch-common.php b/databases/pgpoolAdmin/files/patch-common.php
new file mode 100644
index 000000000000..d812729adecf
--- /dev/null
+++ b/databases/pgpoolAdmin/files/patch-common.php
@@ -0,0 +1,11 @@
+--- common.php.orig	Thu Apr 12 20:13:37 2007
++++ common.php	Thu Apr 12 20:13:55 2007
+@@ -233,7 +233,7 @@
+     if($backendHostName != '') {
+         $conStr = "dbname=$healthCheckDb user=$healthCheckUser host=$backendHostName port=$backendPort" ;
+     } else {
+-        $conStr = "dbname=$healthCheckDb port=$backendPort" ;
++        $conStr = "dbname=$healthCheckDb user=$healthCheckUser port=$backendPort" ;
+     }
+ 
+     $conn = @pg_connect($conStr);
diff --git a/databases/pgpoolAdmin/files/patch-status.tpl b/databases/pgpoolAdmin/files/patch-status.tpl
new file mode 100644
index 000000000000..19984c994051
--- /dev/null
+++ b/databases/pgpoolAdmin/files/patch-status.tpl
@@ -0,0 +1,12 @@
+--- templates/status.tpl.orig	Tue Apr 10 18:48:12 2007
++++ templates/status.tpl	Tue Apr 10 19:58:35 2007
+@@ -183,7 +183,8 @@
+     {/if}
+ </p>
+ {else}
+-{$message.strStopPgpool|escape}
++  <p>{$message.strStopPgpool|escape}</p>
++  <div id="status"></div>
+ {/if}
+ <h2>{$message.strPgpool|escape}</h2>
+     {if $pgpoolIsActive == false}
diff --git a/databases/pgpoolAdmin/pkg-descr b/databases/pgpoolAdmin/pkg-descr
new file mode 100644
index 000000000000..3d294f08939e
--- /dev/null
+++ b/databases/pgpoolAdmin/pkg-descr
@@ -0,0 +1,3 @@
+Web-based administration tool for pgpool-II.
+
+WWW: http://pgpool.projects.postgresql.org/pgpool-II/en/
diff --git a/databases/pgpoolAdmin/pkg-plist b/databases/pgpoolAdmin/pkg-plist
new file mode 100644
index 000000000000..023d13452d83
--- /dev/null
+++ b/databases/pgpoolAdmin/pkg-plist
@@ -0,0 +1,231 @@
+%%WWWDIR%%/README
+%%WWWDIR%%/README.euc_jp
+%%WWWDIR%%/changePassword.php
+%%WWWDIR%%/command.php
+%%WWWDIR%%/common.php
+%%WWWDIR%%/conf/pgmgt.conf.php.sample
+%%WWWDIR%%/config.php
+%%WWWDIR%%/definePgpoolConfParam.php
+%%WWWDIR%%/doc/en/changePassword.html
+%%WWWDIR%%/doc/en/config.html
+%%WWWDIR%%/doc/en/errorCode.html
+%%WWWDIR%%/doc/en/images/1.jpg
+%%WWWDIR%%/doc/en/images/2.jpg
+%%WWWDIR%%/doc/en/images/3.jpg
+%%WWWDIR%%/doc/en/images/4.jpg
+%%WWWDIR%%/doc/en/images/ng.gif
+%%WWWDIR%%/doc/en/images/nodestatus.jpg
+%%WWWDIR%%/doc/en/images/ok.gif
+%%WWWDIR%%/doc/en/images/pgpooladmin.jpg
+%%WWWDIR%%/doc/en/images/restart.jpg
+%%WWWDIR%%/doc/en/images/start.jpg
+%%WWWDIR%%/doc/en/images/status.jpg
+%%WWWDIR%%/doc/en/images/stop.jpg
+%%WWWDIR%%/doc/en/install.html
+%%WWWDIR%%/doc/en/login.html
+%%WWWDIR%%/doc/en/logout.html
+%%WWWDIR%%/doc/en/nodeServerStatus.html
+%%WWWDIR%%/doc/en/pgconfig.html
+%%WWWDIR%%/doc/en/queryCache.html
+%%WWWDIR%%/doc/en/status.html
+%%WWWDIR%%/doc/en/systemDb.html
+%%WWWDIR%%/doc/images/background.gif
+%%WWWDIR%%/doc/images/logo.gif
+%%WWWDIR%%/doc/images/marker.gif
+%%WWWDIR%%/doc/images/sea.jpg
+%%WWWDIR%%/doc/images/spacer.gif
+%%WWWDIR%%/doc/index_en.html
+%%WWWDIR%%/doc/index_ja.html
+%%WWWDIR%%/doc/ja/changePassword.html
+%%WWWDIR%%/doc/ja/config.html
+%%WWWDIR%%/doc/ja/errorCode.html
+%%WWWDIR%%/doc/ja/images/1.jpg
+%%WWWDIR%%/doc/ja/images/2.jpg
+%%WWWDIR%%/doc/ja/images/3.jpg
+%%WWWDIR%%/doc/ja/images/4.jpg
+%%WWWDIR%%/doc/ja/images/ng.gif
+%%WWWDIR%%/doc/ja/images/nodestatus.jpg
+%%WWWDIR%%/doc/ja/images/ok.gif
+%%WWWDIR%%/doc/ja/images/pgpooladmin.jpg
+%%WWWDIR%%/doc/ja/images/restart.jpg
+%%WWWDIR%%/doc/ja/images/start.jpg
+%%WWWDIR%%/doc/ja/images/status.jpg
+%%WWWDIR%%/doc/ja/images/stop.jpg
+%%WWWDIR%%/doc/ja/install.html
+%%WWWDIR%%/doc/ja/login.html
+%%WWWDIR%%/doc/ja/logout.html
+%%WWWDIR%%/doc/ja/nodeServerStatus.html
+%%WWWDIR%%/doc/ja/pgconfig.html
+%%WWWDIR%%/doc/ja/queryCache.html
+%%WWWDIR%%/doc/ja/status.html
+%%WWWDIR%%/doc/ja/systemDb.html
+%%WWWDIR%%/doc/screen.css
+%%WWWDIR%%/help.php
+%%WWWDIR%%/images/ascending.gif
+%%WWWDIR%%/images/back.gif
+%%WWWDIR%%/images/background.gif
+%%WWWDIR%%/images/descending.gif
+%%WWWDIR%%/images/logo.gif
+%%WWWDIR%%/images/marker.gif
+%%WWWDIR%%/images/question.gif
+%%WWWDIR%%/images/sea.jpg
+%%WWWDIR%%/images/spacer.gif
+%%WWWDIR%%/index.php
+%%WWWDIR%%/innerLog.php
+%%WWWDIR%%/innerNodeServerStatus.php
+%%WWWDIR%%/innerSummary.php
+%%WWWDIR%%/innerSystemCatalog.php
+%%WWWDIR%%/install/checkDirectory.php
+%%WWWDIR%%/install/checkParameter.php
+%%WWWDIR%%/install/defaultParameter.php
+%%WWWDIR%%/install/finish.php
+%%WWWDIR%%/install/images/ng.gif
+%%WWWDIR%%/install/images/ok.gif
+%%WWWDIR%%/install/index.php
+%%WWWDIR%%/install/lang/en.lang.php
+%%WWWDIR%%/install/lang/ja.lang.php
+%%WWWDIR%%/install/setLang.php
+%%WWWDIR%%/lang/en.lang.php
+%%WWWDIR%%/lang/ja.lang.php
+%%WWWDIR%%/libs/Config_File.class.php
+%%WWWDIR%%/libs/Smarty.class.php
+%%WWWDIR%%/libs/Smarty_Compiler.class.php
+%%WWWDIR%%/libs/debug.tpl
+%%WWWDIR%%/libs/internals/core.assemble_plugin_filepath.php
+%%WWWDIR%%/libs/internals/core.assign_smarty_interface.php
+%%WWWDIR%%/libs/internals/core.create_dir_structure.php
+%%WWWDIR%%/libs/internals/core.display_debug_console.php
+%%WWWDIR%%/libs/internals/core.get_include_path.php
+%%WWWDIR%%/libs/internals/core.get_microtime.php
+%%WWWDIR%%/libs/internals/core.get_php_resource.php
+%%WWWDIR%%/libs/internals/core.is_secure.php
+%%WWWDIR%%/libs/internals/core.is_trusted.php
+%%WWWDIR%%/libs/internals/core.load_plugins.php
+%%WWWDIR%%/libs/internals/core.load_resource_plugin.php
+%%WWWDIR%%/libs/internals/core.process_cached_inserts.php
+%%WWWDIR%%/libs/internals/core.process_compiled_include.php
+%%WWWDIR%%/libs/internals/core.read_cache_file.php
+%%WWWDIR%%/libs/internals/core.rm_auto.php
+%%WWWDIR%%/libs/internals/core.rmdir.php
+%%WWWDIR%%/libs/internals/core.run_insert_handler.php
+%%WWWDIR%%/libs/internals/core.smarty_include_php.php
+%%WWWDIR%%/libs/internals/core.write_cache_file.php
+%%WWWDIR%%/libs/internals/core.write_compiled_include.php
+%%WWWDIR%%/libs/internals/core.write_compiled_resource.php
+%%WWWDIR%%/libs/internals/core.write_file.php
+%%WWWDIR%%/libs/plugins/block.textformat.php
+%%WWWDIR%%/libs/plugins/compiler.assign.php
+%%WWWDIR%%/libs/plugins/function.assign_debug_info.php
+%%WWWDIR%%/libs/plugins/function.config_load.php
+%%WWWDIR%%/libs/plugins/function.counter.php
+%%WWWDIR%%/libs/plugins/function.cycle.php
+%%WWWDIR%%/libs/plugins/function.debug.php
+%%WWWDIR%%/libs/plugins/function.eval.php
+%%WWWDIR%%/libs/plugins/function.fetch.php
+%%WWWDIR%%/libs/plugins/function.html_checkboxes.php
+%%WWWDIR%%/libs/plugins/function.html_image.php
+%%WWWDIR%%/libs/plugins/function.html_options.php
+%%WWWDIR%%/libs/plugins/function.html_radios.php
+%%WWWDIR%%/libs/plugins/function.html_select_date.php
+%%WWWDIR%%/libs/plugins/function.html_select_time.php
+%%WWWDIR%%/libs/plugins/function.html_table.php
+%%WWWDIR%%/libs/plugins/function.mailto.php
+%%WWWDIR%%/libs/plugins/function.math.php
+%%WWWDIR%%/libs/plugins/function.popup.php
+%%WWWDIR%%/libs/plugins/function.popup_init.php
+%%WWWDIR%%/libs/plugins/modifier.capitalize.php
+%%WWWDIR%%/libs/plugins/modifier.cat.php
+%%WWWDIR%%/libs/plugins/modifier.count_characters.php
+%%WWWDIR%%/libs/plugins/modifier.count_paragraphs.php
+%%WWWDIR%%/libs/plugins/modifier.count_sentences.php
+%%WWWDIR%%/libs/plugins/modifier.count_words.php
+%%WWWDIR%%/libs/plugins/modifier.date_format.php
+%%WWWDIR%%/libs/plugins/modifier.debug_print_var.php
+%%WWWDIR%%/libs/plugins/modifier.default.php
+%%WWWDIR%%/libs/plugins/modifier.escape.php
+%%WWWDIR%%/libs/plugins/modifier.indent.php
+%%WWWDIR%%/libs/plugins/modifier.lower.php
+%%WWWDIR%%/libs/plugins/modifier.nl2br.php
+%%WWWDIR%%/libs/plugins/modifier.regex_replace.php
+%%WWWDIR%%/libs/plugins/modifier.replace.php
+%%WWWDIR%%/libs/plugins/modifier.spacify.php
+%%WWWDIR%%/libs/plugins/modifier.string_format.php
+%%WWWDIR%%/libs/plugins/modifier.strip.php
+%%WWWDIR%%/libs/plugins/modifier.strip_tags.php
+%%WWWDIR%%/libs/plugins/modifier.truncate.php
+%%WWWDIR%%/libs/plugins/modifier.upper.php
+%%WWWDIR%%/libs/plugins/modifier.wordwrap.php
+%%WWWDIR%%/libs/plugins/outputfilter.trimwhitespace.php
+%%WWWDIR%%/libs/plugins/shared.escape_special_chars.php
+%%WWWDIR%%/libs/plugins/shared.make_timestamp.php
+%%WWWDIR%%/login.php
+%%WWWDIR%%/logout.php
+%%WWWDIR%%/nodeServerStatus.php
+%%WWWDIR%%/nodeStatus.php
+%%WWWDIR%%/pgconfig.php
+%%WWWDIR%%/procInfo.php
+%%WWWDIR%%/queryCache.php
+%%WWWDIR%%/screen.css
+%%WWWDIR%%/status.php
+%%WWWDIR%%/systemDb.php
+%%WWWDIR%%/templates/changePassword.tpl
+%%WWWDIR%%/templates/config.tpl
+%%WWWDIR%%/templates/error.tpl
+%%WWWDIR%%/templates/footer.tpl
+%%WWWDIR%%/templates/help/en/changePassword.tpl
+%%WWWDIR%%/templates/help/en/config.tpl
+%%WWWDIR%%/templates/help/en/errorCode.tpl
+%%WWWDIR%%/templates/help/en/login.tpl
+%%WWWDIR%%/templates/help/en/nodeServerStatus.tpl
+%%WWWDIR%%/templates/help/en/pgconfig.tpl
+%%WWWDIR%%/templates/help/en/queryCache.tpl
+%%WWWDIR%%/templates/help/en/status.tpl
+%%WWWDIR%%/templates/help/en/systemDb.tpl
+%%WWWDIR%%/templates/help/ja/changePassword.tpl
+%%WWWDIR%%/templates/help/ja/config.tpl
+%%WWWDIR%%/templates/help/ja/errorCode.tpl
+%%WWWDIR%%/templates/help/ja/login.tpl
+%%WWWDIR%%/templates/help/ja/nodeServerStatus.tpl
+%%WWWDIR%%/templates/help/ja/pgconfig.tpl
+%%WWWDIR%%/templates/help/ja/queryCache.tpl
+%%WWWDIR%%/templates/help/ja/status.tpl
+%%WWWDIR%%/templates/help/ja/systemDb.tpl
+%%WWWDIR%%/templates/innerError.tpl
+%%WWWDIR%%/templates/innerLog.tpl
+%%WWWDIR%%/templates/innerNodeServerStatus.tpl
+%%WWWDIR%%/templates/innerSummary.tpl
+%%WWWDIR%%/templates/innerSystemCatalog.tpl
+%%WWWDIR%%/templates/login.tpl
+%%WWWDIR%%/templates/menu.tpl
+%%WWWDIR%%/templates/nodeServerStatus.tpl
+%%WWWDIR%%/templates/nodeStatus.tpl
+%%WWWDIR%%/templates/pgconfig.tpl
+%%WWWDIR%%/templates/pgmgtNotFound.tpl
+%%WWWDIR%%/templates/procInfo.tpl
+%%WWWDIR%%/templates/queryCache.tpl
+%%WWWDIR%%/templates/status.tpl
+%%WWWDIR%%/templates/systemDb.tpl
+%%WWWDIR%%/version.php
+@exec mkdir %D/%%WWWDIR%%/templates_c
+@exec chown %%WWWOWN%%:%%WWWGRP%% %D/%%WWWDIR%%/templates_c
+@unexec rm -rf %D/%%WWWDIR%%/templates_c
+@dirrm %%WWWDIR%%/templates/help/ja
+@dirrm %%WWWDIR%%/templates/help/en
+@dirrm %%WWWDIR%%/templates/help
+@dirrm %%WWWDIR%%/templates
+@dirrm %%WWWDIR%%/libs/plugins
+@dirrm %%WWWDIR%%/libs/internals
+@dirrm %%WWWDIR%%/libs
+@dirrm %%WWWDIR%%/lang
+@dirrm %%WWWDIR%%/install/lang
+@dirrm %%WWWDIR%%/install/images
+@dirrm %%WWWDIR%%/install
+@dirrm %%WWWDIR%%/images
+@dirrm %%WWWDIR%%/doc/ja/images
+@dirrm %%WWWDIR%%/doc/ja
+@dirrm %%WWWDIR%%/doc/images
+@dirrm %%WWWDIR%%/doc/en/images
+@dirrm %%WWWDIR%%/doc/en
+@dirrm %%WWWDIR%%/doc
+@dirrmtry %%WWWDIR%%/conf
+@dirrmtry %%WWWDIR%%