Hi,
I am trying to set up 2 sers with a shared MySQL database for location service.
192.168.25.163 - server 1 (and MySQL DB)
192.168.25.102 - server 2
I set in both ser.cfg:
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url","sql://ser:heslo@192.168.25.163/ser")
Unfortunately, the second ser (192.168.25.102 ) does not relay calls because it does not see the contacts in usrloc....
Even after reboot they are not synchronized (see below the output of serctl ul show)
I thought db_mode 2 means that ser should read contact list from DB (and write to DB)...What I missed?
Any help is highly appreciated!!!
Tina,
software engineer
=====================server 1
...Record(0x283346d8)...
domain: 'location'
aor : 'tuka'
~~~Contact(0x28334738)~~~
domain : 'location'
aor : 'tuka'
Contact : 'sip:tuka@192.168.25.101:5060'
Expires : 37
q : 0.00
Call-ID :
'560A7CDDD007454085257F2B529045EE@192.168.25.163'CSeq : 51963
replic : 0
User-Agent: 'X-Lite release 1103m'
State : CS_SYNC
Flags : 0
next : 0x0
prev : 0x0
~~~/Contact~~~~
.../Record...
...Record(0x28334828)...
domain:
'location'
aor : '10'
~~~Contact(0x28334888)~~~
domain : 'location'
aor : '10'
Contact : 'sip:100@192.168.25.169'
Expires : 79
q : 0.00
Call-ID :
'77a4044d31169898427c3c556a5d128c@192.168.25.169'CSeq : 1489
replic : 0
User-Agent: 'Asterisk PBX'
State : CS_SYNC
Flags : 0
next : 0x0
prev : 0x0
~~~/Contact~~~~
.../Record...
...Record(0x28334968)...
domain: 'location'
aor :
'1111'
~~~Contact(0x283349c8)~~~
domain : 'location'
aor : '1111'
Contact : 'sip:1111@192.168.25.169'
Expires : 79
q : 0.00
Call-ID :
'000041a710d63af160b7acd93ab50c2a@192.168.25.169'CSeq : 1489
replic : 0
User-Agent: 'Asterisk PBX'
State : CS_SYNC
Flags : 0
next : 0x0
prev : 0x0
~~~/Contact~~~~
.../Record...
---/Domain---
===/Domain list===
================================server 2:
...Record(0x283430e0)...
domain: 'location'
aor : '10'
~~~Contact(0x28343120)~~~
domain : 'location'
aor : '10'
Contact : 'sip:100@192.168.25.169'
Expires : 305
q : 0.00
Call-ID :
'77a4044d31169898427c3c556a5d128c@192.168.25.169'CSeq : 1486
replic : 0
User-Agent: 'Asterisk PBX'
State : CS_SYNC
Flags : 0
next : 0x0
prev : 0x0
~~~/Contact~~~~
.../Record...
...Record(0x283431d8)...
domain: 'location'
aor :
'1111'
~~~Contact(0x28343218)~~~
domain : 'location'
aor : '1111'
Contact : 'sip:1111@192.168.25.169'
Expires : 305
q : 0.00
Call-ID :
'000041a710d63af160b7acd93ab50c2a@192.168.25.169'CSeq : 1486
replic : 0
User-Agent: 'Asterisk PBX'
State : CS_SYNC
Flags : 0
next : 0x0
prev : 0x0
~~~/Contact~~~~
.../Record...
---/Domain---
===/Domain list===
=========================================================