[Serusers] Help needed - synchroniation of usrloc between several sers

[Tina]

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 at 192.168.25.101:5060'
Expires   : 37
q         :       0.00
Call-ID   : '560A7CDDD007454085257F2B529045EE at 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 at 192.168.25.169'
Expires   : 79
q         :       0.00
Call-ID   : '77a4044d31169898427c3c556a5d128c at 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 at 192.168.25.169'
Expires   : 79
q         :       0.00
Call-ID   : '000041a710d63af160b7acd93ab50c2a at 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 at 192.168.25.169'
Expires   : 305
q         :       0.00
Call-ID   : '77a4044d31169898427c3c556a5d128c at 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 at 192.168.25.169'
Expires   : 305
q         :       0.00
Call-ID   : '000041a710d63af160b7acd93ab50c2a at 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===
 
=========================================================





		
---------------------------------
Do you Yahoo!?
 Better first dates. More second dates. Yahoo! Personals 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050401/2f8b90e9/attachment.htm>