From mespio@gmail.com Mon Jan  8 08:34:06 2018
From: Mojtaba <mespio@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 [SR-Users] Error in parse json documents in kamailio with jansson	module
Date: Mon, 08 Jan 2018 11:03:56 +0330
Message-ID:
 <CABVi_ExDa1EfeYbKbhRYQBZ0iByB_fqsi4Tbkj8fmG5WZx21hA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1288556573=="

--===============1288556573==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello,
I used ndbmongo module in kamailio,
I used mongodb_find command to get some data from mongo, like this:

if(mongodb_find("sermongo", "Asterisk", "user", "{ \"number\" :
\"$fU\" }", "res")) {
                xlog("L_INFO", "Data from mongodb is \"
$mongodb(res=>value) \" \n");
                $var(data) = $mongodb(res=>value);
        }
The result in syslog is like this:
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} INFO: <script>: user
Data from mongodb is " { "_id" : { "$oid" : "5916def36803fa48468b456b"
}, "user_type" : "SIP", "context" : "main_routing", "deny" :
"0.0.0.0/0.0.0.0", "call_record" : "no", "dtmfmode" : "rfc2833",
"canreinvite" : "no", "directmedia" : "no", "host" : "dynamic", "type"
: "friend", "nat" : "force_rport,comedia", "port" : "5060", "qualify"
: "yes", "callgroup" : "1", "pickupgroup" : "1", "permit" :
"0.0.0.0/0.0.0.0", "callcounter" : "yes", "faxdetect" : "no",
"call_limit" : "", "name" : "1000", "number" : "1000", "cid_number" :
"1000", "secret" : "123123", "date" : { "$date" : 1494671091612 },
"more_options" : "" } "

Now i need to get just some keys like "context" from json and save
them in PV, i used jansson2.10 for doing this job, like this:

jansson_get("user.context", $var(jdata), "$var(context)");
but i have this error in syslog:
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/pvapi.c:903]: pv_parse_spec2(): error searching pvar "oid"
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/pvapi.c:1107]: pv_parse_spec2(): wrong char [d/100] in [$oid] at
[3 (0)]
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/sr_module.c:1268]: fix_param(): bad PVE format: "{ "_id" : {
"$oid" : "5916def36803fa48468b456b" }, "user_type" : "SIP", "context"
: "main_routing", "deny" : "0.0.0.0/0.0.0.0", "call_record" : "no",
"dtmfmode" : "rfc2833", "canreinvite" : "no", "directmedia" : "no",
"host" : "dynamic", "type" : "friend", "nat" : "force_rport,comedia",
"port" : "5060", "qualify" : "yes", "callgroup" : "1", "pickupgroup" :
"1", "permit" : "0.0.0.0/0.0.0.0", "callcounter" : "yes", "faxdetect"
: "no", "call_limit" : "", "name" : "1000", "number" : "1000",
"cid_number" : "1000", "secret" : "123123", "date" : { "$date" :
1494671091612 }, "more_options" : "" }"
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/mod_fix.c:564]: fixup_spve_null(): Cannot convert function
parameter 1 to spve
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/action.c:1139]: do_action(): runtime fixup failed for
jansson_get param 2
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
[core/action.c:1518]: do_action(): run action error at:
/usr/local/etc/kamailio/kamailio.cfg:990
Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <script>: Send
SIP message to Simotel <192.168.122.1:36854>
Let me know how i could fixed this Error in regard of [$oid]?
Thanks with regards.

-- 
--Mojtaba Esfandiari.S


--===============1288556573==--


From miconda@gmail.com Mon Jan  8 10:01:00 2018
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject:
 Re: [SR-Users] Error in parse json documents in kamailio with jansson module
Date: Mon, 08 Jan 2018 10:00:48 +0100
Message-ID: <8d15dcc8-2984-3a80-84eb-b9b285e236f9@gmail.com>
In-Reply-To:
 <CABVi_ExDa1EfeYbKbhRYQBZ0iByB_fqsi4Tbkj8fmG5WZx21hA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0096151715=="

--===============0096151715==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello,

