Solved Install Drupal 8 with mysql-client57 ?

[FKEinternet]

I have mysql-client57 installed:

# pkg info mysql57-client
mysql57-client-5.7.21_1
Name           : mysql57-client
Version        : 5.7.21_1
Installed on   : Sat Mar 10 16:28:48 2018 EST
Origin         : databases/mysql57-client
Architecture   : FreeBSD:11:amd64
Prefix         : /usr/local
Categories     : databases ipv6
Licenses       : GPLv2
Maintainer     : mmokhi@FreeBSD.org
WWW            : http://www.mysql.com/
Comment        : Multithreaded SQL database (client)
Options        :
        SASLCLIENT     : on
Shared Libs required:
        liblz4.so.1
        libsasl2.so.3
        libedit.so.0
Shared Libs provided:
        libmysqlclient.so.20
Annotations    :
        FreeBSD_version: 1101001
        cpe            : cpe:2.3:a:mysql:mysql:5.7.21:::::freebsd11:x64:1
        repo_type      : binary
        repository     : FreeBSD
Flat size      : 49.0MiB
Description    :
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.

WWW: http://www.mysql.com/

I'm trying to install drupal8, but it wants to install mysql56-client: 5.6.39_1:

# pkg install drupal8
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
        drupal8: 8.5.0
        mysql56-client: 5.6.39_1

Number of packages to be installed: 2

The process will require 96 MiB more space.
13 MiB to be downloaded.

Proceed with this action? [y/N]:

How can I install drupal8 and get it to use my existing mysql-client57? I tried

# pkg set -o databases/mysql56-client:databases/mysql57-client
Change origin from databases/mysql56-client to databases/mysql57-client for all dependencies? [y/N]: y

but it didn't make any difference. Am I going to have to build drupal8 from source and edit the Makefile to change the dependency?

 

[SirDice]

I'm trying to install www/drupal8, but it wants to install mysql56-client: 5.6.39_1:

The official packages are always built using the defaults and the default MySQL version is 5.6. No amount of fiddling is going to change the dependencies of a package.

Am I going to have to build www/drupal8 from source and edit the Makefile to change the dependency?

If you want/need to deviate from the defaults create a /etc/make.conf:

DEFAULT_VERSIONS+=mysql=5.7

And build from ports.

 

[FKEinternet]

Ah, yes, /etc/make.conf.

One of my concerns with the mysql56-client port is the pkg-message:

* * * * * * * * * * * * * * * * * * * * * * * *

Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html

Although this database client is not listed as
"affected", it is vulnerable and will not be
receiving a patch. Please take note of this when
deploying this software.

* * * * * * * * * * * * * * * * * * * * * * * *

I would rather not knowingly deploy a security vulnerability, so I will build from ports.

Thank you.

 

[obsigna]

Ah, yes, /etc/make.conf.

One of my concerns with the mysql56-client port is the pkg-message:

* * * * * * * * * * * * * * * * * * * * * * * *

Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html

Although this database client is not listed as
"affected", it is vulnerable and will not be
receiving a patch. Please take note of this when
deploying this software.

* * * * * * * * * * * * * * * * * * * * * * * *

I would rather not knowingly deploy a security vulnerability, so I will build from ports.

Thank you.

If you use MySQL only as the backend for a web-application running on the same server, then you could simply ignore this vulnerability as it could be easily and absolute effectively mitigated by limiting MySQL listinig only on localhost, for this put the directive bind-address = 127.0.0.1 into my.cnf:
sockstat | grep mysql

mysql    mysqld     1765  5  tcp4   127.0.0.1:3306        *:*
mysql    mysqld     1765  7  stream /tmp/mysql.sock

For doing database maintenance with a dedicated MySQL client from another machine, I use a SSH tunnel. For example Sequel Pro on the Mac: