Thanks Ovidiu, it seem the good way for my case. Le 22/09/2020 17:44, « Users au nom de Ovidiu Sas » <users-boun...@lists.opensips.org au nom de o...@voipembedded.com> a écrit :
Hello Alain, If you don't want to run a full blown db, then you can use db_text without cacheDB. The data is cached into memory at startup. If you update the text file, you can re-cache the data [1]. You can also manipulate the data using the avpops module [2]. Or, you can use cacheDB on top of the text db :) [1]: https://opensips.org/docs/modules/3.1.x/db_text.html#mi_dbt_reload [2]: https://opensips.org/docs/modules/3.1.x/avpops.html Regards, Ovidiu Sas On Tue, Sep 22, 2020 at 9:36 AM Liviu Chircu <li...@opensips.org> wrote: > > 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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users