Update CLARITY GeoServer URIs

[p-a-s-c-a-l]

Once the Export of Geoserver layers from MTG to ATOS has been completed. We have to update all GeoServer URIs of respective resources. AFAIK @therter knows how to do it directly on the level of the database.

Furthermore, I've noticed that there a two ATOS GeoServer instances:

• http://services.clarity-h2020.eu:8080/
• https://geoserver.myclimateservice.eu/

http://services.clarity-h2020.eu:8080/ still seems to cause problems with include in report functionality, since TLS is not enabled for services.clarity-h2020.eu.

Question: Will we move everything to geoserver.myclimateservice.eu? If not, https has to be supported for services.clarity-h2020.eu.

[negroscuro]

We plan to move to the new instance so probably it does not worth the effort to secure the old one.

[p-a-s-c-a-l]

What is now the correct instance for all layers (hazard + hazard-le input layers)? https://geoserver.myclimateservice.eu/ ?

We have to make the changes in the data packages before we set up the synchronisation between DEV and PROD instance of CSIS and also in EMIKAT which currently calls http://services.clarity-h2020.eu:8080

[p-a-s-c-a-l]

Question to @DanielRodera & @maesbri

What is now the correct instance for all layers (hazard + hazard-le input layers)? https://geoserver.myclimateservice.eu/ ?

@therter can prepare the update statements

[therter]

@therter can prepare the update statements

The following update statements will adjust the geoserver urls, if only the url base must be changed.

update node__field_reference_path set field_reference_path_value = replace(field_reference_path_value, 'https://clarity.meteogrid.com/', 'https://geoserver.myclimateservice.eu/') where position('https://clarity.meteogrid.com/' in field_reference_path_value) = 1;
update node__field_reference_path set field_reference_path_value = replace(field_reference_path_value, 'http://services.clarity-h2020.eu:8080/', 'https://geoserver.myclimateservice.eu/') where position('http://services.clarity-h2020.eu:8080/' in field_reference_path_value) = 1;

[p-a-s-c-a-l]

@therter this is done, right?
Did you also check for other services.clarity-2020.eu appearances?

[therter]

@therter this is done, right?

Yes, this is done and on the maintenance site, the url was also corrected.