Il manque une commande Nova

Aujourd’hui nous avons eu à faire à une problématique qui n’aurait pas dû en être une (à mon sens). Nous souhaitions lister toutes les instances Nova d’un même tenant (projet) ainsi que le compute (nœud) sur lequel elles tournaient.

Deux obstacles :

L’utilisateur admin ne liste pas les instances qui ne sont pas dans son tenant
Nous n’avons pas les identifiants de l’utilisateur lié au tenant

C’est dégueulasse mais…

…c’est la seule solution pour le moment (Toi, lecteur si tu en as une autre je suis prenneur). La solution consiste à aller directement taper dans la base de données nova. Qui a dit goret ? 😯

L’obtention du tenant se fait à l’aide de Keystone mais je ne vous apprends rien (Si ? COOL !).

$ keystone tenant-list

Résultat :

+----------------------------------+---------+---------+
|                id                |  name  | enabled |
+----------------------------------+---------+---------+
| 91e4d7010c62494cb5a447ecf68d46ce | client |   True   |
+----------------------------------+---------+---------+

Une fois le tenant obtenu, il ne reste plus qu’à se connecter à la base de données nova puis d’exécuter la requête suivante :

SELECT i.created_at, i.deleted_at, i.host, i.uuid, i.id, t.name FROM instances i JOIN instance_types t ON i.instance_type_id = t.id WHERE project_id = '91e4d7010c62494cb5a447ecf68d46ce';

La requête ci-dessus permet de récupérer les informations suivantes :

Date de création
Date de suppression (nova conserve un historique des instances créées)
Le compute (nœud) ou tourne l’instance
L’identifiant unique de l’instance
L’ID de l’instance dans la table instances
Le nom de la flavor (template) utilisée lors de la création de l’instance

Tada !!

On obtiendra le résultat suivant :

