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| [email protected]
>
>
>
> *De :*sr-users <[email protected]> *De la part de*
> Soltanici Ilie
> *Envoyé :* mercredi 22 août 2018 13:52
> *À :* [email protected]
> *Cc :* Kamailio (SER) - Users Mailing List <[email protected]>
> *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
> <[email protected] <mailto:[email protected]>>:
>
> 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 <[email protected]>
> <file://e.mail.ru/compose/%3fmailto=mailto%[email protected]>:
>
> 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
> [email protected]
> <file://e.mail.ru/compose/%3fmailto=mailto%[email protected]>
>
>
>
> --
>
> 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
> [email protected] <mailto:[email protected]>
>
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
_______________________________________________
Kamailio (SER) - Users Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
