QUESTION IncrediblePBX 13-13 can't login to GUI when changing admin-pw-change error

[RayGrasshopper]

Enter new admin password (MAKE IT SECURE!!): 123456789

admin password will be changed to: 123456789
Press ENTER key to continue or Ctrl-C to abort...
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1406 (22001) at line 1: Data too long for column 'password_sha1' at row 1

Done. Use browser to access FreePBX at http://

root@ip-172-31-27-135:/home/ubuntu#

 

[asifshabir]

Step1:
login as root.
#cd /root
#cat admin-pw-change

Look for these line

echo "admin password will be changed to: $adminpw"
read -p "Press ENTER key to continue or Ctrl-C to abort..."
mysql -u root -ppassw0rd -e "update asterisk.ampusers set password_sha1 = '`echo -n $adminpw | sha1sum`' where username = 'admin' limit 1;"
echo " "

This is your root passowrd: mysql -u root -ppassw0rd

Step2:
Gernerate a new password for admin user for GUI Access

echo -n 'yourpassword' | sha1sum | cut -d' ' -f1

You will get a long number like:

e8c36c9b6fee0easd8e15aa073349cf7asdas18ddd2f29

Step3:
Now follow these steps to set new password for user : admin
mysql -u root -ppassw0rd
mysql> select * from asterisk.ampusers;

mysql> update asterisk.ampusers set password_sha1 = 'e8c36c9b6fee0easd8e15aa073349cf7asdas18ddd2f29' where username = 'admin' limit 1;

asterisk = DB Name
ampusers: Table name

I hope it helps