<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>HI Mehdi,<br>
<br>
Do you get that error only when using it from startup_route ?<br>
<br>
Also, try to change the cachedb_url to "local:///collection2"<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Summit 2019
<a class="moz-txt-link-freetext" href="https://www.opensips.org/events/Summit-2019Amsterdam/">https://www.opensips.org/events/Summit-2019Amsterdam/</a>
</pre>
<div class="moz-cite-prefix">On 8/30/19 10:12 AM, Mehdi Shirazi
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAG2rjps72o=413J8_DufzWGqX+G83b_ZtBOMf599HdY5VyeCNw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi<br>
Please help me configuring sql_cacher.<br>
I use Opensips 2.4.6 .<br>
modparam("cachedb_local", "cachedb_url",
"local:group2:///collection2")<br>
modparam("sql_cacher", "cache_table",<br>
"id=st_caching<br>
db_url=mysql://opensips:1234ms@localhost/opensips<br>
cachedb_url=local:group2:///collection2<br>
table=STrig<br>
key=number<br>
columns=cause")<br>
startup_route {<br>
xlog("The cause is
$sql_cached_value(st_caching:cause:88443322)");<br>
}<br>
in log:<br>
ERROR:sql_cacher:get_rld_vers_from_cache: Failed to get reload
version integer from cachedb<br>
ERROR:sql_cacher:pv_get_sql_cached_value: Error fetching from
cachedb<br>
<br>
Regards<br>
M.Shirazi<br>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>