Bug 238365

Summary:

Update default MySQL version to 5.7

Product:

Ports & Packages

Reporter:

Alex Dupre <ale>

Component:

Ports Framework

Assignee:

Alex Dupre <ale>

Status:

Closed FIXED

Severity:

Affects Many People

CC:

ports-bugs

Priority:

---

Flags:

antoine: exp-run+

Version:

Latest

Hardware:

Any

OS:

Any

Attachments:

Description	Flags
Patch	none
Updated patch	none

Description Alex Dupre freebsd_committer

2019-06-06 14:10:00 UTC

Created attachment 204859 [details]
Patch

MySQL 5.6 is too old and misses many useful features. MySQL 8.0 is too young and may create incompatibily issues. MySQL 5.7 should be a straightforward update.

Comment 1 Antoine Brodin freebsd_committer

2019-06-09 18:56:29 UTC

New failure logs on 12.0 amd64:


http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/amarok-2.9.0.277_4.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/apq-mysql-3.2.0_2.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/ateam_mysql_ldap_auth-1.0_1.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mroonga-9.01.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysac-1.1.2.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysql-connector-odbc-unixodbc-mysql57-5.3.4_1.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysql57-q4m-0.9.14_4.log
http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysqlbigram-1.0.1_1.log

Comment 2 Antoine Brodin freebsd_committer

2019-06-09 18:59:42 UTC

New failure logs on 11.2 i386:


http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/amarok-2.9.0.277_4.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/apq-mysql-3.2.0_2.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/ateam_mysql_ldap_auth-1.0_1.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mroonga-9.01.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysac-1.1.2.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysql-connector-odbc-unixodbc-mysql57-5.3.4_1.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysql57-q4m-0.9.14_4.log
http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysqlbigram-1.0.1_1.log

Comment 3 Alex Dupre freebsd_committer

2019-06-14 08:32:57 UTC

Created attachment 205056 [details]
Updated patch

As expected, most failures are from abandonware software designed for MySQL 5.1. I've added the correct IGNORE lines for them, and fixed amarok and mysql-connector-odbc.

Comment 4 Antoine Brodin freebsd_committer

2019-06-26 15:47:11 UTC

Exp-run looks fine.

Comment 5 commit-hook freebsd_committer

2019-07-01 07:44:00 UTC

A commit references this bug:

Author: ale
Date: Mon Jul  1 07:43:36 UTC 2019
New revision: 505549
URL: https://svnweb.freebsd.org/changeset/ports/505549

Log:
  Update default MySQL version to 5.7.

  PR:		238365
  Submitted by:	ale
  Exp-run by:	antoine
  Approved by:	portmgr (antoine)

Changes:
  head/Mk/Uses/mysql.mk
  head/Mk/bsd.default-versions.mk
  head/UPDATING
  head/audio/amarok/Makefile
  head/audio/amarok/files/patch-cmake_modules_FindMySQL.cmake
  head/databases/apq-mysql/Makefile
  head/databases/ateam_mysql_ldap_auth/Makefile
  head/databases/mroonga/Makefile
  head/databases/mysac/Makefile
  head/databases/mysql-connector-odbc/Makefile
  head/databases/mysql-connector-odbc/distinfo
  head/databases/mysql-connector-odbc/files/patch-CMakeLists.txt
  head/databases/mysql-connector-odbc/files/patch-driver_catalog_no_i_s.c
  head/databases/mysql-connector-odbc/files/patch-driver_desc.c
  head/databases/mysql-connector-odbc/files/patch-driver_handle.c
  head/databases/mysql-connector-odbc/files/patch-driver_parse.c
  head/databases/mysql-connector-odbc/files/patch-util_odbcinstw.c
  head/databases/mysql-q4m/Makefile
  head/databases/mysqlbigram/Makefile