[OpenSIPS-Users] store data locally

[Alain Bieuzent]

Thanks Liviu,

 

It's interesting but seems a bit too overkill to store so little recording.

in French we say "c’est prendre un marteau pour tuer une mouche » (t takes a hammer to kill a fly)

 

you can tell the "vlad" that I don't need any reason to pay for a beer, it will be with pleasure.

 

Regards

 

De : Users <users-bounces at lists.opensips.org> au nom de Liviu Chircu <liviu at opensips.org>
Répondre à : OpenSIPS users mailling list <users at lists.opensips.org>
Date : mardi 22 septembre 2020 à 15:37
À : OpenSIPS users mailling list <users at lists.opensips.org>
Objet : Re: [OpenSIPS-Users] store data locally

 

On 22.09.2020 16:09, Alain Bieuzent wrote:

I need to store some data locally but accessible by opensips.

the data is almost 20 records made up of a couple IP: name

>From opensips script I want to retrieve the name associated with the IP (to put in place profiling).

how do you set up this kind of solution without accessing each call to an external database?

Hi, Alain!

One way would be to use the local cacheDB [1] module through the generic cacheDB scripting functions [2].

Alternatively, if you specifically need to load this data from an SQL DB, for example, the sql_cacher [3] module would be a perfect fit.

Fun Fact:  if you decide to use any of these two modules, you will have to buy a guy named Vlad a beer, and they are not the same Vlad.

Best regards,

[1]: https://opensips.org/docs/modules/3.2.x/cachedb_local.html
[2]: https://www.opensips.org/Documentation/Script-CoreFunctions-3-2#toc4
[3]: https://opensips.org/docs/modules/3.2.x/sql_cacher.html
-- 
Liviu Chircu
www.twitter.com/liviuchircu | www.opensips-solutions.com
_______________________________________________ Users mailing list Users at lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200923/f44b15c5/attachment-0001.html>