Asterisk real time db not working

Asterisk Asterisk Support
1

Hi all I am trying to integrate asterisk dynamic realtime setup . I have 2 asterisk servers.
I connected both one of them to mysql db via odbc . Everything is working fine but when i am registering a user nothing is being reflected in DB. Do i have to add users explicitly .

2

What do you mean by ā€œregistering a userā€? users.conf is deprecated, and there are multiple channel types on which a device can register, all of which will differ in detail.

As far as I know ARA treats the database as readonly, so device registrations will never get recorded there.

3

Registering means ā€˜sipp 10.120.49.61:5060 -i 10.120.49.62 -p 5060 -sf register_alice/uac.xml -m 1ā€™ where uac.xml is scenerio for registration of user alice .

Here are my configs .

extconfig.conf

sippeers => odbc,asterisk,sip_buddies
sippusers => 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
meetme => odbc,asterisk,meetme

extenisons.conf

[users]
exten=>6001,1,Dial(SIP/alice@open-ims.test,20)
exten=>6002,1,Dial(SIP/bob@open-ims.test,20)
exten=>6003,1,Dial(SIP/alice,20)
exten=>6004,1,Dial(SIP/bob,20)
exten=>bob,1,Dial(SIP/bob,20)
exten=>alice,1,Dial(SIP/alice,20)

odbc is being connected to DB i can see the SELECT queries in DB log .

BUT none of the INSERT query being executed on MYSQL DB to insert the peers

10.120.49.61 is my asterisk server ip

in sip.conf i have

[alice]
type=friend
username=alice
;domain=open-ims.test
;host=10.140.7.1
host=dynamic
canreinvite=no
secret =alice
insecure=invite,port
qualify=no
context=users
;deny=0.0.0.0/0
permit=10.0.0.0/255.0.0.0

4

As I said, Iā€™m pretty sure that Asterisk Real Time Architecture is read only, so chan_sip is not going to persist that in the ARA database.

Iā€™m also not aware of any persistence of this in ASTDB; it is really too transient information to want to do that.

Iā€™m guessing you are trying to do some sort of fault tolerant system, but more detail might help people to suggest alternatives.

1 Like
5

David i only want that when i run register uac.xml scenario it should go to data base .
ā€˜sip show peersā€™ information should also reflect in db table . which is not as if now even after configuring odbc for sip

6

I think Asterisk is behaving as intended.

Why do you require a different behaviour?

Note that ARA is community supported and the level of support varies greatly between different parts of Asterisk, with quite a few not supporting it at all.

7

I did this in my /etc/asterisk/extconfig.conf

sippeers => odbc,asterisk,sip_buddies
sippusers => 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
meetme => odbc,asterisk,meetme

and did reload .

Above thing should store peers which is in sip.conf as

[alice]
type=friend
username=alice
;domain=open-ims.test
;host=10.140.7.1
host=dynamic
canreinvite=no
secret =alice
insecure=invite,port
qualify=no
context=users
;deny=0.0.0.0/0
permit=10.0.0.0/255.0.0.0

into database as well . But i am not able to see anything in database table ā€˜sip_buddiesā€™

8

It looks like I was wrong about this being written back.

However you still have have the problem that ARA is community supported, so you may have difficulty finding someone who knows about it.