- Mon 6th Mar 2017, 19:15
#4375
- Appreciate my support? Feel free to buy me a coffee.
- Voipfone are offering you the chance to trial their VoIP service for free for 30 days. Sign me up!
- Sign up for a Dropbox account using my referral link and get an extra 500 MB of bonus space. Sign me up!
First SSH into your server...
To clear the call history, type in the following commands one at a time:
Note 3: Running the mysql command shown above may result in the following error:
To clear the call history, type in the following commands one at a time:
Code: Select all
To clear the call event logs, type in the following commands one at a time:
mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < '2017-03-06 00:00:00';
Code: Select all
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:
mysql
use asteriskcdrdb;
DELETE from cel WHERE eventtime < '2017-03-06 00:00:00';
Code: Select all
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.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 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
- Appreciate my support? Feel free to buy me a coffee.
- Voipfone are offering you the chance to trial their VoIP service for free for 30 days. Sign me up!
- Sign up for a Dropbox account using my referral link and get an extra 500 MB of bonus space. Sign me up!
How did this post make you feel?