FreePBX includes a password recovery feature in the event that you lose or forget the admin password. However, for some reason, it does not work with the latest version of RasPBX. If you find yourself in this situation, here's how to restore access:
First: SSH into your machine or access the command prompt using the local keyboard.
Second: Enter into MySQL by typing the following into the command prompt:
amportal a m
You'll enter into MySQL and see the following:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Third: Add new user and password to the FreePBX database table by typing the following (you can enter these on two separate lines):
INSERT INTO ampusers (username, password_sha1, sections)
VALUES ('zzz', '40fa37ec00c761c7dbb6ebdee6d4a260b922f5f4', '*');
Be sure to incliude the semi-colon at the end of the second line. By doing so, you will be creating a new admin user in FreePBX whose username is "zzz" and whose password is "zzz".
Fourth: Issue the following command to show the table and confirm that "zzz" was added as a user (note that this step is optional and you can skip it if you want):
SELECT * FROM ampusers;
Fifth: Exit from MySQL:
exit
Sixth: Exit from SSH:
exit
Seventh: Use your web browser to access the web interface. Use this username and password:
Username:zzzPassword:zzz
Eighth: Go to Admin -> Administrators.
Ninth: Update the Admin username and password that you want to use.
Tenth: Delete the "zzz" user.
Last edit: advocate 2015-12-02
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
FreePBX includes a password recovery feature in the event that you lose or forget the admin password. However, for some reason, it does not work with the latest version of RasPBX. If you find yourself in this situation, here's how to restore access:
First: SSH into your machine or access the command prompt using the local keyboard.
Second: Enter into MySQL by typing the following into the command prompt:
You'll enter into MySQL and see the following:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Third: Add new user and password to the FreePBX database table by typing the following (you can enter these on two separate lines):
INSERT INTO ampusers (username, password_sha1, sections) VALUES ('zzz', '40fa37ec00c761c7dbb6ebdee6d4a260b922f5f4', '*');Be sure to incliude the semi-colon at the end of the second line. By doing so, you will be creating a new admin user in FreePBX whose username is "zzz" and whose password is "zzz".
Fourth: Issue the following command to show the table and confirm that "zzz" was added as a user (note that this step is optional and you can skip it if you want):
Fifth: Exit from MySQL:
Sixth: Exit from SSH:
Seventh: Use your web browser to access the web interface. Use this username and password:
Eighth: Go to Admin -> Administrators.
Ninth: Update the Admin username and password that you want to use.
Tenth: Delete the "zzz" user.
Last edit: advocate 2015-12-02