Access databases
To access each one, you will need to use their respective credentials and bastion server.
Admin database
This database exists for the Admin site, storing organisation details.
AWS Naming convention: Used for finding the database in the AWS Console
- Production:
wifi-admin-wifi-db - Staging:
wifi-admin-staging-db
Connect to the admin database:
Endpoint: View in the AWS Console(instructions for doing this can be found here)
Username and Password: View the password in AWS Secrets Manager:
- Log in to the AWS console
- Navigate to the Secrets Manager service
- Search for ‘RDS’
Use your favourite GUI or set up an SSH tunnel.
Users database
This database exists for the authentication service, for storing user credentials and login activity.
AWS Naming convention: Used for finding the database in the AWS Console
- Production:
wifi-production-user-dbandwifi-production-user-rr - Staging:
wifi-staging-user-dbandwifi-staging-user-rr
Endpoint: View in the AWS Console(instructions for doing this can be found here)
Username and Password: View the password in AWS Secrets Manager:
- Log in to the AWS console
- Navigate to the Secrets Manager service
- Search for ‘RDS’
Use your favourite GUI or set up an SSH tunnel.
Sessions database
This database exists for the logging service, for tracking user sessions.
AWS Naming convention: Used for finding the database in the AWS Console
- Production:
wifi-wifi-dbandwifi-db-rr - Staging:
wifi-staging-db
Endpoint: View in the AWS Console(instructions for doing this can be found here).
Username and Password: View the password in AWS Secrets Manager:
- Log in to the AWS console
- Navigate to the Secrets Manager service
- Search for ‘RDS’
Use your favourite GUI or set up an SSH tunnel.