IMLS / estimating-wifi

Estimating Wifi is a pilot project to automate the censusing of proximal wifi devices via low-cost and open source tools.
https://10x.gsa.gov/projects/shared-components-for-museums-and-libraries/
Other
10 stars 2 forks source link

Change Postgres configuration to store JWT secret #281

Open anagradova opened 1 year ago

anagradova commented 1 year ago

Description

This command must be run to set up the database to store the JWT secret so that it is not exposed in any database functions as per the Postgrest documentation (https://postgrest.org/en/stable/auth.html)

ALTER DATABASE mydb SET "app.jwt_secret" TO 'reallyreallyreallyreallyverysafe';

User Story

No response

Architectural Decision Records (ADRs)

No response

anagradova commented 1 year ago

Used already in the database for the JWT_gen function. We will need to determine the maintenance process for the system in production.