system service►Atlassian►confluence reset passwd

Atlassian confluence reset passwd

重置 confluence 管理员密码

  1. 在数据库中查看管理员ID

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    MariaDB [test_confluence]> select * from cwd_user where id\G;
    *************************** 1. row ***************************
                     id: 458753
              user_name: liu_p
              ... ....
             credential: {PKCS5S2}VaATUfyNnO5tOglFJN9C8Hqi1UVKA3GTr5zBddT0BnVMTpgNtlP7ciJfdWgERjiz
    1 row in set (0.00 sec)

    MariaDB [test_confluence]> 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 |
    +--------+-----------+--------+
    | 458753 | liu_p      | T      |
    +--------+-----------+--------+
    1 row in set (0.00 sec)

  2. 重置密码,默认为”Ab123456”

    1
    MariaDB [test_confluence]> update cwd_user set credential =  '{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where id=458753;