<div dir="ltr">I doubt that I am seeing the connection the db load fine during startup<div><br></div><div><br></div><div>
<p class=""><br></p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24461]: NOTICE:presence:child_init: init_child [14] pid [24461]</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24461]: INFO:cachedb_mongodb:mongo_new_connection: Connected at server 162.XX.XX.XX with version 2.4.6 , to db AOR.Location</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24465]: NOTICE:presence:child_init: init_child [15] pid [24465]</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24459]: NOTICE:presence:child_init: init_child [13] pid [24459]</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24465]: INFO:cachedb_mongodb:mongo_new_connection: Connected at server 162.XX.XXX.XX with version 2.4.6 , to db AOR.Location</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24467]: NOTICE:presence:child_init: init_child [16] pid [24467]</p>
<p class="">Sep 9 00:35:29 mediaproxy2 /sbin/opensips[24459]: INFO</p><p class=""><br></p><p class="">Is there anyway to reference the server to use during a raw query? Also I am not sure if this applies to raw queries:</p><p class="">section 1.5, 1.2</p><p class=""><br></p><p class="">of</p><p class=""><a href="http://www.opensips.org/html/docs/modules/devel/cachedb_mongodb.html">http://www.opensips.org/html/docs/modules/devel/cachedb_mongodb.html</a><br></p><p class="">cache_store("mongodb:group1","key","$ru value"); </p><p class="">cache_fetch("mongodb:replicaset1","key",$avp(10)); </p><p class="">cache_remove("mongodb:cluster1","key"); <br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class="">Thanks,</p><p class="">Tito</p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p><p class=""><br></p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 8, 2014 at 8:29 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">Maybe some firewall issues?<br>
<span class="HOEnZb"><font color="#888888"><br>
-ovidiu<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
On Mon, Sep 8, 2014 at 8:11 PM, Tito Cumpen <<a href="mailto:tito@xsvoce.com">tito@xsvoce.com</a>> wrote:<br>
> Ovidiu,<br>
><br>
><br>
> I have corrected the param and now I am seeing opensips start without a<br>
> problem the query problem still persists with the error<br>
><br>
> /sbin/opensips[22454]: ERROR:core:cachedb_raw_query: failed to get<br>
> connection for grp name []<br>
><br>
> I am not seeing any attempts being made from this server to the my mongo<br>
> instance on the ingress interface. Any ideas??<br>
><br>
><br>
><br>
> Thanks,<br>
><br>
> Tito<br>
><br>
><br>
><br>
> On Mon, Sep 8, 2014 at 8:01 PM, Ovidiu Sas <<a href="mailto:osas@voipembedded.com">osas@voipembedded.com</a>> wrote:<br>
>><br>
>> 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>
>><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>
>><br>
>> On Mon, Sep 8, 2014 at 7:50 PM, Tito Cumpen <<a href="mailto:tito@xsvoce.com">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>
>> ><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>
>> ><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>
>> > _______________________________________________<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>
>><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">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>
><br>
><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>
<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">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>
</div></div></blockquote></div><br></div>