Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. openfire是一个跨平台的Java为基础的免费的即时通讯服务器实现xampp (的Jabber )协议的扩展。 It is very well suited as corporate instant messaging solution.这是非常适合作为企业即时通讯解决方案。 Here is how you can recover the admin password, in case you forget it.这里是你如何可以恢复管理员密码,如果你忘记它。


How to recover Openfire admin password如何恢复openfire管理员密码

1. 1 。 Login to MySQL and use openfire database.登录到MySQL和使用openfire数据库。 I use the command:我使用的命令:
mysql -uroot -p openfire MySQL的- uroot - P的openfire

2. 2 。 Display the password for the admin user with the query:显示管理员密码与查询:
select password from jiveUser where username = 'admin'; 选择密码从jiveuser其中username = '管理' ;

This will display the initially chosen password for admin.这将显示最初选择的密码管理。 However if you have at any time changed the password from the administration screen then it will display NULL instead.不过,如果您有在任何时间改变密码,从政府当局屏幕,然后它会显示无效。
After first change the password is encrypted and stored in the encryptedPassword field and cannot be recovered.之后,首先改变的密码是加密并存储在encryptedpassword领域和无法恢复。

However you can change the password even without knowing the original password.不过您可以更改密码,甚至不知道原来的密码。

How to change Openfire admin password如何改变openfire管理员密码

Change the admin (or any other users) password by setting password field to chosen value and encryptedPassword field to null.改变政府当局(或任何其他用户)的密码设置密码栏位选择的价值和encryptedpassword领域为NULL 。 For example here is the query to set the admin password to 123456:例如在这里是查询设置管理员密码123456 :
update jiveUser set password='123456', encryptedPassword = null where username ='admin'; 更新jiveuser设置密码= 123456 ' , encryptedpassword =空其中username = '管理' ;

This will change the current admin password to 123456.这将改变目前管理员密码123456 。 Remember to change it to a different value after you login to the admin console.记得将它更改为不同的值后,您登录到管理控制台。 This will also have the side-effect of encrypting your password in database for added security.这也将有副作用加密您的密码在数据库中为增加安全性。

Note: Openfire admin console is available at http://localhost:9090注: openfire管理控制台可在http://localhost:9090