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.
Gaëtan Trellu (goldyfruit)
Derniers articles parGaëtan Trellu (goldyfruit) (voir tous)
- Qinling, let’s the journey begin! - 23 mai 2019
- systemd-networkd, l’âge de la maturité ? - 13 mars 2018
- Hyper-V, Nova, VxLAN et Open vSwitch, enfin une belle histoire ! - 31 décembre 2017
Lister les instances Nova d’un tenant Keystone par Gaëtan Trellu (goldyfruit) est sous Licence Creative Commons Internationale Attribution 4.0.