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

Daniel-Constantin Mierla miconda at gmail.com
Tue Feb 3 12:36:03 CET 2015


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

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


More information about the sr-users mailing list