[SR-Users] Usrloc errors

[Wingsravi R]

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 at 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 at 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 at 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 installed
> 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: Duplicate
> 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 at 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 at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - 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 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/20131026/5060d720/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Blinkclientregister
Type: application/octet-stream
Size: 37455 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20131026/5060d720/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: syslog errors
Type: application/octet-stream
Size: 4866 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20131026/5060d720/attachment-0003.obj>