OpenStack:CLI Cheet Sheet - Revision history

Antony at 12:55, 3 May 2022

2022-05-03T12:55:55Z

Antony: /* Fix Ceph Monitor IP change for existing instances */

2022-04-28T12:24:05Z

Fix Ceph Monitor IP change for existing instances

Antony: /* Fix Ceph Monitor IP change for existing instances */

2022-04-28T12:19:42Z

Fix Ceph Monitor IP change for existing instances

Antony: /* Change Ceph Monitor IP/Ports for existing instance */

2022-04-28T12:17:44Z

Change Ceph Monitor IP/Ports for existing instance

Antony: /* Fix Ceph Monitor IP change for existing instances */

2022-04-28T12:14:25Z

Fix Ceph Monitor IP change for existing instances

Antony: added ceph IP/Port update to mqsql queries

2022-04-28T12:11:20Z

added ceph IP/Port update to mqsql queries

Antony: adding common stuf from my local cheatsheet

2022-04-25T10:35:38Z

adding common stuf from my local cheatsheet

David at 07:53, 17 April 2022

2022-04-17T07:53:05Z

David at 07:49, 17 April 2022

2022-04-17T07:49:10Z

David: Created page with "== CLI Commands == From: https://docs.openstack.org/nova/latest/admin/services.html

 # list hypervisor details openstack hypervisor list --long   # list VMs with availa..."

2022-04-17T07:47:51Z

Created page with "== CLI Commands == From: https://docs.openstack.org/nova/latest/admin/services.html <pre> # list hypervisor details openstack hypervisor list --long # list VMs with availa..."

New page

== CLI Commands ==
From: https://docs.openstack.org/nova/latest/admin/services.html

<pre>
# list hypervisor details
openstack hypervisor list --long

# list VMs with availability zone
openstack server list --long -c ID -c Name -c Status -c Networks -c "Image Name" -c "Flavor Name" -c "Availability Zone"

# list VMs on all hypervisor
openstack server list --all --long -c ID -c Name -c Host

# list VMs on specific hypervisor
openstack server list --all-projects --host ${COMPUTE_NODE}

# get VM count by hypervisor
openstack server list --all --long -c Host -f value | sort | uniq -c

# list compute nodes
openstack compute service list --service nova-compute

# list compute service
openstack compute service list --host ${OS_NODE}

# add / enable compute service
openstack compute service set --enable com1-dev nova-compute

# disable compute service
for OS_SERVICE in $(openstack compute service list --host ${OS_NODE} -c Binary -f value); do
openstack compute service set --disable --disable-reason "Maintenance" ${OS_NODE} ${OS_SERVICE}
done

# Search for server witch status error
openstack server list --all --status ERROR

# Search for server with status resizing
openstack server list --all --status=VERIFY_RESIZE

# List instances / VMs
openstack server list
openstack server list -c ID -c Name -c Status -c Networks -c Host --long

# Show VM diagnostics / statistics
nova diagnostics ${SERVER_ID}
openstack server show --diagnostics ${SERVER_ID}

# show hypervisor usage
openstack usage list
</pre>

@@ Line 258: / Line 258: @@
 <pre>
 update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.1.58.156", "10.1.58.157", "10.1.58.158")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not;
 </pre>

@@ Line 243: / Line 243: @@
 update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.10.3.1", "10.10.3.4", "10.10.3.10")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not_like_this b.connection_info LIKE '%15526f5f-5fd6-4199-948a-158d59eec0ba%';
 </pre>
 ==== Fix Ceph Monitor Port Change ====

@@ Line 238: / Line 238: @@
 </pre>
 ==== Fix Ceph Monitor IP change for existing instances ====
 <pre>
 update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.10.3.1", "10.10.3.4", "10.10.3.10")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not_like_this b.connection_info LIKE '%15526f5f-5fd6-4199-948a-158d59eec0ba%';

@@ Line 223: / Line 223: @@
 == Openstack time saving SQL Queries ==
 === Change Ceph Monitor IP/Ports for existing instance ===
 ==== Fix Ceph Monitor IP change for existing instances ====
 <pre>

@@ Line 225: / Line 225: @@
 ==== Fix Ceph Monitor IP change for existing instances ====
 <pre>
-update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.10.3.1", "10.10.3.4", "10.10.3.10")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not;
+update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.10.3.1", "10.10.3.4", "10.10.3.10")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not_like_this b.connection_info LIKE '%15526f5f-5fd6-4199-948a-158d59eec0ba%';
 </pre>
 ==== Fix Ceph Monitor Port Change ====
 <pre>
 update block_device_mapping as b set connection_info = json_replace(connection_info, '$.data.hosts', JSON_ARRAY("10.1.58.156", "10.1.58.157", "10.1.58.158")) where instance_uuid in (select i.uuid from instances as i where i.deleted_at is null) AND JSON_EXISTS(b.connection_info, '$.data.hosts') = 1 and b.deleted_at is NULL and remove_this_deliberate_bit_of_invalid_syntax_and_replace_with_a_specific_volume_id_that_you can_easily_validate_and_roll_back_if_not;
 </pre>

@@ Line 218: / Line 218: @@
 openstack volume create --image 60fad4a3-f2cc-4ce2-a148-c1a61bb4d2a1  --size 40 centos-82-bootable --type lightos
 openstack server create --volume centos-82-bootable --flavor m1.tiny --key-name mykey --network demo-net demo1
 </pre>

@@ Line 185: / Line 185: @@
 <pre>
 docker exec -t nova_libvirt qemu-x86_64 -version
 </pre>

@@ Line 84: / Line 84: @@
 openstack compute service list --host ${NODE_ID}
 openstack compute service delete ${NODE_ID}
 </pre>

@@ Line 48: / Line 48: @@
 # show hypervisor usage
 openstack usage list
 </pre>