quoting it would tell mongo that it is a string, not a function. just like quoting now() in mysql.
for the sake of completeness, i tried it as well but it fails with the same error message. the whole insert command works on mongo's console so i know it is correct.
my guess is there is some quirks with the way it handles the syntax just like nodejs' issues with the syntax. it's not something you can copy and paste to mongo's console. but the question is, where is the documentation on it? on nodejs, it is very clear on the docmentation that there might be some extra parameters before the callbacks. On Jun 27, 2015 10:10 PM, "Alex Balashov" abalashov@evaristesys.com wrote:
I don't think the 'time' value is valid. If it incorporates whitespace, it needs to be: "new Date()".
-- Alex Balashov | Principal | Evariste Systems LLC 303 Perimeter Center North, Suite 300 Atlanta, GA 30346 United States
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
Sent from my BlackBerry. *From: *Kelvin Chua *Sent: *Saturday, June 27, 2015 10:05 *To: *SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List *Reply To: *Kamailio (SER) - Users Mailing List *Subject: *[SR-Users] invalid char in json text
Playing around with ndb_mongodb
getting this error:
ERROR: ndb_mongodb [mongodb_client.c:262]: mongodbc_exec_cmd(): Failed to run command: lexical error: invalid char in json text
query is very simple: db.cdrs.insert({time:new Date(),src_user:"kelvin",term_ani:"14112",src_domain:"domain.com ",src_ip:"0",dst_ouser:"18188",dst_user:"18112",dst_domain:"domain.com"})
which is inside a pv mongodb_cmd("mgs1", "datab", "cdrs", "$var(MNG_MISSED)", "mgr1");
tried this: insert({time:new Date(),src_user:"kelvin",term_ani:"14112",src_domain:" domain.com",src_ip:"0",dst_ouser:"18188",dst_user:"18112",dst_domain:" domain.com"})
and other combinations, same error
any ideas? i guess we need some more examples on the documentation
Kelvin Chua
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users