<div dir="ltr"><div>Hi Gonzaio,<br><br>Thanks for the reply.<br><br>Yes the registrations are not updating to DB and info stays in cache. We are getting Register packets every two minutes (expires = 120) and we are using the default timer_interval value (60). What is the suggested timer_value value here ? <br><br>DB : Postgres <br><br><span style="color:rgb(0,0,255)">kamailio_settings=# select username,contact,socket,expires from location where username='varghesetest' ;<br> username | contact | socket | expires <br>----------+---------+--------+---------<br>(0 rows)<br></span><br><br><span style="color:rgb(0,0,255)">root@kamailio-registrar:/tmp# kamctl ul show varghesetest<br>Contact:: <sip:uf9bc7vo@123.201.209.17:49235;transport=ws>;q=;expires=47;flags=0x0;cflags=0x0;state=1;socket=<tls:<a href="http://10.171.145.73:5063">10.171.145.73:5063</a>>;methods=0x20F;received=<sip:123.201.209.17:49235;transport=WS>;user_agent=<WebSDK 0.3.1-devel-tag-v0.18.7>;<br></span><br>When we remove the registration in the cache then for the next Register packet it will update the registration status to DB. <br><br><span style="color:rgb(56,118,29)">root@kamailio-registrar:/tmp# kamctl ul rm varghesetest</span><br><br>After the Register Packet it will update to DB <br><br><br><span style="color:rgb(204,0,0)">root@registrar-vhtkbz:~# kamctl ul show varghesetest <br>Contact::<sip:uf9bc7vo@123.201.209.17:49235;transport=ws>;q=;expires=118;flags=0x0;cflags=0x0;state=1;socket=<tls:<a href="http://10.171.145.73:5063">10.171.145.73:5063</a>>;methods=0x20F;received=<sip:123.201.209.17:49235;transport=WS>;user_agent=<WebSDK 0.3.1-devel-tag-v0.18.7>;</span><br><br><span style="color:rgb(255,0,0)">kamailio_settings=# select username,contact,socket,expires from location where username='varghesetest' ;<br> username | contact | socket | expires <br>--------------------+------------------------------------------------+-------------------------+---------------------<br> varghesetest | sip:uf9bc7vo@123.201.209.17:49235;transport=ws | tls:<a href="http://10.171.145.73:5063">10.171.145.73:5063</a> | 2014-10-09 08:22:07<br>(1 row)<br></span><br>Let me know if you need any more details.<br><br></div>Regards<br><br>Varghese Paul <br><div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 9, 2014 at 12:16 PM, Gonzalo Gasca <span dir="ltr"><<a href="mailto:gascagonzalo@gmail.com" target="_blank">gascagonzalo@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Varghese,<br>
<br>
When you mentioned some of the endpoint registrations are not updated<br>
to Db, which Db type and command are you using to verify this?<br>
Do you mean new registrations are not updated into Db and info stays in cache?<br>
I see you are using mode 1, check if "timer_interval" param makes a difference.<br>
<br>
In one of my webrtc PoC I'm using a shared db in mode 3 to force Db<br>
only write and I use 0x04 flag: save("location", "0x04") to allow only<br>
1 record.<br>
since I haven't implemented SIP replication across my Kamailio cluster.<br>
<br>
This is what I get:<br>
a) I register using webrtc client:<br>
In both Servers I get:<br>
#kamctl ul show gogasca<br>
Contact:: <sips:gogasca@df7jal23ls0d.invalid;rtcweb-breaker=no;transport=wss>;q=;expires=202;flags=0x0;cflags=0x0;state=1;socket=<NUL>;methods=0xFFFFFFFF;user_agent=<Llamato<br>
client>;reg-id=0<br>
<br>
mysql> use kamailiodb;<br>
mysql>select username,contact,socket,expires from location;<br>
<br>
+----------+-------------------------------------------------------------------+-----------------------+---------------------+<br>
<br>
| username | contact<br>
| socket | expires |<br>
<br>
+----------+-------------------------------------------------------------------+-----------------------+---------------------+<br>
<br>
| gogasca | sips:gogasca@df7jal23ls0d.invalid;rtcweb-breaker=no;transport=wss<br>
| tcp:<a href="http://172.31.27.85:5062" target="_blank">172.31.27.85:5062</a> | 2014-10-09 06:32:56 |<br>
<br>
+----------+-------------------------------------------------------------------+-----------------------+---------------------+<br>
<br>
I unregister and in both servers I get:<br>
root@ip-172-31-38-153:/etc/kamailio# kamctl ul show gogasca<br>
404 AOR not found<br>
<br>
Can you send us the output of what are you getting?<br>
<br>
-Gonzalo<br>
<div><div class="h5"><br>
On Wed, Oct 8, 2014 at 10:01 AM, Varghese Paul <<a href="mailto:varghesepaul87@gmail.com">varghesepaul87@gmail.com</a>> wrote:<br>
> Hi all,<br>
><br>
> We are experiencing a strange problem in our Kamilio server. Some of the<br>
> webrtc endpoint registrations are not updated to the Database and there is<br>
> no issue with the registration. Once we flushed the registration for this<br>
> endpoint then it is updating to the DB for the new Register Packet.<br>
><br>
> Flushed the Registration for the endpont : kamctl ul rm <USERNAME><br>
><br>
> Kamalio Version: 4.1.2<br>
><br>
> modparam("usrloc", "db_url", DBURL)<br>
> modparam("usrloc", "db_mode", 1)<br>
> modparam("usrloc", "nat_bflag", 3)<br>
> modparam("usrloc", "use_domain", 1)<br>
><br>
> Is there any other settings to avoid this issue ?<br>
><br>
> Regards<br>
><br>
> Varghese Paul<br>
><br>
><br>
</div></div>> _______________________________________________<br>
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
> <a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
><br>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div><br></div></div></div>