cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Alvarez <william_alva...@live.com>
Subject Re: How to remove unused/unwanted management server from mysql
Date Tue, 03 Aug 2021 16:15:59 GMT
Install phpmyadmin and manage it using the gui. It's easier.

Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: James Steele <jsteele.email@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message