<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><br><div>If you know a user that have the issue ... just check for it on the log statement of mysql, you will see the update statement, and could replicate it directly ... to check what it does.</div><div><br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>De: </b>"Theo" <axessofficetheo@gmail.com><br><b>Para: </b>"Raúl Alexis Betancor Santana" <rabs@dimension-virtual.com><br><b>CC: </b>spce-user@lists.sipwise.com<br><b>Enviados: </b>Viernes, 21 de Noviembre 2014 17:04:25<br><b>Asunto: </b>Re: [Spce-user] sip registration stuck 3.5.16<br><div><br></div><div dir="ltr">Hi<div><br></div><div>I agree that it doesn't hurt and has no adverse effects, but now that we are onto this I would love to get it sorted. While we haven't use the customer portal extensively at all, I can see the scenario of receiving a call in the middle of the night "we have 15 users connected but I only have one phone"</div><div><br></div><div>I have enabled the logging in mysql but am not sure what to look for now. I see things being updated, and I see some being deleted. But because this is quite intermittent and only some seem to get stuck I am not sure how to replicate this. It mostly works fine and then every now and then one gets stuck and just remains there.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 21, 2014 at 5:43 PM, Raúl Alexis Betancor Santana <span dir="ltr"><<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:times new roman,new york,times,serif;font-size:12pt;color:#000000"><div>Expired registers (or even duplicated ones) ... as opposite as Aziz thinks ... doesn't hurt the system ... it's only a matter of wasting DB space and loading time of kamailio-proxy, no more.</div><div><br></div><hr><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt"><b>De: </b>"Theo" <<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>><br><b>Para: </b>"Raúl Alexis Betancor Santana" <<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>><br><b>CC: </b><a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br><b>Enviados: </b>Viernes, 21 de Noviembre 2014 15:51:10<div><div class="h5"><br><b>Asunto: </b>Re: [Spce-user] sip registration stuck 3.5.16<br><div><br></div><div dir="ltr">I am very happy to accept there is something wrong with install(s) - just haven't really had any other issues.... I will do as you say and see if I can get any further with this. No IP address was changed on the box - and as I said all appears to be running fine.<div><br></div><div>Aziz - I have a feeling your thread is being hi-jacked a little here?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 21, 2014 at 5:28 PM, Raúl Alexis Betancor Santana <span dir="ltr"><<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:times new roman,new york,times,serif;font-size:12pt;color:#000000"><div>I'm sure ... 100% sure ... that you have DB issues between kamailio-proxy and mysql, or directly mysql issues ... I suggest you to activate sql statement log on mysql, and wait 60s ... you should see the statement from the kamailio-proxy thread that will erase the expired registrations, and then you will be able to trace the problem.</div><div><br></div><hr><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt"><span><b>De: </b>"Theo" <<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>><br><b>Para: </b>"Andreas Granig" <<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a>><br></span><b>CC: </b><a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br><b>Enviados: </b>Viernes, 21 de Noviembre 2014 15:23:06<br><b>Asunto: </b>Re: [Spce-user] sip registration stuck 3.5.16<div><div><br><div><br></div><div dir="ltr">here is a nice example - you will see those are long expired:<div><br></div><div><ul style="margin:0px 1.5em 1.5em 0px;padding:0px 0px 0px 1.5em;border:0px;font-size:12.222222328186px;font-family:'Helvetica Neue',Arial,Helvetica,sans-serif;vertical-align:baseline;list-style:none;line-height:20.0019989013672px"><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">A510IP/42.075.00.000.000</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px"><a href="http://sip:tamasha1@192.168.10.205:5060" target="_blank">sip:tamasha1@192.168.10.205:5060</a></div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-11-21 17:40:45</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=193647" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2048;line=0g558d01</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-06-05 15:15:59</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=108246" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2048;line=o7qm8al6</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-07-28 17:22:25</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=131144" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2048;line=sjs2oc9h</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-11-21 18:24:43</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=193646" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2056;line=zx2nckqz</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-10-10 14:01:27</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=164424" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2068;line=zaul2pu8</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-09-23 09:28:59</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=153669" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2075;line=q7mer4r4</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-11-19 11:04:58</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=171698" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2094;line=y734quc2</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-10-02 14:41:07</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=161033" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/8.4.35</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.224:2106;line=bb7gge3q</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-09-10 09:18:30</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=146210" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/<a href="http://8.7.3.19" target="_blank">8.7.3.19</a></div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.230:2048;line=degxi5oh</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-11-21 17:38:40</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:30px;min-height:20px"><a href="https://196.41.123.113:1443/subscriber/expire?subscriber_id=302&contact_id=193658" style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;color:rgb(69,158,0);text-decoration:none" target="_blank"><span title="Expire Now"><span></span><span style="margin:0px;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:13.3333339691162px;font-family:inherit;vertical-align:baseline;display:block;line-height:1.4;min-height:20px">Expire Now</span></span></a></div></li><li><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">User Agent:</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">snom300/<a href="http://8.7.3.19" target="_blank">8.7.3.19</a></div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Contact</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">sip:tamasha1@192.168.10.230:2048;line=nuporyrn</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">NAT</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:430px;min-height:20px">yes</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:190px;min-height:20px">Expires</div><div style="margin:3px auto;padding:0px;border:0px;font-weight:inherit;font-style:inherit;font-size:12.222222328186px;font-family:inherit;vertical-align:baseline;float:left;width:270px;min-height:20px">2014-10-16 10:48:20</div></li></ul></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 21, 2014 at 5:10 PM, Andreas Granig <span dir="ltr"><<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Just to add my 2 cents:<br>
<br>
The proxy (kamailio) uses in-memory caching for registrations and writes<br>
them back to DB. The panel displays the registrations from the DB.<br>
<br>
Now if you delete something from the DB, it's not reflected in the<br>
proxy, because it still will be in the cache. So what we're doing is to<br>
delete a registration from the cache (by telling the proxy to purge it),<br>
and the proxy will propagate it down to the DB.<br>
<br>
The same happens if the proxy detects that a registration has expired.<br>
It will delete it from the cache and propagate the deletion down to the DB.<br>
<br>
Now here is where it's getting interesting: if the registration is no<br>
longer in the cache (for whatever reason) and it still is in the DB (for<br>
whatever else reason), you see it in the panel and can click on the<br>
delete button, but as the deletion request is sent to the proxy, it will<br>
just do nothing because it doesn't have it in the cache, so it will<br>
still persist in the DB.<br>
<br>
This scenario should never happen (famous last words), so to<br>
troubleshoot it, you'd need to dump the registrations from the cache<br>
using "ngcp-sercmd proxy ul.dump" and check the count (see<br>
"Stats"->"Records") and compare it to the db by doing "mysql kamailio -e<br>
"select id, username, domain, expires from location".<br>
<br>
Take into account that the cache count can/will potentially be lower<br>
than the db count because the proxy batches deletion in a separate<br>
process, which is executed every 60 sec. So to fetch the "real" expired<br>
registrations, do this: "mysql kamailio -e "select id, username, domain,<br>
expires from location where expires < date_sub(now(), interval 90 second)"<br>
<br>
So this will give you a representation of your current state. Note that<br>
if a registration is not in the cache but only in the DB, it's not a<br>
real operational issue, because the proxy will not know about it.<br>
<br>
It still doesn't answer the question how this can even happen, so you<br>
need to provide a full trace ("tcpdump -i any -s 0 -w /tmp/reg.pcap port<br>
5060") of a complete cycle (fresh registration and subsequent<br>
registrations, which will then cause the issue you described), along<br>
with the full kamailio-proxy.log, so we can check for errors etc. Also<br>
provide the output of "ngcp-sercmd proxy ul.dump" and "mysql kamailio -e<br>
"select id, username, domain, expires from location" along with the<br>
timestamps when you executed those commands.<br>
<br>
Andreas<br>
<span><br>
On 11/21/2014 03:41 PM, Raúl Alexis Betancor Santana wrote:<br>
><br>
> Helo Aziz ... let's talk about ...<br>
><br>
> 1- Doesn't matter ... if you have more than one register for the same<br>
> user, the only thing that happens it's that on an outbound request to<br>
> that subscriber, SPCE will launch 2 branches ... one will fail and the<br>
> other one will sucess. No big deal at all.<br>
> 2- That should not happens ... as expired registration should be<br>
> auto-erased. Have you installed the system from 0 ? .. or did you<br>
> upgrade from older version?<br>
> 3- That sounds as an upgrades SPCE version that didn't complete the upgrade.<br>
><br>
><br>
</span><span>> ------------------------------------------------------------------------<br>
> *De: *"Aziz Palmer" <Aziz.Palmer@AirFIBER.com><br>
> *Para: *"Raúl Alexis Betancor Santana" <<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>>,<br>
> <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
</span>> *Enviados: *Viernes, 21 de Noviembre 2014 14:31:25<br>
<span>> *Asunto: *RE: sip registration stuck 3.5.16<br>
><br>
</span><span>> Thank you Raul for your input and suggestions. Not to get into a long<br>
> discussion but I at first didn't think it was a big deal until the<br>
> following accours<br>
> 1. the network environment at subscriber changes (change of IP) -<br>
> asterisk registers and now you have 2 active registrations in the db.<br>
> 2. Customers logging into the user portal and see the expired time stamp<br>
> 3. Deleting the registration in the UI will not completely delete it in<br>
> the db but add a second and third and so on registration.<br>
><br>
> all my test was with public IPs i've even tested it while both asterisk<br>
> and sipwise was connected to the same switch both in a virtual and hard<br>
> environment<br>
><br>
> Thank you again Raul but before placing into production it's absolutely<br>
> imperative that the basic functionality work properly - register and<br>
> register.<br>
><br>
> Warmest Regards,<br>
> Aziz<br>
><br>
><br>
</span><span>> ------------------------------------------------------------------------<br>
> *From:* Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>] on behalf of<br>
> Raúl Alexis Betancor Santana [<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>]<br>
</span>> *Sent:* Friday, November 21, 2014 6:06 AM<br>
<span>> *To:* <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
> *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
</span><span>> Just to add ... that we are using SPCE since it's first versions ... and<br>
> don't have that issue. With lot of asterisk customers with versions from<br>
> Asterisk 1.2 to Asterisk 12 .<br>
><br>
> As it seems that the register doesn't get auto-expired (I don't<br>
> undestand why it hurts you that they are on the location table ... but<br>
> that another thing), if you are experiencing 'registration lost' with<br>
> Asterisk and SPCE ... 99.9% of the times it a fault on Asterisk or in a<br>
> middle router that 'modify' the SIP request.<br>
><br>
> Best and faster thing you could do to track the issue ... it to capture<br>
> the traffic JUST on the Asterisk ... and on the SPCE and compare them,<br>
> if you see any difference ... then you probably have a sip-alg-activated<br>
> device on the middle of the path.<br>
><br>
> If you don't have access to the Asterisk boxes ... just install one<br>
> yourself for testing, it's easy and fast. ... Faster than trying that<br>
> someneone give you the solution on a comunity list<br>
><br>
</span>> ------------------------------------------------------------------------<br>
> *De: *"Daniel Grotti" <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>><br>
> *Para: *"Aziz Palmer" <Aziz.Palmer@AirFIBER.com>, "Theo"<br>
> <<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>><br>
> *CC: *<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
> *Enviados: *Viernes, 21 de Noviembre 2014 14:08:31<br>
> *Asunto: *Re: [Spce-user] sip registration stuck 3.5.16<br>
<span>><br>
> Hi,<br>
> why are you so sure ?<br>
> Kamailio version is the same, so if there is an issue it's also in PRO.<br>
> I opened the internal ticket # 0010303.<br>
><br>
> We will update you soon.<br>
><br>
> Daniel<br>
><br>
><br>
><br>
> On 11/21/2014 02:54 PM, Aziz Palmer wrote:<br>
><br>
> Thank you Daniel!<br>
><br>
> quick question - i'm sure the customers that are using the pro<br>
> version aren't having this issue. Why is it happening on the CE<br>
> version? (I've spent so much time on it and i'm trying to more<br>
> understand it)<br>
><br>
> Thank you,<br>
> Aziz<br>
</span>> ------------------------------------------------------------------------<br>
> *From:* Daniel Grotti [<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>]<br>
> *Sent:* Friday, November 21, 2014 1:17 AM<br>
> *To:* Aziz Palmer; Theo<br>
> *Cc:* <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
<span>> *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
</span><span>> Aziz,<br>
> I was able to have a look at the issue, and I opened an internal<br>
> ticket about that.<br>
> We will have a look at this and let you know.<br>
><br>
> Daniel<br>
><br>
><br>
><br>
> On 11/19/2014 12:41 AM, Aziz Palmer wrote:<br>
><br>
> Theo,<br>
> can you send what you put in your sip trunk settings when you<br>
> connect to sipwise? (this part seems pretty straight forward but<br>
> would like to try someone else's settings.)<br>
><br>
> Thank you<br>
</span>> ------------------------------------------------------------------------<br>
> *From:* Theo [<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>]<br>
> *Sent:* Thursday, November 13, 2014 5:40 AM<br>
> *To:* Aziz Palmer<br>
> *Cc:* Andreas Granig; <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
<span>> *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
</span><span>> Hi<br>
><br>
> The problem is on the asterisk side so they are the ones to fix<br>
> it (assuming that is indeed your problem). The "fix" on the spce<br>
> is merely a work around to not ban the user and accept the<br>
> registration.<br>
><br>
> On Thu, Nov 13, 2014 at 3:38 PM, Aziz Palmer<br>
</span><span>> <<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.com</a> <mailto:<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.com</a>>> wrote:<br>
><br>
> Thank you Theo!<br>
><br>
> but what i don't understand if this is the case why wasn't<br>
> fixed ?<br>
><br>
> what should i be doing instead when having users register to<br>
> avoid this issue?<br>
><br>
> Is this happening to you also? if so what did you do to fix<br>
> it? (follow the steps below?)<br>
><br>
> Thank you!<br>
><br>
><br>
</span>> ------------------------------------------------------------------------<br>
> *From:* Theo [<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a><br>
> <mailto:<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>>]<br>
> *Sent:* Thursday, November 13, 2014 5:30 AM<br>
> *To:* Aziz Palmer<br>
> *Cc:* Andreas Granig; <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<span>><br>
> *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
</span><span>> Sorry I accidentally replied just to you rather than to the<br>
> list.:<br>
><br>
> Hi<br>
><br>
> This looks like the stale nonce issue which is an asterisk<br>
> problem. The workaround has been posted a few times - search<br>
> for stale nonce and I am sure you'll find it easily<br>
><br>
> Good luck<br>
><br>
><br>
><br>
><br>
><br>
><br>
</span>> to Aziz<br>
<span>><br>
> It would be this one:<br>
><br>
> <a href="http://lists.sipwise.com/pipermail/spce-user/2014-January/005712.html" target="_blank">http://lists.sipwise.com/pipermail/spce-user/2014-January/005712.html</a><br>
><br>
> On Thu, Nov 13, 2014 at 3:00 PM, Aziz Palmer<br>
</span>> <<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.com</a> <mailto:<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.com</a>>><br>
<span>> wrote:<br>
><br>
> kamailio.location<br>
> what command do I need to execute to provide this<br>
> information?<br>
><br>
><br>
> kamailio-proxy.log<br>
><br>
> Nov 13 06:49:36 tx-portal-2 proxy[22474]: NOTICE:<br>
> <script>: Authentication failed, stale nonce -<br>
> R=sip:sipwise.xyz..com<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
</span>> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:49:36 tx-portal-2 proxy[22473]: NOTICE:<br>
> <script>: New request on proxy - M=REGISTER<br>
> R=sip:sipwise.xyz..com<br>
> F=sip:master.sample.edge@sipwise.xyz..com<br>
> T=sip:master.sample.edge@sipwise.xyz..com<br>
</span>> IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a> <<a href="http://104.34.42.10:5060" target="_blank">http://104.34.42.10:5060</a>><br>
> (<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a> <<a href="http://127.0.0.1:5060" target="_blank">http://127.0.0.1:5060</a>>)<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:49:36 tx-portal-2 proxy[22473]: WARNING:<br>
> app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database<br>
> connection. Reconnecting<br>
> Nov 13 06:49:36 tx-portal-2 proxy[22473]: NOTICE:<br>
> <script>: Contacts successfully updated, expires in 120s<br>
> - R=sip:sipwise.xyz..com<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
</span>> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:51:21 tx-portal-2 proxy[22480]: NOTICE:<br>
> <script>: New request on proxy - M=REGISTER<br>
> R=sip:sipwise.xyz..com<br>
> F=sip:master.sample.edge@sipwise.xyz..com<br>
> T=sip:master.sample.edge@sipwise.xyz..com<br>
</span>> IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a> <<a href="http://104.34.42.10:5060" target="_blank">http://104.34.42.10:5060</a>><br>
> (<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a> <<a href="http://127.0.0.1:5060" target="_blank">http://127.0.0.1:5060</a>>)<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:51:21 tx-portal-2 proxy[22480]: WARNING:<br>
> app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database<br>
> connection. Reconnecting<br>
> Nov 13 06:51:21 tx-portal-2 proxy[22480]: NOTICE:<br>
> <script>: Contacts successfully updated, expires in 120s<br>
> - R=sip:sipwise.xyz..com<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
</span>> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:53:06 tx-portal-2 proxy[22475]: NOTICE:<br>
> <script>: New request on proxy - M=REGISTER<br>
> R=sip:sipwise.xyz..com<br>
> F=sip:master.sample.edge@sipwise.xyz..com<br>
> T=sip:master.sample.edge@sipwise.xyz..com<br>
</span>> IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a> <<a href="http://104.34.42.10:5060" target="_blank">http://104.34.42.10:5060</a>><br>
> (<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a> <<a href="http://127.0.0.1:5060" target="_blank">http://127.0.0.1:5060</a>>)<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>> Nov 13 06:53:06 tx-portal-2 proxy[22475]: WARNING:<br>
> app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database<br>
> connection. Reconnecting<br>
> Nov 13 06:53:06 tx-portal-2 proxy[22475]: NOTICE:<br>
> <script>: Contacts successfully updated, expires in 120s<br>
> - R=sip:sipwise.xyz..com<br>
> ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
</span>> <mailto:<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a>><br>
<span>><br>
><br>
><br>
><br>
> what does this mean "WARNING: app_lua<br>
> [app_lua_sr.c:100]: lua_sr_log(): lost database<br>
> connection. Reconnecting"?<br>
><br>
><br>
><br>
> ________________________________________<br>
> From: Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>>] on behalf<br>
> of Andreas Granig [<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a><br>
> <mailto:<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a>>]<br>
<span>> Sent: Thursday, November 13, 2014 1:26 AM<br>
> To: <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<div><div>> Subject: Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
> Hi,<br>
><br>
> It's most likely not a bug of the system, rather than a<br>
> problem with<br>
> your clients registering on said system. I risk to say<br>
> that because the<br>
> registrar is based on Kamailio, which is serving dozens<br>
> of millions of<br>
> SIP devices out there, so it would be a huge surprise<br>
> for it not to work<br>
> correctly.<br>
><br>
> The only way to find out what the REAL issue is for you<br>
> to send an<br>
> example entry in the kamailio.location table of the DB,<br>
> along with a<br>
> full network trace of this client trying to register on<br>
> the system, and<br>
> also the kamailio-proxy.log file.<br>
><br>
> Andreas<br>
><br>
> On 11/13/2014 06:47 AM, Aziz Palmer wrote:<br>
> > thats not the issue - the problem is when you<br>
> RE-register a sip trunk it<br>
> > will stop updating sipwise. in order to fix that you<br>
> need to manually go<br>
> > into the subscriber and delete the registration. it<br>
> will not delete but<br>
> > instead a new registration will appear.<br>
> ><br>
> ><br>
> > SPCE - are you aware of this bug (its a serous issue -<br>
> since it gives<br>
> > the admins a lot of manual work/tech support calls) I<br>
> would like to put<br>
> > this this into partial production but can't - please help?<br>
> ><br>
> > Thanks!<br>
> ><br>
> ------------------------------------------------------------------------<br>
> > *From:* Raúl Alexis Betancor Santana<br>
> [<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a><br>
</div></div>> <mailto:<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>>]<br>
<span>> > *Sent:* Wednesday, November 12, 2014 1:54 PM<br>
> > *To:* Aziz Palmer<br>
> > *Subject:* Re: sip registration stuck 3.5.16<br>
> ><br>
> > 3600 secs ... 1 h ... it's default time on the config.xml<br>
> > kamailio.proxy.default_expire option ... you could<br>
> change it ... or set<br>
> > it on the web interface at domain-level or user-level<br>
> if you prefer, and<br>
> > as far as you don't touched the .cfg's ... they expire.<br>
> ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> > *De: *"Aziz Palmer" <Aziz.Palmer@AirFIBER.com><br>
> > *Para: *"Raúl Alexis Betancor Santana"<br>
> <<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a><br>
</span>> <mailto:<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>>>,<br>
> > <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<span>> > *Enviados: *Miércoles, 12 de Noviembre 2014 21:17:53<br>
> > *Asunto: *RE: sip registration stuck 3.5.16<br>
> ><br>
> > they are not auto-expiring (I wish they were)<br>
> ><br>
> > if they are - taking a extremely long time<br>
> ><br>
> ------------------------------------------------------------------------<br>
> > *From:* Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>>] on behalf of<br>
<span>> > Raúl Alexis Betancor Santana<br>
> [<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a><br>
</span>> <mailto:<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>>]<br>
<span>> > *Sent:* Wednesday, November 12, 2014 1:04 PM<br>
> > *To:* <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<span>> > *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
> ><br>
> ><br>
> > Why did you whant to remove the old register? ...<br>
> location entries<br>
> > auto-expire, so you don't have to worry about them.<br>
> ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> > *De: *"Aziz Palmer" <Aziz.Palmer@AirFIBER.com><br>
> > *Para: *<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<span>> > *Enviados: *Miércoles, 12 de Noviembre 2014 20:47:13<br>
> > *Asunto: *[Spce-user] sip registration stuck 3.5.16<br>
> ><br>
> > I hate to ask again but this is turning into a real<br>
> issue - the<br>
> > "registered devices" are not automatically being<br>
> removed and when trying<br>
> > to manually delete them, nothing happens.<br>
> ><br>
> > Can i set a timer on how long these orphan registered<br>
> devices stay part<br>
> > of sipwise?<br>
> ><br>
> > how can i delete these devices without having to issue<br>
> the below command<br>
> > - I would like to delete specific devices and not all<br>
> of them<br>
> ><br>
> > mysql kamailio -e "delete from location"<br>
> > /etc/init.d/kamailio-proxy restart<br>
> ><br>
> ><br>
> > Thanks again,<br>
> > Aziz<br>
> ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> > *From:* Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>>] on behalf of<br>
<span>> > Aziz Palmer [Aziz.Palmer@AirFIBER.com]<br>
> > *Sent:* Tuesday, November 11, 2014 12:15 PM<br>
> > *To:* <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a>><br>
<div><div>> > *Subject:* [Spce-user] sip registration stuck 5.3.16<br>
> ><br>
> > Hello SPCE Team,<br>
> > here is what appears to be a bug<br>
> ><br>
> > I enter sip registration settings into asterisk,<br>
> registers fine with<br>
> > sipwise. Then I make a change within the sip trunk<br>
> settings of asterisk<br>
> > and apply the new settings. Then previous sip<br>
> registration gets stuck;<br>
> > meaning within sipwise 2 registrations appear (old &<br>
> new). When i try to<br>
> > delete the old one, it stays stuck. The only way i<br>
> discovered to be able<br>
> > to remove the old registration is by issuing this<br>
> command, then i can<br>
> > delete the registration.<br>
> ><br>
> > /etc/init.d/kamailio-proxy restart<br>
> ><br>
> > what additional information can i provide to have your<br>
> team troubleshoot<br>
> > this issue?<br>
> ><br>
> > Thank you,<br>
> > Anees<br>
> ><br>
> > _______________________________________________<br>
> > Spce-user mailing list<br>
> > <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
</div></div>> <mailto:<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>><br>
<span>> > <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Spce-user mailing list<br>
> > <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>><br>
<span>> > <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
> ><br>
> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>><br>
<span>> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
</span>> <mailto:<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>><br>
<div><div>> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Spce-user mailing list<br>
> <a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
><br>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
</div></div></blockquote></div><br></div>
<br>_______________________________________________<br>Spce-user mailing list<br><a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br><a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br></div></div></div><div><br></div></div></div><br>_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
<br></blockquote></div><br></div>
</div></div></div><div><br></div></div></div><br>_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
<br></blockquote></div><br></div>
</div><br></div></body></html>