Discussion:
[SR-Users] KAMAILIO not updating Registration status to DB
Varghese Paul
2014-10-08 17:01:44 UTC
Permalink
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
Gonzalo Gasca
2014-10-09 06:46:57 UTC
Permalink
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-QsEt/***@public.gmane.org;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-QsEt/***@public.gmane.org;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:
***@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
Post by Varghese Paul
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
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Varghese Paul
2014-10-09 08:25:04 UTC
Permalink
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)


***@kamailio-registrar:/tmp# kamctl ul show varghesetest
Contact:: <sip:uf9bc7vo-***@public.gmane.org: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.

***@kamailio-registrar:/tmp# kamctl ul rm varghesetest

After the Register Packet it will update to DB


***@registrar-vhtkbz:~# kamctl ul show varghesetest
Contact::<sip:uf9bc7vo-***@public.gmane.org: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-***@public.gmane.org: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
Post by Gonzalo Gasca
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.
#kamctl ul show gogasca
;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 |
+----------+-------------------------------------------------------------------+-----------------------+---------------------+
;rtcweb-breaker=no;transport=wss
| tcp:172.31.27.85:5062 | 2014-10-09 06:32:56 |
+----------+-------------------------------------------------------------------+-----------------------+---------------------+
404 AOR not found
Can you send us the output of what are you getting?
-Gonzalo
Post by Varghese Paul
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
Post by Varghese Paul
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
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Loading...