<html xmlns:v="urn:schemas-microsoft-com:vml" 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;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="DA">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DA">It seems that the respective plugin is missing or can not be loaded. Can you do a ldd on the db_mysql module?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DA">E.g. like this: ldd /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DA" style="mso-fareast-language:EN-US">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DA" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DA" style="mso-fareast-language:EN-US">Henning<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">-- <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Henning Westerholt –
</span><span style="mso-fareast-language:EN-US"><a href="https://skalatan.de/blog/"><span lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Kamailio services –
</span><span style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span lang="EN-GB" style="color:#0563C1">https://gilawa.com</span></a></span><span style="mso-fareast-language:EN-US">
<span lang="EN-GB"><o:p></o:p></span></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b> sr-users <sr-users-bounces@lists.kamailio.org>
<b>On Behalf Of </b>Nicki Otte<br>
<b>Sent:</b> Thursday, January 21, 2021 8:27 AM<br>
<b>To:</b> sr-users@lists.kamailio.org<br>
<b>Subject:</b> [SR-Users] Kamailio, debian and MySQL caching_sha2_password<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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...<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Listening on<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: 185.31.176.39:5060<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: 185.31.176.39:80<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Aliases:<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: voipgw01.evercall.dk:80<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: voipgw01.evercall.dk:5060<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: INFO: rr [rr_mod.c:185]: mod_init(): outbound module not available<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio /usr/sbin/kamailio[24262]: ERROR: dispatcher [dispatch.c:903]: ds_connect_db(): cannot initialize db connection<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Control process exited, code=exited, status=255/EXCEPTION<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Failed with result 'exit-code'.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">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]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">kamailio-json-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">kamailio-mysql-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">kamailio-outbound-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<br>
default-libmysqlclient-dev/stable,now 1.0.5 amd64 [installed]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">default-libmysqld-dev/stable,now 1.0.5 amd64 [installed]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">libmariadb-dev/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">libmariadb-dev-compat/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-apt-config/unknown,now 0.8.16-1 all [installed]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-common/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-community-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-community-client-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-community-client-plugins/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-community-server/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-community-server-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DA">mysql-server/unknown,now 8.0.23-1debian10 amd64 [installed]<br>
<br>
Thanks in advance<br>
Nicki Bo Otte<o:p></o:p></span></p>
</div>
</body>
</html>