[SR-Users] Fail to reload htable

Thu Aug 23 16:30:30 CEST 2018

Hi,

Well, my mistake, I thought it was the ‘auth’ attribute that you mentioned .

Cordialement.

Patrick GINHOUX 

Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux at unisys.com

De : Daniel-Constantin Mierla <miconda at gmail.com> 
Envoyé : jeudi 23 août 2018 16:20
À : Ginhoux, Patrick <patrick.ginhoux at fr.unisys.com>
Cc : Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>; Soltanici Ilie <iliesh at mail.ru>; Henning Westerholt <hw at kamailio.org>
Objet : Re: [SR-Users] Fail to reload htable

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 <mailto:patrick.ginhoux at unisys.com> 

De : sr-users  <mailto:sr-users-bounces at lists.kamailio.org> <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 <mailto:miconda at gmail.com> 
Cc : Kamailio (SER) - Users Mailing List  <mailto:sr-users at lists.kamailio.org> <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  <file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com> <miconda at 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 <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> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180823/ee9dff69/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 7876 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180823/ee9dff69/attachment.bin>