Use the sql_cacher module to cache the content of the file.
First, declare the cache that you want to use, then configure the
sql_cacher to use the file:
loadmodule "cachedb_local.so"
modparam("cachedb_local", "cache_collections", "my_cache")
modparam("cachedb_local", "cachedb_url", "local:///my_cache")
loadmodule "sql_cacher.so"
modparam("sql_cacher", "cache_table",
"id=my_cache_id
db_url=text:///tmp/opensipsdb
cachedb_url=local:///my_cache
table=my_table
key=my_key
columns=my_value
on_demand=0")Or you can simply use the avpops module directly on the db_text file. -ovidiu https://opensips.org/docs/modules/3.1.x/cachedb_local.html https://opensips.org/docs/modules/3.1.x/sql_cacher.html https://opensips.org/docs/modules/3.1.x/avpops.html On Sun, Nov 15, 2020 at 9:49 AM Mark Allen <[email protected]> wrote: > > Being a bit dense here - the documentation says to set modparams like... > > modparam("usrloc|auth_db", "db_url", "text:///tmp/opensipsdb") > > ...if I'm using a separate table with our specific info rather than, say, > usrloc - what am I putting in as the module name? > > On Fri, 13 Nov 2020 at 16:39, Maxim Sobolev <[email protected]> wrote: >> >> Who doubted it?! I personally think db_text is absolutely brilliant, cuts >> devtesting effort 10x easily. >> >> -Max >> >> On Fri., Nov. 13, 2020, 7:31 a.m. johan, <[email protected]> wrote: >>> >>> And so is the usefulness of db_text proven :-) >>> >>> On 13/11/2020 16:06, Ovidiu Sas wrote: >>> >>> Take a look at db_text and sql_cacher modules! >>> >>> Regards, >>> Ovidiu Sas >>> >>> On Fri, Nov 13, 2020 at 09:50 Mark Allen <[email protected]> wrote: >>>> >>>> Just would like to consult the hive mind. I want to read the contents of a >>>> multi-line text file to be used by my OpenSIPS config. Ideally, I'll get a >>>> key:value CSV pair from the file and store each pair in memcache - e.g. >>>> >>>> file contains: >>>> >>>> a, 113 >>>> b, 214 >>>> c, 771 >>>> >>>> read it in line by line and cache_store() with the letter as the attribute >>>> and the number as the value. >>>> >>>> I was thinking that I could use exec() to 'cat' the contents of the file, >>>> storing stdout in an AVP, and then work through that array splitting >>>> letter and number with a string transformation ready for cache_store(). >>>> However, if I do this the full file contents are stored as a single string >>>> in the first value with "#012" added in place of the new lines. >>>> >>>> Obviously, I can use a string transform s.select{} using #012 as a >>>> delimiter in an intermediary step, but am I just doing this the hard way? >>>> Is there a better way to achieve this? >>>> _______________________________________________ >>>> Users mailing list >>>> [email protected] >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> -- >>> VoIP Embedded, Inc. >>> http://www.voipembedded.com >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
