[SR-Users] KAMAILIO not updating Registration status to DB

[Varghese Paul]

Hi Gonzaio,

Thanks for the reply.

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 ?

DB : Postgres

kamailio_settings=# select username,contact,socket,expires from location
where username='varghesetest' ;
 username | contact | socket | expires
----------+---------+--------+---------
(0 rows)


root at kamailio-registrar:/tmp# kamctl ul show varghesetest
Contact:: <sip:uf9bc7vo at 123.201.209.17:49235
;transport=ws>;q=;expires=47;flags=0x0;cflags=0x0;state=1;socket=<tls:
10.171.145.73:5063>;methods=0x20F;received=<sip:123.201.209.17:49235;transport=WS>;user_agent=<WebSDK
0.3.1-devel-tag-v0.18.7>;

When we remove the registration in the cache then for the next Register
packet it will update the registration status to DB.

root at kamailio-registrar:/tmp# kamctl ul rm varghesetest

After the Register Packet it will update to DB


root at registrar-vhtkbz:~# kamctl ul show varghesetest
Contact::<sip:uf9bc7vo at 123.201.209.17:49235
;transport=ws>;q=;expires=118;flags=0x0;cflags=0x0;state=1;socket=<tls:
10.171.145.73:5063>;methods=0x20F;received=<sip:123.201.209.17:49235;transport=WS>;user_agent=<WebSDK
0.3.1-devel-tag-v0.18.7>;

kamailio_settings=# select username,contact,socket,expires from location
where username='varghesetest' ;
      username      |                    contact
|         socket          |       expires
--------------------+------------------------------------------------+-------------------------+---------------------
    varghesetest    | sip:uf9bc7vo at 123.201.209.17:49235;transport=ws | tls:
10.171.145.73:5063 | 2014-10-09 08:22:07
(1 row)

Let me know if you need any more details.

Regards

Varghese Paul

On Thu, Oct 9, 2014 at 12:16 PM, Gonzalo Gasca <gascagonzalo at gmail.com>
wrote:

> Hi Varghese,
>
> When you mentioned some of the endpoint registrations are not updated
> to Db, which Db type and command are you using to verify this?
> Do you mean new registrations are not updated into Db and info stays in
> cache?
> I see you are using mode 1, check if  "timer_interval" param makes a
> difference.
>
> In one of my webrtc PoC I'm using a shared db in mode 3 to force Db
> only write and I use 0x04 flag: save("location", "0x04") to allow only
> 1 record.
> since I haven't implemented SIP replication across my Kamailio cluster.
>
> This is what I get:
> a) I register using webrtc client:
> In both Servers I get:
> #kamctl ul show gogasca
> Contact:: <sips:gogasca at df7jal23ls0d.invalid
> ;rtcweb-breaker=no;transport=wss>;q=;expires=202;flags=0x0;cflags=0x0;state=1;socket=<NUL>;methods=0xFFFFFFFF;user_agent=<Llamato
> client>;reg-id=0
>
> mysql> use kamailiodb;
> mysql>select username,contact,socket,expires from location;
>
>
> +----------+-------------------------------------------------------------------+-----------------------+---------------------+
>
> | username | contact
>         | socket                | expires             |
>
>
> +----------+-------------------------------------------------------------------+-----------------------+---------------------+
>
> | gogasca  | sips:gogasca at df7jal23ls0d.invalid
> ;rtcweb-breaker=no;transport=wss
> | tcp:172.31.27.85:5062 | 2014-10-09 06:32:56 |
>
>
> +----------+-------------------------------------------------------------------+-----------------------+---------------------+
>
> I unregister and in both servers I get:
> root at ip-172-31-38-153:/etc/kamailio# kamctl ul show gogasca
> 404 AOR not found
>
> Can you send us the output of what are you getting?
>
> -Gonzalo
>
> On Wed, Oct 8, 2014 at 10:01 AM, Varghese Paul <varghesepaul87 at gmail.com>
> wrote:
> > Hi all,
> >
> > We are experiencing a strange problem in our Kamilio server. Some of the
> > webrtc endpoint registrations are not updated to the Database and there
> is
> > no issue with the registration. Once we flushed the registration for this
> > endpoint then it is updating to the DB for the new Register Packet.
> >
> > Flushed the Registration for the endpont : kamctl ul rm <USERNAME>
> >
> > Kamalio Version: 4.1.2
> >
> > modparam("usrloc", "db_url", DBURL)
> > modparam("usrloc", "db_mode", 1)
> > modparam("usrloc", "nat_bflag", 3)
> > modparam("usrloc", "use_domain", 1)
> >
> > Is there any other settings to avoid this issue ?
> >
> > Regards
> >
> > Varghese Paul
> >
> >
> > _______________________________________________
> > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> > sr-users at lists.sip-router.org
> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> >
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141009/70d4b4fc/attachment.html>