Get help with installing, upgrading and running a PBX such as Asterisk.
User avatar
By WelshPaul
Posts Signature Likes Avatar Topics
#4375
First SSH into your server...

To clear the call history, type in the following commands one at a time:
Code: Select all
mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < '2017-03-06 00:00:00';
To clear the call event logs, type in the following commands one at a time:
Code: Select all
mysql
use asteriskcdrdb;
DELETE from cel WHERE eventtime < '2017-03-06 00:00:00';
Note 1: You only need to enter 'mysql' and 'use asteriskcdrdb;' once after SSH'ing into your server. So if you wanted to clear both the call history and call event logs, use the following:
Code: Select all
mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < '2017-03-06 00:00:00';
DELETE from cel WHERE eventtime < '2017-03-06 00:00:00';
Note 2: Replace the date with the date from which point you want the logs to be cleared from. Using the date '2017-03-06 00:00:00' in the above example will only clear any records held before this date.

Note 3: Running the mysql command shown above may result in the following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
If so enter: mysql -u root -p and then press enter, enter the password for user root and once again press enter. If your not sure what the mysql username and passord is, look in etc/freepbx.conf
0

Thank you all forum members and moderators. I just got…

Hello, Which applications such as Whatsapp, Skype, Tel…

Hi Tony, I have just found that in the FAQ as well, se…

PSTN (analogue Phone line) to PBX

Hi, You/I need to think about FXO and FXS ports, see h…

Sign up for VIP membership