You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by pd...@apache.org on 2015/03/08 06:27:13 UTC
cloudstack-docs-admin git commit: CLOUDSTACK-3990: update SQL queries
to match database structure
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 <pd...@apache.org>
Authored: Sun Mar 8 00:26:53 2015 -0500
Committer: Pierre-Luc Dion <pd...@apache.org>
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