<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>in your email you have htable defined with dbtable attribute,
like one pasted next, which I grabbed from the link you provided:</p>
<pre style="white-space: pre-wrap; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">modparam("htable", "htable", "mbxrangeHash=>size=4;dbtable=mbxrange;")
</pre>
<br>
So it is not the same case.<br>
<br>
The dbtable attribute should be listed in the section documenting
htable parameter. Or, were you asking something else?<br>
<br>
Cheers,<br>
Daniel<br class="Apple-interchange-newline">
<br>
<div class="moz-cite-prefix">On 23.08.18 16:07, Ginhoux, Patrick
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CY1PR07MB2489337833F8230B7C221DA3B6370@CY1PR07MB2489.namprd07.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<base href="https://e.mail.ru/" target="_self">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Texte brut Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:Consolas;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.TextebrutCar
{mso-style-name:"Texte brut Car";
mso-style-priority:99;
mso-style-link:"Texte brut";
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">Hi Daniel,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">May I ask you some questions about the htable
reload problem ?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US">I
reported a similar case that Henning and I have discussed (</span><span
lang="EN-US"><a
href="https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html"
moz-do-not-send="true">https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html</a></span><span
style="color:#1F497D" lang="EN-US">). I solved it by adding
a symlink as follows:<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span
lang="EN-US">mkdir /var/lib/mysql</span><span
style="color:#1F497D" lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:35.4pt"><span
lang="EN-US">ln -s /myqdata/mysiprdb/data/mysiprdb.sock
/var/lib/mysql/mysql.sock<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US">Here,
you pointed about the htable auth defined with dbtable
attribute in the config file.<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US">I
was looking at the documentation for the 5.0.7 level but I
don’t find the reference of this settings. Can you show me
where it is documented?<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US">And
do you think it could also fix my case ?<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:#1F497D" lang="EN-US">Thanks
in advance for the help.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<div
style="mso-element:para-border-div;border:none;border-top:solid
#CCCCCC 1.0pt;padding:4.0pt 0cm 0cm 0cm">
<p class="MsoNormal"
style="margin-bottom:3.0pt;border:none;padding:0cm"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444"
lang="FR-BE">Cordialement.<o:p></o:p></span></b></p>
<p class="MsoNormal"
style="margin-bottom:3.0pt;border:none;padding:0cm"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444"
lang="FR-BE">Patrick GINHOUX</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444"
lang="FR-BE"> <b><o:p></o:p></b></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:3.0pt"><span
style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444"
lang="FR-BE">Unisys | +33 1 46 69 52 12 </span><span
style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444">|
+33 6 60 32 24 74</span><span
style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444">
</span><span
style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444">|
<a class="moz-txt-link-abbreviated" href="mailto:patrick.ginhoux@unisys.com">patrick.ginhoux@unisys.com</a></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
sr-users <a class="moz-txt-link-rfc2396E" href="mailto:sr-users-bounces@lists.kamailio.org"><sr-users-bounces@lists.kamailio.org></a> <b>De
la part de</b> Soltanici Ilie<br>
<b>Envoyé :</b> mercredi 22 août 2018 13:52<br>
<b>À :</b> <a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a><br>
<b>Cc :</b> Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.kamailio.org"><sr-users@lists.kamailio.org></a><br>
<b>Objet :</b> Re: [SR-Users] Fail to reload htable<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Daniel,<br>
<br>
I need to reload a hash table to clear all records without
waiting before they will expire. I can delete them all one by
one with htable.delete - or make a loop with htable.dump and
then delete them - but I was thinking that the same can be
achieved by htable.reload command.<br>
<br>
I didn't pay attention to this line from the documentation: "R<span
style="font-family:"Helvetica",sans-serif">eload
hash table from database."</span><br>
Thank You<br>
<br>
<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #0857A6
1.0pt;padding:0cm 0cm 0cm
8.0pt;margin-left:7.5pt;margin-top:7.5pt;margin-right:7.5pt;margin-bottom:7.5pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">Среда, 22
августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <<a
href="mailto:miconda@gmail.com" moz-do-not-send="true">miconda@gmail.com</a>>:<o:p></o:p></p>
<div id="">
<div>
<div>
<div id="style_15349348210000000805_BODY">
<div>
<p>Hello,<o:p></o:p></p>
<p>then there is no database table from where to
reload -- why you issue a reload in this case? It
should be done only when writing records to
database table and then you want them to be loaded
in memory.<o:p></o:p></p>
<p>Cheers,<br>
Daniel<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 21.08.18 19:06, Soltanici
Ilie wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi
Daniel,<br>
<br>
No, it is not.<br>
<br>
modparam("htable", "htable",
"auth=>size=8;autoexpire=300;")<br>
<br>
<br>
<o:p></o:p></p>
<blockquote style="border:none;border-left:solid
#0857A6 1.0pt;padding:0cm 0cm 0cm
8.0pt;margin-left:7.5pt;margin-top:7.5pt;margin-right:7.5pt;margin-bottom:7.5pt">
<p class="MsoNormal"
style="margin-bottom:12.0pt">Вторник, 21
августа 2018, 8:07 +01:00 от Daniel-Constantin
Mierla <a
href="file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com"
target="_blank" moz-do-not-send="true"><miconda@gmail.com></a>:<o:p></o:p></p>
<div id="">
<div>
<div>
<div
id="style_15348352480000000327_BODY_mailru_css_attribute_postfix">
<p class="MsoNormal"
style="margin-bottom:12.0pt">Hello,<br>
<br>
is the htable auth defined with
dbtable attribute?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
On 20.08.18 21:04, Henning Westerholt
wrote:<br>
> Am Montag, 20. August 2018,
20:58:43 CEST schrieb Soltanici Ilie:<br>
>> In the logs, I see these
errors:<br>
>><br>
>> ERROR: <core>
[db.c:463]: db_use_table(): invalid
parameter value<br>
>> Aug 20 19:56:41
kamailio[12716]: ERROR: <core>
[db.c:463]: db_use_table():<br>
>> invalid parameter value Aug
20 19:56:41 kamailio[12716]: ERROR:
htable<br>
>> [ht_db.c:211]:
ht_db_load_table(): failed to
use_table<br>
> Hi,<br>
><br>
> please keep the list in CC.<br>
><br>
> This error is related to a
database issue. Please double check if
there are <br>
> any issues during startup in the
log. Do you see any other error there?<br>
><br>
> A similar (not 100% identical)
issue was discussed recently here:<br>
><br>
> <a
href="https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html"
target="_blank"
moz-do-not-send="true">https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html</a><br>
><br>
> Maybe this helps you as well.<br>
><br>
> Best regards,<br>
><br>
> Henning<br>
><br>
<br>
-- <br>
Daniel-Constantin Mierla -- <a
href="http://www.asipto.com"
target="_blank"
moz-do-not-send="true">www.asipto.com</a><br>
<a
href="http://www.twitter.com/miconda"
target="_blank"
moz-do-not-send="true">www.twitter.com/miconda</a>
-- <a
href="http://www.linkedin.com/in/miconda"
target="_blank"
moz-do-not-send="true">www.linkedin.com/in/miconda</a><br>
Kamailio World Conference -- <a
href="http://www.kamailioworld.com"
target="_blank"
moz-do-not-send="true">www.kamailioworld.com</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</blockquote>
<p class="MsoNormal"><br>
<br>
С уважением,<br>
Ilie Soltanici<br>
<a
href="file://e.mail.ru/compose/%3fmailto=mailto%253ailiesh@mail.ru"
target="_blank" moz-do-not-send="true">iliesh@mail.ru</a><o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank" moz-do-not-send="true">www.asipto.com</a><o:p></o:p></pre>
<pre><a href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a><o:p></o:p></pre>
<pre>Kamailio World Conference -- <a href="http://www.kamailioworld.com" target="_blank" moz-do-not-send="true">www.kamailioworld.com</a><o:p></o:p></pre>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p class="MsoNormal"><br>
<br>
С уважением,<br>
Ilie Soltanici<br>
<a href="mailto:iliesh@mail.ru" moz-do-not-send="true">iliesh@mail.ru</a><o:p></o:p></p>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio World Conference -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
</body>
</html>