0 like 0 dislike
392 views
Need help on basic conf of ARA
in Education & Reference by (1.3k points) | 392 views

2 Answers

0 like 0 dislike

nano /etc/asterisk/extconfig.conf

sippeers => odbc,asterisk,sip_buddies
sipusers => odbc,asterisk,sip_buddies
extensions => odbc,asterisk,extensions
voicemail => odbc,asterisk,voicemail_users
queues => odbc,asterisk,queue_table
queue_members => odbc,asterisk,queue_member_table
queue_log => odbc,asterisk,queue_log
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!!

by
edited
0 0
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
by

Related questions

1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked May 29, 2019 in Education & Reference by Marc (2.4k points) | 67 views
3 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

1,202 questions
1,348 answers
553 comments
1,994 users