<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">I solved this issue by <span style="color:rgb(0,0,0);font-family:sans-serif;font-size:12.571428298950195px;line-height:19.19999885559082px">setting the variable "sip-allow-multiple-registrations" to "false" in the user directory</span></div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:12.571428298950195px;line-height:19.19999885559082px"><br>
</span></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:12.571428298950195px;line-height:19.19999885559082px">I tried to do the same by setting </span><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><param name="multiple-registrations" value="false"/> in the sip_profile itself instead of the directory, but it doesn't work. I am still getting multiple records of the same user registration.</span></div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><br>
</span></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)">Does anyone know why </span><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><param name="multiple-registrations" value="true"/> doesn't work but </span><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><param name="</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:12.727272033691406px;line-height:19.19999885559082px">sip-allow-multiple-registrations</span><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)">" value="false"/> does?</span></div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><br>
</span></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)">I am using FreeSWITCH 1.2 if it makes a difference.</span></div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><br>
</span></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)">Thanks,</span></div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)"><br>
</span></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><span style="color:rgb(0,0,0);font-family:monospace,Courier;font-size:12.571428298950195px;line-height:1.3em;background-color:rgb(249,249,249)">Henry</span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 21, 2014 at 1:05 AM, Henry Huang <span dir="ltr"><<a href="mailto:red.rain.seven@gmail.com" target="_blank">red.rain.seven@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">I did not enable the multiple_registation parameter in sip profile, but I am seeing multiple registrations of the same user in the sip_registration table through odbc. </div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">Here is how it happened, the client (pjsip) is registering through TCP, without un-registering, the client failed and got restarted again. Hence another registration was fired to the server; however, it did not replace the previous record, but instead created an additional one. </div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">Now, can someone explain to me how that is possible? How can I make sure the new registration overwrite the previous one. The only thing different is that every time when the client register again, it's using a different TCP port. Can that be the cause of multiple record? If so, what should I do?</div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">Here is an example of the registered record from sip_registration table except the TCP port number is different every time. I have also masked the IP addresses and sip_user</div>
<div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><div class="gmail_default">
call_id: VV3Fz9nEPrGZaVHi-Na0xUMR43u5pe4E</div><div class="gmail_default"> sip_user: ****999</div><div class="gmail_default"> sip_host: <a href="http://sip.domain.com" target="_blank">sip.domain.com</a></div>
<div class="gmail_default">
presence_hosts: <a href="http://sip.domain.com" target="_blank">sip.domain.com</a>,10.10.10.10</div><div class="gmail_default"> contact: "user" <sip:****999@123.123.123.123:49311;transport=TCP;ob;fs_nat=yes;fs_path=sip%3A71117x0%40124.124.124.124%3A5060></div>
<div class="gmail_default"> status: Registered(AUTO-NAT-2.0)</div><div class="gmail_default"> rpid: unknown</div><div class="gmail_default"> expires: 1408559112</div><div class="gmail_default">
user_agent: unknown</div><div class="gmail_default"> server_user: ****999</div><div class="gmail_default"> server_host: 11.11.11.11</div><div class="gmail_default"> profile_name: device_kamailio</div><div class="gmail_default">
hostname: freeswitch01</div><div class="gmail_default"> network_ip: 124.124.124.124</div><div class="gmail_default"> network_port: 5060</div><div class="gmail_default"> sip_username: ****999</div><div class="gmail_default">
sip_realm: 124.124.124.124</div><div class="gmail_default"> mwi_user: ****999</div><div class="gmail_default"> mwi_host: <a href="http://sip.domain.com" target="_blank">sip.domain.com</a></div><div class="gmail_default">
orig_server_host: 12.12.12.12</div><div class="gmail_default"> orig_hostname: freeswitch01</div><div class="gmail_default"> sub_host: NULL</div></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">
<br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">
Thanks,</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)">
Henry</div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(51,51,51)"><br></div></div>
</blockquote></div><br></div>