[Serusers] user location with MySQL database - synchronization between several routers

[Tina]

Hi,
I am trying to set up 2 sers with shared MySQL database for location service. 
192.168.25.163 - server 1
192.168.25.102 - server 2
192.168.25.163 - data base
 
I have several clients to register and save in data base.
 
I set in both ser.cfg:
 
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url","sql://ser:heslo@192.168.25.163/ser")
 
 
After reboot I see:
=====================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===
 
=========================================================
I thought in db_mode 2 server takes contacts from DB, not in-memory...Any ideas how to synchronize them (I am not going to use t_replicate() )?
 
Tina,
software engineer
 
AQny help highly appreciated!!!
 
 

		
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - now with 250MB free storage. Learn more.
		
---------------------------------
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site! 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050331/2e5f25bc/attachment.htm>