<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>out of curiosity, one more question: do you stick with MySQL for
some specific reasons (e.g., support, performance, replication,
...)?</p>
<p>In most of my deployments I migrated to MariaDB, because it is
the default one shipped by Debian Stable and I haven't faced any
major issue so far...</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 27.07.20 10:51, Mark Boyce wrote:<br>
</div>
<blockquote type="cite"
cite="mid:ABC15B1D-35F9-49E6-B533-1829780B452F@darkorigins.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Hi
<div class=""><br class="">
</div>
<div class="">Yes not surprised. Ubuntu has been lagging behind
on MySQL v5 for ages, which is one of the reasons I use MySQLs
own repo. I have been using Ubuntu 18.04 with kamailio 5.3 from
repo, MySQL 8 from MySQL repo, and TLS without issue.</div>
<div class=""><br class="">
</div>
<div class="">Cheers</div>
<div class="">Mark<br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On 27 Jul 2020, at 09:46, Daniel-Constantin
Mierla <<a href="mailto:miconda@gmail.com" class=""
moz-do-not-send="true">miconda@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8" class="">
<div class="">
<p class="">Hello,</p>
<p class="">ok, thanks for these details!</p>
<p class="">I asked mainly because the libmysqlclient
seems to have some issues in older ubuntu (16.04 and
18.04) when using tls and libssl 1.1, based on reports
on community. Nothing similar reported when using
mariadb so far.<br class="">
</p>
<p class="">Cheers,<br class="">
Daniel<br class="">
</p>
<div class="moz-cite-prefix">On 27.07.20 10:25, Mark
Boyce wrote:<br class="">
</div>
<blockquote type="cite"
cite="mid:9842E5F4-518E-4117-982F-CB57490877AC@darkorigins.com"
class="">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8" class="">
Hi
<div class=""><br class="">
</div>
<div class="">Package - Cool. FYI 5.4 from git seems
to compile ok, although I’m only compiling modules
I’m using. (Only issue I’m having is G729 for
rtpengine, but that’s another story...)<br class="">
<div class=""><br class="">
</div>
<div class="">MySQL - Using MySQL’s repo is force of
habit for getting v8. Ubuntu has been shipping
with MySQL v5.7, although having just checked on
20.04 is finally shipping with MySQL 8.0.20 now</div>
<div class=""><br class="">
</div>
<div class="">Package: mysql-server<br class="">
Versions:<br class="">
<b class="">8.0.21</b>-1ubuntu20.04
(/var/lib/apt/lists/repo.<b class=""><a
href="http://mysql.com/" class=""
moz-do-not-send="true">mysql.com</a></b>_apt_ubuntu_dists_focal_mysql-8.0_binary-amd64_Packages)
(/var/lib/dpkg/status)<br class="">
Description Language:<br class="">
File:
/var/lib/apt/lists/repo.mysql.com_apt_ubuntu_dists_focal_mysql-8.0_binary-amd64_Packages<br
class="">
MD5:
40f35c3f688a48dea4283a87850ef877<br class="">
<br class="">
<b class="">8.0.20</b>-0ubuntu0.20.04.1
(/var/lib/apt/lists/nova.clouds.archive.<b
class=""><a href="http://ubuntu.com/" class=""
moz-do-not-send="true">ubuntu.com</a></b>_ubuntu_dists_focal-updates_main_binary-amd64_Packages)
(/var/lib/apt/lists/security.ubuntu.com_ubuntu_<br
class="">
dists_focal-security_main_binary-amd64_Packages)</div>
<div class=""> Description Language:<br class="">
File:
/var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal_main_binary-amd64_Packages<br
class="">
MD5:
743caadb7bcc9923a15d886cf7260d23<br class="">
<br class="">
</div>
<div class="">Maria 10.3 is also available on Ubuntu
20.04</div>
<div class=""><br class="">
</div>
<div class="">Package: mariadb-server<br class="">
Versions:<br class="">
1:10.3.22-1ubuntu1
(/var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal_universe_binary-amd64_Packages)<br
class="">
Description Language:<br class="">
File:
/var/lib/apt/lists/nova.clouds.archive.<b class=""><a
href="http://ubuntu.com/" class=""
moz-do-not-send="true">ubuntu.com</a></b>_ubuntu_dists_focal_universe_binary-amd64_Packages<br
class="">
MD5:
47753d361ef73aaa0d808a49d4717d3f</div>
<div class=""><br class="">
</div>
<div class="">To get 10.5 (Stable) we’d need to use
the Maria Repo <a
href="https://mariadb.org/download/#mariadb-repositories"
class="" moz-do-not-send="true">https://mariadb.org/download/#mariadb-repositories</a></div>
<div class=""><br class="">
</div>
<div class="">Cheers</div>
<div class="">Mark</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On 27 Jul 2020, at 09:02,
Daniel-Constantin Mierla <<a
href="mailto:miconda@gmail.com" class=""
moz-do-not-send="true">miconda@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Hello,<br class="">
<br class="">
there is an open issue on tracker for adding
packaging jobs for Ubuntu<br class="">
20.04, hopefully Victor can find some time
soon for it:<br class="">
<br class="">
- <a
href="https://github.com/kamailio/kamailio/issues/2338"
class="" moz-do-not-send="true">https://github.com/kamailio/kamailio/issues/2338</a><br
class="">
<br class="">
Otherwise I am curious to know if MySQL
server is shipped with Ubuntu<br class="">
20.04 by default? You said "MySQL 8 (From
MySQL Repo)", just want to be<br class="">
sure if MySQL or MariaDB is the default one
(maybe you wanted to use<br class="">
MySQL Repo to get a more recent version).<br
class="">
<br class="">
Cheers,<br class="">
Daniel<br class="">
<br class="">
On 24.07.20 20:27, Mark Boyce wrote:<br
class="">
<blockquote type="cite" class="">Hi all<br
class="">
<br class="">
This is installing 5.3 for Bionic (18.04)
on Focal (20.04) but as I know you’re in
the throws of building 5.4 thought I'd
throw this out there in case it changes
anything;<br class="">
<br class="">
Installing kamailio from;<br class="">
deb <a
href="http://deb.kamailio.org/kamailio53"
class="" moz-do-not-send="true">http://deb.kamailio.org/kamailio53</a>
bionic main<br class="">
<br class="">
<br class="">
The following packages have unmet
dependencies:<br class="">
kamailio : Depends: libreadline7 (>=
6.0) but it is not installable<br class="">
kamailio-mysql-modules : Depends:
libmysqlclient20 (>= 5.7.11) but it is
not installable<br class="">
kamailio-redis-modules : Depends:
libhiredis0.13 (>= 0.13.1) but it is
not installable<br class="">
<br class="">
libreadline7<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>->
libreadline8 (v 8.0-4)<br class="">
libmysqlclient20<span class="Apple-tab-span" style="white-space:pre"> </span>->
libmysqlclient21 (v 8.0.21-1ubuntu20.04)<br
class="">
libhiredis0.13<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>->
libhiredis-dev (v 0.14.0-6).<br class="">
<br class="">
<br class="">
Ubuntu Server 20.04 LTS (focal)<br
class="">
MySQL 8 (From MySQL Repo)<br class="">
Redis 6 from latest stable <br class="">
<br class="">
<br class="">
Best regards<br class="">
Mark<br class="">
-- <br class="">
Mark Boyce<br class="">
Dark Origins Ltd<br class="">
_______________________________________________<br class="">
Kamailio (SER) - Users Mailing List<br
class="">
<a
href="mailto:sr-users@lists.kamailio.org"
class="" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br
class="">
<a class="moz-txt-link-freetext"
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users"
moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br
class="">
</blockquote>
<br class="">
-- <br class="">
Daniel-Constantin Mierla -- <a
href="http://www.asipto.com/" class=""
moz-do-not-send="true">www.asipto.com</a><br
class="">
<a href="http://www.twitter.com/miconda"
class="" moz-do-not-send="true">www.twitter.com/miconda</a>
-- <a
href="http://www.linkedin.com/in/miconda"
class="" moz-do-not-send="true">www.linkedin.com/in/miconda</a><br
class="">
Funding: <a
href="https://www.paypal.me/dcmierla"
class="" moz-do-not-send="true">https://www.paypal.me/dcmierla</a><br
class="">
<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
<div class="">
<div style="letter-spacing: normal; text-align:
start; text-indent: 0px; text-transform: none;
white-space: normal; word-spacing: 0px;
-webkit-text-stroke-width: 0px; word-wrap:
break-word; -webkit-nbsp-mode: space;
line-break: after-white-space;" class="">
<div style="orphans: 2; widows: 2;" class=""><br
class="">
</div>
<div style="orphans: 2; widows: 2;" class="">-- </div>
<div style="orphans: 2; widows: 2;" class="">Mark
Boyce</div>
<div style="orphans: 2; widows: 2;" class="">Dark
Origins Ltd</div>
<div style="orphans: 2; widows: 2;" class="">e: <a
href="mailto:mark@darkorigins.com" class=""
moz-do-not-send="true">mark@darkorigins.com</a></div>
</div>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com/" moz-do-not-send="true">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" moz-do-not-send="true">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla" moz-do-not-send="true">https://www.paypal.me/dcmierla</a></pre>
</div>
</div>
</blockquote>
</div>
<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; word-spacing: 0px;
-webkit-text-stroke-width: 0px; word-wrap: break-word;
-webkit-nbsp-mode: space; line-break: after-white-space;"
class="">
<div style="orphans: 2; widows: 2;" class="">-- </div>
<div style="orphans: 2; widows: 2;" class="">Mark Boyce</div>
<div style="orphans: 2; widows: 2;" class="">Dark Origins
Ltd</div>
<div style="orphans: 2; widows: 2;" class="">e: <a
href="mailto:mark@darkorigins.com" class=""
moz-do-not-send="true">mark@darkorigins.com</a></div>
<div style="orphans: 2; widows: 2;" class=""><br class="">
</div>
</div>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</body>
</html>