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(a)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'(a)'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(a)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(a)gmail.com
> *Sent:* Monday,
March 28, 2022 1:11 PM
> *To:* Henning Westerholt <hw(a)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(a)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(a)lists.kamailio.org> *On Behalf Of *
> Paclinio
> *Sent:* Friday, March 25, 2022 5:22 PM
> *To:* sr-users(a)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