Install we admin on you sql server and manage it using the gui. Get Outlook for Android<https://aka.ms/AAb9ysg> ________________________________ From: James Steele <jsteele.em...@gmail.com> Sent: Tuesday, August 3, 2021 6:56:22 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: How to remove unused/unwanted management server from mysql
Hi, I have an unwanted management server reported here on macfgan01, it is marked as DOWN: mysql> SELECT * FROM mshost; +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ | id | msid | runid | name | uuid | state | version | service_ip | service_port | last_update | removed | alert_count | +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ | 1 | 207360503444273 | 1627662680438 | macfgan01 | f685b3cf-5459-4425-bd2e-6be2865540c4 | Down | 4.15.1.0 | 10.257.0.4 | 9090 | 2021-07-30 17:17:36 | NULL | 0 | | 2 | 279278805491062 | 1627987566294 | macfgan01 | 64ce078b-e945-475d-a9d6-30dbe30569a7 | Up | 4.15.1.0 | 10.257.0.4 | 9090 | 2021-08-03 10:46:27 | NULL | 0 | | 3 | 191709488474348 | 1627987314655 | macfgan05 | 03544bf1-41af-4d5f-b36d-e7190b3c5504 | Up | 4.15.1.0 | 10.257.0.8 | 9090 | 2021-08-03 10:46:28 | NULL | 0 | | 4 | 38182022782117 | 1627980352341 | macfgan04 | 19c51d30-2d29-4a0e-8991-1af35835b6dd | Up | 4.15.1.0 | 10.257.0.7 | 9090 | 2021-08-03 10:46:27 | NULL | 0 | | 5 | 209430416376190 | 1627987033082 | macfgan02 | de6d0fa5-6c8f-40b4-88de-7a9bcf717e07 | Up | 4.15.1.0 | 10.257.0.5 | 9090 | 2021-08-03 10:46:27 | NULL | 0 | | 6 | 205492837091104 | 1627987210052 | macfgan03 | 5ed659d7-8c9b-4499-86a0-321531fab9aa | Up | 4.15.1.0 | 10.257.0.6 | 9090 | 2021-08-03 10:46:27 | NULL | 0 | +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ 6 rows in set (0.00 sec) What are the commands needed to remove this management server? MySQL newbie question probably! TIA, Jim