+---------------------+---------------------+------------+--------------------------------------+------+-------------+
| created_at          | deleted_at          | host       | uuid                                 | id   | name        |
+---------------------+---------------------+------------+--------------------------------------+------+-------------+
| 2012-12-04 22:50:32 | 2012-12-04 22:52:39 | compute003 | 5b6158fd-0059-4fe0-9af2-87d77f57f952 |    9 | m1.tiny     |
| 2012-12-04 23:13:49 | 2012-12-04 23:16:05 | compute003 | bcf01370-4018-4621-aa6b-5a64fd4d6a8e |   10 | m1.tiny     |
| 2012-12-05 19:02:52 | 2012-12-05 19:30:13 | compute003 | 149538b9-575f-4dc4-b78e-c627d3e27e32 |   21 | m1.small    |
| 2012-12-06 13:19:04 | 2012-12-06 13:19:55 | compute002 | 7db2c788-2a62-454f-b582-6b798b4f725b |   23 | m1.tiny     |
| 2012-12-06 15:25:54 | 2012-12-06 15:26:59 | compute002 | 3b9c0718-bfec-4265-9d9a-172e5623d08c |   25 | m1.large    |
| 2012-12-06 15:32:13 | 2012-12-06 15:48:29 | compute002 | 335e504e-b543-470f-a9e8-3229067f21e1 |   26 | m1.large    |
| 2012-12-06 15:49:09 | 2012-12-06 17:05:52 | compute002 | 550267db-2497-4c0e-bca3-0ba0a4c2c685 |   27 | m1.tiny     |
| 2012-12-06 17:07:48 | 2012-12-06 17:27:07 | compute002 | 0229bc75-0129-47e0-b145-d7c1ea8e7a21 |   28 | m1.tiny     |
| 2012-12-06 17:22:20 | 2012-12-06 17:23:13 | compute001 | ed406c64-eecc-467f-8551-ec85ad42d82a |   29 | m1.tiny     |
| 2012-12-06 17:22:51 | 2012-12-06 17:27:07 | compute003 | c6154fd9-f31f-4628-bda2-7bce281c3f6a |   30 | m1.large    |
| 2012-12-06 18:21:25 | 2012-12-06 19:13:02 | compute002 | eddcb979-171e-451b-ac1d-08dbac87dbe1 |   32 | m1.tiny     |
| 2012-12-06 18:21:51 | 2012-12-06 18:22:55 | compute001 | aeddbd3e-938c-4861-86d5-458c652efb40 |   33 | m1.tiny     |
| 2012-12-06 18:21:52 | 2012-12-06 18:22:54 | compute003 | 3913161a-6ddf-4b11-88f3-ea02dab3f7bf |   34 | m1.tiny     |
| 2012-12-06 18:23:15 | 2012-12-06 18:38:01 | compute001 | c590714a-f41b-4410-8983-365633221c5a |   35 | m1.tiny     |
| 2012-12-06 18:23:46 | 2012-12-06 19:13:03 | compute003 | a6494f75-79d6-4024-b757-e7d3de1dd98f |   36 | m1.tiny     |
| 2012-12-06 18:38:15 | 2012-12-06 19:13:02 | compute001 | f75f9ec0-2021-4714-9a65-2dc109fdf3f1 |   37 | m1.tiny     |
| 2012-12-06 19:13:41 | 2012-12-06 20:22:58 | compute002 | ae048dcb-ad9c-4057-91c4-602230665f85 |   38 | m1.tiny     |
| 2012-12-06 19:52:18 | 2012-12-06 19:53:08 | compute001 | 6cf8d3b9-7790-40e6-af49-431503e089e9 |   39 | m1.tiny     |
| 2012-12-06 19:54:08 | 2012-12-06 19:58:15 | compute001 | e2216770-f891-4a1c-bce2-9a2dad519631 |   40 | m1.tiny     |
| 2012-12-06 19:56:37 | 2012-12-06 20:22:57 | compute003 | f23f8e7c-0d07-4889-af8a-44b5875e1c27 |   41 | m1.tiny     |
| 2012-12-06 20:23:25 | 2012-12-06 20:42:12 | compute002 | 648df0b0-7205-4b3e-b6f9-47a8a669b7e8 |   42 | m1.tiny     |
| 2012-12-06 20:23:25 | 2012-12-06 21:37:13 | compute001 | 745eb133-45c2-43ce-a876-ce8171bc0ef3 |   43 | m1.tiny     |
| 2012-12-06 20:23:26 | 2012-12-06 20:59:12 | compute003 | 6689f7fd-de6e-432e-bc4d-33274bf180e3 |   44 | m1.tiny     |
| 2012-12-06 20:59:24 | 2012-12-06 21:12:00 | compute003 | c1049a86-f7c2-4c68-bbc4-775b4ffbf1a9 |   46 | m1.tiny     |
| 2012-12-06 21:01:30 | 2012-12-06 21:11:58 | compute002 | fff1d378-a16d-42d5-bea9-9dbc71b87641 |   47 | m1.tiny     |
| 2012-12-06 21:03:05 | 2012-12-06 21:03:36 | compute002 | 4c5acc6a-f66b-4fe1-af11-43b813f58003 |   48 | m1.tiny     |
| 2012-12-06 21:03:40 | 2012-12-06 21:11:58 | compute002 | 3cff227e-698a-4f42-a502-65f2ca9daa2a |   49 | m1.tiny     |
| 2012-12-06 21:08:16 | 2012-12-06 21:11:55 | compute001 | e446c190-3af2-4132-acb7-b7861adb6050 |   50 | m1.tiny     |
| 2012-12-06 21:08:16 | 2012-12-06 21:12:00 | compute003 | 3f0dcf16-e37e-48f9-9862-3ec01b0a8287 |   51 | m1.tiny     |
| 2012-12-06 21:08:16 | 2012-12-06 21:11:56 | compute002 | 1bd9ef65-af60-415b-ace1-d7a9e68cea6b |   52 | m1.tiny     |
| 2012-12-06 21:08:16 | 2012-12-06 21:11:54 | compute001 | 1c25e088-62b9-4ee5-8347-2280eecf62b6 |   53 | m1.tiny     |
| 2012-12-06 21:08:17 | 2012-12-06 21:11:58 | compute003 | 46d4445d-9958-4d4a-afc2-e17bf8995696 |   54 | m1.tiny     |
| 2012-12-06 21:08:17 | 2012-12-06 21:11:54 | compute002 | 1a0aae08-47e3-4731-91cb-0b35c2a9ce54 |   55 | m1.tiny     |
| 2012-12-06 21:08:17 | 2012-12-06 21:11:53 | compute001 | 6d5ec45c-8ed7-4549-8bf9-d845e7fde8ed |   56 | m1.tiny     |
| 2012-12-06 21:08:17 | 2012-12-06 21:11:58 | compute003 | aaba8ba1-99a6-4682-bf3d-3016c8d7007b |   57 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:24 | compute002 | 4808a695-7c1b-4952-b7fa-795ff6fe0457 |   58 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:25 | compute003 | b11588ad-583c-4a53-bea6-d532e08b0392 |   59 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:24 | compute002 | 4e7b9cf0-4d14-48cf-9acd-83794dd1ea1a |   60 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:37:12 | compute001 | 90fc38ce-bdc4-4fa8-a603-8ec16787a933 |   61 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:26 | compute003 | 071996d0-be0c-4803-aff8-3525adbd4970 |   62 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:22 | compute002 | 01d73538-ccf8-4a11-8f3d-d022568aaa16 |   63 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:37:14 | compute001 | 353c0e0d-9223-4dc6-aba7-2d2f45a96be3 |   64 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:25 | compute003 | b31b0b37-8246-4ed8-adec-4b7f5b149f13 |   65 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:20 | compute002 | f109c6ad-42c2-4136-beb7-388ffe87323b |   66 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:37:11 | compute001 | cc62e9cf-a19a-481a-a71d-b3955a0fcc66 |   67 | m1.tiny     |
| 2012-12-06 21:13:06 | 2012-12-06 21:18:25 | compute003 | 03cfd6ae-a0ca-4dbe-be2a-e4f3bfbb8289 |   68 | m1.tiny     |
| 2012-12-06 21:13:07 | 2012-12-06 21:18:20 | compute002 | 1ad9687c-287d-42c8-8b00-3bd81b8189b1 |   69 | m1.tiny     |
| 2012-12-06 21:37:55 | 2012-12-06 22:06:02 | compute002 | 0cd13cea-6c36-4296-b579-d81afe4f53b8 |   70 | m1.tiny     |
| 2012-12-06 23:21:40 | 2012-12-07 03:50:40 | compute002 | 37a26aec-c7a2-412b-b314-1c3a4aa21220 |   74 | m1.tiny     |
| 2012-12-06 23:37:35 | 2012-12-07 03:50:39 | compute001 | 4855ecb1-817b-4d65-bdcd-ec0913e11099 |   75 | m1.tiny     |
| 2012-12-07 03:50:57 | 2013-04-19 12:47:25 | compute002 | 9e958d6f-a11f-4668-b871-f3d7710b91e0 |   76 | small       |
| 2012-12-11 15:23:28 | 2013-02-09 21:23:56 | compute003 | 831bb725-1dbc-49e5-92c4-90fb84844268 |   81 | xlarge      |
| 2012-12-11 16:24:05 | 2012-12-11 16:48:34 | compute001 | fc1fac45-5d32-4489-8cc9-f05868ef0e52 |   82 | medium      |
| 2012-12-11 21:02:52 | 2012-12-11 21:35:02 | compute001 | 7c6bf11f-a787-4b11-a0e9-e64ef158ccfc |   85 | small       |
| 2012-12-13 01:05:40 | 2013-01-10 03:29:16 | compute003 | 6a75ec8e-8f9a-4dd6-9445-9b4a774e0ea0 |   92 | small       |
| 2012-12-13 01:09:10 | 2013-01-10 03:29:15 | compute003 | 1e682483-0d74-4796-8b4e-a55b99ac1af1 |  100 | small       |
| 2012-12-13 01:09:31 | 2013-05-01 12:02:20 | compute001 | 97b31073-5f7c-4dff-b3ee-f350cda75f89 |  101 | small       |
| 2012-12-13 01:09:50 | 2013-05-01 12:02:00 | compute002 | 76b91a5a-9ae5-4c82-81c4-7052a3568813 |  102 | small       |
| 2012-12-13 01:10:08 | 2013-05-01 12:01:22 | compute003 | b99463a5-b270-4792-88d2-502ae1d2a99c |  103 | small       |
| 2012-12-13 01:10:27 | 2013-05-01 12:02:20 | compute001 | 4066ea31-1e4d-4880-a923-de017b2a072b |  104 | small       |
| 2012-12-13 01:10:43 | 2013-05-01 12:01:12 | compute002 | 2dff60f9-9b28-4fa3-98c1-e45658d05ccb |  105 | small       |
| 2012-12-13 01:11:01 | 2013-05-01 12:01:22 | compute003 | f2b9d1de-3dc2-4c7a-a24c-e9b41c93bf44 |  106 | small       |
| 2012-12-13 01:11:18 | 2013-05-01 12:02:20 | compute001 | 83fefb47-e992-48c5-b57d-3e0366092f93 |  107 | small       |
| 2012-12-13 01:11:41 | 2013-05-01 12:01:12 | compute002 | 57ed7ab9-a359-49e3-9044-9439467a63a8 |  108 | small       |
| 2012-12-13 01:12:01 | 2013-05-01 12:01:23 | compute003 | fb3b1e7c-e4df-4199-994b-1d1d2385f240 |  109 | small       |
| 2012-12-13 01:12:16 | 2013-05-01 12:02:20 | compute001 | e153e131-ad7a-4edd-a00e-ba3d8a3b2068 |  110 | small       |
| 2012-12-18 02:16:08 | 2013-01-07 14:24:11 | compute002 | 77093ec4-23c6-4951-9807-7a0479a66271 |  121 | medium      |
| 2012-12-20 19:56:25 | 2013-02-10 17:12:31 | compute003 | 6ca85436-a139-491b-a57c-b7b32a3975d0 |  123 | medium      |
| 2012-12-21 11:13:36 | 2012-12-21 11:14:31 | compute003 | 9600cb49-f7e5-44ca-b537-ac9250c3f13e |  126 | tiny        |
| 2012-12-21 13:39:34 | 2012-12-21 14:14:48 | compute003 | 953be5b7-051f-481e-90be-a71f13b62a3e |  127 | tiny        |
| 2012-12-21 14:15:06 | 2012-12-21 14:19:01 | compute003 | 8baf901f-ef04-48d8-9319-ddbbd31cde0c |  128 | tiny        |
| 2012-12-21 14:23:20 | 2012-12-21 14:29:11 | compute003 | 63577eb5-0ab9-4dc3-a3d1-02bb8a0d3467 |  129 | tiny        |
| 2012-12-21 14:29:53 | 2012-12-21 14:30:50 | compute003 | c9f460b8-dd1c-481f-b512-47b4c254b310 |  130 | tiny        |
| 2012-12-21 15:33:36 | 2012-12-21 15:35:46 | compute001 | 39bcd931-829e-4088-b6aa-a6006564cbf1 |  131 | tiny        |
| 2012-12-22 18:39:57 | 2012-12-22 18:45:26 | compute001 | 0814a1f6-453a-4706-85c8-2d52e7515d4f |  132 | small       |
| 2013-01-10 15:32:16 | 2013-01-10 15:48:13 | compute002 | 38fae8b3-3e4a-4bcb-bfd2-cc1130cd0dd7 |  153 | small       |
| 2013-01-25 06:34:16 | 2013-01-25 06:35:26 | compute001 | 3db56a2a-382f-43f8-b16a-e7c532994900 |  174 | tiny        |
| 2013-01-25 06:34:44 | 2013-01-25 06:37:03 | compute001 | 792f6d3c-a4ac-4d86-ba82-f9bf06093a6c |  175 | tiny        |
| 2013-02-01 14:46:28 | 2013-02-11 16:04:54 | compute001 | 75fa47aa-1ace-4123-b0ec-745559a151b2 |  177 | small       |
| 2013-02-05 13:52:18 | 2013-02-05 13:55:29 | compute001 | 0aa17eb5-06c6-4ff9-ac86-cd3cd0dcca5b |  180 | small       |
| 2013-02-05 13:52:18 | 2013-02-05 13:55:29 | compute001 | 95cdf9b6-b602-405d-b524-f6738164406a |  181 | small       |
| 2013-02-05 15:39:50 | 2013-02-05 15:55:22 | compute001 | 064a10c8-6147-41b0-a9a3-962907f0b299 |  182 | medium      |
| 2013-02-05 15:55:51 | 2013-04-19 12:48:09 | compute001 | 504b7528-52c5-4255-b1fe-856b0f499b0e |  183 | medium      |
| 2013-02-06 16:07:19 | 2013-05-29 14:09:09 | compute003 | 826d03e7-629b-431a-9a43-91e2464d37cc |  185 | small       |
| 2013-02-09 20:46:01 | 2013-03-05 19:14:27 | compute001 | f4c06122-24a7-4500-8086-fd0a69818a61 |  187 | xlarge      |
| 2013-02-10 16:00:35 | 2013-02-11 16:16:02 | compute003 | 59fca10d-868c-4705-8bba-598d6fa0b649 |  188 | large       |
| 2013-02-10 16:36:28 | 2013-05-29 14:09:10 | compute003 | 11375b7e-1e90-4655-8ef8-1191e7ae8007 |  189 | small       |
| 2013-02-12 20:09:33 | 2013-02-12 20:15:53 | compute003 | 8cd9885c-c406-49a9-a61c-5b4855a11423 |  197 | small       |
| 2013-02-12 20:18:43 | 2013-02-12 21:00:00 | compute003 | e29a859a-755a-413b-90d0-84bc071e9ef8 |  198 | small       |
| 2013-02-21 19:26:08 | 2013-02-27 13:39:29 | compute002 | daafd71d-4cee-4b02-8403-104398830ddf |  249 | small       |
| 2013-03-01 03:46:58 | 2013-04-03 16:25:34 | compute003 | ef2eecce-07b9-4738-a6f6-39381335996b |  291 | xlarge      |
| 2013-03-04 19:56:09 | 2013-03-05 19:14:27 | compute001 | c38680b0-b8f3-44c9-8d43-0a133342fa48 |  302 | large       |
| 2013-03-26 20:51:29 | 2013-03-26 21:01:52 | compute002 | 63432077-8541-4486-9550-99d0a8c9e21d |  786 | medium      |
| 2013-03-31 13:25:57 | 2013-03-31 15:27:05 | compute003 | 72110323-643f-420c-a475-7a63bddeff3e |  883 | small_swap  |
| 2013-04-02 19:10:53 | 2013-04-03 16:25:24 | compute002 | d0d1797f-2388-4632-a967-2f3a9d29d69b |  897 | large       |
| 2013-04-03 16:24:55 | 2013-04-25 03:36:05 | compute002 | 2efdc6db-61bd-427a-afc0-205d658ca157 |  916 | xlarge      |
| 2013-04-04 18:41:50 | 2013-04-04 18:55:16 | compute001 | bad0ce61-4ede-483c-9d74-6ff4b5e85875 | 1001 | small       |
| 2013-04-08 13:19:05 | 2013-04-16 02:36:21 | compute001 | f8bf0816-91eb-475f-bdcf-eb62915e5c98 | 1024 | xlarge_swap |
| 2013-04-11 19:34:02 | 2013-04-11 20:58:35 | compute002 | 4d779593-61a2-4c86-b5f6-53eb562f82b3 | 1065 | small_swap  |
| 2013-04-11 19:36:00 | 2013-04-11 20:57:16 | compute001 | 38266a83-c0ff-45b2-9209-147cd26bb7cf | 1066 | small       |
| 2013-04-17 13:17:56 | 2013-04-17 13:19:22 | compute001 | 2bb34551-3b74-42a5-9222-bc0e5f620b5f | 1102 | xxlarge     |
| 2013-05-09 14:05:19 | 2013-05-09 14:19:44 | compute002 | 08db4563-ad81-4c44-899e-525cfdb402b2 | 1238 | small       |
| 2013-05-10 12:50:56 | 2013-05-10 12:59:46 | compute002 | b5711a4d-0973-4fc1-94ae-7e7f86c08750 | 1243 | small       |
| 2013-05-21 12:17:56 | 2013-05-21 17:12:36 | compute002 | a8b985db-3776-4681-9b61-dd9b67e921ba | 1316 | large       |
| 2013-05-30 13:07:41 | 2013-05-30 15:07:52 | compute001 | cb23b185-1ae8-48e5-8f2e-b65156924335 | 1396 | xlarge      |
+---------------------+---------------------+------------+--------------------------------------+------+-------------+

Morale de l’histoire : OpenStack est encore jeune alors ne pestez pas contre les acteurs du projet si ce genre de bidouille est à employer de temps en temps.