<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV><FONT size=2 face="Courier New">Hi,</FONT></DIV>
<DIV><FONT size=2 face="Courier New"></FONT> </DIV>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">I'm testing the p_usrloc module (Kamailio version 3.3.2,
installed via ubuntu package) and it looks like it's working but for some reason
a re-registration is causing a new entry being added to the distributed location
table instead of updating the existing one.</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT
face="Courier New"></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">The kamailio configuration looks like
this:</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt"></FONT></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">#!define DBURL
"mysql://openser:openserrw@localhost/openser"</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt"></FONT></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">loadmodule "p_usrloc.so"</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "db_mode", 3)</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "write_db_url",
DBURL)</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "read_db_url",
DBURL)</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "write_on_db", 1)</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "alg_location",
1)</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">modparam("p_usrloc", "reg_db_table",
"locdb")</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT
face="Courier New"></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">mysql> select * from locdb;</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">+----+----+-------------------------------------------+--------+--------+---------------------+-------+----+</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">| id | no | url<SPAN
style="mso-spacerun: yes">
</SPAN>| status | errors | failover<SPAN
style="mso-spacerun: yes">
</SPAN>| spare | rg |</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">+----+----+-------------------------------------------+--------+--------+---------------------+-------+----+</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">|<SPAN style="mso-spacerun: yes"> </SPAN>1 |<SPAN
style="mso-spacerun: yes"> </SPAN>1 |
mysql://root:secret@172.16.10.131/openser |<SPAN
style="mso-spacerun: yes"> </SPAN>1 |<SPAN
style="mso-spacerun: yes"> </SPAN>0 | 1900-01-01
00:00:01 |<SPAN style="mso-spacerun: yes"> </SPAN>0
|<SPAN style="mso-spacerun: yes"> </SPAN>0 |</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">|<SPAN style="mso-spacerun: yes"> </SPAN>1 |<SPAN
style="mso-spacerun: yes"> </SPAN>2 |
mysql://root:secret@172.16.10.132/openser | <SPAN
style="mso-spacerun: yes"> </SPAN>1 |<SPAN
style="mso-spacerun: yes"> </SPAN>0 | 1900-01-01
00:00:01 |<SPAN style="mso-spacerun: yes"> </SPAN>0
|<SPAN style="mso-spacerun: yes"> </SPAN>0 |</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">+----+----+-------------------------------------------+--------+--------+---------------------+-------+----+</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT
face="Courier New"></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">When using the default usrloc functionality everything
is working fine. The only difference I noticed is that the default usrloc is
using MYSQL UPDATE to update the location entry and that p_usrloc is using MYSQL
REPLACE. </FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt"></FONT></FONT> </P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">Regards</FONT></FONT></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoPlainText><FONT face="Courier New"><FONT
style="FONT-SIZE: 11pt">Hans</FONT></FONT></P></DIV></DIV></BODY></HTML>