TUTORIAL: Add/recover access to PBXware in case of lost password
In the event of a mishandling and your administrator password has been lost, it is possible to manually add an administrator account.
Prerequisites:
To recover your administrator access to the PBXware web interface, you will need to:
- be in possession of your root password
- have a command-line terminal available
1. Log in via SSHto your PBXware machine
2. Enter the MySQL shell with the following command:
/opt/pbxware/sh/mysql Change an account password
Changing the administrator account password will allow you to recover it and subsequently log in using that password.
Select the database and the table:
use sitemanager_global; select * from users; +----+---------------+-------------------------+----------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+-----------------+------------+----------------+----------+-----------+------------+------------------+----------------------+ | id | name | email | username | password | password_sha | password_salt | type | password_expiry | last_login | password_reset | disabled | tfa_setup | tfa_secret | tfa_force_logins | last_password_change | +----+---------------+-------------------------+----------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+-----------------+------------+----------------+----------+-----------+------------+------------------+----------------------+ | 1 | Administrator | test@gmail.com | | | 37cbf7a4bd9247c44aaca1f37c14a04b2fec4a8493b76b827d750264b44H3g40 | 14a439d6b3b48c81ad9548bc3f430e966ba10fae4e8eeefa9721ff2d47e3acbf | 1 | NULL | 1666708613 | NULL | NULL | NULL | NULL | 0 | NULL | +----+---------------+-------------------------+----------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+-----------------+------------+----------------+----------+-----------+------------+------------------+----------------------+ 6 rows in set (0.00 sec) - Now change the user password
update users set password = md5('VOTREMDP') where id = 1; Add a new access account
Alternatively, if you want to log in to a customer system to which you do not have administrator access and you have the root password, it is possible to create a new administrator account:
insert into sitemanager_global.users set name='Bicom France', email='support@ags-next.com', password=md5("VotreMotDePasse"), type=1; This command will thus avoid changing the password of the already existing administrator account.
