Hello,

it is not taking so long to load the records, there is a limit related to how often the reload commands can be executed:

  - https://www.kamailio.org/docs/modules/stable/modules/permissions.html#permissions.p.reload_delta

It is by design for safety reasons. If you do need reloading very often, it might be just better to match with sql query (sqlops) directly over the database table records.

Cheers,
Daniel

On 05.09.23 10:19, Martin Nyström wrote:

Hey OEJ 😊

 

Yes, the message returned should be updated. However, before resorting to htables I am still curious why it would take ~8 seconds to load my 4-row large, trusted table from db.

Is there a way I can troubleshoot this further? I’ve solved this temporary with a queue for the rpc requests.

 

 

 

/M

 

From: Olle E. Johansson <oej@edvina.net>
Date: Tuesday, 5 September 2023 at 09:13
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] Re: kamcmd reload is slow or blocking additional reloads

CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

 

 



On 4 Sep 2023, at 15:46, Martin Nyström <martin.nystrom@connectel.se> wrote:

 

Hello,

 

Hi Martin :-) !



Running ”kamcmd permissions.trustedReload” it instantly returns “Reload OK” but I cannot repeat the reload for about 8 seconds. This is the same for dialplan.reload and dispatcher.reload.

 

root@superman.local:/# kamcmd permissions.trustedReload

Reload OK

That message should propably be changed to “Reload initiated OK"

root@superman.local:/# kamcmd permissions.trustedReload

error: 500 - ongoing reload

root@superman.local:/# kamcmd permissions.trustedReload

error: 500 - ongoing reload

 

There are scenarios where I might need to reload the permission table multiple times within this 8 second window. Is this some kind of intended block or is something at fault?

 

modparam("db_mysql", "ping_interval", 60)

modparam("db_mysql", "timeout_interval", 4)

modparam("db_mysql", "auto_reconnect", 1)

modparam("db_mysql", "opt_ssl_mode", 0)

modparam("permissions", "db_url", "mysql://kamailio:xxxxx@aws-rds-database /kamailio")

 

version: kamailio 5.7.1 (x86_64/linux) 

flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, MEM_JOIN_FREE, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED

ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB

poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.

id: unknown 

compiled with gcc 10.2.1

 

 

Maybe think about using htables instead as you can manipulate them easier.

 

We may want a way to check last reload of trusted table in order to confirm that it was loaded ok. 

 

/O


__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to sr-users-leave@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:



-- 
Daniel-Constantin Mierla (@ asipto.com)
twitter.com/miconda -- linkedin.com/in/miconda
Kamailio Consultancy - Training Services -- asipto.com
Kamailio World Conference - kamailioworld.com