[SR-Users] Fail to reload htable

[Daniel-Constantin Mierla]

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 at unisys.com
>
>  
>
> *De :*sr-users <sr-users-bounces at lists.kamailio.org> *De la part de*
> Soltanici Ilie
> *Envoyé :* mercredi 22 août 2018 13:52
> *À :* miconda at gmail.com
> *Cc :* Kamailio (SER) - Users Mailing List <sr-users at 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 at gmail.com <mailto:miconda at 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 at 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 at 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 at mail.ru <mailto:iliesh at mail.ru>
>

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180823/9a35ae34/attachment.html>