![InCloudUs - if [ "$UNIX" == "true" ]; then echo "Youpi \o/"; fi](https://blog.incloudus.com/wp-content/uploads/2013/09/Little-tux-b-w.sh-600x6001-e1382623229226.png)
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 !).
|
1 |
$ keystone tenant-list |
Résultat :
|
1 2 3 4 5 |
+----------------------------------+---------+---------+ | 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 :
|
1 |
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 :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 |
+---------------------+---------------------+------------+--------------------------------------+------+-------------+ | 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.
The following two tabs change content below.
Gaëtan Trellu (goldyfruit)
Technical Operation Manager chez Ormuco
Autodidacte en informatique, depuis 2005 je parcours l’écosystème Unix à la recherche de nouvelles connaissances et de nouvelles rencontres.
Derniers articles parGaëtan Trellu (goldyfruit) (voir tous)
- 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
- iPXE et la fameuse erreur 0x040ee119 qui rend fou ! - 17 avril 2017
Lister les instances Nova d’un tenant Keystone par Gaëtan Trellu (goldyfruit) est sous Licence Creative Commons Internationale Attribution 4.0.