Get help with installing, upgrading and running a PBX such as Asterisk.
User avatar
By Manny
Posts Likes Avatar Topics
#3106
I have been struggling with this for most of the day! :-/

I have had my FREEPBX server up and running for some time now and as a result have thousands and thousands of records stored but there appears to be no way to clear them?

After googling it appears that they are stored in a database on the server but how do I safely clear any old records and only keep records from 2015 onwards?
0
User avatar
By WelshPaul
Posts Signature Likes Avatar Topics
#3107
You will need to SSH into your server...

Once in run the following commands:
Code: Select all
mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < '2015-01-01 00:00:00';
Running the mysql command shown above may result in an error requiring that you login first. If so enter: mysql -u root -p and then press enter, enter the password for user root and once again press enter.

Your CDR should only hold records from 1st January 2015 onwards. :)
0
0
Sipgate Basic and multiple SIP clients

Ok, thanks. Was worried that using the same sip user in…

Your device was probably listed on Cisco's provisioning…

This means it is very dangerous to post here other t…

https://www.ukvoipforums.com/viewtopic.php?t=58#p5950

Sign up for VIP membership