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&characterEncoding=UTF-8&characterSetResults=UTF-8&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 Query OK, 1 row affected (0.00 sec)
admin/admin可以登录了