<div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hi<br></div>Is there a way to see content of sql_cacher loaded inside of cachedb_local with "mi cache_fetch" command ?<br><pre><code>Regards<br></code></pre><pre><code>M.Shirazi<br></code></pre></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Sep 16, 2019 at 6:23 PM Mehdi Shirazi <<a href="mailto:m.shirazi@gmail.com">m.shirazi@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi<br clear="none"><div dir="ltr">Thanks for reply.<br clear="none"></div></div>
        inside main route it was working ok but inside <span>startup_route (2.4.6 and 3.0) not worki</span>ng.<br clear="none">Regards<br clear="none">M.Shirazi</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Sep 12, 2019 at 8:16 PM Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF">
    <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 cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a href="https://www.opensips-solutions.com" target="_blank">https://www.opensips-solutions.com</a>
OpenSIPS Summit 2019
  <a href="https://www.opensips.org/events/Summit-2019Amsterdam/" target="_blank">https://www.opensips.org/events/Summit-2019Amsterdam/</a>
</pre>
    <div>On 8/30/19 10:12 AM, Mehdi Shirazi
      wrote:<br>
    </div>
    <blockquote type="cite">
      
      <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></fieldset>
      <pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </div>

</blockquote></div>
</blockquote></div>