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