[Mapbender-commits] r9980 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-10-22 06:54:24 -0700 (Mon, 22 Oct 2018)
New Revision: 9980

Modified:
   trunk/mapbender/resources/db/install_geoportal_mb28.sh
Log:
Allow to define initial services for default guis

Modified: trunk/mapbender/resources/db/install_geoportal_mb28.sh
===================================================================
--- trunk/mapbender/resources/db/install_geoportal_mb28.sh	2018-10-22 09:34:05 UTC (rev 9979)
+++ trunk/mapbender/resources/db/install_geoportal_mb28.sh	2018-10-22 13:54:24 UTC (rev 9980)
@@ -95,11 +95,6 @@
 	echo "Acquire::http::Proxy \"http://$http_proxy_host:$http_proxy_port\";" > /etc/apt/apt.conf
     fi 
     # first line should be: Acquire::http::Proxy "http://$http_proxy_host:$http_proxy_port";
-    # for subversion alter /etc/subversion/servers - alter following lines
-    # # http-proxy-host = defaultproxy.whatever.com
-    sed -i "s/# http-proxy-host = defaultproxy.whatever.com/http-proxy-host = $http_proxy_host/g" /etc/subversion/servers
-    sed -i "s/# http-proxy-port = 7000/http-proxy-port = $http_proxy_port/g" /etc/subversion/servers
-    # # http-proxy-port = 7000
 fi
 ############################################################
 if [ $install_system_packages = 'true' ]; then
@@ -112,6 +107,19 @@
 # mysql root password: mysqlroot - normally debian-sys-maint
 # after install - 1.9GB!!!
 ############################################################
+#
+# 
+############################################################
+# set some environment variables
+############################################################
+if [ $use_proxy = 'true' ]; then
+    # for subversion alter /etc/subversion/servers - alter following lines
+    # # http-proxy-host = defaultproxy.whatever.com
+    sed -i "s/# http-proxy-host = defaultproxy.whatever.com/http-proxy-host = $http_proxy_host/g" /etc/subversion/servers
+    sed -i "s/# http-proxy-port = 7000/http-proxy-port = $http_proxy_port/g" /etc/subversion/servers
+    # # http-proxy-port = 7000
+fi
+############################################################
 if [ $create_folders = 'true' ]; then
     # initial installation of geoportal.rlp on debian 8
     ############################################################
@@ -464,6 +472,7 @@
 su - postgres -c "psql -q -p $mapbender_database_port -d $mapbender_database_name -c 'GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO $mapbender_database_user'"
 su - postgres -c "psql -q -p $mapbender_database_port -d $mapbender_database_name -c 'GRANT ALL PRIVILEGES ON DATABASE $mapbender_database_name TO $mapbender_database_user'"
 su - postgres -c "psql -q -p $mapbender_database_port -d $mapbender_database_name -c 'GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE $mapbender_database_name TO $mapbender_database_user'"
+su - postgres -c "psql -q -p $mapbender_database_port -d $mapbender_database_name -c 'GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA mapbender TO $mapbender_database_user'"
 
 #####################
 # add precise coordinate transformation to proj and postgis extension
@@ -553,6 +562,15 @@
 [ -f /tmp/wmsmonitorlock ] && : || php5 ${installation_folder}mapbender/tools/mod_monitorCapabilities_main.php group:${mapbender_subadmin_group_id} > /dev/null
 EOF
     #####################
+    # register initial services for default and extended search GUIs
+    ##################### Geoportal-RLP
+    wms_id_1=`/usr/bin/php -f ${installation_folder}mapbender/tools/registerOwsCli.php userId=1 guiId='Geoportal-RLP' serviceType='wms' serviceAccessUrl='http://geo4.service24.rlp.de/wms/dop_basis.fcgi?REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS'`
+    wms_id_2=`/usr/bin/php -f ${installation_folder}mapbender/tools/registerOwsCli.php userId=1 guiId='Geoportal-RLP' serviceType='wms' serviceAccessUrl='http://www.gdi-rp-dienste2.rlp.de/cgi-bin/mapserv?map=/data/umn/geoportal/relief_rp/rlp_relief.map&REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS'`
+    wms_id_3=`/usr/bin/php -f ${installation_folder}mapbender/tools/registerOwsCli.php userId=1 guiId='Geoportal-RLP' serviceType='wms' serviceAccessUrl='http://geo5.service24.rlp.de/wms/karte_rp.fcgi?REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS'`
+    ##################### Geoportal-RLP_erwSuche2
+    wms_id_4=`/usr/bin/php -f ${installation_folder}mapbender/tools/registerOwsCli.php userId=1 guiId='Geoportal-RLP_erwSuche2' serviceType='wms' serviceAccessUrl='http://geo4.service24.rlp.de/wms/dop_basis.fcgi?REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS'`
+    wms_id_5=`/usr/bin/php -f ${installation_folder}mapbender/tools/registerOwsCli.php userId=1 guiId='Geoportal-RLP_erwSuche2' serviceType='wms' serviceAccessUrl='http://www.gdi-rp-dienste2.rlp.de/cgi-bin/mapserv?map=/data/umn/geoportal/relief_rp/rlp_relief.map&REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS'`
+    #####################
 fi
 
 ############################################################