Disallow cdr report

Again, you would have to ask that in the right forum, you don’t have root access to mysqld so any advise might well break your system.

Hi, I have a little problem with my cel.MYD being too big. How can I delete some entries from it? Thanks.

[root@localhost ~]# ls -lh /var/lib/mysql/asteriskcdrdb/
total 6.4G
-rw-rw----. 1 mysql mysql 14K Mar 15 2017 cdr.frm
-rw-rw----. 1 mysql mysql 707M Oct 13 05:50 cdr.MYD
-rw-rw----. 1 mysql mysql 190M Oct 13 05:50 cdr.MYI
-rw-rw----. 1 mysql mysql 14K Mar 15 2017 cel.frm
-rw-rw----. 1 mysql mysql 4.6G Oct 13 05:50 cel.MYD
-rw-rw----. 1 mysql mysql 964M Oct 13 05:50 cel.MYI
-rw-rw----. 1 mysql mysql 61 Mar 15 2017 db.opt

It’s the Call Event Log database. There’s no way to access the database directly from FreePBX (that I’m aware of) but you can log into MySQL from the console and delete records from the CEL database table based on their date. I don’t remember the exact field name, but the command in MySQL is going to be something like

“DELETE FROM cel WHERE [date field name] < ‘1999-12-31 23:59:59’;”