Where are the CDR records stored?

I have recently downloaded and configured an official FreePBX Distro 10.13.66-1 from https://www.freepbx.org/downloads/ and I have some scripts that I have used on my original server, but they aren’t working on the new one. Both are running the same version of freepbx, so I’m assuming this version either doesn’t have mysql for call records or they have changed it. Can someone point me in the right direction?

CDR records are stored in MySQL database “asteriskcdrdb”. There are two tables, cdr and cel.

3 Likes

Ok so that’s what I had, do I have to do something to be able to access it remotely? over the same subnet network?

You will have to create a mysql user for this purpose (with appropriate security), the existing mysql users are all locked to localhost.

ahhh, ok, Thanks so much! I hope to know half of what you guys know about this one day! How long have you been using freepbx?