Asterisk real time db not working

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 .

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.

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

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

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

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.

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’

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.