<div dir="ltr"><div><div><div>Dear Feroz,<br><br></div>From past experience DO NOT ATTEMPT this :). You will surely run into many bottle necks from switching to NoSQL. NoSQL is good for caching during call processing not for storing persistent data.<br><br></div>Regards,<br></div>Qasim<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jul 14, 2016 at 11:38 PM, Jim DeVito <span dir="ltr"><<a href="mailto:jim@devito.cc" target="_blank">jim@devito.cc</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I addition to what Eric said I suspect you are failing to load cachedb_mongodb as stated "The following modules must be loaded before this module: At least one NoSQL cachedb_* module."<br>
<br>
Thanks!!<br>
<br>
---<br>
Jim DeVito<br>
Mobile 440.941.3860<span class=""><br>
<br>
On 2016-07-14 10:31, feroze waris wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hi Daniel and Benajmin,<br>
<br>
Thank you for reply and sharing link of mongodb basics. Yes there is a<br>
performance issue. I want that opensips writes and get information of<br>
dialog, location, subscriber etc from cachedb(mongodb). For this task<br></span>
i came across with the module named DB_CACHEDB (<br>
<a href="http://www.opensips.org/html/docs/modules/2.1.x/db_cachedb.html" rel="noreferrer" target="_blank">http://www.opensips.org/html/docs/modules/2.1.x/db_cachedb.html</a> [3] ).<br>
<br>
<br>
According to documentation what this module do is " THE DB_CACHEDB<br>
MODULE WILL EXPOSE THE SAME FRONT DB API, HOWEVER IT WILL RUN ON TOP<br>
OF A NOSQL BACK-END, EMULATING THE SQL CALLS TO THE BACK-END SPECIFIC<br>
QUERIES."<span class=""><br>
<br>
I implemented this module and also created collections in mongodb<br>
according to mysql tables list. Now when i start opensips it gives me<br>
following error<br>
<br>
Jul 14 17:27:45 localhost [23610]: ERROR:core:db_check_api: module<br>
db_mongodb does not export db_use_table function<br>
Jul 14 17:27:45 localhost [23610]: ERROR:uri:mod_init: No database<br>
module found<br>
Jul 14 17:27:45 localhost [23610]: ERROR:core:init_mod: failed to<br>
initialize module uri<br>
Jul 14 17:27:45 localhost [23610]: ERROR:core:main: error while<br>
initializing modules<br>
<br>
my opensips version is 2.1.3<br>
<br>
On Wed, Jul 13, 2016 at 6:52 PM, Benjamin Cropley<br>
<<a href="mailto:benjamin.cropley@gmail.com" target="_blank">benjamin.cropley@gmail.com</a>> wrote:<br>
<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
You don't have to explicitly define a schema when you insert a<br>
document into MongoDB.<br>
<br>
For example, you could create a MongoDB database, and then<br>
immediately do an insert into an insert into a collection without<br>
even creating it or a 'schema'.<br>
<br>
Maybe you should do some reading about MongoDB and NoSQL in general,<br>
as a basic understanding should have answered that question :)<br>
<br>
</span><a href="https://docs.mongodb.com/manual/faq/fundamentals/" rel="noreferrer" target="_blank">https://docs.mongodb.com/manual/faq/fundamentals/</a> [2]<span class=""><br>
<br>
On Wed, Jul 13, 2016 at 2:44 PM, feroze waris<br>
<<a href="mailto:feroze.chaudhry@gmail.com" target="_blank">feroze.chaudhry@gmail.com</a>> wrote:<br>
<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hi,<br>
<br>
Can anyone tell me how to move opensips DB from SQL to NoSQL. I<br>
have seen a module name db_cachedb which has a support for mongodb<br>
but how to move mysql schema to mongodb schema.<br>
<br>
Regards<br>
Feroze<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
</span><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a> [1]<br>
</blockquote><span class="">
<br>
--<br>
<br>
All the best,<br>
Ben Cropley<br>
07539 366 905<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
</span><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a> [1]<br>
</blockquote>
<br>
<br>
<br>
Links:<br>
------<br>
[1] <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
[2] <a href="https://docs.mongodb.com/manual/faq/fundamentals/" rel="noreferrer" target="_blank">https://docs.mongodb.com/manual/faq/fundamentals/</a><br>
[3] <a href="http://www.opensips.org/html/docs/modules/2.1.x/db_cachedb.html" rel="noreferrer" target="_blank">http://www.opensips.org/html/docs/modules/2.1.x/db_cachedb.html</a><span class=""><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" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</span></blockquote><div class="HOEnZb"><div class="h5">
<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" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>