[sr-dev] location table expire/ruid problem again

Wed Apr 24 00:20:03 CEST 2013

Hello,

I tried to reproduce, but didn't get it. Can you give the parameters you 
set for registrar and usrloc modules? Maybe is specific for some 
matching mode or other parameter value. I tried with default config 
file, over udp as well as over tcp, with and without gruu enabled.

Cheers,
Daniel

On 4/23/13 9:06 PM, Juha Heinanen wrote:
> Daniel-Constantin Mierla writes:
>
>> can you capture (ngrep) the REGISTER requests for the two cases and send
>> them over? I don't have a pjsua with me right now, but I can re-inject
>> them with protoshot and reproduce, that will help to troubleshoot properly.
> daniel,
>
> the requests along with some syslog entries and comments are below.  i
> removed Authorization: headers from register requests.
>
> -- juha
>
> T 2013/04/23 22:01:22.372754 192.98.102.10:57892 -> 192.98.102.10:5060 [AP]
> REGISTER sip:192.98.102.10 SIP/2.0.
> Via: SIP/2.0/TCP 192.98.102.10:57892;rport;branch=z9hG4bKPj9e911277-3bc5-4184-807f-6fa5534b1f21.
> Route: <sip:192.98.102.10;transport=tcp;lr>.
> Max-Forwards: 70.
> From: <sip:jh at test.fi>;tag=68259460-b3cc-49e7-81f4-3e6138d5eec9.
> To: <sip:jh at test.fi>.
> Call-ID: 9f971272-fcf4-4312-874f-d390a448e88a.
> CSeq: 28125 REGISTER.
> User-Agent: PJSUA v2.1 Linux-3.2.0.4/x86_64/glibc-2.13.
> Supported: outbound, path.
> Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;reg-id=1;+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>".
> Expires: 300.
> Allow: PRACK, INVITE, ACK, BYE, CANCEL, UPDATE, INFO, SUBSCRIBE, NOTIFY, REFER, MESSAGE, OPTIONS.
> Content-Length:  0.
>
> Apr 23 22:01:22 siika /usr/sbin/sip-proxy[6393]: INFO: REGISTER <sip:jh at test.fi> by <jh at test.fi> from <192.98.102.10> is authorized
>
> ##
> T 2013/04/23 22:01:22.501737 192.98.102.10:5060 -> 192.98.102.10:57892 [AP]
> SIP/2.0 200 OK.
> Via: SIP/2.0/TCP 192.98.102.10:57892;rport=57892;branch=z9hG4bKPj9e911277-3bc5-4184-807f-6fa5534b1f21.
> From: <sip:jh at test.fi>;tag=68259460-b3cc-49e7-81f4-3e6138d5eec9.
> To: <sip:jh at test.fi>;tag=c02670ad1171fe45d9ff9a27d6c2cb82-a4e7.
> Call-ID: 9f971272-fcf4-4312-874f-d390a448e88a.
> CSeq: 28125 REGISTER.
> Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;q=0.5;expires=300;received="sip:192.98.102.10:57892;transport=TCP";+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>";reg-id=1.
> Supported: outbound.
> Require: outbound.
> Server: OpenXg SIP Proxy  (4.1.0-dev3 (x86_64/linux)).
> Content-Length: 0.
> .
>
> at this point i -KILLed pjsua and started it again.
>
> ##
> T 2013/04/23 22:01:51.333822 192.98.102.10:52559 -> 192.98.102.10:5060 [AP]
> REGISTER sip:192.98.102.10 SIP/2.0.
> Via: SIP/2.0/TCP 192.98.102.10:52559;rport;branch=z9hG4bKPj5dc30bbd-73e3-483d-8ff8-7401cd8c49c7.
> Route: <sip:192.98.102.10;transport=tcp;lr>.
> Max-Forwards: 70.
> From: <sip:jh at test.fi>;tag=c9c332e4-24cb-461e-a978-efb48200cf7f.
> To: <sip:jh at test.fi>.
> Call-ID: 0f3f745f-1846-4a3b-a1fd-b900ad896c3c.
> CSeq: 2625 REGISTER.
> User-Agent: PJSUA v2.1 Linux-3.2.0.4/x86_64/glibc-2.13.
> Supported: outbound, path.
> Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;reg-id=1;+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>".
> Expires: 300.
> Allow: PRACK, INVITE, ACK, BYE, CANCEL, UPDATE, INFO, SUBSCRIBE, NOTIFY, REFER, MESSAGE, OPTIONS.
> Content-Length:  0.
> .
>
> Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: INFO: REGISTER <sip:jh at test.fi> by <jh at test.fi> from <192.98.102.10> is authorized
> #Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry 'uloc-5176d955-18f9-1' for key 'ruid_idx'
> Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: <core> [db_query.c:235]: error while submitting query
> Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: usrloc [ucontact.c:615]: inserting contact in db failed
> Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: usrloc [ucontact.c:998]: failed to update database
> Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: registrar [save.c:739]: failed to update contact
> #
> T 2013/04/23 22:01:51.441256 192.98.102.10:5060 -> 192.98.102.10:52559 [AP]
> SIP/2.0 500 Server Internal Error.
> Via: SIP/2.0/TCP 192.98.102.10:52559;rport=52559;branch=z9hG4bKPj5dc30bbd-73e3-483d-8ff8-7401cd8c49c7.
> From: <sip:jh at test.fi>;tag=c9c332e4-24cb-461e-a978-efb48200cf7f.
> To: <sip:jh at test.fi>;tag=c02670ad1171fe45d9ff9a27d6c2cb82-d6cb.
> Call-ID: 0f3f745f-1846-4a3b-a1fd-b900ad896c3c.
> CSeq: 2625 REGISTER.
> Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;q=0.5;expires=300;received="sip:192.98.102.10:52559;transport=TCP";+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>";reg-id=1.
> P-Registrar-Error: usrloc_contact_update failed.
> Server: OpenXg SIP Proxy  (4.1.0-dev3 (x86_64/linux)).
> Content-Length: 0.

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda