CM重置密码：
Last login: Thu Feb 26 16:13:15 2015 from 192.168.100.74
[root@master180 ~]# grep password /etc/cloudera-scm-server/db.properties
com.cloudera.cmf.db.password=xxxxxxxx
[root@master180 ~]# psql -h localhost -p 7432 -U scm
Password for user scm:
psql (8.4.20)
Type “help” for help.
scm=> select host_id,host_identifier,name,ip_address from hosts;
host_id | host_identifier | name | ip_address
———+————————————–+———–+—————–
6 | ea37a6d4-57d1-4885-a7f8-4b10058643d0 | slave183 | 192.168.100.183
8 | 35e53e7c-0ca5-442c-a501-b94cb05fced8 | slave184 | 192.168.100.184
7 | 0c3e996c-035a-40de-a02c-4bb3f69724c3 | slave181 | 192.168.100.181
4 | b0771b8f-0989-4204-b62d-397685f83f96 | master180 | 192.168.100.180
5 | d625dde7-2211-44a6-bc53-868392effbad | slave182 | 192.168.100.182
(5 rows)
^
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | passwo
rd_login | optimistic_lock_version
———+———————————————————————————+——————————————————————+———————-+——-
———+————————-
3 | __cloudera_internal_user__mgmt-EVENTSERVER-b66f85dfdac7ddffe241a10fb0f52e6b | 1388147faaf876d1726a00c83b02bd8ce70d768df65b522553f341d388c7e76f | 490481174932330546 | t
| 10
4 | __cloudera_internal_user__mgmt-SERVICEMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 219e5d520543c1850df5b325182fa5429462304471e7b690c98efcc4d9cf7670 | 7438454581178551695 | t
| 10
5 | __cloudera_internal_user__mgmt-ACTIVITYMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 4d0661f23f444d04a996b36bca7fd6dfaf46762e9abb3d4f216449ed11cccfb8 | 2042803164878594517 | t
| 10
2 | __cloudera_internal_user__mgmt-HOSTMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | d0366b91984b44621f864cc43e3c790c63c77156aaa87e67ec31f44380c04a0d | 3559746710453072901 | t
| 10
1 | admin | 1dc0a78163ecaf90a36053ae544450100b9d5944f460306e901164d638841041 | -8551175399606246023 | t
| 6
(5 rows)
scm=> select * from user_roles;
user_role_id | user_id | user_role | optimistic_lock_version
————–+———+————+————————-
2 | 1 | ROLE_ADMIN | 0
3 | 2 | ROLE_USER | 0
4 | 3 | ROLE_USER | 0
5 | 4 | ROLE_USER | 0
6 | 5 | ROLE_USER | 0
(5 rows)
scm=> delete from user_roles;
DELETE 5
scm=> delete from users;
ERROR: update or delete on table “users” violates foreign key constraint “fk_user_setting_user” on table “user_settings”
DETAIL: Key (user_id)=(1) is still referenced from table “user_settings”.
scm=> delete from user_roles;
DELETE 0
scm=>
scm=>
scm=> select * from user_roles;
user_role_id | user_id | user_role | optimistic_lock_version
————–+———+———–+————————-
(0 rows)
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | passwo
rd_login | optimistic_lock_version
———+———————————————————————————+——————————————————————+———————-+——-
———+————————-
3 | __cloudera_internal_user__mgmt-EVENTSERVER-b66f85dfdac7ddffe241a10fb0f52e6b | 1388147faaf876d1726a00c83b02bd8ce70d768df65b522553f341d388c7e76f | 490481174932330546 | t
| 10
4 | __cloudera_internal_user__mgmt-SERVICEMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 219e5d520543c1850df5b325182fa5429462304471e7b690c98efcc4d9cf7670 | 7438454581178551695 | t
| 10
5 | __cloudera_internal_user__mgmt-ACTIVITYMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 4d0661f23f444d04a996b36bca7fd6dfaf46762e9abb3d4f216449ed11cccfb8 | 2042803164878594517 | t
| 10
2 | __cloudera_internal_user__mgmt-HOSTMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | d0366b91984b44621f864cc43e3c790c63c77156aaa87e67ec31f44380c04a0d | 3559746710453072901 | t
| 10
1 | admin | 1dc0a78163ecaf90a36053ae544450100b9d5944f460306e901164d638841041 | -8551175399606246023 | t
| 6
(5 rows)
scm=>
^
scm=> select * from user_settings;
user_setting_id | user_id | attr |
value
| optimistic_lock_version
—————–+———+—————————————————–+———————————————————————————————————–
———————————————————————————————————————————————————————————————
———————————————————————————————————-+————————-
1 | 1 | com.cloudera.server.web.cmf.events.recent_filters | [“[{\”filter\”:{\”valueUri\”:\”/cmf/events/typeahead/SERVICE\”,\”displayName\”:\”服务\”,\”propertyName\”:\
“SERVICE\”,\”compareTypes\”:[{\”name\”:\”EQ_WITH_OR\”,\”displayName\”:\”=\”,\”ordinal\”:5}]},\”compareType\”:{\”name\”:\”EQ_WITH_OR\”,\”displayName\”:\”=\”,\”ordinal\”:5},\”values\”:[\”spar
k\”],\”filterName\”:\”SERVICE\”,\”compareTypeName\”:\”EQ_WITH_OR\”,\”value\”:\”spark\”,\”complete\”:1}]”] | 0
2 | 1 | com.cloudera.scm.config.page.version | 1
| 1
3 | 1 | com.cloudera.server.web.cmf.charts.recent_tsqueries | [“SELECT cpu_percent_across_hosts WHERE entityName = \”1\” AND category = CLUSTER”]
| 0
(3 rows)
scm=> delete from user_settings;
DELETE 3
scm=> select * from user_settings;
user_setting_id | user_id | attr | value | optimistic_lock_version
—————–+———+——+——-+————————-
(0 rows)
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | passwo
rd_login | optimistic_lock_version
———+———————————————————————————+——————————————————————+———————-+——-
———+————————-
3 | __cloudera_internal_user__mgmt-EVENTSERVER-b66f85dfdac7ddffe241a10fb0f52e6b | 1388147faaf876d1726a00c83b02bd8ce70d768df65b522553f341d388c7e76f | 490481174932330546 | t
| 10
4 | __cloudera_internal_user__mgmt-SERVICEMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 219e5d520543c1850df5b325182fa5429462304471e7b690c98efcc4d9cf7670 | 7438454581178551695 | t
| 10
5 | __cloudera_internal_user__mgmt-ACTIVITYMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | 4d0661f23f444d04a996b36bca7fd6dfaf46762e9abb3d4f216449ed11cccfb8 | 2042803164878594517 | t
| 10
2 | __cloudera_internal_user__mgmt-HOSTMONITOR-b66f85dfdac7ddffe241a10fb0f52e6b | d0366b91984b44621f864cc43e3c790c63c77156aaa87e67ec31f44380c04a0d | 3559746710453072901 | t
| 10
1 | admin | 1dc0a78163ecaf90a36053ae544450100b9d5944f460306e901164d638841041 | -8551175399606246023 | t
| 6
(5 rows)
scm=> delete from users;
DELETE 5
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | password_login | optimistic_lock_version
———+———–+—————+—————+—————-+————————-
(0 rows)
刷新CM登录页面，即可用admin/admin重新登录了。再查询：
scm=>
scm=>
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | password_login | optimistic_lock_version
———+———–+——————————————————————+———————-+—————-+————————-
1 | admin | 3f60282eccf0f45516d73b0aab0d7ec276c0429be6fa1621aac6a5474001f62a | -3723872225283822814 | t | 1
(1 row)
scm=> select * from user_settings;
user_setting_id | user_id | attr | value | optimistic_lock_version
—————–+———+——+——-+————————-
(0 rows)
scm=> select * from user_roles;
user_role_id | user_id | user_role | optimistic_lock_version
————–+———+————+————————-
2 | 1 | ROLE_ADMIN | 0
(1 row)
更改初始密码密码后：
scm=>
scm=>
scm=> select * from USERS;
user_id | user_name | password_hash | password_salt | password_login | optimistic_lock_version
———+———–+——————————————————————+———————-+—————-+————————-
1 | admin | e34237cbbfb58df0336e16ceebf1d7331c3d493fd7c78566cc598b695530c9df | -3870999648764349353 | t | 2
(1 row)
scm=>
