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===
=========================================================
--------------------------------- Do you Yahoo!? Better first dates. More second dates. Yahoo! Personals
-
Tina