I migrated configs from another server and upgraded. I was locked out. I logged into the the server and looked through the ampusers table and saw the previous accounts’ passwords were converted to sha1 but the default admin account was gone. I logged into the old box and saw the passwords were cleartext so I borrowed one and logged into the new server. I try creating a new admin account and got:
I hacked line 1905 of admin/modules/core/functions.inc.php to read $sql = “INSERT INTO ampusers (username, password_sha1, extension_low, extension_high, deptname, sections) VALUES (”;
Now the password got inserted into the correct field but it was clear text. I did a echo password | sha1sum on the command line and got a sha1 checksum, inserted that into the password field but unfortunately freepbx would not accept my credentials.
Thanks for the proper fix, however i was unable to find /etc/pbx/httpd-pbx.conf or any other file with AuthMySQLPasswordField in it.
[SOLVED] In Ubuntu Server 12.04:
In file ~/admin/modules/core/function.inc.php find and chnge string: INSERT INTO ampusers …
change to REPLACE INTO ampusers …