[OpenSIPS-Users] MongoDB bug

[kamika]

Hello

I just found maybe the Bug in MongoDB Module. In order to have scalable
system i have used Perl and ran Mongo connection under Perl when the latest
version was 1.8. MondoDB driver for Perl itself has problems in its code and
by now was not resolved by developers. Now, when 1.9 is released i tried to
set native opensips's MongoDB Module with json and use raw query. Then I
found that it cannot execute the following query:

cache_raw_query("mongodb","{ \"op\" : \"find\", \"query\": {\"phone\":
77073517003}, \"fields\": {\"id\":1,\"email\":1}}","$avp(mongo_result)");

However the following query executes successfully under Mongo CLI:
 db.users.find({phone:77072517003},{"id":1,"email":1})
{ "_id" : ObjectId("51866650f1ac4fc22100050e"), "email" :
"kamil.nigmatullin at xxx.xx", "id" : NumberLong(668) }

If i modify key in query as follows:
cache_raw_query("mongodb","{ \"op\" : \"find\", \"query\": {\"id\": 668},
\"fields\": {\"id\":1,\"email\":1}}","$avp(mongo_result)");
then query runs successfully and I am geting my results in
$avp(mongo_result).

We use all phones as Integers in Mongodb to ease Inedex development and
quicken searches. I think it is something with NumberLong. I have special
account with phone 1 and it runs perfectly good. Debug do not show anything
exept that nothing was fetched from mongodb.

Thank you. 



--
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/MongoDB-bug-tp7586282.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.