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

2015-09-18 Thread Amelye Chatila 
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 
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  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
>
-- 
_
-- 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

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

2015-09-17 Thread Amelye Chatila 
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

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

2015-09-17 Thread Faheem Muhammad 
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  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