<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Thank you Theo<br>
<br>
I tried it the below settings and it registers just fine but if you reload asterisk, sipwise will stop updating the mysql database<br>
<br>
i reinstalled sipwise 3.6.1 using the ISO image - and got the same result<br>
<br>
i just find it hard to imagine this is only happening to me<br>
<br>
Theo,<br>
what version are you running?<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF643038"><font color="#000000" face="Tahoma" size="2"><b>From:</b> Theo [axessofficetheo@gmail.com]<br>
<b>Sent:</b> Wednesday, November 19, 2014 3:16 AM<br>
<b>To:</b> Aziz Palmer<br>
<b>Subject:</b> Re: [Spce-user] sip registration stuck 3.5.16<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">Hi Aziz
<div><br>
</div>
<div>
<div>host=domain.blah.blah</div>
<div>username=whatever</div>
<div>secret=crazypass</div>
<div>type=peer</div>
<div>context=from-trunk</div>
<div>insecure=port,invite (not on all servers, works with and without)</div>
</div>
<div><br>
</div>
<div style="">registration string: user:pass@domain</div>
<div style=""><br>
</div>
<div style="">That's it. It it different from yours?</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Nov 19, 2014 at 1:41 AM, Aziz Palmer <span dir="ltr">
<<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.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="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">
<div>
<div style="font-family:Tahoma; font-size:13px">Theo,</div>
<div style="font-family:Tahoma; font-size:13px">can you send what you put in your sip trunk settings when you connect to sipwise? (this part seems pretty straight forward but would like to try someone else's settings.)</div>
<div style="font-family:Tahoma; font-size:13px"><br>
</div>
<div style="font-family:Tahoma; font-size:13px">Thank you</div>
</div>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr>
<div style="direction:ltr"><font color="#000000" face="Tahoma"><b>From:</b> Theo [<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>]<br>
<b>Sent:</b> Thursday, November 13, 2014 5:40 AM
<div>
<div class="h5"><br>
<b>To:</b> Aziz Palmer<br>
<b>Cc:</b> Andreas Granig; <a href="mailto:spce-user@lists.sipwise.com" target="_blank">
spce-user@lists.sipwise.com</a><br>
<b>Subject:</b> Re: [Spce-user] sip registration stuck 3.5.16<br>
</div>
</div>
</font><br>
</div>
<div>
<div class="h5">
<div></div>
<div>
<div dir="ltr">Hi
<div><br>
</div>
<div>The problem is on the asterisk side so they are the ones to fix it (assuming that is indeed your problem). The "fix" on the spce is merely a work around to not ban the user and accept the registration.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Nov 13, 2014 at 3:38 PM, Aziz Palmer <span dir="ltr">
<<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.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="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">
<div>
<div style="font-family:Tahoma; font-size:13px">
<div>Thank you Theo!</div>
<div><br>
</div>
<div>but what i don't understand if this is the case why wasn't fixed ?</div>
<div><br>
</div>
<div>what should i be doing instead when having users register to avoid this issue?</div>
<div><br>
</div>
<div>Is this happening to you also? if so what did you do to fix it? (follow the steps below?)</div>
<div><br>
</div>
<div>Thank you!</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr>
<div style="direction:ltr"><font color="#000000" face="Tahoma"><b>From:</b> Theo [<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>]<br>
<b>Sent:</b> Thursday, November 13, 2014 5:30 AM<br>
<b>To:</b> Aziz Palmer<br>
<b>Cc:</b> Andreas Granig; <a href="mailto:spce-user@lists.sipwise.com" target="_blank">
spce-user@lists.sipwise.com</a>
<div>
<div><br>
<b>Subject:</b> Re: [Spce-user] sip registration stuck 3.5.16<br>
</div>
</div>
</font><br>
</div>
<div>
<div>
<div></div>
<div>
<div dir="ltr">Sorry I accidentally replied just to you rather than to the list.:
<div><br>
</div>
<div>
<div style="font-family:arial,sans-serif; font-size:medium">
<div style="width:875px">
<div>
<div>
<div>
<div>
<div style="font-size:13px">
<div style="overflow:hidden">
<div dir="ltr">Hi
<div><br>
</div>
<div>This looks like the stale nonce issue which is an asterisk problem. The workaround has been posted a few times - search for stale nonce and I am sure you'll find it easily</div>
<div><br>
</div>
<div>Good luck</div>
</div>
<div>
<div><img></div>
</div>
</div>
</div>
<div></div>
</div>
<div></div>
</div>
<div style="font-size:13px">
<div>
<div></div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="font-family:arial,sans-serif; font-size:medium">
<div style="width:875px">
<div>
<div>
<div>
<div>
<div><br>
</div>
</div>
<div>
<div style="font-size:13px">
<table cellpadding="0">
<tbody>
<tr>
<td style="width:572px"><br>
</td>
<td>
<div>
<div style="outline:0px"><span><img alt=""></span></div>
</div>
</td>
<td></td>
<td rowspan="2">
<div><img alt=""></div>
<div><img alt=""></div>
</td>
</tr>
<tr>
<td colspan="3">
<table style="width:750px" cellpadding="0">
<tbody>
<tr>
<td>
<div><span>to <span dir="ltr" name="Aziz">Aziz</span></span></div>
<div><img alt=""></div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<div></div>
<div></div>
<div></div>
<div></div>
<div style="font-size:13px">
<div style="overflow:hidden">
<div dir="ltr">It would be this one:
<div><br>
</div>
<div><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></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Nov 13, 2014 at 3:00 PM, Aziz Palmer <span dir="ltr">
<<a href="mailto:Aziz.Palmer@airfiber.com" target="_blank">Aziz.Palmer@airfiber.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
kamailio.location<br>
what command do I need to execute to provide this information?<br>
<br>
<br>
kamailio-proxy.log<br>
<br>
Nov 13 06:49:36 tx-portal-2 proxy[22474]: NOTICE: <script>: Authentication failed, stale nonce - R=sip:sipwise.xyz..com ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:49:36 tx-portal-2 proxy[22473]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:sipwise.xyz..com F=sip:master.sample.edge@sipwise.xyz..com T=sip:master.sample.edge@sipwise.xyz..com IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a>
(<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>) ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:49:36 tx-portal-2 proxy[22473]: WARNING: app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database connection. Reconnecting<br>
Nov 13 06:49:36 tx-portal-2 proxy[22473]: NOTICE: <script>: Contacts successfully updated, expires in 120s - R=sip:sipwise.xyz..com ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:51:21 tx-portal-2 proxy[22480]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:sipwise.xyz..com F=sip:master.sample.edge@sipwise.xyz..com T=sip:master.sample.edge@sipwise.xyz..com IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a>
(<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>) ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:51:21 tx-portal-2 proxy[22480]: WARNING: app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database connection. Reconnecting<br>
Nov 13 06:51:21 tx-portal-2 proxy[22480]: NOTICE: <script>: Contacts successfully updated, expires in 120s - R=sip:sipwise.xyz..com ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:53:06 tx-portal-2 proxy[22475]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:sipwise.xyz..com F=sip:master.sample.edge@sipwise.xyz..com T=sip:master.sample.edge@sipwise.xyz..com IP=<a href="http://104.34.42.10:5060" target="_blank">104.34.42.10:5060</a>
(<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>) ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
Nov 13 06:53:06 tx-portal-2 proxy[22475]: WARNING: app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database connection. Reconnecting<br>
Nov 13 06:53:06 tx-portal-2 proxy[22475]: NOTICE: <script>: Contacts successfully updated, expires in 120s - R=sip:sipwise.xyz..com ID=<a href="mailto:7233034d51f47c1a7ca56eb2353030ae@104.34.42.10" target="_blank">7233034d51f47c1a7ca56eb2353030ae@104.34.42.10</a><br>
<br>
<br>
<br>
<br>
what does this mean "WARNING: app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database 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>] on behalf of Andreas Granig [<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a>]<br>
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>
Subject: Re: [Spce-user] sip registration stuck 3.5.16<br>
<div>
<div><br>
Hi,<br>
<br>
It's most likely not a bug of the system, rather than a problem with<br>
your clients registering on said system. I risk to say that because the<br>
registrar is based on Kamailio, which is serving dozens of millions of<br>
SIP devices out there, so it would be a huge surprise for it not to work<br>
correctly.<br>
<br>
The only way to find out what the REAL issue is for you to send an<br>
example entry in the kamailio.location table of the DB, along with a<br>
full network trace of this client trying to register on 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 RE-register a sip trunk it<br>
> will stop updating sipwise. in order to fix that you need to manually go<br>
> into the subscriber and delete the registration. it 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 - since it gives<br>
> the admins a lot of manual work/tech support calls) I would like to put<br>
> this this into partial production but can't - please help?<br>
><br>
> Thanks!<br>
> ------------------------------------------------------------------------<br>
> *From:* Raúl Alexis Betancor Santana [<a href="mailto:rabs@dimension-virtual.com" target="_blank">rabs@dimension-virtual.com</a>]<br>
> *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 change it ... or set<br>
> it on the web interface at domain-level or user-level if you prefer, and<br>
> as far as you don't touched the .cfg's ... they expire.<br>
><br>
> ------------------------------------------------------------------------<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>
> *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>
> *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>
> *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>
> *Subject:* Re: [Spce-user] sip registration stuck 3.5.16<br>
><br>
><br>
> Why did you whant to remove the old register? ... location entries<br>
> auto-expire, so you don't have to worry about them.<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>
> *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 issue - the<br>
> "registered devices" are not automatically being removed and when trying<br>
> to manually delete them, nothing happens.<br>
><br>
> Can i set a timer on how long these orphan registered devices stay part<br>
> of sipwise?<br>
><br>
> how can i delete these devices without having to issue the below command<br>
> - I would like to delete specific devices and not all 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>
> *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>
> 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>
> *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, registers fine with<br>
> sipwise. Then I make a change within the sip trunk settings of asterisk<br>
> and apply the new settings. Then previous sip registration gets stuck;<br>
> meaning within sipwise 2 registrations appear (old & new). When i try to<br>
> delete the old one, it stays stuck. The only way i discovered to be able<br>
> to remove the old registration is by issuing this 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 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>
> <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>
_______________________________________________<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>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</body>
</html>