[SR-Users] Install 5.3 on Ubuntu 20.04 With MySQL 8

Mon Jul 27 13:53:03 CEST 2020

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 at gmail.com
>> <mailto:miconda at 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
>>> <http://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
>>> <http://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
>>> <http://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 at gmail.com <mailto:miconda at 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 at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>> -- 
>>>> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com/>
>>>> www.twitter.com/miconda <http://www.twitter.com/miconda> --
>>>> www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>>>> Funding: https://www.paypal.me/dcmierla
>>>>
>>>
>>>
>>> -- 
>>> Mark Boyce
>>> Dark Origins Ltd
>>> e: mark at darkorigins.com <mailto:mark at darkorigins.com>
>> -- 
>> 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 at darkorigins.com <mailto:mark at darkorigins.com>
>
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20200727/50c54b49/attachment.htm>