Very few support cases require transfer of customer data into AMS's custody to resolve a problem. Further, and with limited exception, there is never a reason for the development team to actually need specific card numbers in order to do any testing because we have our own test numbers and test merchant accounts.
|
Standard practice requires removal of all card data before a database transfer is to occur (if a database needs to be transferred to AMS in the first place)
|
The general steps are:
Testing @ Customer Site
- Make a backup of the customer's database using the BackupTM_SUPPORT backup script. This automatically implements the postgresql database dump flags below.
- load the backup database that exhibits the error onto the customers server as a 'test' database so that production is not affected.
- Perform one last test on the test database at the customer site to ensure the problem still exists
Testing in Tier II Development Environment
- Make a SUPPORT backup using BackupTM_SUPPORT which
- Dumps the backup database under a separate name (that end in _SUPPORT) on the backup folder
- This uses the
-T fCreditCardsEncrypted parameters with pg_dump to ensure no such data is transmitted.
eg:the default parameters in the support script exclude any encrypted card data. other files can be added if they are large (other candidates are transactions, web logs and/or eblasts)
pg_dump -F c -v -T fCreditCardsEncrypted datbase > /path/to/backup.backup
- Use the link https://backups.artsman.com and enter the appropriate credentials as per the web page image to the right. This will migrate the _SUPPORT database to a secure location on private server via https using latest high transport layer encryption available (currently TLS 1.3)
- Inform Tier II when the database has uploaded and they will resolve the case and remove the data.