The list of things to be changed in OpenSpecimen when moving the production database to the test environment.

Data directory

The data directory on the app server contains files like JSON files, bulk import reports, consents files, spr files, files uploaded via Forms controls, etc. Therefore whole data directory should be copied from prod to test.

OpenSpecimen Settings

From Home → Settings → Common tab below properties should be changed.

Application URL: This should be configured to test application URL.
Deployment environment: This should be changed to 'TEST'.
Data directory: This should be configured to the physical location of the test server data directory.

OpenSpecimen > Moving database from one instance to another > image-20200425-054404.png

SAML Configuration

If LDAP / SAML is configured on the test server then following needs to be ensured in the test environment

Following tables should not be refreshed or should not be touched: os_auth_domains, os_auth_providers, os_auth_provider_props.
1. Alternatively, these tables need to be copied before the refresh and restored after the refresh process.
The $OS_DATA_DIR/saml directory should not be touched or copied from the prod environment.