[SR-Users] Wrong location entries when using usrloc with Mongo

Daniel-Constantin Mierla miconda at gmail.com
Tue Feb 3 20:42:48 CET 2015


I pushed a patch on git master branch for this issue, can you try it and
report the results?

I tested a bit with usrloc and DB_ONLY mode, it seemed fine here.

Cheers,
Daniel

On 03/02/15 12:36, Daniel-Constantin Mierla wrote:
> I haven't had time to look at it, being traveling to Fosdem in the
> past days. It is on my short term agenda.
>
> Cheers,
> Daniel
>
> On 02/02/15 12:38, Mickael Marrache wrote:
>>
>> Any news regarding this issue?
>>
>>  
>>
>> I don't think *{ "expires" : { "$date" : 1422728781000 }, "expires" :
>> { "$date" : 0 } }*is a valid query… Is the intent to remove entries
>> where *expires =* *1422728781000 or expires = 0*? If yes, I think the
>> logical operator $or should be used for that? Let me know how I can
>> help you to figure out what the issue is.
>>
>>  
>>
>> Thanks,
>>
>> Mickael
>>
>>  
>>
>> *From:*Mickael Marrache [mailto:mickaelmarrache at gmail.com]
>> *Sent:* Saturday, January 31, 2015 8:32 PM
>> *To:* 'Kamailio (SER) - Users Mailing List'
>> *Subject:* RE: [SR-Users] Wrong location entries when using usrloc
>> with Mongo
>>
>>  
>>
>> Hi,
>>
>>  
>>
>> The log entries are all of the form:
>>
>>  
>>
>> DEBUG: db_mongodb [mongodb_dbase.c:948]: db_mongodb_delete(): delete
>> filter document: { "expires" : { "$date" : 1422728781000 }, "expires"
>> : { "$date" : 0 } }
>>
>>  
>>
>> Mickael
>>
>>  
>>
>> *From:*sr-users [mailto:sr-users-bounces at lists.sip-router.org] *On
>> Behalf Of *Daniel-Constantin Mierla
>> *Sent:* Friday, January 30, 2015 4:28 PM
>> *To:* Kamailio (SER) - Users Mailing List
>> *Subject:* Re: [SR-Users] Wrong location entries when using usrloc
>> with Mongo
>>
>>  
>>
>> I checked quickly the code and mongo c api, it looks ok. Can you see
>> a debug message with content like:
>>
>>  
>>
>> ... delete filter document: ...
>>
>>  
>>
>> when running with debug=3? If yes, can you send it over to check if
>> is correct?
>>
>>  
>>
>> Cheers,
>>
>> Daniel
>>
>>  
>>
>> On Fri, Jan 30, 2015 at 10:45 AM, Daniel-Constantin Mierla
>> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>>
>> Hello,
>>
>>  
>>
>> it seems that the fileds inside the object are deleted, not the
>> entire object. The match was done on username and ruid for deletion,
>> both of them are missing.
>>
>>  
>>
>> I will look at the mongo api to see if something was set wrong there
>> for the delete command.
>>
>>  
>>
>> Cheers,
>>
>> Daniel
>>
>>  
>>
>>  
>>
>> On Fri, Jan 30, 2015 at 9:54 AM, Mickael Marrache
>> <mickaelmarrache at gmail.com <mailto:mickaelmarrache at gmail.com>> wrote:
>>
>>     I forgot to precise that I allow only one contact per AOR.
>>
>>      
>>
>>     modparam("registrar", "max_contacts", 1)
>>
>>     save("location", "0x04")
>>
>>      
>>
>>     *From:*Mickael Marrache [mailto:mickaelmarrache at gmail.com
>>     <mailto:mickaelmarrache at gmail.com>]
>>     *Sent:* Friday, January 30, 2015 10:51 AM
>>     *To:* sr-users at lists.sip-router.org
>>     <mailto:sr-users at lists.sip-router.org>
>>     *Subject:* Wrong location entries when using usrloc with Mongo
>>
>>      
>>
>>     Hi,
>>
>>      
>>
>>     I start with no location nor in Mongo, nor in memory. My UA
>>     registers successfully and I can see the location entry in Mongo.
>>     Then, I close my UA which unregisters (by setting Expires header
>>     to 0). Then, I open the app again and a new registration is made.
>>
>>      
>>
>>     The entry after first registration. Looks okay.
>>
>>      
>>
>>     { "_id" : ObjectId("54cb38f684e58133783f2b42"), "username" : "A",
>>     "contact" :
>>     "sip:A at 192.168.1.3:54217;rinstance=DFAEBBC7;transport=tcp",
>>     "expires" : ISODate("2015-01-30T08:55:34Z"), "q" : -1, "callid" :
>>     "297EC55073A07BF78F0C05822A6CCDFB47E48705", "cseq" : 8809,
>>     "flags" : 0, "cflags" : 0, "user_agent" : "Acrobits Softphone
>>     Business/3.1", "received" :
>>     "sip:XXXXXXXXXXX:54217;transport=tcp", "path" :
>>     "<sip:XXXXXXXXXX;lr;received=sip:XXXXXXXXXXX:54217%3Btransport%3Dtcp>",
>>     "socket" : "udp:XXXXXXXXX:5060", "methods" : 4751,
>>     "last_modified" : ISODate("2015-01-30T07:55:34Z"), "ruid" :
>>     "uloc-54cb38df-3378-2", "instance" : null, "reg_id" : 0 }
>>
>>      
>>
>>     The same entry after un register (Expires 0). Note that the
>>     username field is missing. In any case, I expected the entry to
>>     be deleted.
>>
>>      
>>
>>     { "_id" : ObjectId("54cb38f684e58133783f2b42"), "expires" :
>>     ISODate("2015-01-30T08:56:51Z"), "q" : -1, "cseq" : 8811, "flags"
>>     : 0, "cflags" : 0, "user_agent" : "Acrobits Softphone
>>     Business/3.1", "received" : "sip: XXXXXXXXX:54217;transport=tcp",
>>     "path" : "<sip: XXXXXXXXX;lr;received=sip:
>>     XXXXXXXXX:54217%3Btransport%3Dtcp>", "socket" : "udp:
>>     XXXXXXXXX:5060", "methods" : 4751, "last_modified" :
>>     ISODate("2015-01-30T07:56:51Z"), "callid" :
>>     "297EC55073A07BF78F0C05822A6CCDFB47E48705", "instance" : null,
>>     "reg_id" : 0, "contact" :
>>     "sip:A at 192.168.1.3:54217;rinstance=DFAEBBC7;transport=tcp" }
>>
>>      
>>
>>     The entries after second registration. The new entry looks okay.
>>     But, the old entry is still here.
>>
>>      
>>
>>     { "_id" : ObjectId("54cb38f684e58133783f2b42"), "expires" :
>>     ISODate("2015-01-30T08:56:51Z"), "q" : -1, "cseq" : 8811, "flags"
>>     : 0, "cflags" : 0, "user_agent" : "Acrobits Softphone
>>     Business/3.1", "received" : "sip: XXXXXXXXX:54217;transport=tcp",
>>     "path" : "<sip: XXXXXXXXX;lr;received=sip:
>>     XXXXXXXXX:54217%3Btransport%3Dtcp>", "socket" : "udp:
>>     XXXXXXXXX:5060", "methods" : 4751, "last_modified" :
>>     ISODate("2015-01-30T07:56:51Z"), "callid" :
>>     "297EC55073A07BF78F0C05822A6CCDFB47E48705", "instance" : null,
>>     "reg_id" : 0, "contact" :
>>     "sip:A at 192.168.1.3:54217;rinstance=DFAEBBC7;transport=tcp" }
>>
>>      
>>
>>     { "_id" : ObjectId("54cb3a7884e581337a25b895"), "username" : "A",
>>     "contact" :
>>     "sip:A at 192.168.1.3:54217;rinstance=DFAEBBC7;transport=tcp",
>>     "expires" : ISODate("2015-01-30T09:02:00Z"), "q" : -1, "callid" :
>>     "297EC55073A07BF78F0C05822A6CCDFB47E48705", "cseq" : 8813,
>>     "flags" : 0, "cflags" : 0, "user_agent" : "Acrobits Softphone
>>     Business/3.1", "received" : "sip: XXXXXXXXX:54217;transport=tcp",
>>     "path" : "<sip: XXXXXXXXX;lr;received=sip:
>>     XXXXXXXXX:54217%3Btransport%3Dtcp>", "socket" : "udp:
>>     XXXXXXXXX:5060", "methods" : 4751, "last_modified" :
>>     ISODate("2015-01-30T08:02:00Z"), "ruid" : "uloc-54cb38df-337a-1",
>>     "instance" : null, "reg_id" : 0 }
>>
>>      
>>
>>     The issue is the entry is not deleted after un registering.
>>
>>      
>>
>>     I precise that registrations are dispatched over multiple
>>     registrars with all accesses the same Mongo cluster.
>>
>>      
>>
>>     Thanks,
>>
>>     Mickael
>>
>>      
>>
>>      
>>
>>     _______________________________________________
>>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
>>     mailing list
>>     sr-users at lists.sip-router.org <mailto:sr-users at 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://twitter.com/#%21/miconda> -
>> http://www.linkedin.com/in/micond <http://www.linkedin.com/in/miconda>
>>
>>
>>
>>  
>>
>> -- 
>>
>> Daniel-Constantin Mierla - http://www.asipto.com
>>
>> http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> -
>> http://www.linkedin.com/in/micond <http://www.linkedin.com/in/miconda>
>>
>
> -- 
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150203/322a6319/attachment.html>


More information about the sr-users mailing list