Hello,

out of curiosity, one more question: do you stick with MySQL for some specific reasons (e.g., support, performance, replication, ...)?

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...

Cheers,
Daniel

On 27.07.20 10:51, Mark Boyce wrote:
Hi

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.

Cheers
Mark

On 27 Jul 2020, at 09:46, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

ok, thanks for these details!

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.

Cheers,
Daniel

On 27.07.20 10:25, Mark Boyce wrote:
Hi

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...)

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

Package: mysql-server
Versions:
8.0.21-1ubuntu20.04 (/var/lib/apt/lists/repo.mysql.com_apt_ubuntu_dists_focal_mysql-8.0_binary-amd64_Packages) (/var/lib/dpkg/status)
 Description Language:
                 File: /var/lib/apt/lists/repo.mysql.com_apt_ubuntu_dists_focal_mysql-8.0_binary-amd64_Packages
                  MD5: 40f35c3f688a48dea4283a87850ef877

8.0.20-0ubuntu0.20.04.1 (/var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal-updates_main_binary-amd64_Packages) (/var/lib/apt/lists/security.ubuntu.com_ubuntu_
dists_focal-security_main_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal_main_binary-amd64_Packages
                  MD5: 743caadb7bcc9923a15d886cf7260d23

Maria 10.3 is also available on Ubuntu 20.04

Package: mariadb-server
Versions:
1:10.3.22-1ubuntu1 (/var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal_universe_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/nova.clouds.archive.ubuntu.com_ubuntu_dists_focal_universe_binary-amd64_Packages
                  MD5: 47753d361ef73aaa0d808a49d4717d3f

To get 10.5 (Stable) we’d need to use the Maria Repo https://mariadb.org/download/#mariadb-repositories

Cheers
Mark


On 27 Jul 2020, at 09:02, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

there is an open issue on tracker for adding packaging jobs for Ubuntu
20.04, hopefully Victor can find some time soon for it:

  - https://github.com/kamailio/kamailio/issues/2338

Otherwise I am curious to know if MySQL server is shipped with Ubuntu
20.04 by default? You said "MySQL 8 (From MySQL Repo)", just want to be
sure if MySQL or MariaDB is the default one (maybe you wanted to use
MySQL Repo to get a more recent version).

Cheers,
Daniel

On 24.07.20 20:27, Mark Boyce wrote:
Hi all

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;

Installing kamailio from;
deb     http://deb.kamailio.org/kamailio53 bionic main


The following packages have unmet dependencies:
kamailio : Depends: libreadline7 (>= 6.0) but it is not installable
kamailio-mysql-modules : Depends: libmysqlclient20 (>= 5.7.11) but it is not installable
kamailio-redis-modules : Depends: libhiredis0.13 (>= 0.13.1) but it is not installable

libreadline7 -> libreadline8 (v 8.0-4)
libmysqlclient20 -> libmysqlclient21 (v 8.0.21-1ubuntu20.04)
libhiredis0.13 -> libhiredis-dev  (v 0.14.0-6).


Ubuntu Server 20.04 LTS (focal)
MySQL 8 (From MySQL Repo)
Redis 6 from latest stable


Best regards
Mark
--
Mark Boyce
Dark Origins Ltd
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla



-- 
Mark Boyce
Dark Origins Ltd
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla

-- 
Mark Boyce
Dark Origins Ltd
e: mark@darkorigins.com

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla