Confluence 重置密码步骤

当我们忘记Confluence密码或者不能作为admin登陆的话，请参考以下方法：

• 首先，你的有mysql或者其他数据库的权限啦，找到admin权限的用户

  select u.id, u.user_name, u.active from cwd_user u
  join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
  where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';
  确保找到的用户处于激活状态
  UPDATE cwd_user
  SET active = 'T'
  WHERE user_name ='<user_name>';
  

• 如果没有local admin存在，那我们只好自己建立了。

  insert into cwd_user(id, user_name, lower_user_name, active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, directory_id, credential) values (1212121, 'admin', 'admin', 'T', '2009-11-26 17:42:08', '2009-11-26 17:42:08', 'A. D.', 'a. d.', 'Ministrator', 'ministrator', 'A. D. Ministrator', 'a. d. ministrator', 'admin@example.com', 'admin@example.com', (select id from cwd_directory where directory_name='Confluence Internal Directory'), 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==');
  
  insert into user_mapping values ('2c9681954172cf560000000000000001', 'admin', 'admin');
  
  添加新组
  
  insert into cwd_group(id, group_name, lower_group_name, active, local, created_date, updated_date, description, group_type, directory_id)
  values ( '888888','confluence-administrators','confluence-administrators','T','F','2011-03-21 12:20:29','2011-03-21 12:20:29',NULL,'GROUP',(select id from cwd_directory where directory_name='Confluence Internal Directory'));
  insert into cwd_group(id, group_name, lower_group_name, active, local, created_date, updated_date, description, group_type, directory_id)
  values ( '999999','confluence-users','confluence-users','T','F','2011-03-21 12:20:29','2011-03-21 12:20:29',NULL,'GROUP',(select id from cwd_directory where directory_name='Confluence Internal Directory'));
  
  添加组关系
  insert into cwd_membership (id, parent_id, child_user_id) values (888888, (select id from cwd_group where group_name='confluence-users' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);
  insert into cwd_membership (id, parent_id, child_user_id) values (999999, (select id from cwd_group where group_name='confluence-administrators' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);
  
  如果你用的是oracle数据库，请用 sysdate 代替 created_date.
  

• 替换admin密码，加密后的密码如下
  x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==，为了更改密码，我们要关闭Confluence
  登陆mysql执行

  update cwd_user set credential =
  'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
  where id=<id from Stage 1>;
  

• 更改Internal Directory 为第一

  找到directory 名
  
  select d.id, d.directory_name, m.list_index from cwd_directory d join cwd_app_dir_mapping m on d.id=m.directory_id;
  
  交换directory顺序
  
  update cwd_app_dir_mapping set list_index = 0 where directory_id = <Internal Directory id>;
  update cwd_app_dir_mapping set list_index = <Noted Internal Directory list_index> where directory_id = <Directory id that had list_index 0>;
  
  查看是否激活directory
  select id, directory_name, active from cwd_directory where id = <Internal Directory id>;
  
  如果必要，激活
  
  update cwd_directory set active = 'T' where id = <Internal Directory id>;
  

重启登陆，打完收工

---

您的鼓励是我写作最大的动力

俗话说，投资效率是最好的投资。 如果您感觉我的文章质量不错，读后收获很大，预计能为您提高 10% 的工作效率，不妨小额捐助我一下，让我有动力继续写出更多好文章。