Hi, Mehdi!
Unfortunately there's no way you could fetch the cached values, as these
are only loaded _after_ the startup_route is ran. So even if you go over
MI to the MI interface, you will still not get the value.
You may try to set the sql_cacher in an on_demand mode.
Best regards,
Răzvan
On 9/21/19 4:27 PM, Mehdi Shirazi wrote:
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 <[email protected]
<mailto:[email protected]>> 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
<[email protected] <mailto:[email protected]>> 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 list
[email protected] <mailto:[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
--
Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
