'./asteriskcdrdb/cel' is marked as crashed and should be repaired

FreePBX
1

Freepbx 13

SQLSTATE[HY000]: General error: 145 Table ‘./asteriskcdrdb/cel’ is marked as crashed and should be repairedSQL -
SELECT * FROM asteriskcdrdb.cel WHERE uniqueid = ‘1505604683.0’ OR linkedid = ‘1505604683.0’ ORDER BY eventtime, id::

I tried

fwconsole util tablefix

but that did not handle this problem.

Any idea?

2

[[email protected] ~]# fwconsole util tablefix
Attempting to repair MySQL Tables (this may take some time)
MySQL Tables Repaired

3

Just to clarify, this did NOT handle the problem

4

Hello @MIKEK,

You can repair your cel table manually.
Type the following commands in your linux console:

1. mysql asteriskcdrdb
2. repair table cel;

Wait until you will get a confirmation prompt.

Thank you,

Daniel Friedman
Trixton LTD.

5

[[email protected] ~]# mysql asteriskcdrdb
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

What password do I need to use?

6

I was able to run

mysqlcheck --repair --all-databases

With the user freepbxuser and the password from etc/ freepbx.conf