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

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Wed Dec 12 09:31:54 PST 2018


Author: armin11
Date: 2018-12-12 09:31:54 -0800 (Wed, 12 Dec 2018)
New Revision: 10009

Modified:
   trunk/mapbender/resources/db/install_geoportal_mb28.sh
Log:
New options to set initial extent and srs, some bugfixes

Modified: trunk/mapbender/resources/db/install_geoportal_mb28.sh
===================================================================
--- trunk/mapbender/resources/db/install_geoportal_mb28.sh	2018-12-11 16:21:04 UTC (rev 10008)
+++ trunk/mapbender/resources/db/install_geoportal_mb28.sh	2018-12-12 17:31:54 UTC (rev 10009)
@@ -22,7 +22,7 @@
 ############################################################
 use_ssl="false"
 domain_name="192.168.56.101" #beware of using other ports here - some things will not work as expected
-not_proxy_hosts="localhost,127.0.0.1"
+not_proxy_hosts="localhost,127.0.0.1,192.168.56.101"
 ############################################################
 # 
 ############################################################
@@ -46,6 +46,13 @@
 ############################################################
 # 
 ############################################################
+#
+minx="289000"
+miny="5423000"
+maxx="465000"
+maxy="5647000"
+epsg="EPSG:25832"
+############################################################
 bbox_wgs84="6.05,48.9,8.6,50.96"
 ############################################################
 ############################################################
@@ -198,6 +205,7 @@
 
 sed -i "s/error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT/error_reporting = E_ERROR/g" /etc/php5/apache2/php.ini
 sed -i "s/;error_log = php_errors.log/error_log = \/tmp\/php5_apache_errors\.log/g" /etc/php5/apache2/php.ini
+error_log = syslogsed -i "s/error_log = syslog/;error_log = syslog/g" /etc/php5/apache2/php.ini
 
 
 # set some environment variables
@@ -601,6 +609,50 @@
   OWNER TO postgres;
 GRANT ALL ON TABLE users_for_publishing TO postgres;
 GRANT ALL ON TABLE users_for_publishing TO $mapbender_database_user;
+
+--add csw information 
+
+
+INSERT INTO cat VALUES (1, '2.0.2', 'GeoDatenKatalog.De', 'Bereitstellung des Geodatenkatalog.de der GeoDatenInfrastruktur Deutschland (GDI-DE)', 'http://gdk.gdi-de.org/gdi-de/srv/eng/csw?SERVICE=CSW&VERSION=2.0.2&REQUEST=GetCapabilities', 'none', 'none', NULL, NULL, 'admin admin', 'Administrator', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 'iserted via sql - no caps available!', 5299, 1502980960);
+
+INSERT INTO cat_op_conf VALUES (1, 'get', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'getcapabilities');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'getcapabilities');
+INSERT INTO cat_op_conf VALUES (1, 'post_xml', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'getcapabilities');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'describerecord');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'describerecord');
+INSERT INTO cat_op_conf VALUES (1, 'post_xml', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'describerecord');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'getdomain');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'http://ims.geoportal.de/gdi-de/srv/eng/csw', 'getdomain');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'http://ims.geoportal.de/gdi-de/srv/eng/csw-publication', 'transaction');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'http://ims.geoportal.de/gdi-de/srv/eng/csw-publication', 'transaction');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'http://ims.geoportal.de/gdi-de/srv/eng/csw-publication', 'harvest');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'http://ims.geoportal.de/gdi-de/srv/eng/csw-publication', 'harvest');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecords');
+INSERT INTO cat_op_conf VALUES (1, 'post_xml', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecords');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecordbyid');
+INSERT INTO cat_op_conf VALUES (1, 'post_xml', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecordbyid');
+INSERT INTO cat_op_conf VALUES (1, 'get', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecords');
+INSERT INTO cat_op_conf VALUES (1, 'post', 'https://gdk.gdi-de.org/gdi-de/srv/eng/csw', 'getrecordbyid');
+
+
+CREATE TABLE gp_csw (
+    csw_id integer,
+    csw_name text,
+    fkey_cat_id integer,
+    csw_p integer,
+    csw_h integer,
+    hierachylevel character(50)
+);
+
+
+ALTER TABLE gp_csw OWNER TO postgres;
+GRANT ALL ON TABLE gp_csw TO $mapbender_database_user;
+
+INSERT INTO gp_csw VALUES (5, 'GeodatenkatalogDE - Sonstige Informationen', 1, 1, 5, 'nonGeographicDataset');
+INSERT INTO gp_csw VALUES (3, 'GeodatenkatalogDE - Dienste', 1, 1, 5, 'service');
+INSERT INTO gp_csw VALUES (4, 'GeodatenkatalogDE - Anwendungen', 1, 1, 5, 'application');
+INSERT INTO gp_csw VALUES (2, 'GeodatenkatalogDE - Geodaten', 1, 1, 5, 'dataset/series');
+
 EOF
 #####################
 sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -f ${installation_folder}geoportal_database_adoption_1.sql
@@ -608,6 +660,8 @@
 
 # recreate the guis via psql
 sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -f ${installation_folder}mapbender/resources/db/gui_Geoportal-RLP.sql # -- maybe a problem: too long entry ...
+# fix invocation of javascript functions for digitize module
+sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -c "UPDATE gui_element SET e_pos = '3' where e_id = 'kml' AND fkey_gui_id = 'Geoportal-RLP'"
 # 
 sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -f ${installation_folder}mapbender/resources/db/gui_Owsproxy_csv.sql
 sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -f ${installation_folder}mapbender/resources/db/gui_admin_wms_metadata.sql
@@ -745,6 +799,10 @@
     ##################### demo service
 eval $wms_6_register_cmd
     #####################
+    # update database to set initial extent and epsg for Main GUI: TODO: maybe use a hidden layer !
+    sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -c "UPDATE gui_wms SET gui_wms_epsg = '$epsg' WHERE fkey_gui_id = 'Geoportal-RLP'"
+    sudo -u postgres psql -q -p $mapbender_database_port -d $mapbender_database_name -c "UPDATE layer_epsg SET minx = '$minx', miny = '$miny', maxx = '$maxx', maxy = '$maxy' WHERE fkey_layer_id IN (SELECT layer_id FROM layer WHERE fkey_wms_id IN (SELECT fkey_wms_id FROM gui_wms WHERE fkey_gui_id = 'Geoportal-RLP' AND gui_wms_position = 0) AND layer_parent='') AND epsg = '$epsg'"
+    #####################
 fi
 
 if [ $checkout_mapbender_conf = 'true' ]; then



More information about the Mapbender_commits mailing list