WARNING: Any manual MySQL modifications are at your own risk and should be performed by a person familiar with MySQL. Eventual issues caused are not covered by Bicom Systems support
To change the interface password from mySQL, proceed as follows:
cd /opt/pbxware
sh/mysql
mysql> use sitemanager_global; mysql> select * from users;
Output should look something like this:
+----+---------------+-------------------------+----------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+-----------------+------------+----------------+----------+-----------+------------+------------------+----------------------+
| 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 | [email protected] | | | 37cbf7a4bd9247c44aaca1f37c14a04b2fec4a8493b76b827d750264b44H3g40 | 14a439d6b3b48c81ad9548bc3f430e966ba10fae4e8eeefa9721ff2d47e3acbf | 1 | NULL | 1666708613 | NULL | NULL | NULL | NULL | 0 | NULL |
+----+---------------+-------------------------+----------+----------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+------+-----------------+------------+----------------+----------+-----------+------------+------------------+----------------------+
6 rows in set (0.00 sec)
mysql> update users set password = md5('$YOURNEW PASSWORD') where id = 1;
Make sure to replace $YOURNEWPASSWORD with new password you would like to set and try to log in with it.