Skip to main content

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-db and wifi-production-user-rr
  • Staging: wifi-staging-user-db and wifi-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-db and wifi-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.

This page was last reviewed on 1 April 2022. It needs to be reviewed again on 1 October 2022 by the page owner #govwifi .
This page was set to be reviewed before 1 October 2022 by the page owner #govwifi. This might mean the content is out of date.