From deykunov@gmail.com Tue Nov 20 15:41:03 2018
From: Andrey Deykunov <deykunov@gmail.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] registrar::save() does not save 'received' field of the
	'location' table
Date: Tue, 20 Nov 2018 09:27:19 -0500
Message-ID:
 <CAEsJsWAv6bGdS81JrdZiVuR3EthUE=b0HDUQquxmp9sNJppNNA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0694968672=="

--===============0694968672==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi,

We deploy kamailio in the cluster containing two nodes (Active and
Passive). When Active node becomes Passive, our websocket clients continue
sending REGISTER to this node. Passive node routes these requests to the
Active node through the UDP, that causes the following warning message:

2018-11-14T04:43:31.070005-08:00 qapbx-ca1-1 kamailio[25597]: WARNING:
<core> [core/forward.c:231]: get_send_socket2(): protocol/port
mismatch (forced udp:64.78.52.88:5060, to ws:10.9.3.116:20033)


Every registered client should be stored in the 'location':

$var(save_val) =3D save("location", 0, "sip:$au@$td");
if ($var(save_val) <=3D 0) {
xlog("L_ERR", "[$fU,R,$ci]: Registration saving failed, contact $ct");
sl_reply_error();
} else if ($var(save_val) =3D=3D 3) {
xlog("L_INFO", "[$fU,R,$ci]: Unregistration accepted. Login: $fU; ua: $ua;
s-ip: $si; s-port: $sp; 3d parm: sip:$au@$td");
} else {
xlog("L_INFO", "[$fU,R,$ci]: Registration accepted. Login: $fU; ua: $ua;
s-ip: $si; s-port: $sp; 3d parm: sip:$au@$td");
}

Log output of the Avtive node:

2018-11-14T04:43:31.063376-08:00 qapbx-ca1-2 kamailio[24722]: INFO:
<script>: [54004221,R,ibca3ujmr0q81nn0l5puen]: REGISTER received with
R-URI: sip:64.78.52.90, ct:
<sip:vu2o757j(a)si7ofk7i8cs7.invalid;transport=3Dws>;+sip.ice;
reg-id=3D1;+sip.instance=3D"<urn:uuid:00ff4c8d-2a5e-4614-b80a-d7c14c0e41e3>";=
expires=3D600,
cseq=3D1, s-ip: 64.78.52.88, s-port: 5060
2018-11-14T04:43:31.063947-08:00 qapbx-ca1-2 kamailio[24722]: INFO:
<script>: Our node is active
2018-11-14T04:43:31.064323-08:00 qapbx-ca1-2 kamailio[24722]: INFO:
<script>: [54004221,R,ibca3ujmr0q81nn0l5puen]: Authorization headers
are empty in REGISTER command. Send 401 Unauthorized to 64.78.52.88
2018-11-14T04:43:31.285967-08:00 qapbx-ca1-2 kamailio[24716]: INFO:
<script>: [54004221,R,ibca3ujmr0q81nn0l5puen]: REGISTER received with
R-URI: sip:64.78.52.90, ct:
<sip:vu2o757j(a)si7ofk7i8cs7.invalid;transport=3Dws>;+sip.ice;
reg-id=3D1;+sip.instance=3D"<urn:uuid:00ff4c8d-2a5e-4614-b80a-d7c14c0e41e3>";=
expires=3D600,
cseq=3D2, s-ip: 64.78.52.88, s-port: 5060
2018-11-14T04:43:31.286564-08:00 qapbx-ca1-2 kamailio[24716]: INFO:
<script>: Our node is active
2018-11-14T04:43:31.286943-08:00 qapbx-ca1-2 kamailio[24716]: INFO:
<script>: [54004221,R,ibca3ujmr0q81nn0l5puen]: Registration accepted.
Login: 54004221; ua: JsSIP 3.2.11; s-ip: 64.78.52.88; s-port: 5060; 3d
parm: sip:54004221(a)qapbx-ca1.qaserverdata.net


but in this scenario the save() method stores null value in the 'received'
row. How can I fix it?

Thank you,
Andrey



--===============0694968672==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0
ciI+SGksPGRpdj48YnI+PC9kaXY+PGRpdj5XZSBkZXBsb3kga2FtYWlsaW8gaW4gdGhlIGNsdXN0
ZXIgY29udGFpbmluZyB0d28gbm9kZXMgKEFjdGl2ZSBhbmQgUGFzc2l2ZSkuIFdoZW4gQWN0aXZl
IG5vZGUgYmVjb21lcyBQYXNzaXZlLCBvdXIgd2Vic29ja2V0IGNsaWVudHMgY29udGludWUgc2Vu
ZGluZyBSRUdJU1RFUiB0byB0aGlzIG5vZGUuIFBhc3NpdmUgbm9kZSByb3V0ZXMgdGhlc2UgcmVx
dWVzdHMgdG8gdGhlIEFjdGl2ZSBub2RlIHRocm91Z2ggdGhlIFVEUCwgdGhhdCBjYXVzZXMgdGhl
IGZvbGxvd2luZyB3YXJuaW5nIG1lc3NhZ2U6PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48cHJl
IHN0eWxlPSJtYXJnaW4tdG9wOjBweDttYXJnaW4tYm90dG9tOjBweDtwYWRkaW5nOjBweDttYXgt
aGVpZ2h0OjMwZW07b3ZlcmZsb3c6YXV0bzt3b3JkLXdyYXA6bm9ybWFsO3dvcmQtYnJlYWs6bm9y
bWFsO2NvbG9yOnJnYigyMyw0Myw3Nyk7Zm9udC1zaXplOjEycHg7YmFja2dyb3VuZC1jb2xvcjpy
Z2IoMjQ0LDI0NSwyNDcpIj4yMDE4LTExLTE0VDA0OjQzOjMxLjA3MDAwNS0wODowMCBxYXBieC1j
YTEtMSBrYW1haWxpb1syNTU5N106IFdBUk5JTkc6ICZsdDtjb3JlJmd0OyBbY29yZS9mb3J3YXJk
LmM6MjMxXTogZ2V0X3NlbmRfc29ja2V0MigpOiBwcm90b2NvbC9wb3J0IG1pc21hdGNoIChmb3Jj
ZWQgdWRwOjxhIGhyZWY9Imh0dHA6Ly82NC43OC41Mi44ODo1MDYwIj42NC43OC41Mi44ODo1MDYw
PC9hPiwgdG8gd3M6PGEgaHJlZj0iaHR0cDovLzEwLjkuMy4xMTY6MjAwMzMiPjEwLjkuMy4xMTY6
MjAwMzM8L2E+KTwvcHJlPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+RXZlcnkgcmVnaXN0ZXJl
ZCBjbGllbnQgc2hvdWxkIGJlIHN0b3JlZCBpbiB0aGUgJiMzOTtsb2NhdGlvbiYjMzk7OsKgPGJy
PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdiBzdHlsZT0iY29sb3I6cmdiKDIxMiwyMTIs
MjEyKTtiYWNrZ3JvdW5kLWNvbG9yOnJnYigzMCwzMCwzMCk7Zm9udC1mYW1pbHk6JnF1b3Q7RHJv
aWQgU2FucyBNb25vJnF1b3Q7LG1vbm9zcGFjZSxtb25vc3BhY2UsJnF1b3Q7RHJvaWQgU2FucyBG
YWxsYmFjayZxdW90Oztmb250LXNpemU6MTRweDtsaW5lLWhlaWdodDoxOXB4O3doaXRlLXNwYWNl
OnByZSI+PGRpdj4gICAgICAgICAgICAgICAgJHZhcihzYXZlX3ZhbCkgPSBzYXZlKDxzcGFuIHN0
eWxlPSJjb2xvcjpyZ2IoMjA2LDE0NSwxMjApIj4mcXVvdDtsb2NhdGlvbiZxdW90Ozwvc3Bhbj4s
IDAsIDxzcGFuIHN0eWxlPSJjb2xvcjpyZ2IoMjA2LDE0NSwxMjApIj4mcXVvdDtzaXA6JGF1QCR0
ZCZxdW90Ozwvc3Bhbj4pPHNwYW4gc3R5bGU9ImNvbG9yOnJnYigxMDYsMTUzLDg1KSI+Ozwvc3Bh
bj48L2Rpdj48ZGl2PiAgICAgICAgICAgICAgICBpZiAoJHZhcihzYXZlX3ZhbCkgJmx0Oz0gMCkg
ezwvZGl2PjxkaXY+ICAgICAgICAgICAgICAgICAgICAgICAgeGxvZyg8c3BhbiBzdHlsZT0iY29s
b3I6cmdiKDIwNiwxNDUsMTIwKSI+JnF1b3Q7TF9FUlImcXVvdDs8L3NwYW4+LCA8c3BhbiBzdHls
ZT0iY29sb3I6cmdiKDIwNiwxNDUsMTIwKSI+JnF1b3Q7WyRmVSxSLCRjaV06IFJlZ2lzdHJhdGlv
biBzYXZpbmcgZmFpbGVkLCBjb250YWN0ICRjdCZxdW90Ozwvc3Bhbj4pPHNwYW4gc3R5bGU9ImNv
bG9yOnJnYigxMDYsMTUzLDg1KSI+Ozwvc3Bhbj48L2Rpdj48ZGl2PiAgICAgICAgICAgICAgICAg
ICAgICAgIHNsX3JlcGx5X2Vycm9yKCk8c3BhbiBzdHlsZT0iY29sb3I6cmdiKDEwNiwxNTMsODUp
Ij47PC9zcGFuPjwvZGl2PjxkaXY+ICAgICAgICAgICAgICAgIH0gZWxzZSBpZiAoJHZhcihzYXZl
X3ZhbCkgPT0gMykgezwvZGl2PjxkaXY+ICAgICAgICAgICAgICAgICAgICAgICAgeGxvZyg8c3Bh
biBzdHlsZT0iY29sb3I6cmdiKDIwNiwxNDUsMTIwKSI+JnF1b3Q7TF9JTkZPJnF1b3Q7PC9zcGFu
PiwgPHNwYW4gc3R5bGU9ImNvbG9yOnJnYigyMDYsMTQ1LDEyMCkiPiZxdW90O1skZlUsUiwkY2ld
OiBVbnJlZ2lzdHJhdGlvbiBhY2NlcHRlZC4gTG9naW46ICRmVTsgdWE6ICR1YTsgcy1pcDogJHNp
OyBzLXBvcnQ6ICRzcDsgM2QgcGFybTogc2lwOiRhdUAkdGQmcXVvdDs8L3NwYW4+KTxzcGFuIHN0
eWxlPSJjb2xvcjpyZ2IoMTA2LDE1Myw4NSkiPjs8L3NwYW4+PC9kaXY+PGRpdj4gICAgICAgICAg
ICAgICAgfSBlbHNlIHs8L2Rpdj48ZGl2PiAgICAgICAgICAgICAgICAgICAgICAgIHhsb2coPHNw
YW4gc3R5bGU9ImNvbG9yOnJnYigyMDYsMTQ1LDEyMCkiPiZxdW90O0xfSU5GTyZxdW90Ozwvc3Bh
bj4sIDxzcGFuIHN0eWxlPSJjb2xvcjpyZ2IoMjA2LDE0NSwxMjApIj4mcXVvdDtbJGZVLFIsJGNp
XTogUmVnaXN0cmF0aW9uIGFjY2VwdGVkLiBMb2dpbjogJGZVOyB1YTogJHVhOyBzLWlwOiAkc2k7
IHMtcG9ydDogJHNwOyAzZCBwYXJtOiBzaXA6JGF1QCR0ZCZxdW90Ozwvc3Bhbj4pPHNwYW4gc3R5
bGU9ImNvbG9yOnJnYigxMDYsMTUzLDg1KSI+Ozwvc3Bhbj48L2Rpdj48ZGl2PiAgICAgICAgICAg
ICAgICB9PC9kaXY+PC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5Mb2cgb3V0cHV0IG9m
IHRoZSBBdnRpdmUgbm9kZTo8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PjxwcmUgc3R5bGU9Im1h
cmdpbi10b3A6MHB4O21hcmdpbi1ib3R0b206MHB4O3BhZGRpbmc6MHB4O21heC1oZWlnaHQ6MzBl
bTtvdmVyZmxvdzphdXRvO3dvcmQtd3JhcDpub3JtYWw7d29yZC1icmVhazpub3JtYWw7Y29sb3I6
cmdiKDIzLDQzLDc3KTtmb250LXNpemU6MTJweDtiYWNrZ3JvdW5kLWNvbG9yOnJnYigyNDQsMjQ1
LDI0NykiPjIwMTgtMTEtMTRUMDQ6NDM6MzEuMDYzMzc2LTA4OjAwIHFhcGJ4LWNhMS0yIGthbWFp
bGlvWzI0NzIyXTogSU5GTzogJmx0O3NjcmlwdCZndDs6IFs1NDAwNDIyMSxSLGliY2EzdWptcjBx
ODFubjBsNXB1ZW5dOiBSRUdJU1RFUiByZWNlaXZlZCB3aXRoIFItVVJJOiBzaXA6NjQuNzguNTIu
OTAsIGN0OiAmbHQ7c2lwOnZ1Mm83NTdqQHNpN29mazdpOGNzNy5pbnZhbGlkO3RyYW5zcG9ydD13
cyZndDs7K3NpcC5pY2U7CnJlZy1pZD0xOytzaXAuaW5zdGFuY2U9JnF1b3Q7Jmx0O3Vybjp1dWlk
OjAwZmY0YzhkLTJhNWUtNDYxNC1iODBhLWQ3YzE0YzBlNDFlMyZndDsmcXVvdDs7ZXhwaXJlcz02
MDAsIGNzZXE9MSwgcy1pcDogNjQuNzguNTIuODgsIHMtcG9ydDogNTA2MAoyMDE4LTExLTE0VDA0
OjQzOjMxLjA2Mzk0Ny0wODowMCBxYXBieC1jYTEtMiBrYW1haWxpb1syNDcyMl06IElORk86ICZs
dDtzY3JpcHQmZ3Q7OiBPdXIgbm9kZSBpcyBhY3RpdmUKMjAxOC0xMS0xNFQwNDo0MzozMS4wNjQz
MjMtMDg6MDAgcWFwYngtY2ExLTIga2FtYWlsaW9bMjQ3MjJdOiBJTkZPOiAmbHQ7c2NyaXB0Jmd0
OzogWzU0MDA0MjIxLFIsaWJjYTN1am1yMHE4MW5uMGw1cHVlbl06IEF1dGhvcml6YXRpb24gaGVh
ZGVycyBhcmUgZW1wdHkgaW4gUkVHSVNURVIgY29tbWFuZC4gU2VuZCA0MDEgVW5hdXRob3JpemVk
IHRvIDY0Ljc4LjUyLjg4CjIwMTgtMTEtMTRUMDQ6NDM6MzEuMjg1OTY3LTA4OjAwIHFhcGJ4LWNh
MS0yIGthbWFpbGlvWzI0NzE2XTogSU5GTzogJmx0O3NjcmlwdCZndDs6IFs1NDAwNDIyMSxSLGli
Y2EzdWptcjBxODFubjBsNXB1ZW5dOiBSRUdJU1RFUiByZWNlaXZlZCB3aXRoIFItVVJJOiBzaXA6
NjQuNzguNTIuOTAsIGN0OiAmbHQ7c2lwOnZ1Mm83NTdqQHNpN29mazdpOGNzNy5pbnZhbGlkO3Ry
YW5zcG9ydD13cyZndDs7K3NpcC5pY2U7CnJlZy1pZD0xOytzaXAuaW5zdGFuY2U9JnF1b3Q7Jmx0
O3Vybjp1dWlkOjAwZmY0YzhkLTJhNWUtNDYxNC1iODBhLWQ3YzE0YzBlNDFlMyZndDsmcXVvdDs7
ZXhwaXJlcz02MDAsIGNzZXE9Miwgcy1pcDogNjQuNzguNTIuODgsIHMtcG9ydDogNTA2MAoyMDE4
LTExLTE0VDA0OjQzOjMxLjI4NjU2NC0wODowMCBxYXBieC1jYTEtMiBrYW1haWxpb1syNDcxNl06
IElORk86ICZsdDtzY3JpcHQmZ3Q7OiBPdXIgbm9kZSBpcyBhY3RpdmUKMjAxOC0xMS0xNFQwNDo0
MzozMS4yODY5NDMtMDg6MDAgcWFwYngtY2ExLTIga2FtYWlsaW9bMjQ3MTZdOiBJTkZPOiAmbHQ7
c2NyaXB0Jmd0OzogWzU0MDA0MjIxLFIsaWJjYTN1am1yMHE4MW5uMGw1cHVlbl06IFJlZ2lzdHJh
dGlvbiBhY2NlcHRlZC4gTG9naW46IDU0MDA0MjIxOyB1YTogSnNTSVAgMy4yLjExOyBzLWlwOiA2
NC43OC41Mi44ODsgcy1wb3J0OiA1MDYwOyAzZCBwYXJtOiBzaXA6NTQwMDQKPGEgaHJlZj0ibWFp
bHRvOjIyMUBxYXBieC1jYTEucWFzZXJ2ZXJkYXRhLm5ldCI+MjIxQHFhcGJ4LWNhMS5xYXNlcnZl
cmRhdGEubmV0PC9hPjwvcHJlPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+YnV0IGluIHRoaXMg
c2NlbmFyaW8gdGhlIHNhdmUoKSBtZXRob2Qgc3RvcmVzIG51bGwgdmFsdWUgaW4gdGhlICYjMzk7
cmVjZWl2ZWQmIzM5OyByb3cuIEhvdyBjYW4gSSBmaXggaXQ/wqA8L2Rpdj48ZGl2Pjxicj48L2Rp
dj48ZGl2PlRoYW5rIHlvdSw8L2Rpdj48ZGl2PkFuZHJleTwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk
aXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2
PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwv
ZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJy
PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+
PGJyPjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pgo=

--===============0694968672==--