Dismiss MapStore 1 GeoStore Database

[randomorder]

We just dismissed MapStore 1 from the BZ Infrastructure but its GeoStore database couldn't be removed because is still being used by MapStore2 and GeoServer. To have both MapStore 1 and MapStore 2 available at the same time in the infrastructure, a view was set up on the MapStore 1 GeoStore database in order to share users and groups with MapStore 2. The same database is also used by GeoServer for the usergroup and role services.

We'll have to backup and remove the view and fix the mapstore 2 geostore db and update geoserver to use this db before we drop the old geostore db.

[randomorder]

This is the MapStore2 GeoStore Database @tdipisa

The views are pointing to the Mapstore1 users / groups

CREATE OR REPLACE FORCE VIEW "GEOSTORE2"."GS_USER" ("ID", "NAME", "USER_PASSWORD", "USER_ROLE", "GROUP_ID", "ENABLED") AS 
  SELECT "ID","NAME","USER_PASSWORD","USER_ROLE","GROUP_ID","ENABLED"    
FROM "GEOSTORE"."GS_USER";

CREATE OR REPLACE FORCE VIEW "GEOSTORE2"."GS_USERGROUP" ("ID", "GROUPNAME", "DESCRIPTION", "ENABLED") AS 
  SELECT "ID","GROUPNAME","DESCRIPTION","ENABLED"    
FROM "GEOSTORE"."GS_USERGROUP";

CREATE OR REPLACE FORCE VIEW "GEOSTORE2"."GS_USERGROUP_MEMBERS" ("USER_ID", "GROUP_ID") AS 
  SELECT "USER_ID","GROUP_ID"    
FROM "GEOSTORE"."GS_USERGROUP_MEMBERS";

CREATE OR REPLACE FORCE VIEW "GEOSTORE2"."GS_USER_ATTRIBUTE" ("ID", "NAME", "STRING", "USER_ID") AS 
  SELECT "ID","NAME","STRING","USER_ID"    
FROM "GEOSTORE"."GS_USER_ATTRIBUTE";

Unfortunately I am not allowed to dump the database with my client application. We can eventually ask ComuneBZ to do it for us