<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><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;
color:black;}
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;
color:black;
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;
color:black;}
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";
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
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;
color:black;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:Consolas;}
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;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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]--></head><body bgcolor=white lang=FR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Well, my mistake, I thought it was the ‘auth’ attribute that you mentioned .<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language: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 lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'>Cordialement.<o:p></o:p></span></b></p><p class=MsoNormal style='margin-bottom:3.0pt;border:none;padding:0cm'><b><span lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'>Patrick GINHOUX</span></b><span lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'> <b><o:p></o:p></b></span></p></div><p class=MsoNormal style='margin-bottom:3.0pt'><span lang=FR-BE style='font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444'>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'>| patrick.ginhoux@unisys.com</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;color:windowtext'>De :</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Daniel-Constantin Mierla <miconda@gmail.com> <br><b>Envoyé :</b> jeudi 23 août 2018 16:20<br><b>À :</b> Ginhoux, Patrick <patrick.ginhoux@fr.unisys.com><br><b>Cc :</b> Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>; Soltanici Ilie <iliesh@mail.ru>; Henning Westerholt <hw@kamailio.org><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>Hello,<o:p></o:p></p><p>in your email you have htable defined with dbtable attribute, like one pasted next, which I grabbed from the link you provided:<o:p></o:p></p><pre style='white-space:pre-wrap;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px'>modparam("htable", "htable", "mbxrangeHash=>size=4;dbtable=mbxrange;")<o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><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<o:p></o:p></p><div><p class=MsoNormal>On 23.08.18 16:07, Ginhoux, Patrick wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi Daniel,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>May I ask you some questions about the htable reload problem ?</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'>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">https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html</a></span><span lang=EN-US style='color:#1F497D'>). I solved it by adding a symlink as follows:</span><o:p></o:p></p><p class=MsoPlainText style='margin-left:35.4pt'><span lang=EN-US>mkdir /var/lib/mysql</span><o:p></o:p></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</span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US> </span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'>Here, you pointed about the htable auth defined with dbtable attribute in the config file.</span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'>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?</span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'>And do you think it could also fix my case ?</span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoPlainText><span lang=EN-US style='color:#1F497D'>Thanks in advance for the help.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #CCCCCC 1.0pt;padding:4.0pt 0cm 0cm 0cm'><p class=MsoNormal style='margin-bottom:3.0pt'><b><span lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'>Cordialement.</span></b><o:p></o:p></p><p class=MsoNormal style='margin-bottom:3.0pt'><b><span lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'>Patrick GINHOUX</span></b><span lang=FR-BE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#444444'> </span><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:3.0pt'><span lang=FR-BE style='font-size:9.0pt;font-family:"Calibri",sans-serif;color:#444444'>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 | <a href="mailto:patrick.ginhoux@unisys.com">patrick.ginhoux@unisys.com</a></span><o:p></o:p></p></div><p class=MsoNormal><span style='mso-fareast-language:EN-US'> </span><o:p></o:p></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 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 href="mailto:miconda@gmail.com">miconda@gmail.com</a><br><b>Cc :</b> Kamailio (SER) - Users Mailing List <a href="mailto:sr-users@lists.kamailio.org"><sr-users@lists.kamailio.org></a><br><b>Objet :</b> Re: [SR-Users] Fail to reload htable</span><o:p></o:p></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><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">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><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"><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">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">www.asipto.com</a><br><a href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a><br>Kamailio World Conference -- <a href="http://www.kamailioworld.com" target="_blank">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">iliesh@mail.ru</a><o:p></o:p></p></blockquote><p class=MsoNormal><br><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">www.asipto.com</a><o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio World Conference -- <a href="http://www.kamailioworld.com" target="_blank">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">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">www.asipto.com</a><o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio World Conference -- <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre></div></body></html>