mysql -u root( assuming no password was set)
mysql -u root -pand enter your password
SHOW DATABASES;to make sure you can see the DB's ( notice the semicolon)
REPAIR TABLE asteriskcdrdb.cdr;
How to reset a root password in PIAF and generic RHEL(Red Hat Enterprise Linux) based systems.
Having the ability to reset your PIAF password in-case of a lock-out is very vital when it's necessary to keep a open communication. Resetting a password may take a few minutes.
You can see, there are options to reset other passwords in PIAF from this menu as well.
*This should work on most RHEL-based systems
***Some devices may have SELINUX enabled or enforced, so it may not work if that is the case.
The main change from the 2.9 to 2.10 update is the layout of the menu buttons inside the GUI. Initially they were on the left hand side inside collapsible folders, now they are on the top of the page with drop down items.
Next follow the instructions from the 2.10 Upgrade Tool
Review of 2.10
The layout of the 2.10 GUI has changed the layout and placement of the menu items from the left hand side as expandable items to a single row on the top with fewer items. Several items were also moved around,so be sure to take some time to re-navigate through the Menu's. There are no longer separate Menu's to navigate through to go Setup and Tools. Overall the management of Asterisk and file management has improved from 2.9 to 2.10.
The update process to version 2.11 is very similar to the update of 2.10. The overall look of the GUI has not changed since the previous update, but some of the modules were cleaned up and reorganized.
Review of FreePBX 2.11
While there was no major change in the interface, there were some bug fixes and improved efficiency
Webmin is a web based administration tool that allows you to make changes to the server without going through the command line. Webmin runs on port 9001 by default inside the PBX in a Flash GUI.