DCB MOBIUS Beta 2.2 - 25 Oct 2023

Component

Version

New Version for Release?

dcb-service

v1.7.3

dcb-locate

v2.2.2

dcb-admin-ui

v1.0.2

dcb-devops

v1.0.1


Changes

Additionally, in dcb-service

  • [Ingest]

    • In Sierra - deleted=true means ONLY deleted records, and suppressed=true means ONLY suppressed records. The default is to return all and that's what we want. Do not send deleted or suppressed parameters when harvesting.

  • [General]

    • Re-elect selected bib on cluster if current is deleted

  • [Security]

    • remove anon auth from remaining rest endpoints

  • [General]

    • Query for page then expand in separate query (Cluster export optimisations for pushing to ES/OS)

  • [Refactor]

    • Move record clustering service into package.

  • [Rework]

    • Cluster controller to use service and improve response time

  • [Polaris]

    • Override the isEnabled method to honor settings from config

    • Force page-size to 100 maximum

Deployment

Summary

Change Category

Required

Recommended

Not Required

Change Category

Required

Recommended

Not Required

Complete reset

(DCB Postgres, OpenSearch)

 

(Keycloak)

Environment configuration

 

No changes to keycloak

Host LMS configuration or setup

(New systems)

 

 

Service configuration

 

 

Ingest

(New sources)

 

 

Index

 

 

Library configuration

(New Config)

 

 

Scope: This release will create a test system involving a number of Stand-Alone Sierra systems which will be a part of the final MOBIUS network, and a number of Sierra Clusters which are currently using Sierra but will be moving to FOLIO in the final configuration. The purpose is to enable testing between member libraries, to build confidence with those libraries staying with their existing systems, and to allow libraries migrating to FOLIO to partially experience how the system will behave for them.

Instructions

  1. Download and compile the tagged release sourcecode from dcb-service and dcb-locate

  2. Fully remove existing tables from DCB Postgres schema. Take care to remove flyway_schema_history LAST. This is a manual operation normally completed through PGAGMIN.

  3. Fully remove the existing Elastic/OpenSearch indexes and reconfigure the new schemas - there is a “schema.sh” script in the dcb-devops repository which can be adapted for this.

  4. Update deployment of dcb-service and dcb-locate executables with newly built artefacts - this will cause regeneration of the tables in the Postgres schema. Check tables are present after deployment.

  5. Verify and Deploy host LMS configurations (ingest:true) for:

    1. KCTOWERS (Cluster, Sierra)

    2. BRIDGES (Cluster, Sierra)

    3. AVALON (Cluster, SIerra)

    4. COOLCAT (Standalone, SGCL, Sierra)

    5. DM (Standalone Sierra)

    6. WASHU (Standalone Sierra)

    7. Optionally - SEMO IF we have creds

  6. Verify and Load the mapping files

    1. Local to Central Patron Types

      1. Verify: DONE (2023-10-25 21:07)

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"numericRangeMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?gid=518437160&single=true&output=tsv "
        }'

    2. Local to Central Item Types

      1. Verify: DONE (2023-10-25 21:07)

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"numericRangeMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?output=tsv&gid=375838007 "
        }'

    3. Central to Local Patron Types

      1. Verify: DONE (2023-10-25 21:07)

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"referenceValueMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?gid=280712508&single=true&output=tsv "
        }'

    4. Central to Local Item Types

      1. Verify: DONE (2023-10-25 21:07)

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"referenceValueMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?output=tsv&gid=1273101045 "
        }'

    5. Shelving Location to Agency Mappings

      1. Verify: MISSING DM VALUES

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"referenceValueMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vTbJ3CgU6WYT4t5njNZPYHS8xjhjD8mevHVJK2oUWe5Zqwuwm_fbvv58hypPgDjXKlbr9G-8gVJz4zt/pub?gid=57428779&single=true&output=tsv "
        }'

    6. Pickup Location Mappings

      1. Verify: Mostly complete - some duplicate location codes - need to discuss with TA

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
        "profile":"referenceValueMappingImport",
        "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vTbJ3CgU6WYT4t5njNZPYHS8xjhjD8mevHVJK2oUWe5Zqwuwm_fbvv58hypPgDjXKlbr9G-8gVJz4zt/pub?gid=523902094&single=true&output=tsv "
        }'

    7. Agencies

      1. Verify: DONE (2023-10-25 21:07)

      2. Load: (https://docs.google.com/spreadsheets/d/e/2PACX-1vTbJ3CgU6WYT4t5njNZPYHS8xjhjD8mevHVJK2oUWe5Zqwuwm_fbvv58hypPgDjXKlbr9G-8gVJz4zt/pub?gid=727698722&single=true&output=tsv via bash script)

  7. Reset cfg.json - remove cursor key+value for push-to-opensearch script

Verification

After clear down - check postgres database is EMPTY
After deployment - check postgres tables recreated
After deployment - check OpenSearch schema in place

 

 

Operated as a Community Resource by the Open Library Foundation