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@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
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@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 list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 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@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/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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users