It is very simple, asterisk can log cdrs automatically by configuring cdr_mysql.conf. All you need to create a mysql table along with proper read/write permissions. You can find the cdr table schema from the below link.
https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend Regards, Muhammad Faheem On Thu, Sep 17, 2015 at 3:21 PM, Amelye Chatila <amec...@gmail.com> wrote: > I have asterisk 13.5 configured with a simple dial plan, 3 SIP clients two > Laptops and smartphone with softphones installed. Now I am trying to store > cdr into a database but not able to make a connection of ODBC drivers to > MySQL is there an option or anything. Thanks in advance > > My configuration:: > *sip.conf* > > [general] > trasport=udp ;Data format | sample commennt > > [template01](!) > type=friend > context=from-internal > host=dynamic > disallow=all > allow=ulaw > context=from-internal > secret=unsecurepassword > > [6001](template01) > > [7001](template01) > bindport=6050 > > > *extensions.conf* > > [from-internal] > exten => 7001,1,Dial(SIP/7001,30) > exten => 6001,1,Dial(SIP/6001,30) > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users