I Want To Store Cdr Into Database
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`50
*extensions.conf*
[from-internal]
exten => 7001,1,Dial(SIP/7001,30)
exten => 6001,1,Dial(SIP/6001,30)
2 thoughts on - I Want To Store Cdr Into Database
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
Thank you, I was able to configure the Asterisk with MySQL
Kind Regards, Amelye Chatila