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) -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20150917/8223c5ad/attachment.html>
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 <amechax at 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20150917/eef21924/attachment.html>
Thank you, I was able to configure the Asterisk with MySQL Kind Regards, Amelye Chatila On Thu, Sep 17, 2015 at 4:19 PM, Faheem Muhammad <faheem2084 at gmail.com> wrote:> 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 <amechax at 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20150918/b3e0b00c/attachment.html>