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 provides for the Admin portal, 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

Username: View in the AWS Console, or the terraform config.

  • Production: grep 'admin-db-username' '.private/non-encrypted/secrets-to-copy/govwifi/wifi-london/variables.auto.tfvars'
  • Staging: grep 'admin-db-username' '.private/non-encrypted/secrets-to-copy/govwifi/staging-london/variables.auto.tfvars'

Password: Get the password from the [encrypted terraform secrets][getting-a-secret]:

  • Production: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep admin-db-password
  • Staging: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/staging-london/secrets.auto.tfvars | grep admin-db-password

Use your favourite GUI, or set up an SSH tunnel.

Users database

This database provides 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.

Username: View in the AWS Console, or [the terraform config][getting-a-secret].

  • Production: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^user-db-username"
  • Staging: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/staging-london/secrets.auto.tfvars | grep -e "^user-db-username"

Password: Get the password from the [encrypted terraform secrets][getting-a-secret]:

  • Production: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^user-db-password"
  • Staging: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^user-db-password"

Use your favourite GUI, or set up an SSH tunnel.

Sessions database

This database provides 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.

Username: View in the AWS Console, or [the terraform config][getting-a-secret].

  • Production: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^db-user"
  • Staging: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/staging-london/secrets.auto.tfvars | grep -e "^db-user"

Password: Get the password from the [encrypted terraform secrets][getting-a-secret]:

  • Production: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^db-password"
  • Staging: PASSWORD_STORE_DIR=.private/passwords pass show secrets-to-copy/govwifi/wifi-london/secrets.auto.tfvars | grep -e "^db-password"

Use your favourite GUI, or set up an SSH tunnel.

This page was last reviewed on 10 January 2021. It needs to be reviewed again on 10 July 2021 by the page owner #govwifi .
This page was set to be reviewed before 10 July 2021 by the page owner #govwifi. This might mean the content is out of date.