Testing

Mirroring the database

1. Export the database from the production server:

   pg_dump --clean -U portal -h localhost portal > prod-pre-2.X-dump.sql

2. Copy the database dump to the staging server

3. (Is this still necessary?) Modify the DB dump to ensure all UTF8 characters (the idp_account_request table has non utf8 characters):

   iconv -f iso8859-1 -t utf-8 < prod-pre-2.X-dump.sql > prod-pre-2.X-dump-utf-8.sql

4. Import the database dump into the staging database

   import_database.py --dump_file prod-pre-2.X-dump-utf-8.sql \
       --old_hostname ch.geni.net --new_hostname ch.staging.geni.net \
       --old_authority ch.geni.net --new_authority ch.staging.geni.net

5. Update the iRODS server URL to use the test server, using psql on the staging server:

   update service_registry
       set service_url = 'https://geni-gimi.renci.org:8443/irods-rest-test/rest'
       where service_url = 'https://geni-gimi.renci.org:8443/irods-rest-0.0.1-SNAPSHOT/rest';

6. Load the staging/dev CA cert

   cd geni-portal/bin
   psql -U portal -h localhost -f add-dev-signer.sql portal

7. Test basic portal functions after import, and before software update

8. Apply any pre-update steps (OS updates, dependency updates)

9. Apply release branch to staging clearinghouse

   cd <geni-portal>
   bin/geni-portal-install

10. Follow any post-update instructions in the CHANGES.md files