Repair the MySQL Database
Connecting to the UCX Command Line Interface (UCX Release 6.0)
Occasionally you may be required to repair the MySQL database on the UCX. This can be done by issuing a command via the UCX Command Line Interface.
Connect to the UCX via a Secure Shell (SSH) connection. Typically this is done via an open source terminal emulator software called PuTTY. This can be downloaded from putty.org.
Step 1: Open the PuTTY application.
Step 2: Enter your values for Host Name (or IP address), Port, and Connection type. If you UCX is remotely connected you need to either use its E-MetroTel VPN address or the remote site's Public name or IP address, although this requires you to have port mapping configured to allow your router to direct the connection to the UCX private IP address on port 22. The port number to configure in this screen should either be 22 or the address configured on your router. The connection type should be SSH.
Step 3: When configured, click Open.
UCX Command Line Interface Login
Step 1: Log in to the UCX Command Line Interface using the same username/password combination that you use for Administrator access to the UCX Web-based Configuration Utility.
Step 2: After typing the administrator password, press Enter on your keyboard.
Repair the MySQL Database
Step 1: At the prompt, type the command: elastix-helper dbcheck and press Enter on your keyboard.
Step 2: Review the response:
Usage Example
The following shows a corrupt CDR Report in the UCX Web-based Configuration Utility:
Running the elastix-helper dbcheck command:
And the resulting CDR Report shows that data has been recovered, although some of the more recent records may be missing due to the original corruption.: