Hello,
in your email you have htable defined with dbtable attribute, like one pasted next, which I grabbed from the link you provided:
modparam("htable", "htable", "mbxrangeHash=>size=4;dbtable=mbxrange;")
So it is not the same case.
The dbtable attribute should be listed in the section documenting htable parameter. Or, were you asking something else?
Cheers, Daniel
On 23.08.18 16:07, Ginhoux, Patrick wrote:
Hi Daniel,
May I ask you some questions about the htable reload problem ?
I reported a similar case that Henning and I have discussed (https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html). I solved it by adding a symlink as follows:
mkdir /var/lib/mysql
ln -s /myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
Here, you pointed about the htable auth defined with dbtable attribute in the config file.
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?
And do you think it could also fix my case ?
Thanks in advance for the help.
*Cordialement.*
*Patrick GINHOUX***
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74| patrick.ginhoux@unisys.com
*De :*sr-users sr-users-bounces@lists.kamailio.org *De la part de* Soltanici Ilie *Envoyé :* mercredi 22 août 2018 13:52 *À :* miconda@gmail.com *Cc :* Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org *Objet :* Re: [SR-Users] Fail to reload htable
Daniel,
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.
I didn't pay attention to this line from the documentation: "Reload hash table from database." Thank You
Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@gmail.com>>: Hello, 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. Cheers, Daniel On 21.08.18 19:06, Soltanici Ilie wrote: Hi Daniel, No, it is not. modparam("htable", "htable", "auth=>size=8;autoexpire=300;") Вторник, 21 августа 2018, 8:07 +01:00 от Daniel-Constantin Mierla <miconda@gmail.com> <file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com>: Hello, is the htable auth defined with dbtable attribute? Cheers, Daniel On 20.08.18 21:04, Henning Westerholt wrote: > Am Montag, 20. August 2018, 20:58:43 CEST schrieb Soltanici Ilie: >> In the logs, I see these errors: >> >> ERROR: <core> [db.c:463]: db_use_table(): invalid parameter value >> Aug 20 19:56:41 kamailio[12716]: ERROR: <core> [db.c:463]: db_use_table(): >> invalid parameter value Aug 20 19:56:41 kamailio[12716]: ERROR: htable >> [ht_db.c:211]: ht_db_load_table(): failed to use_table > Hi, > > please keep the list in CC. > > This error is related to a database issue. Please double check if there are > any issues during startup in the log. Do you see any other error there? > > A similar (not 100% identical) issue was discussed recently here: > > https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html > > Maybe this helps you as well. > > Best regards, > > Henning > -- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com> С уважением, Ilie Soltanici iliesh@mail.ru <file://e.mail.ru/compose/%3fmailto=mailto%253ailiesh@mail.ru> -- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>С уважением, Ilie Soltanici iliesh@mail.ru mailto:iliesh@mail.ru