<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1744909144;
mso-list-type:hybrid;
mso-list-template-ids:-1321562254 804146000 873070595 873070597 873070593 873070595 873070597 873070593 873070595 873070597;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style></head><body lang="ES-CL" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal">Hi.</p><p class="MsoNormal"><span lang="EN-US">I’m trying to set up an environment where I can fetch data from a local mysql database at startup and have it available for opensips in cached memory. So far I think the SQL_CACHER module can do this operation. But I’m getting a little bit confused in the configuration. So far in the exported parameter “cache_table” I have:</span></p><ul style="margin-top:0cm" type="disc"><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">id </span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">db_url</span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">cachedb_url</span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">table</span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">key</span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">columns</span></li><li class="MsoListParagraph" style="margin-left:0cm"><span lang="EN-US">on_demand</span></li></ul><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">In the DB_URL I have the SQL database where I store the date I want to fetch for later use.</span></p><p class="MsoNormal"><span lang="EN-US">But I’m confused with the CACHEDB_URL ? What’s the idea of this DB?. I’m getting the data from the DB_URL, but then I have to store it in this CACHEDB???... If so… can I use another table in the same SQL database?.. or I need to use another method?. Can someone help me understand the whole picture here?.</span></p><p class="MsoNormal"><span lang="EN-US">In case I need to set up this “cachedb_url” what is recommended?... and how to set up?</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US">Thanks in advance!</span></p><p class="MsoNormal"><span lang="EN-US">Best Regards,</span></p><p class="MsoNormal"><span lang="EN-US">Ricardo Martinez.-</span></p><p class="MsoNormal"><span lang="EN-US"> </span></p><p class="MsoNormal"><span lang="EN-US"> </span></p></div></body></html>