0 like 0 dislike
330 views
Need help on basic conf of ARA
asked May 22, 2015 in Education & Reference by Sam (1,370 points) | 330 views
    

2 Answers

0 like 0 dislike

nano /etc/asterisk/extconfig.conf

sippeers => odbc,asterisk,sipbuddies
sipusers => odbc,asterisk,sip
buddies
extensions => odbc,asterisk,extensions
voicemail => odbc,asterisk,voicemailusers
queues => odbc,asterisk,queue
table
queuemembers => odbc,asterisk,queuemembertable
queue
log => odbc,asterisk,queuelog
meetme => odbc,asterisk,meetme
musiconhold => odbc,asterisk,musiconhold
sip.conf => odbc,asterisk,sip
reg


nano /etc/asterisk/extentions.conf

[general]

[globals]
;
[from-sip]
switch =>Realtime/CONTEXT1@


nano /etc/asterisk/res_odbc.conf

[asterisk]
dsn => asterisk-connector
username => root
password => paasword

pre-connect => yes

nano /etc/odbc.ini

[asterisk-connector]
Description = MySQL ODBC
Driver = MySQL
Socket = /var/lib/mysql/mysql.sock
Server = localhost
User = root
Password = mysqlpassword
Database = DBname
Option = 3


DONE!!

answered May 22, 2015 by Puneet
edited Jul 4, 2015
nano /etc/asterisk/cdr_adaptive_odbc.conf

[adaptive_connection]
connection=asterisk
table=cdr
alias start => calldate

then  

module reload cdr_adaptive_odbc.so

if error then install
mysql-connector-odbc by using yum install libmyodbc5*

if no error you will see below

 module reload cdr_adaptive_odbc.so
    -- Reloading module 'cdr_adaptive_odbc.so' (Adaptive ODBC CDR backend)
  == Parsing '/etc/asterisk/cdr_adaptive_odbc.conf': Found
[Mar 17 07:06:50] NOTICE[9211]: res_odbc.c:1529 odbc_obj_connect: Connecting asterisk
[Mar 17 07:06:50] NOTICE[9211]: res_odbc.c:1568 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
    -- Found adaptive CDR table cdr@asterisk.
    -- Found alias start for column calldate in cdr@asterisk
0 like 0 dislike
answered Mar 30, 2016 by anonymous

Related questions

1 like 0 dislike
1 answer
0 like 0 dislike
2 answers
1 like 0 dislike
1 answer
asked Oct 23 in Education & Reference by Sam (1,370 points) | 13 views
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Mathe Forum Schule und Studenten
1,169 questions
1,309 answers
276 comments
1,602 users