Hi,
ok, this is probably the issue then. It looks that you have mix between mariadb and mysql installed, which is probably not a good idea, maybe you can investigate this and see why it’s
the case. If you want to use this mariadb plugin, you would probably indeed need to use mariadb.
Cheers,
Henning
From: Nicki Otte <duckay@live.com>
Sent: Thursday, January 21, 2021 11:22 AM
To: Henning Westerholt <hw@skalatan.de>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Cc: Kamailio (SER) - Devel Mailing List <sr-dev@lists.kamailio.org>
Subject: RE: Kamailio, debian and MySQL caching_sha2_password
The file is not in my system. I believe it’s not a part of the standard MySQL installation for debian?
My quess is that it would be available, if i used MariaDB
// Nicki Bo Otte
From: Henning Westerholt
Sent: 21. januar 2021 10:58
To: Kamailio (SER) - Users Mailing List
Cc: Kamailio (SER) - Devel Mailing List;
Nicki Otte
Subject: RE: Kamailio, debian and MySQL caching_sha2_password
Hi Nicki,
Ok, this looks ok on a first sight. Do you’ve checked as well if the file
/usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so is available and readable?
Cheers,
Henning
From: sr-users <sr-users-bounces@lists.kamailio.org>
On Behalf Of Nicki Otte
Sent: Thursday, January 21, 2021 9:49 AM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Cc: Kamailio (SER) - Devel Mailing List <sr-dev@lists.kamailio.org>
Subject: Re: [SR-Users] Kamailio, debian and MySQL caching_sha2_password
nbo@Kamailio:~$ ldd /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so
linux-vdso.so.1 (0x00007ffdc3137000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f592074f000)
libmariadb.so.3 => /lib/x86_64-linux-gnu/libmariadb.so.3 (0x00007f59206f8000)
libsrdb2.so.1 => /usr/lib/x86_64-linux-gnu/kamailio/libsrdb2.so.1 (0x00007f59206e9000)
libsrdb1.so.1 => /usr/lib/x86_64-linux-gnu/kamailio/libsrdb1.so.1 (0x00007f59206ae000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f592068d000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f59204cc000)
/lib64/ld-linux-x86-64.so.2 (0x00007f5920798000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f5920347000)
libgnutls.so.30 => /lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f592019a000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f591ff7c000)
libp11-kit.so.0 => /lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f591fe4d000)
libidn2.so.0 => /lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f591fe2e000)
libunistring.so.2 => /lib/x86_64-linux-gnu/libunistring.so.2 (0x00007f591fcaa000)
libtasn1.so.6 => /lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f591fa95000)
libnettle.so.6 => /lib/x86_64-linux-gnu/libnettle.so.6 (0x00007f591fa5d000)
libhogweed.so.4 => /lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007f591fa24000)
libgmp.so.10 => /lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f591f9a1000)
libffi.so.6 => /lib/x86_64-linux-gnu/libffi.so.6 (0x00007f591f997000)
// Nicki Bo Otte
From: Henning Westerholt
Sent: 21. januar 2021 09:37
To: Kamailio (SER) - Users Mailing List
Cc: Kamailio (SER) - Devel Mailing List
Subject: Re: [SR-Users] Kamailio, debian and MySQL caching_sha2_password
Hello,
It seems that the respective plugin is missing or can not be loaded. Can you do a ldd on the db_mysql module?
E.g. like this: ldd /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so
Cheers,
Henning
From: sr-users <sr-users-bounces@lists.kamailio.org>
On Behalf Of Nicki Otte
Sent: Thursday, January 21, 2021 8:27 AM
To: sr-users@lists.kamailio.org
Subject: [SR-Users] Kamailio, debian and MySQL caching_sha2_password
Hi all
Have any of you experienced problems using MySQL(Not MariaDB) on a debian machine, with caching_sha2_password?
I am having some trouble:
Jan 21 08:13:41 MobileValue-Kamailio systemd[1]: Starting Kamailio (OpenSER) - the Open Source SIP Server...
Jan 21 08:13:42 MobileValue-Kamailio kamailio: INFO: <core> [core/tcp_main.c:4983]: init_tcp(): using epoll_lt as the io watch method (auto detected)
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Listening on
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: 185.31.176.39:5060
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: 185.31.176.39:80
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Aliases:
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: voipgw01.evercall.dk:80
Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: voipgw01.evercall.dk:5060
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: INFO: rr [../outbound/api.h:52]: ob_load_api(): unable to import bind_ob - maybe module is not loaded
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: INFO: rr [rr_mod.c:185]: mod_init(): outbound module not available
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: db_mysql [km_my_con.c:163]: db_mysql_new_connection(): driver error: Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so:
cannot open shared object file: No such file or directory
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: <core> [db.c:319]: db_do_init2(): could not add connection to the pool
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: dispatcher [dispatch.c:903]: ds_connect_db(): cannot initialize db connection
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: dispatcher [dispatch.c:937]: ds_init_db(): unable to connect to the database
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: dispatcher [dispatcher.c:404]: mod_init(): could not initiate a connect to the database
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: <core> [core/sr_module.c:849]: init_mod(): Error while initializing module dispatcher (/usr/lib/x86_64-linux-gnu/kamailio/modules/dispatcher.so)
Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Control process exited, code=exited, status=255/EXCEPTION
Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Failed with result 'exit-code'.
Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.
I can get around the problem, by making the kamailio & kamailioro user use mysql_native_password instead.
But am i wrong to belieave that it should Work out of the box?
Here are the installed packages from APT:
kamailio/unknown,now 5.4.3+bpo10 amd64 [installed]
kamailio-json-modules/unknown,now 5.4.3+bpo10 amd64 [installed]
kamailio-mysql-modules/unknown,now 5.4.3+bpo10 amd64 [installed]
kamailio-outbound-modules/unknown,now 5.4.3+bpo10 amd64 [installed]
default-libmysqlclient-dev/stable,now 1.0.5 amd64 [installed]
default-libmysqld-dev/stable,now 1.0.5 amd64 [installed]
libmariadb-dev/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]
libmariadb-dev-compat/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]
mysql-apt-config/unknown,now 0.8.16-1 all [installed]
mysql-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-common/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-community-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-community-client-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-community-client-plugins/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-community-server/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-community-server-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]
mysql-server/unknown,now 8.0.23-1debian10 amd64 [installed]
Thanks in advance
Nicki Bo Otte