<div dir="ltr">Yes I am also doing that with local cache but I was confused with sql_cacher and with mongo db also it can be done?...I was just wondering what are these for?<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jan 13, 2016 at 1:40 AM, <span dir="ltr"><<a href="mailto:jarrod@unixc.org" target="_blank">jarrod@unixc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">John,<br>
<br>
I do something similar for caching auth user id and passwords using cachedb_redis/cachedb_local and db_postgres.<br>
<br>
My basic logic first checks cache (cache_fetch) to see if the key exists. If it does I will pv_proxy_authorize using the value stored in the populated avp from the fetch. If the cache does not exist, I will query Postgres (avp_db_query) and store (cache_store) the value in cache with a lifetime so that it will automatically repopulate at a later time. The only time I may adjust the cache out of band would be if the user modifies their SIP password through the portal which causes the system to delete the stale key/value from the cachedb store.<br>
<br>
This may or may not address your concern, but I hope it helps.<br>
<br>
Jarrod<br>
<div><div class="h5"><br>
> On Jan 12, 2016, at 1:54 PM, John Nash <<a href="mailto:john.nash778@gmail.com">john.nash778@gmail.com</a>> wrote:<br>
><br>
> I am using local cache db module in order to keep user id and password in memory and now plan to keep some other data in memory too and that I want to keep in some centralized cache.<br>
><br>
> It will be like Opensips1, Opensips2.... <-----> Cache server <---------> Postgresql<br>
><br>
> I also need to periodically update cache (using some mi commands may be)<br>
><br>
> I saw many of the modules related to cache in opensips (Like sql_cacher, cachedb_* , DB_CACHEDB) and I am confused on what should I use for my need and how these are all related.<br>
><br>
> Any suggestions?<br>
</div></div>> _______________________________________________<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" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><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" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br></div>