Hello,
please keep the list in CC – that others can comment as well.
Can you actually connect from the kamailio system e.g. with mysql client? If yes, as I said – I would try to debug the issue further with network analysis tools.
Cheers,
Henning
-- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.comhttps://gilawa.com/
From: Paclinio thomas.leutscher@gmail.com Sent: Monday, March 28, 2022 1:11 PM To: Henning Westerholt hw@gilawa.com Subject: Re: [SR-Users] Kamailio : kamctl address reload with HAProxy
Hello,
KAMCTL :
I've resolved the problem with kamctl that now can communicate with my remote Cluster by adding this line in kamctlrc.
// HAPROXY = 192.168.1.37 DBHOST=192.168.1.37 DBACCESSHOST=192.168.1.37
I can now add and reload new addresses with success.
KAMAILIO + HAPROXY:
But now, I've this issue when restarting kamailio.
Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [address.c:233]: reload_address_db_table(): database problem - invalid record Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [permissions.c:657]: mod_init(): failed to initialize the allow_address function Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module permissions (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so)
My DBURL is
#!substdef "!DB_USER!kamailio!g" #!substdef "!DB_PASS!XXXXX!g" #!substdef "!DB_HOST!192.168.1.37!g" // HA PROXY #!substdef "!DB_PORT!MY_PORT_DB!g" #!substdef "!DB_NAME!kamailio!g"
#!define DBURL "mysql://DB_USER:DB_PASS@DB_HOST/DB_NAME"
KAMAILIO + REMOTE DB :
Even I using a remote database I'm getting the same issue. I've discovered the connection between kamailio and remote database is aborded instantly after restarting kamailio.
Mar 28 11:47:30 db03srv mariadbd[874]: 2022-03-28 11:47:30 44076 [Warning] Aborted connection 44076 to db: 'kamailio' user: 'kamailio' host: '192.168.1.41' (Got an error reading communication packets)
Thank you
[Das Bild wurde vom Absender entfernt.]https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.comhttps://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
Le dim. 27 mars 2022 à 22:52, Henning Westerholt <hw@gilawa.commailto:hw@gilawa.com> a écrit : Hello,
it seems the data that gets delivered to the Kamailio is corrupted. Analyse it further e.g. with a network trace, wireshark etc..
Cheers,
Henning
-- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.comhttps://gilawa.com/
From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Paclinio Sent: Friday, March 25, 2022 5:22 PM To: sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org Subject: [SR-Users] Kamailio : kamctl address reload with HAProxy
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.
[Das Bild wurde vom Absender entfernt.]https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail Virus-free. www.avast.comhttps://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
Hello,
*KAMCTL :*
I've resolved the problem with kamctl that now can communicate with my remote Cluster by adding this line in kamctlrc. But Kamailio doesn't start.
// HAPROXY = 192.168.1.37
DBHOST=192.168.1.37
DBACCESSHOST=192.168.1.37
I can now add and reload new addresses with success.
*KAMAILIO + HAPROXY:*
But now, I've this issue when restarting kamailio.
Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions
[address.c:233]: reload_address_db_table(): database problem - invalid record Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [permissions.c:657]: mod_init(): failed to initialize the allow_address function Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module permissions (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so)
My DBURL is
#!substdef "!DB_USER!kamailio!g"
#!substdef "!DB_PASS!XXXXX!g" #!substdef "!DB_HOST!192.168.1.37!g" // HA PROXY #!substdef "!DB_PORT!MY_PORT_DB!g" #!substdef "!DB_NAME!kamailio!g"
#!define DBURL "mysql://DB_USER:DB_PASS@DB_HOST/DB_NAME"
*KAMAILIO + REMOTE DB :*
Even I using a remote database I'm getting the same issue. I've discovered the connection between kamailio and remote database is aborded instantly after restarting kamailio.
Mar 28 11:47:30 db03srv mariadbd[874]: 2022-03-28 11:47:30 44076 [Warning]
Aborted connection 44076 to db: 'kamailio' user: 'kamailio' host: '192.168.1.41' (Got an error reading communication packets)
*RECREATING DATABASE : *
Now I've dropped all my database to recreate a new one by using "kamdbctl create". I've GRANT all privileges to my root remote user.
GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.37 WITH GRANT OPTION;
But I receive this error message when creating.
$ sudo kamdbctl create
-e \E[37;33mINFO: creating database kamailio ... -e \E[37;33mINFO: granting privileges to database kamailio ... ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailio'@ '192.168.1.37' ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailioro'@'192.168.1.37' -e \E[37;31mERROR: granting access host privileges to database kamailio failed!
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>
Le lun. 28 mars 2022 à 13:34, Henning Westerholt hw@gilawa.com a écrit :
Hello,
please keep the list in CC – that others can comment as well.
Can you actually connect from the kamailio system e.g. with mysql client? If yes, as I said – I would try to debug the issue further with network analysis tools.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
*From:* Paclinio thomas.leutscher@gmail.com *Sent:* Monday, March 28, 2022 1:11 PM *To:* Henning Westerholt hw@gilawa.com *Subject:* Re: [SR-Users] Kamailio : kamctl address reload with HAProxy
Hello,
*KAMCTL :*
I've resolved the problem with kamctl that now can communicate with my remote Cluster by adding this line in kamctlrc.
// HAPROXY = 192.168.1.37
DBHOST=192.168.1.37
DBACCESSHOST=192.168.1.37
I can now add and reload new addresses with success.
*KAMAILIO + HAPROXY:*
But now, I've this issue when restarting kamailio.
Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [address.c:233]: reload_address_db_table(): database problem - invalid record Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [permissions.c:657]: mod_init(): failed to initialize the allow_address function Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module permissions (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so)
My DBURL is
#!substdef "!DB_USER!kamailio!g" #!substdef "!DB_PASS!XXXXX!g" #!substdef "!DB_HOST!192.168.1.37!g" // HA PROXY #!substdef "!DB_PORT!MY_PORT_DB!g" #!substdef "!DB_NAME!kamailio!g"
#!define DBURL "mysql://DB_USER:DB_PASS@DB_HOST/DB_NAME"
*KAMAILIO + REMOTE DB :*
Even I using a remote database I'm getting the same issue.
I've discovered the connection between kamailio and remote database is aborded instantly after restarting kamailio.
Mar 28 11:47:30 db03srv mariadbd[874]: 2022-03-28 11:47:30 44076 [Warning] Aborted connection 44076 to db: 'kamailio' user: 'kamailio' host: '192.168.1.41' (Got an error reading communication packets)
Thank you
[image: Das Bild wurde vom Absender entfernt.] 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
Le dim. 27 mars 2022 à 22:52, Henning Westerholt hw@gilawa.com a écrit :
Hello,
it seems the data that gets delivered to the Kamailio is corrupted. Analyse it further e.g. with a network trace, wireshark etc..
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
*From:* sr-users sr-users-bounces@lists.kamailio.org *On Behalf Of * Paclinio *Sent:* Friday, March 25, 2022 5:22 PM *To:* sr-users@lists.kamailio.org *Subject:* [SR-Users] Kamailio : kamctl address reload with HAProxy
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.
[image: Das Bild wurde vom Absender entfernt.] 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
Yes I can connect to mysql server from my kamailio server using "root" and password.
Here's his privileges :
MariaDB [(none)]> SHOW GRANTS for root@192.168.1.37;
+-------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@192.168.1.37 |
+-------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO `root`@`192.168.1.37` IDENTIFIED BY PASSWORD '*55A5415CF2A42EEC2F8D75D210569A643AEC15B9' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
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>
Le lun. 28 mars 2022 à 13:51, Paclinio thomas.leutscher@gmail.com a écrit :
Hello,
*KAMCTL :*
I've resolved the problem with kamctl that now can communicate with my remote Cluster by adding this line in kamctlrc. But Kamailio doesn't start.
// HAPROXY = 192.168.1.37
DBHOST=192.168.1.37
DBACCESSHOST=192.168.1.37
I can now add and reload new addresses with success.
*KAMAILIO + HAPROXY:*
But now, I've this issue when restarting kamailio.
Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions
[address.c:233]: reload_address_db_table(): database problem - invalid record Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [permissions.c:657]: mod_init(): failed to initialize the allow_address function Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module permissions (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so)
My DBURL is
#!substdef "!DB_USER!kamailio!g"
#!substdef "!DB_PASS!XXXXX!g" #!substdef "!DB_HOST!192.168.1.37!g" // HA PROXY #!substdef "!DB_PORT!MY_PORT_DB!g" #!substdef "!DB_NAME!kamailio!g"
#!define DBURL "mysql://DB_USER:DB_PASS@DB_HOST/DB_NAME"
*KAMAILIO + REMOTE DB :*
Even I using a remote database I'm getting the same issue. I've discovered the connection between kamailio and remote database is aborded instantly after restarting kamailio.
Mar 28 11:47:30 db03srv mariadbd[874]: 2022-03-28 11:47:30 44076 [Warning]
Aborted connection 44076 to db: 'kamailio' user: 'kamailio' host: '192.168.1.41' (Got an error reading communication packets)
*RECREATING DATABASE : *
Now I've dropped all my database to recreate a new one by using "kamdbctl create". I've GRANT all privileges to my root remote user.
GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.37 WITH GRANT OPTION;
But I receive this error message when creating.
$ sudo kamdbctl create
-e \E[37;33mINFO: creating database kamailio ... -e \E[37;33mINFO: granting privileges to database kamailio ... ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailio'@ '192.168.1.37' ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailioro'@'192.168.1.37' -e \E[37;31mERROR: granting access host privileges to database kamailio failed!
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 <#m_4223648189801241987_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Le lun. 28 mars 2022 à 13:34, Henning Westerholt hw@gilawa.com a écrit :
Hello,
please keep the list in CC – that others can comment as well.
Can you actually connect from the kamailio system e.g. with mysql client? If yes, as I said – I would try to debug the issue further with network analysis tools.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
*From:* Paclinio thomas.leutscher@gmail.com *Sent:* Monday, March 28, 2022 1:11 PM *To:* Henning Westerholt hw@gilawa.com *Subject:* Re: [SR-Users] Kamailio : kamctl address reload with HAProxy
Hello,
*KAMCTL :*
I've resolved the problem with kamctl that now can communicate with my remote Cluster by adding this line in kamctlrc.
// HAPROXY = 192.168.1.37
DBHOST=192.168.1.37
DBACCESSHOST=192.168.1.37
I can now add and reload new addresses with success.
*KAMAILIO + HAPROXY:*
But now, I've this issue when restarting kamailio.
Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [address.c:233]: reload_address_db_table(): database problem - invalid record Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: permissions [permissions.c:657]: mod_init(): failed to initialize the allow_address function Mar 28 10:54:39 kamailio /usr/sbin/kamailio[8416]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module permissions (/usr/lib/x86_64-linux-gnu/kamailio/modules/permissions.so)
My DBURL is
#!substdef "!DB_USER!kamailio!g" #!substdef "!DB_PASS!XXXXX!g" #!substdef "!DB_HOST!192.168.1.37!g" // HA PROXY #!substdef "!DB_PORT!MY_PORT_DB!g" #!substdef "!DB_NAME!kamailio!g"
#!define DBURL "mysql://DB_USER:DB_PASS@DB_HOST/DB_NAME"
*KAMAILIO + REMOTE DB :*
Even I using a remote database I'm getting the same issue.
I've discovered the connection between kamailio and remote database is aborded instantly after restarting kamailio.
Mar 28 11:47:30 db03srv mariadbd[874]: 2022-03-28 11:47:30 44076 [Warning] Aborted connection 44076 to db: 'kamailio' user: 'kamailio' host: '192.168.1.41' (Got an error reading communication packets)
Thank you
[image: Das Bild wurde vom Absender entfernt.] 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
Le dim. 27 mars 2022 à 22:52, Henning Westerholt hw@gilawa.com a écrit :
Hello,
it seems the data that gets delivered to the Kamailio is corrupted. Analyse it further e.g. with a network trace, wireshark etc..
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
*From:* sr-users sr-users-bounces@lists.kamailio.org *On Behalf Of * Paclinio *Sent:* Friday, March 25, 2022 5:22 PM *To:* sr-users@lists.kamailio.org *Subject:* [SR-Users] Kamailio : kamctl address reload with HAProxy
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.
[image: Das Bild wurde vom Absender entfernt.] 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
-
Henning Westerholt -
Paclinio