KB : How to remove customers from OnDemand DB

Whenever client will receive 401 during process of installing TFS4JIRA plugin in the Cloud 99% of the time it means that we need to delete his record in our own DB.

Step-by-step guide

You will need direct address of clients Jira Cloud instance like 'https://demo.atlassian.net'

To remove a client from DB please perform those steps.

1. SSH to our Lightsail instance 

   ssh ubuntu@tfs4jira-ondemand-checkins.spartez.com -p 1011

2. Enter the spell 

   psql -h aws-tfs4jira-database.cwegminyi5et.eu-central-1.rds.amazonaws.com -U tfs4jira tfs4jira

3. It will ask for password which you can get in step 2.

4. Then in terminal type 

   select * from jiras where url='https://_direct_address_of_clients_Jira_Cloud_instance_';

   With 'https://demo.atlassian.net' it would be 

   select * from jiras where url='https://demo.atlassian.net';

5. Check if it returns just one value. Afterwards run the same query but instead of select use delete so it would look like this 

   delete from jiras where url='https://_direct_address_of_clients_Jira_Cloud_instance_' LIMIT 1;

6. Cross fingers and hope for the best!