Users unable to login to UCP

FreePBX Installation / Upgrade
1

After upgrading to FreePBX 13, users cannot login to UCP.

I have tries creating a test user in User Manager and setting the UCP login permission to ‘Yes’ but the test user cannot login.

The ucp_err.log in /var/log/asterisk has a message that states “There was an error with MySQL Connection”.

Does anyone have any ideas where to look next?

Thanks.

2

I have the same issue, did you find a fix?

3

In my case, this was a crashed users table in the asterisk database. To check for crashed tables:
Execute mysql -u root -p [YOURMYSQLROOTPASSWORD]
SHOW TABLE STATUS FROM ‘asterisk’;

If a table is marked as crashed from the mysql prompt:
use asterisk;
repair table [YOURCRASHEDTABLE];

That is what solved my problem.