the issue is triggered by the fact that the JSON document has $xyz
tokens (e.g., $oid), which match the kamailio variables format, and the
jansson_get() tries to replace them, but no such variable is exported by
kamailio, throwing an error.

Try to replace $ with $$ inside the $var(data), something like:

$var(m) = "$";

$var(r) = "$$";

$var(newdata) = $(var(data){s.replace,$var(m),$var(r)});

Let us know if works, if now, we have to look at the code of jansson
module and see how it evaluates its parameters for functions.

Cheers,
Daniel

On 08.01.18 08:33, Mojtaba wrote:
> Hello,
> I used ndbmongo module in kamailio,
> I used mongodb_find command to get some data from mongo, like this:
>
> if(mongodb_find("sermongo", "Asterisk", "user", "{ \"number\" :
> \"$fU\" }", "res")) {
>                 xlog("L_INFO", "Data from mongodb is \"
> $mongodb(res=>value) \" \n");
>                 $var(data) = $mongodb(res=>value);
>         }
> The result in syslog is like this:
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} INFO: <script>: user
> Data from mongodb is " { "_id" : { "$oid" : "5916def36803fa48468b456b"
> }, "user_type" : "SIP", "context" : "main_routing", "deny" :
> "0.0.0.0/0.0.0.0", "call_record" : "no", "dtmfmode" : "rfc2833",
> "canreinvite" : "no", "directmedia" : "no", "host" : "dynamic", "type"
> : "friend", "nat" : "force_rport,comedia", "port" : "5060", "qualify"
> : "yes", "callgroup" : "1", "pickupgroup" : "1", "permit" :
> "0.0.0.0/0.0.0.0", "callcounter" : "yes", "faxdetect" : "no",
> "call_limit" : "", "name" : "1000", "number" : "1000", "cid_number" :
> "1000", "secret" : "123123", "date" : { "$date" : 1494671091612 },
> "more_options" : "" } "
>
> Now i need to get just some keys like "context" from json and save
> them in PV, i used jansson2.10 for doing this job, like this:
>
> jansson_get("user.context", $var(jdata), "$var(context)");
> but i have this error in syslog:
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/pvapi.c:903]: pv_parse_spec2(): error searching pvar "oid"
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/pvapi.c:1107]: pv_parse_spec2(): wrong char [d/100] in [$oid] at
> [3 (0)]
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/sr_module.c:1268]: fix_param(): bad PVE format: "{ "_id" : {
> "$oid" : "5916def36803fa48468b456b" }, "user_type" : "SIP", "context"
> : "main_routing", "deny" : "0.0.0.0/0.0.0.0", "call_record" : "no",
> "dtmfmode" : "rfc2833", "canreinvite" : "no", "directmedia" : "no",
> "host" : "dynamic", "type" : "friend", "nat" : "force_rport,comedia",
> "port" : "5060", "qualify" : "yes", "callgroup" : "1", "pickupgroup" :
> "1", "permit" : "0.0.0.0/0.0.0.0", "callcounter" : "yes", "faxdetect"
> : "no", "call_limit" : "", "name" : "1000", "number" : "1000",
> "cid_number" : "1000", "secret" : "123123", "date" : { "$date" :
> 1494671091612 }, "more_options" : "" }"
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/mod_fix.c:564]: fixup_spve_null(): Cannot convert function
> parameter 1 to spve
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/action.c:1139]: do_action(): runtime fixup failed for
> jansson_get param 2
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <core>
> [core/action.c:1518]: do_action(): run action error at:
> /usr/local/etc/kamailio/kamailio.cfg:990
> Jan  8 07:23:36 ubuntu14 /usr/local/sbin/kamailio[12127]: {1 2 INVITE
> MDRlMjRlNGVjZGY1Y2JkYjA5OGM2ZTg1ZTFjZTk0Nzg.} ERROR: <script>: Send
> SIP message to Simotel <192.168.122.1:36854>
> Let me know how i could fixed this Error in regard of [$oid]?
> Thanks with regards.
>

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - March 5-7, 2018, Berlin - www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.com



--===============0096151715==--