<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>