<div dir="ltr">Liviu,<div><br></div><div>Thanks for your reply</div><div><br></div><div>this worked for me cache_raw_query("mongodb:instance1","<span class="">{ \"op\" : \"find\",\"query\": { \"User\" : \"$rU\"} }</span>","$avp(mongo_result)")<span class="">; </span></div><div><br></div><div>The documentation is lacking the escape characters around the pseudo variables. Unless this is assumed it should be added otherwise a JSON parse error is thrown.</div><div><br></div><div>Ovidiu,</div><div><br></div><div>Thanks for the suggestions.</div><div><br></div><div>Thanks,</div><div>Tito</div>
</div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Sep 9, 2014 at 7:55 AM, Liviu Chircu <span dir="ltr"><<a href="mailto:liviu@opensips.org" target="_blank">liviu@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div><tt>Hello Tito,<br>
<br>
Either use the group name everywhere, or don't specify it at all
in the modparam:<br>
<br>
</tt><tt>modparam("db_cachedb","cachedb_url","mongodb://localhost
...<br>
or<br>
</tt><tt>cache_raw_query("mongodb:instance1" ...<br>
<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Liviu Chircu
OpenSIPS Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre><div><div class="h5">
On 09/09/2014 03:11 AM, Tito Cumpen wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">Ovidiu,
<div><br>
</div>
<div><br>
</div>
<div>I have corrected the param and now I am seeing opensips
start without a problem the query problem still persists with
the error </div>
<div>
<p>/sbin/opensips[22454]:
ERROR:core:cachedb_raw_query: failed to get connection for
grp name []</p>
<p>I am not seeing any attempts being made from this
server to the my mongo instance on the ingress interface.
Any ideas??</p>
<p><br>
</p>
<p><br>
Thanks,</p>
<p>Tito</p>
<p><br>
</p>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 8, 2014 at 8:01 PM, Ovidiu
Sas <span dir="ltr"><<a href="mailto:osas@voipembedded.com" target="_blank">osas@voipembedded.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Here's
what works for me (I use both mongo and cache):<br>
loadmodule "cachedb_mongodb.so"<br>
modparam("cachedb_mongodb",<br>
"cachedb_url","mongodb:instance1://localhost:27017/db.collection")<br>
loadmodule "db_cachedb.so"<br>
modparam("db_cachedb","cachedb_url","mongodb:instance1://localhost:27017/db.collection")<br>
<br>
You have the wrong module name (cachedb_mongo vs.
cachedb_mongodb)<br>
<br>
Regards,<br>
Ovidiu Sas<br>
<div>
<div><br>
On Mon, Sep 8, 2014 at 7:50 PM, Tito Cumpen <<a href="mailto:tito@xsvoce.com" target="_blank">tito@xsvoce.com</a>>
wrote:<br>
> Hello Group,<br>
><br>
><br>
> I am perplexed about what the correct params are to
point opensips to an<br>
> instance of mongodb<br>
><br>
><br>
> I am currently using these<br>
><br>
><br>
> loadmodule "db_cachedb.so"<br>
><br>
> loadmodule "cachedb_mongodb.so"<br>
><br>
><br>
>
modparam("cachedb_mongo","cachedb_url","mongodb:instance1://162.XXX.XX.XXXX:27017/AOR.Location")<br>
><br>
> which triggers this error<br>
><br>
> Parameter <cachedb_url> not found in module
<cachedb_mongo> - can't set<br>
><br>
> Alternatively I have tried using :<br>
><br>
><br>
>
modparam("db_cachedb","cachedb_url","mongodb:instance1://162.XX.XX.XX:27017/AOR.Location")<br>
><br>
> which would cause the following error when running
this query<br>
><br>
> cache_raw_query("mongodb","{ \"op\"
: \"find\", \"ns\" :<br>
> \"AOR.Location\", \"query\": {\"User\" : $rU}
}","$avp(mongo_result)");<br>
><br>
><br>
> ERROR:core:cachedb_raw_query: failed to get
connection for grp name [}<br>
><br>
> I am using Opensips version 1.11<br>
><br>
> Thanks<br>
><br>
><br>
><br>
</div>
</div>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<span><font color="#888888"><br>
<br>
<br>
--<br>
VoIP Embedded, Inc.<br>
<a href="http://www.voipembedded.com" target="_blank">http://www.voipembedded.com</a><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</font></span></blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>