[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