[OpenSIPS-Users] sql_cacher with cachedb_local

[Mehdi Shirazi]

Hi
Is there a way to see content of sql_cacher loaded inside of cachedb_local
with "mi cache_fetch" command ?

Regards

M.Shirazi


On Mon, Sep 16, 2019 at 6:23 PM Mehdi Shirazi <m.shirazi at gmail.com> wrote:

> Hi
> Thanks for reply.
> inside main route it was working ok but inside startup_route (2.4.6 and
> 3.0) not working.
> Regards
> M.Shirazi
>
> On Thu, Sep 12, 2019 at 8:16 PM Bogdan-Andrei Iancu <bogdan at opensips.org>
> wrote:
>
>> HI Mehdi,
>>
>> Do you get that error only when using it from startup_route ?
>>
>> Also, try to change the cachedb_url to "local:///collection2"
>>
>> Regards,
>>
>> Bogdan-Andrei Iancu
>>
>> OpenSIPS Founder and Developer
>>   https://www.opensips-solutions.com
>> OpenSIPS Summit 2019
>>   https://www.opensips.org/events/Summit-2019Amsterdam/
>>
>> On 8/30/19 10:12 AM, Mehdi Shirazi wrote:
>>
>> Hi
>> Please help me configuring sql_cacher.
>> I use Opensips 2.4.6 .
>> modparam("cachedb_local", "cachedb_url", "local:group2:///collection2")
>> modparam("sql_cacher", "cache_table",
>> "id=st_caching
>> db_url=mysql://opensips:1234ms@localhost/opensips
>> cachedb_url=local:group2:///collection2
>> table=STrig
>> key=number
>> columns=cause")
>> startup_route {
>>     xlog("The cause is $sql_cached_value(st_caching:cause:88443322)");
>>     }
>> in log:
>> ERROR:sql_cacher:get_rld_vers_from_cache: Failed to get reload version
>> integer from cachedb
>> ERROR:sql_cacher:pv_get_sql_cached_value: Error fetching from cachedb
>>
>> Regards
>> M.Shirazi
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190921/76eefbd5/attachment.html>