<DIV>Hi,</DIV>
<DIV>I am trying to set up 2 sers with shared MySQL database for location service. </DIV>
<DIV>192.168.25.163 - server 1</DIV>
<DIV>192.168.25.102 - server 2</DIV>
<DIV>192.168.25.163 - data base</DIV>
<DIV> </DIV>
<DIV>I have several clients to register and save in data base.</DIV>
<DIV> </DIV>
<DIV>I set in both ser.cfg:</DIV>
<DIV> </DIV>
<DIV><STRONG><EM>modparam("usrloc", "db_mode", 2)<BR>modparam("usrloc", "db_url","sql://ser:heslo@192.168.25.163/ser")</EM></STRONG></DIV>
<DIV><STRONG><EM></EM></STRONG> </DIV>
<DIV> </DIV>
<DIV>After reboot I see:</DIV>
<DIV>=====================server 1</DIV>
<DIV>...Record(0x283346d8)...<BR>domain: 'location'<BR>aor : 'tuka'<BR>~~~Contact(0x28334738)~~~<BR>domain : 'location'<BR>aor : 'tuka'<BR>Contact : 'sip:tuka@192.168.25.101:5060'<BR>Expires : 37<BR>q : 0.00<BR>Call-ID : <A href="mailto:'560A7CDDD007454085257F2B529045EE@192.168.25.163'">'560A7CDDD007454085257F2B529045EE@192.168.25.163'</A><BR>CSeq : 51963<BR>replic : 0<BR>User-Agent: 'X-Lite release 1103m'<BR>State : CS_SYNC<BR>Flags : 0<BR>next : 0x0<BR>prev : 0x0<BR>~~~/Contact~~~~<BR>.../Record...<BR>...Record(0x28334828)...<BR>domain: 'location'<BR>aor : '10'<BR>~~~Contact(0x28334888)~~~<BR>domain :
'location'<BR>aor : '10'<BR>Contact : 'sip:100@192.168.25.169'<BR>Expires : 79<BR>q : 0.00<BR>Call-ID : <A href="mailto:'77a4044d31169898427c3c556a5d128c@192.168.25.169'">'77a4044d31169898427c3c556a5d128c@192.168.25.169'</A><BR>CSeq : 1489<BR>replic : 0<BR>User-Agent: 'Asterisk PBX'<BR>State : CS_SYNC<BR>Flags : 0<BR>next : 0x0<BR>prev : 0x0<BR>~~~/Contact~~~~<BR>.../Record...<BR>...Record(0x28334968)...<BR>domain: 'location'<BR>aor : '1111'<BR>~~~Contact(0x283349c8)~~~<BR>domain : 'location'<BR>aor : '1111'<BR>Contact : 'sip:1111@192.168.25.169'<BR>Expires :
79<BR>q : 0.00<BR>Call-ID : <A href="mailto:'000041a710d63af160b7acd93ab50c2a@192.168.25.169'">'000041a710d63af160b7acd93ab50c2a@192.168.25.169'</A><BR>CSeq : 1489<BR>replic : 0<BR>User-Agent: 'Asterisk PBX'<BR>State : CS_SYNC<BR>Flags : 0<BR>next : 0x0<BR>prev : 0x0<BR>~~~/Contact~~~~<BR>.../Record...</DIV>
<DIV>---/Domain---<BR>===/Domain list===</DIV>
<DIV>================================server 2:</DIV>
<DIV> </DIV>
<DIV>...Record(0x283430e0)...<BR>domain: 'location'<BR>aor : '10'<BR>~~~Contact(0x28343120)~~~<BR>domain : 'location'<BR>aor : '10'<BR>Contact : 'sip:100@192.168.25.169'<BR>Expires : 305<BR>q : 0.00<BR>Call-ID : <A href="mailto:'77a4044d31169898427c3c556a5d128c@192.168.25.169'">'77a4044d31169898427c3c556a5d128c@192.168.25.169'</A><BR>CSeq : 1486<BR>replic : 0<BR>User-Agent: 'Asterisk PBX'<BR>State : CS_SYNC<BR>Flags : 0<BR>next : 0x0<BR>prev : 0x0<BR>~~~/Contact~~~~<BR>.../Record...<BR>...Record(0x283431d8)...<BR>domain: 'location'<BR>aor : '1111'<BR>~~~Contact(0x28343218)~~~<BR>domain :
'location'<BR>aor : '1111'<BR>Contact : 'sip:1111@192.168.25.169'<BR>Expires : 305<BR>q : 0.00<BR>Call-ID : <A href="mailto:'000041a710d63af160b7acd93ab50c2a@192.168.25.169'">'000041a710d63af160b7acd93ab50c2a@192.168.25.169'</A><BR>CSeq : 1486<BR>replic : 0<BR>User-Agent: 'Asterisk PBX'<BR>State : CS_SYNC<BR>Flags : 0<BR>next : 0x0<BR>prev : 0x0<BR>~~~/Contact~~~~<BR>.../Record...</DIV>
<DIV>---/Domain---<BR>===/Domain list===</DIV>
<DIV> </DIV>
<DIV>=========================================================</DIV>
<DIV>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() )?</DIV>
<DIV> </DIV>
<DIV>Tina,</DIV>
<DIV>software engineer</DIV>
<DIV> </DIV>
<DIV>AQny help highly appreciated!!!</DIV>
<DIV> </DIV>
<DIV> </DIV><p>
<hr size=1>Do you Yahoo!?<br>
Yahoo! Mail - now with 250MB free storage. <a href="http://us.rd.yahoo.com/evt=29914/*http://info.mail.yahoo.com/mail_250">Learn more.</a><p>
<hr size=1>Do you Yahoo!?<br>
Yahoo! Small Business - <a href="http://us.rd.yahoo.com/evt=31637/*http://smallbusiness.yahoo.com/resources/">Try our new resources site!</a>