[prev in list] [next in list] [prev in thread] [next in thread]
List: sr-users
Subject: Re: [SR-Users] Usrloc errors
From: Wingsravi R <wingsravi777 () gmail ! com>
Date: 2013-10-26 10:43:02
Message-ID: CAJRwe0EwU77==czfkBwb3eOxc2mrSm=31WxYfAf_uoQaODXueQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Dear Daniel,
Thank you for the reply
Please below find the attachment of ngrep output when i tried to register
Blink clients to the kamailio server.
Here are the contents of lacation table in database:
mysql> select * from location;
+----+-----------------------+----------+---------------+------------------=
--------------+----------+------+---------------------+-------+------------=
----------------------+------+---------------------+-------+--------+------=
-----------------+-----------------------+---------+-----------------------=
--------------------------+--------+
| id | ruid | username | domain |
contact | received | path | expires |
q | callid | cseq | last_modified |
flags | cflags | user_agent | socket | methods |
instance | reg_id |
+----+-----------------------+----------+---------------+------------------=
--------------+----------+------+---------------------+-------+------------=
----------------------+------+---------------------+-------+--------+------=
-----------------+-----------------------+---------+-----------------------=
--------------------------+--------+
| 72 | uloc-526b8d87-34e7-11 | 1111 | kamailio.test |
sip:29854013@192.168.2.96:5060 | NULL | NULL | 2013-10-26 15:41:27 |
-1.00 | ef1839714d7045948c98d3c050c75c39 | 2 | 2013-10-26 15:31:27 |
0 | 512 | Blink 0.5.0 (Windows) | udp:192.168.2.41:5060 | NULL |
<urn:uuid:d2256fbe-2df2-4180-9a48-547bfb76e6c5> | 0 |
| 73 | uloc-526b8d87-34e8-f | 1112 | kamailio.test |
sip:21748309@192.168.2.97:5060 | NULL | NULL | 2013-10-26 15:35:12 |
-1.00 | 91d3e8bc5da742de96c2dee9c697b964 | 1 | 2013-10-26 15:25:12 |
0 | 512 | Blink 0.5.0 (Windows) | udp:192.168.2.41:5060 | NULL |
<urn:uuid:1a7ff846-cde0-4a46-8ff6-785066ed12c9> | 0 |
+----+-----------------------+----------+---------------+------------------=
--------------+----------+------+---------------------+-------+------------=
----------------------+------+---------------------+-------+--------+------=
-----------------+-----------------------+---------+-----------------------=
--------------------------+--------+
2 rows in set (0.00 sec)
And also there are errors in syslog as in the attachment below.
Seems like something wrong with presence subscription.
Is it like without the presence visibility between the clients, file
transfer can not be possible ?
your help will meant a lot.
Regards
Ravi
On Fri, Oct 25, 2013 at 10:35 PM, Daniel-Constantin Mierla <
miconda@gmail.com> wrote:
> Hello,
>
> can you get the network traffic for those registers (e.g., ngrep, pcap)
> and provide as well the list of records inside location table in database=
?
>
> If it is something big, you can send it to me.
>
> Cheers,
> Daniel
>
>
> On 10/25/13 5:26 PM, Wingsravi R wrote:
>
> Hi kamailio'ns
>
> I am working on MSRP module of Kamailio serverV 4.0.3, which is installe=
d
> from Ubuntu 12.04(precise) repository.
>
> When i am trying to register SIP clients(Blink) to kamailio server,
> frequently logging following user location related errors in syslog,
> SIP clients are registering to kamailio sever successfully, but still
> logging these errors and client presence is not visible to other client.
>
> Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]: ERROR: db_mysql
> [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplica=
te
> entry 'uloc-526a7929-3bab-91' for key 'ruid_idx'
> Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]: ERROR: <core>
> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]: ERROR: usrloc
> [ucontact.c:625]: db_insert_ucontact(): inserting contact in db failed
> Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]: ERROR: usrloc
> [urecord.c:368]: wb_timer(): updating contact in db failed (aor:
> 1112@kamailio.test)
>
> Below attachment is my Kamailio config file (please suggest me if any
> changes to be made).
>
> Anybody please help me in resolving the issues
>
> PS: With the same script when i used to register the clients (jitsi) to
> kamailio i am logging presence related errors (which i posted too in the
> mailing list with the subject as : Presence issues)
>
> Regards,
> Ravi
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr=
-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/list=
info/sr-users
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/mic=
onda - http://www.linkedin.com/in/miconda
> Kamailio Advanced Trainings - Berlin, Nov 25-28; Miami, Nov 18-20, 2013
> - more details about Kamailio trainings at http://www.asipto.com -
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
[Attachment #5 (text/html)]
<div dir="ltr"><div>Dear Daniel,<br><br></div><div>Thank you for the \
reply<br><br></div><div>Please below find the attachment of ngrep output when i tried \
to register Blink clients to the kamailio server.<br><br></div>Here are the contents \
of lacation table in database:<br> <div><br>mysql> select * from \
location;<br>+----+-----------------------+----------+---------------+---------------- \
----------------+----------+------+---------------------+-------+--------------------- \
-------------+------+---------------------+-------+--------+-----------------------+-- \
---------------------+---------+-------------------------------------------------+--------+<br>
| id | ruid | username | domain | contact \
| received | path | expires | q | callid | \
cseq | last_modified | flags | cflags | user_agent | socket \
| methods | instance | reg_id |<br> \
+----+-----------------------+----------+---------------+----------------------------- \
---+----------+------+---------------------+-------+---------------------------------- \
+------+---------------------+-------+--------+-----------------------+--------------- \
--------+---------+-------------------------------------------------+--------+<br> | \
72 | uloc-526b8d87-34e7-11 | 1111 | kamailio.test | <a \
href="http://sip:29854013@192.168.2.96:5060">sip:29854013@192.168.2.96:5060</a> | \
NULL | NULL | 2013-10-26 15:41:27 | -1.00 | ef1839714d7045948c98d3c050c75c39 | \
2 | 2013-10-26 15:31:27 | 0 | 512 | Blink 0.5.0 (Windows) | udp:<a \
href="http://192.168.2.41:5060">192.168.2.41:5060</a> | NULL | \
<urn:uuid:d2256fbe-2df2-4180-9a48-547bfb76e6c5> | 0 |<br> | 73 | \
uloc-526b8d87-34e8-f | 1112 | kamailio.test | <a \
href="http://sip:21748309@192.168.2.97:5060">sip:21748309@192.168.2.97:5060</a> | \
NULL | NULL | 2013-10-26 15:35:12 | -1.00 | 91d3e8bc5da742de96c2dee9c697b964 | \
1 | 2013-10-26 15:25:12 | 0 | 512 | Blink 0.5.0 (Windows) | udp:<a \
href="http://192.168.2.41:5060">192.168.2.41:5060</a> | NULL | \
<urn:uuid:1a7ff846-cde0-4a46-8ff6-785066ed12c9> | 0 |<br> \
+----+-----------------------+----------+---------------+----------------------------- \
---+----------+------+---------------------+-------+---------------------------------- \
+------+---------------------+-------+--------+-----------------------+--------------- \
--------+---------+-------------------------------------------------+--------+<br> 2 \
rows in set (0.00 sec)<br><br></div><div>And also there are errors in syslog as in \
the attachment below.<br><br></div><div>Seems like something wrong with presence \
subscription.<br>Is it like without the presence visibility between the clients, file \
transfer can not be possible ?<br> </div><div><br></div><div>your help will meant a \
lot.<br><br></div><div>Regards<br></div><div>Ravi<br></div><div><br></div></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Oct 25, 2013 at 10:35 \
PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" \
target="_blank">miconda@gmail.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
can you get the network traffic for those registers (e.g., ngrep,
pcap) and provide as well the list of records inside location table
in database?<br>
<br>
If it is something big, you can send it to me.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 10/25/13 5:26 PM, Wingsravi R wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>Hi kamailio'ns<br>
<br>
</div>
I am working on MSRP module of Kamailio serverV
4.0.3, which is installed from Ubuntu 12.04(precise)
repository. <br>
</div>
<br>
When i am trying to register SIP clients(Blink) to
kamailio server, frequently logging following user
location related errors in syslog,<br>
SIP clients are registering to kamailio sever
successfully, but still logging these errors and
client presence is not visible to other client.<br>
<br>
Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]:
ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query:
Duplicate entry 'uloc-526a7929-3bab-91' for key
'ruid_idx'<br>
Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]:
ERROR: <core> [db_query.c:235]:
db_do_insert_cmd(): error while submitting query<br>
Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]:
ERROR: usrloc [ucontact.c:625]: db_insert_ucontact():
inserting contact in db failed<br>
Oct 25 20:09:05 kamailio /usr/sbin/kamailio[15277]:
ERROR: usrloc [urecord.c:368]: wb_timer(): updating
contact in db failed (aor: <a href="mailto:1112@kamailio.test" \
target="_blank">1112@kamailio.test</a>)<br> <br>
</div>
Below attachment is my Kamailio config file (please
suggest me if any changes to be made).<br>
<br>
</div>
Anybody please help me in resolving the issues<br>
<br>
</div>
PS: With the same script when i used to register the clients
(jitsi) to kamailio i am logging presence related errors
(which i posted too in the mailing list with the subject as
: Presence issues)<br>
<br>
</div>
Regards,<br>
</div>
Ravi<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" \
target="_blank">sr-users@lists.sip-router.org</a> <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><span \
class="HOEnZb"><font color="#888888"> </font></span></pre><span class="HOEnZb"><font \
color="#888888"> </font></span></blockquote><span class="HOEnZb"><font \
color="#888888"> <br>
<pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" \
target="_blank">http://www.asipto.com</a> <a href="http://twitter.com/#!/miconda" \
target="_blank">http://twitter.com/#!/miconda</a> - <a \
href="http://www.linkedin.com/in/miconda" \
target="_blank">http://www.linkedin.com/in/miconda</a> Kamailio Advanced Trainings - \
Berlin, Nov 25-28; Miami, Nov 18-20, 2013
- more details about Kamailio trainings at <a href="http://www.asipto.com" \
target="_blank">http://www.asipto.com</a> - </pre>
</font></span></div>
<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> \
<br></blockquote></div><br></div>
--089e0158b86a1690d804e9a25dab--
["Blinkclientregister" (application/octet-stream)]
["syslog" (application/octet-stream)]
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic