openfire登录密码忘了

http://192.168.31.156:9090/

 登录openfire数据库修改下密码

# cat /opt/openfire/conf/openfire.xml |grep "mysql"
      <driver>com.mysql.cj.jdbc.Driver</driver>  
      <serverURL>jdbc:mysql://192.168.31.156:3306/ts110_openfire?rewriteBatchedStatements=true&amp;characterEncoding=UTF-8&amp;characterSetResults=UTF-8&amp;serverTimezone=UTC</serverURL>  
 

# mysql -uroot -p

mysql> desc ofUser;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| username          | varchar(64)  | NO   | PRI | NULL    |       |
| storedKey         | varchar(32)  | YES  |     | NULL    |       |
| serverKey         | varchar(32)  | YES  |     | NULL    |       |
| salt              | varchar(32)  | YES  |     | NULL    |       |
| iterations        | int(11)      | YES  |     | NULL    |       |
| plainPassword     | varchar(32)  | YES  |     | NULL    |       |
| encryptedPassword | varchar(255) | YES  |     | NULL    |       |
| name              | varchar(100) | YES  |     | NULL    |       |
| email             | varchar(100) | YES  |     | NULL    |       |
| creationDate      | char(15)     | NO   | MUL | NULL    |       |
| modificationDate  | char(15)     | NO   |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+
11 rows in set (0.00 sec)
密码加密了,删除，重新添加

mysql> select * from ofUser where username="admin";
+----------+------------------------------+------------------------------+----------------------------------+------------+---------------+----------------------------------------------------------------------------------+------------+-------------------+--------------+------------------+
| username | storedKey                    | serverKey                    | salt                             | iterations | plainPassword | encryptedPassword                                                                | name       | email             | creationDate | modificationDate |
+----------+------------------------------+------------------------------+----------------------------------+------------+---------------+----------------------------------------------------------------------------------+------------+-------------------+--------------+------------------+
| admin    | /YPve9sX0tHALzoZiWtJFVZLvMo= | iPHxS/hswJHaV3CVklLEtWGcYRQ= | sd7io6TXsbR9jT+i3h3ze9HF7nZKngcL |       4096 | NULL          | 3dd1dee95dd6bd7506974b4119587c08b95f2684c9142924cba5f298d85171ca51343f558fd6e2fa | Administra | admin@example.com | 0            | 0                |
+----------+------------------------------+------------------------------+----------------------------------+------------+---------------+----------------------------------------------------------------------------------+------------+-------------------+--------------+------------------+
1 row in set (0.00 sec)
 

mysql> delete from ofUser where username='admin';
Query OK, 1 row affected (0.00 sec)
 

mysql> insert into ofUser(username,plainPassword,name,email,creationDate,modificationDate) values('admin','admin','Administrator','admin@example.com','0','0');
Query OK, 1 row affected (0.00 sec)
 

admin/admin可以登录了