Re: [OpenSIPS-Users] variable/avp value check

2024-02-13 Thread Ben Newlin
: Users on behalf of Alexey Date: Tuesday, February 13, 2024 at 1:55 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] variable/avp value check EXTERNAL EMAIL - Please use caution with links and attachments Hi Ben, thank you for your response but this is not the case. Documentation

Re: [OpenSIPS-Users] variable/avp value check

2024-02-13 Thread Alexey
Hi Ben, thank you for your response but this is not the case. Documentation says: 'columns : If not present, all the columns from the table will be cached'. So in our case all columns from the DB are cached. Our main question - How does '$sql_cached_value(id{sep}col{sep}key)' work ? We want that

Re: [OpenSIPS-Users] variable/avp value check

2024-02-12 Thread Ben Newlin
: Monday, February 12, 2024 at 1:23 AM To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] variable/avp value check EXTERNAL EMAIL - Please use caution with links and attachments Hi list, We implemented next config: # cachedb module loadmodule "cachedb_local.so" modparam(&quo

Re: [OpenSIPS-Users] variable/avp value check

2024-02-12 Thread Alexey
Hi list, We implemented next config: # cachedb module loadmodule "cachedb_local.so" modparam("cachedb_local", "cachedb_url", "local:///my_cache") modparam("cachedb_local", "cache_collections", "my_cache") # sql_cacher module loadmodule "sql_cacher.so" modparam("sql_cacher", "cache_table", "id=my

Re: [OpenSIPS-Users] variable/avp value check

2024-02-09 Thread Ben Newlin
, February 9, 2024 at 12:46 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] variable/avp value check EXTERNAL EMAIL - Please use caution with links and attachments Hi list, the problem was solved. Highlights: 1. Select data from DB using timer_route with timeout (for regular

Re: [OpenSIPS-Users] variable/avp value check

2024-02-09 Thread Alexey
Hi list, the problem was solved. Highlights: 1. Select data from DB using timer_route with timeout (for regular data updates) and store it in AVP. This AVP is seen in timer_route only. So, put all its values into the local_cache (with the same timeout), to be able to use it in the main route. t

Re: [OpenSIPS-Users] variable/avp value check

2024-02-07 Thread Ben Newlin
You should look at the SQL Cacher module: https://opensips.org/docs/modules/3.2.x/sql_cacher.html Ben Newlin From: Users on behalf of Alexey Date: Wednesday, February 7, 2024 at 11:13 AM To: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] variable/avp value check EXTERNAL EMAIL

Re: [OpenSIPS-Users] variable/avp value check

2024-02-07 Thread Alexey
for each [1] statement seems to be what I need [1] https://www.opensips.org/Documentation/Script-Statements-3-2#toc4 -- best regards, Alexey https://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-b