Remove Tenant from Database

Sometimes the installation of your tenant appliance failed, and Horizon DaaS failed to cleanup the old tenant configuration in the database. So when you want to use the same network settings or other settings from the previous installation, you get an error that the network is in use, and cannot be added.

With these steps you can remove the configuration from the database.

1. SSH to primary Service Provider

2. Log in to the Fabric Database.

psql -U admin fdb

3. Find the Tenant ID:
***this will be the “org_id=xxxx” value used for the remainder of the commands 

select id, org_name from organization;

4. Disable the Tenant
 ******** need to make sure we are using the correct ID******

UPDATE organization SET is_disabled='t' where id='xxxx';

5.  SQL Querys

select * from compute_pool where org_id=xxxx; 
delete from compute_pool where org_id=xxxx;

select * from billing_summary where org_id=xxxx; 
delete from billing_summary where org_id=xxxx;

select * from organization where id=xxxx; 
delete from organization where id=xxxx;

select * from appliance where org_id=xxxx; 
delete from appliance where org_id=xxxx;

Find more Horizon DaaS related content here.

 1,943 total views,  2 views today