Update puppet deployment script for RDS-Stg instance name change

[jsjiang]

Update puppet deployment script for RDS-Stg instance name change:

• Current name: rds-ias-ezid-search3-stg.cmcguhglinoa.us-west-2.rds.amazonaws.com
• New name: rds-uc3-ezid1-stg.cmcguhglinoa.us-west-2.rds.amazonaws.com

[jsjiang]

IAS ticket for RDS-Stg instance name change Assessment ticket: #508

[jsjiang]

There is no need to update puppet. What we need to do is update the SSM parameter.

From Ashley:

The RDS hostname (username, password ect.) comes from SSM. You can update the parameter yourself from the "aws ops box" uc3-aws2-ops as the uc3aws user.

To get the /uc3/ezid/ui/stg/database_host parameter:

agould@uc3-aws2-ops:~> aws ssm get-parameter --name /uc3/ezid/ui/stg/database_host
{
    "Parameter": {
        "Name": "/uc3/ezid/ui/stg/database_host",
        "Type": "String",
        "Value": "rds-ias-ezid-search3-stg.cmcguhglinoa.us-west-2.rds.amazonaws.com",
        "Version": 1,
        "LastModifiedDate": "2022-05-21T09:59:15.189000-07:00",
        "ARN": "arn:aws:ssm:us-west-2:451826914157:parameter/uc3/ezid/ui/stg/database_host",
        "DataType": "text"
    }
}

To update the /uc3/ezid/ui/stg/database_host parameter:

aws ssm put-parameter --type String --name /uc3/ezid/ui/stg/database_host --value rds-uc3-ezid1-stg.cmcguhglinoa.us-west-2.rds.amazonaws.com --overwrite

Run the uc3_pupapply.sh command to deploy the change

• Checkout an earlier version of the ezid git repo in the ~/install/ezid directory, for example 3.2.0
• run the uc3_pupapply.sh command to deploy the newest version
  • the settings.py file will be updated with the new RDS hostname - confirmed

[jsjiang]

• Change was made on 12/11
• verified configuration change in the settings.py file
• checked services by running the verify_ezid_after_patching.py command.