Kamailio : kamctl address reload with HAProxy - sr-users

25 Mar 2022

Dear colleagues,

I've installed a Galera cluster with a HAProxy that kamailio interacts
with.
Kamailio's DBURL is linked to the proxy that will contact the databases.
Kamailio works fine except when I need to reload something from the
database (Using kamctl).

When cache and database are the same I receive

sudo kamctl address reload
...
  {
   "jsonrpc":  "2.0",
   "result": "Reload OK",
   "id": 13111
 } 

Now when I have something using kamctl, it still works and is replaced on
all my databases.

sipsecure@kamailio:~$ sudo kamctl address add 0 192.168.48.15 32 0 Test
...
  -e \E[37;33mINFO: execute '/sbin/kamctl address
reload' to synchronize
 cache and database 

 Then when i try to reload i receive

sipsecure@kamailio:~$ sudo kamctl address reload
...
  {
   "jsonrpc":  "2.0",
   "error":  {
     "code": 500,
     "message":  "Reload failed."
   },
   "id": 13504
 } 

And when I'm going to read my logs to see a error, I only see that little
sentence

Mar 25 17:14:40 kamailio /usr/sbin/kamailio[13343]: ERROR: permissions
...
  [address.c:233]: reload_address_db_table(): database
problem - invalid
 record 

Could I have some explanation ?

Thank you.

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>