• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

Switch CDR recording from plain text to MySQL in Trixbox

Hello,

I'm running Trixbox CE 2.8.0.4.

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

Any help is appreciated.
0
alexkink
Asked:
alexkink
1 Solution
 
PhonebuffCommented:
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;
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now