Steps for Adding a New Tenant
Login to RDS Database Using PGAdmin
Open PGAdmin: Launch PGAdmin on your system.
Connect to RDS:
In PGAdmin, add a new server connection using the credentials (hostname, port, username, password) for your RDS instance.
Create a New Database
Run the Create Database Script: (Replace the name of the database for the county name)
Run Database Schema Script
Run Database Data Script
Update Central Database.
Connect to the Central Database: Log in to the central database for the environment where the new tenant will be added (e.g., Test, QA, Stage, or Prod).
Add New County: If the county is not present, execute: (Replace name of the County)
Add New State: If the state is not present, execute: (Replace name of the State)
Add New Tenant: Execute the SQL script to add the new tenant. Make sure to replace the placeholders with the actual values:
Insert Default User
Still Connected to Central Database: Ensure you're connected to the central database where the default user should be added. This script with insert the Default user testcoral@catalisgov.com. This user is already registered in the Catalis Identity Server.
Login to Catalis Identity Server https://test-login.automonapps.com/Account/Login
Access Identity Server: Log in to the Catalis Identity Server using your credentials.
Create New Tenant: Follow the steps within the Identity Server to add a new tenant. Ensure that:
The tenant name matches the database name created.
Additional details are filled in as required by the server.
Create new tenant
Assign Default user to new Tenant
Coral application will do a redirect to the identity server to determine if the user is authorized
Identify server will return the Token and TenanId
Apis will be authorized by using the Token Id returned by the Identity Server