Repository: cloudstack-docs-admin Updated Branches: refs/heads/master e51a1a4c2 -> 1f35778d3
CLOUDSTACK-3990: update SQL queries to match database structure Project: http://git-wip-us.apache.org/repos/asf/cloudstack-docs-admin/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack-docs-admin/commit/1f35778d Tree: http://git-wip-us.apache.org/repos/asf/cloudstack-docs-admin/tree/1f35778d Diff: http://git-wip-us.apache.org/repos/asf/cloudstack-docs-admin/diff/1f35778d Branch: refs/heads/master Commit: 1f35778d3fc9c13ee1f454a697950a1ff67f4d54 Parents: e51a1a4 Author: Pierre-Luc Dion <[email protected]> Authored: Sun Mar 8 00:26:53 2015 -0500 Committer: Pierre-Luc Dion <[email protected]> Committed: Sun Mar 8 00:26:53 2015 -0500 ---------------------------------------------------------------------- source/hosts.rst | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack-docs-admin/blob/1f35778d/source/hosts.rst ---------------------------------------------------------------------- diff --git a/source/hosts.rst b/source/hosts.rst index 755a891..2150ce6 100644 --- a/source/hosts.rst +++ b/source/hosts.rst @@ -233,18 +233,22 @@ To change a Node's password: .. code:: bash - mysql> select id from cloud.host where name like '%h%'; + mysql> SELECT id FROM cloud.host WHERE name like '%h%'; #. This should return a single ID. Record the set of such IDs for these - hosts. + hosts. Now retrieve the host_details row id for the host + + .. code:: bash + + mysql> SELECT * FROM cloud.host_details WHERE name='password' AND host_id={previous step ID}; #. Update the passwords for the host in the database. In this example, - we change the passwords for hosts with IDs 5, 10, and 12 to + we change the passwords for hosts with host IDs 5 and 12 and host_details IDs 8 and 22 to "password". .. code:: bash - mysql> update cloud.host set password='password' where id=5 or id=10 or id=12; + mysql> UPDATE cloud.host_details SET value='password' WHERE id=8 OR id=22; Over-Provisioning and Service Offering Limits
