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
-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://gilawa.comhttps://gilawa.com/
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
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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 09:37 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org 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
-- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.comhttps://gilawa.com/
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
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
-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://gilawa.comhttps://gilawa.com/
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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 09:37 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org 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
-- 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 Nicki Otte Sent: Thursday, January 21, 2021 8:27 AM To: sr-users@lists.kamailio.orgmailto: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
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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 10:58 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org; Nicki Ottemailto:duckay@live.com 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
-- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.comhttps://gilawa.com/
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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 09:37 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org 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
-- 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 Nicki Otte Sent: Thursday, January 21, 2021 8:27 AM To: sr-users@lists.kamailio.orgmailto: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
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
-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://gilawa.comhttps://gilawa.com/
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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 10:58 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org; Nicki Ottemailto:duckay@live.com 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
-- 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 Nicki Otte Sent: Thursday, January 21, 2021 9:49 AM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Cc: Kamailio (SER) - Devel Mailing List <sr-dev@lists.kamailio.orgmailto: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 Westerholtmailto:hw@skalatan.de Sent: 21. januar 2021 09:37 To: Kamailio (SER) - Users Mailing Listmailto:sr-users@lists.kamailio.org Cc: Kamailio (SER) - Devel Mailing Listmailto:sr-dev@lists.kamailio.org 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
-- 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 Nicki Otte Sent: Thursday, January 21, 2021 8:27 AM To: sr-users@lists.kamailio.orgmailto: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
-
Henning Westerholt -
Nicki Otte