<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=Windows-1252">
<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;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.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" link="blue" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">nbo@Kamailio:~$ ldd /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so</p>
<p class="MsoNormal"> linux-vdso.so.1 (0x00007ffdc3137000)</p>
<p class="MsoNormal"> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f592074f000)</p>
<p class="MsoNormal"> libmariadb.so.3 => /lib/x86_64-linux-gnu/libmariadb.so.3 (0x00007f59206f8000)</p>
<p class="MsoNormal"> libsrdb2.so.1 => /usr/lib/x86_64-linux-gnu/kamailio/libsrdb2.so.1 (0x00007f59206e9000)</p>
<p class="MsoNormal"> libsrdb1.so.1 => /usr/lib/x86_64-linux-gnu/kamailio/libsrdb1.so.1 (0x00007f59206ae000)</p>
<p class="MsoNormal"> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f592068d000)</p>
<p class="MsoNormal"> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f59204cc000)</p>
<p class="MsoNormal"> /lib64/ld-linux-x86-64.so.2 (0x00007f5920798000)</p>
<p class="MsoNormal"> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f5920347000)</p>
<p class="MsoNormal"> libgnutls.so.30 => /lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f592019a000)</p>
<p class="MsoNormal"> libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f591ff7c000)</p>
<p class="MsoNormal"> libp11-kit.so.0 => /lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f591fe4d000)</p>
<p class="MsoNormal"> libidn2.so.0 => /lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f591fe2e000)</p>
<p class="MsoNormal"> libunistring.so.2 => /lib/x86_64-linux-gnu/libunistring.so.2 (0x00007f591fcaa000)</p>
<p class="MsoNormal"> libtasn1.so.6 => /lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f591fa95000)</p>
<p class="MsoNormal"> libnettle.so.6 => /lib/x86_64-linux-gnu/libnettle.so.6 (0x00007f591fa5d000)</p>
<p class="MsoNormal"> libhogweed.so.4 => /lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007f591fa24000)</p>
<p class="MsoNormal"> libgmp.so.10 => /lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f591f9a1000)</p>
<p class="MsoNormal"> libffi.so.6 => /lib/x86_64-linux-gnu/libffi.so.6 (0x00007f591f997000)</p>
<p class="MsoNormal"><br>
// Nicki Bo Otte</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="border:none;padding:0cm"><b>From: </b><a href="mailto:hw@skalatan.de">Henning Westerholt</a><br>
<b>Sent: </b>21. januar 2021 09:37<br>
<b>To: </b><a href="mailto:sr-users@lists.kamailio.org">Kamailio (SER) - Users Mailing List</a><br>
<b>Cc: </b><a href="mailto:sr-dev@lists.kamailio.org">Kamailio (SER) - Devel Mailing List</a><br>
<b>Subject: </b>Re: [SR-Users] Kamailio, debian and MySQL caching_sha2_password</p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">E.g. like this: ldd /usr/lib/x86_64-linux-gnu/kamailio/modules/db_mysql.so<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span 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 lang="DE" 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 lang="DE" 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 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>
<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><span lang="DE">From:</span></b><span lang="DE"> 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></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Listening on<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: 185.31.176.39:5060<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: 185.31.176.39:80<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: Aliases:<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: tcp: voipgw01.evercall.dk:80<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio kamailio[24260]: udp: voipgw01.evercall.dk:5060<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Control process exited, code=exited, status=255/EXCEPTION<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: kamailio.service: Failed with result 'exit-code'.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">Jan 21 08:13:42 MobileValue-Kamailio systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">kamailio-json-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">kamailio-mysql-modules/unknown,now 5.4.3+bpo10 amd64 [installed]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">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></p>
<p class="MsoNormal" style="margin-left:35.4pt">default-libmysqld-dev/stable,now 1.0.5 amd64 [installed]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">libmariadb-dev/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">libmariadb-dev-compat/stable,now 1:10.3.27-0+deb10u1 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-apt-config/unknown,now 0.8.16-1 all [installed]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-common/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-community-client/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-community-client-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-community-client-plugins/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-community-server/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-community-server-core/unknown,now 8.0.23-1debian10 amd64 [installed,automatic]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt">mysql-server/unknown,now 8.0.23-1debian10 amd64 [installed]<br>
<br>
Thanks in advance<br>
Nicki Bo Otte<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>