在做confluence数据迁移之后,出现了使用admin账户无法登录,日志报错信息如下:
直接修改数据库,更改admin密码
查询admin用户的id
mysql> 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';
+---------+------------+--------+
| id | user_name | active |
+---------+------------+--------+
| 229377 | admin | T |
| 1343489 | i_chenglin | T |
+---------+------------+--------+
2 rows in set (0.00 sec)
更改密码为admin
mysql> update cwd_user set credential = 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==' where id=229377;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
另一种方法是使用recovery模式进入confluence,然后找到对应的管理员账户,随后修改密码
进入recovery模式的方法:
修改setenv.sh脚本
CATALINA_OPTS="-Datlassian.recovery.password=12345678" #增加属性,密码为12345678
修改完成后,重启confluence,登录名:recovery_admin 密码:12345678