Hello James,
If this is production be very cautious about touching the base.
This will do the trick:
USE cloud;
DELETE FROM host WHERE id=12;
Best regards,
Jordan
-----Original Message-----
From: James Steele <[email protected]>
Sent: 03 септември 2021 г. 17:28
To: [email protected]
Subject: Remove host from MySQL?
[X] This message came from outside your organization
Hi all,
We have a host that was removed from the webUI, but it somehow still exists in
the cloudstack MySQL database.
I wanted to remove the host, reinstall the OS and then re-add back to CS -
keeping the same name & IP.
What is the MySQL command to remove the existing host entry? Would be something
like:
use cloud;
select * from host;
update host set removed=now() where id=12;
FYI: this is the same Host 12 mentioned here:
https://urldefense.com/v3/__https://github.com/apache/cloudstack/issues/5300__;!!A6UyJA!xxSOzkY4Lt4gw1sCqCER6DHC-Cvdc4dEl_df2vKC_ldCsQl1Mu0jn5iHGzR4VsCR7b_nNb6verIS$
Thanks, Jim
