后台修改cvk密码导致主机状态异常

无

忘记CVK后台密码，通过ssh工具记录登录CVK后台修改root密码导致主机状态异常。

后台命令修改root密码后与前台数据库中记录密码不一致,导致前台显示主机状态异常，此种情况需要将密码修改一致即可恢复正常。

因为客户忘记原来密码，所以需要通过数据库查询原密码。

通过数据库查询原密码，然后再通过后台命令将密码修改一致，如果要修改主机密码，可以通过前台管理界面“修改主机”方式修改。

root@cvm1:~# mysql -uroot -p1q2w3e
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 215
Server version: 5.5.53-0ubuntu0.12.04.1 (Ubuntu)
 
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> use vservice;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> select * from TBL_HOST where NAME='cvknode10';
+----+--------------+------------+-----------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------+-------------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------+-------------+-----------+---------+-----------+----------------+---------------------+-------------+
| ID | HOST_POOL_ID | CLUSTER_ID | NAME      | IPADDR      | HOST_USER | PW   | MEMORY | CPU  | CPU_CORES | CPU_SOCKETS | STORAGE | STATUS | CPU_FREQUENCY | CPU_PROVIDER | CPU_DETAIL                                | PROVIDER                                    | STORAGE_ALLOCATION | STORAGE_AVILABLE | ISCSI_NODE_NAME                     | MAINTAIN | CVK_MAINTAIN | PUBLIC_CLOUD_ID | MAC               | OP_GROUP_ID | OP_GROUP_CODE | WAKE_CATEGORY | IPMI_IPADDR | IPMI_USER | IPMI_PW | HA_ENABLE | CVK_VERSION    | ADD_TIME            | HA_RESOURCE |
+----+--------------+------------+-----------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------+-------------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------+-------------+-----------+---------+-----------+----------------+---------------------+-------------+
|  2 |            1 |          1 | cvknode10 | 172.31.6.10 | root      | root | 160568 |   56 |        14 |           2 | 1751907 |      1 |          2519 | GenuineIntel | Intel(R) Xeon(R) CPU E5-2660 v4 @ 2.00GHz | New H3C Technologies Co., Ltd. UIS R390X G2 |             318452 |          1433454 | ***.***.debian:01:cvknode10 |        0 |            0 |            NULL | 74:EA:CB:73:BF:2F |           1 | 00            |          NULL | NULL        | NULL      | NULL    |         1 | 5.0 (E0513H05) | 2019-04-09 10:40:04 |           0 |
+----+--------------+------------+-----------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------+-------------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------+-------------+-----------+---------+-----------+----------------+---------------------+-------------+
1 row in set (0.00 sec)
 
mysql>