Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] I want to store cdr into database


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
amechax at gmail.com
Guest





PostPosted: Thu Sep 17, 2015 5:21 am    Post subject: [asterisk-users] I want to store cdr into database Reply with quote

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)
Back to top
faheem2084 at gmail.com
Guest





PostPosted: Thu Sep 17, 2015 8:20 am    Post subject: [asterisk-users] I want to store cdr into database Reply with quote

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@gmail.com (amechax@gmail.com)> wrote:
Quote:
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
Back to top
amechax at gmail.com
Guest





PostPosted: Fri Sep 18, 2015 6:08 am    Post subject: [asterisk-users] I want to store cdr into database Reply with quote

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@gmail.com (faheem2084@gmail.com)> wrote:
Quote:
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@gmail.com (amechax@gmail.com)> wrote:


Quote:
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services