25 Oct
2013
25 Oct
'13
6:26 p.m.
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(a)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
25 Oct
25 Oct
8:05 p.m.
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://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 -
26 Oct
26 Oct
1:31 p.m.
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
4048
days inactive
4049
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Wingsravi R