Switch CDR recording from plain text to MySQL in Trixbox

Posted on 2012-09-11
Last Modified: 2012-11-23

I'm running Trixbox CE

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

Any help is appreciated.
Question by:alexkink
    1 Comment
    LVL 15

    Accepted Solution

    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;

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    The point of this post is to give you a copy/paste installation solution to setting up Asterisk 1.6 on Ubuntu 9.04 (or similar) server. # Setup the system apt-get install subversion apt-get install make apt-get install linux-source kernel-p…
    Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now