<HTML><BODY>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, Arial, sans-serif; text-align: justify;" data-mce-style="font-family: Helvetica, Arial, sans-serif; text-align: justify;">eload hash table from database."</span><br>Thank You<br><br><br><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <miconda@gmail.com>:<br>
<br>
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div>
<base target="_self" href="https://e.mail.ru/">
<div id="style_15349348210000000805_BODY"><div class="class_1534956326">
<p>Hello,</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.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix_mailru_css_attribute_postfix">On 21.08.18 19:06, Soltanici Ilie
wrote:<br>
</div>
<blockquote type="cite" cite="mid:1534871219.215428486@f499.i.mail.ru">
Hi Daniel,<br>
<br>
No, it is not.<br>
<br>
modparam("htable", "htable", "auth=>size=8;autoexpire=300;")<br>
<br>
<br>
<br>
<blockquote style="border-left:1px solid #0857A6;margin:10px;padding:0 0 0 10px;"> Вторник, 21 августа 2018, 8:07 +01:00 от
Daniel-Constantin Mierla <a class="moz-txt-link-rfc2396E_mailru_css_attribute_postfix" href="//e.mail.ru/compose/?mailto=mailto%3amiconda@gmail.com" target="_blank" rel=" noopener noreferrer"><miconda@gmail.com></a>:<br>
<br>
<div id="">
<div class="js-helper_mailru_css_attribute_postfix js-readmsg-msg_mailru_css_attribute_postfix">
<style></style>
<div>
<div id="style_15348352480000000327_BODY_mailru_css_attribute_postfix">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" rel=" noopener noreferrer">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" rel=" noopener noreferrer">www.asipto.com</a><br>
<a href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true" rel=" noopener noreferrer">www.twitter.com/miconda</a> --
<a href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true" rel=" noopener noreferrer">www.linkedin.com/in/miconda</a><br>
Kamailio World Conference -- <a href="http://www.kamailioworld.com" target="_blank" moz-do-not-send="true" rel=" noopener noreferrer">www.kamailioworld.com</a><br>
<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<br>
С уважением,<br>
Ilie Soltanici<br>
<a class="moz-txt-link-abbreviated_mailru_css_attribute_postfix" href="//e.mail.ru/compose/?mailto=mailto%3ailiesh@mail.ru" target="_blank" rel=" noopener noreferrer">iliesh@mail.ru</a><br>
</blockquote>
<br>
<pre class="moz-signature_mailru_css_attribute_postfix" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated_mailru_css_attribute_postfix" href="http://www.asipto.com" target="_blank" rel=" noopener noreferrer">www.asipto.com</a>
<a class="moz-txt-link-abbreviated_mailru_css_attribute_postfix" href="http://www.twitter.com/miconda" target="_blank" rel=" noopener noreferrer">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated_mailru_css_attribute_postfix" href="http://www.linkedin.com/in/miconda" target="_blank" rel=" noopener noreferrer">www.linkedin.com/in/miconda</a>
Kamailio World Conference -- <a class="moz-txt-link-abbreviated_mailru_css_attribute_postfix" href="http://www.kamailioworld.com" target="_blank" rel=" noopener noreferrer">www.kamailioworld.com</a></pre>
</div></div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote> <br>
<br>С уважением,<br>Ilie Soltanici<br>iliesh@mail.ru<br></BODY></HTML>