Switch CDR recording from plain text to MySQL in Trixbox


I'm running Trixbox CE

I need to switch to MySQL for recording of CDR data.

Any help is appreciated.
Who is Participating?
PhonebuffConnect With a Mentor Commented:
Well, I though Trixbox already did that for you ..  But you should get off of Trixbox altogether as the CE is not longer supported and has a number of exposures.

Here is a simple example of query against the DB..

mysql -u asteriskuser -p

mysql> show databases;

mysql> show tables from asteriskcdrdb;

mysql> show asteriskcdrdb.cdr;

mysql> ex asteriskcdrdb.cdr;

mysql> select count(*) from asteriskcdrdb.cdr where datediff(now(), calldate) > 120;
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.