<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="DA" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi all<br>
<br>
Have any of you experienced problems using MySQL(Not MariaDB) on a debian machine, with caching_sha2_password?
<br>
<br>
I am having some trouble:<br>
Jan 21 08:13:41 MobileValue-Kamailio systemd[1]: Starting Kamailio (OpenSER) - the Open Source SIP Server...</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Listening on</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: 185.31.176.39:5060</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: 185.31.176.39:80</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Aliases:</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: voipgw01.evercall.dk:80</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: voipgw01.evercall.dk:5060</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: INFO: rr [rr_mod.c:185]: mod_init(): outbound module not available</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: dispatcher [dispatch.c:903]: ds_connect_db(): cannot initialize db connection</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">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)</p>
<p class="MsoNormal">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</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Control process exited, code=exited, status=255/EXCEPTION</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Failed with result 'exit-code'.</p>
<p class="MsoNormal">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I can get around the problem, by making the kamailio & kamailioro user use mysql_native_password instead.<br>
<br>
But am i wrong to belieave that it should Work out of the box?<br>
<br>
Here are the installed packages from APT:<br>
kamailio/unknown,now 5.4.3+bpo10 amd64 [installed]</p>
<p class="MsoNormal">kamailio-json-modules/unknown,now 5.4.3+bpo10 amd64 [installed]</p>
<p class="MsoNormal">kamailio-mysql-modules/unknown,now 5.4.3+bpo10 amd64 [installed]</p>
<p class="MsoNormal">kamailio-outbound-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<br>
default-libmysqlclient-dev/stable,now 1.0.5 amd64 [installed]</p>
<p class="MsoNormal">default-libmysqld-dev/stable,now 1.0.5 amd64 [installed]</p>
<p class="MsoNormal">libmariadb-dev/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]</p>
<p class="MsoNormal">libmariadb-dev-compat/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-apt-config/unknown,now 0.8.16-1 all [installed]</p>
<p class="MsoNormal">mysql-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-common/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-community-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-community-client-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-community-client-plugins/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-community-server/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-community-server-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]</p>
<p class="MsoNormal">mysql-server/unknown,now 8.0.23-1debian10 amd64 [installed]<br>
<br>
Thanks in advance<br>
Nicki Bo Otte</p>
</div>
</body>
</html>