Solved Upgrade Failed: MySQL56 -> MySQL57

Lamia

Active Member

Thanks: 23
Messages: 163

#1
I tried upgrading mysql today but got the below error:

Code:
===>   mysql57-client-5.7.21_1 depends on shared library: libedit.so.0 - found (/usr/local/lib/libedit.so.0)
===>  Configuring for mysql57-client-5.7.21_1
===>  Performing out-of-source build
/bin/mkdir -p /var/ports/basejail/usr/ports/databases/mysql57-client/work/.build
CMake Deprecation Warning at CMakeLists.txt:27 (CMAKE_POLICY):
  The OLD behavior for policy CMP0018 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:33 (CMAKE_POLICY):
  The OLD behavior for policy CMP0022 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:41 (CMAKE_POLICY):
  The OLD behavior for policy CMP0026 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


-- Running cmake version 3.10.2
-- Configuring with MAX_INDEXES = 64U
-- CMAKE_GENERATOR: Unix Makefiles
-- SIZEOF_VOIDP 8
getconf: no such configuration parameter `LEVEL1_DCACHE_LINESIZE'
-- MySQL 5.7.21
-- Packaging as: mysql-5.7.21-FreeBSD11.1-x86_64
-- Local boost dir /var/ports/basejail/usr/ports/databases/mysql57-client/work/mysql-5.7.21/boost/boost_1_59_0
-- Found /var/ports/basejail/usr/ports/databases/mysql57-client/work/mysql-5.7.21/boost/boost_1_59_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 105900
-- BOOST_INCLUDE_DIR /var/ports/basejail/usr/ports/databases/mysql57-client/work/mysql-5.7.21/boost/boost_1_59_0
-- NUMA library missing or required version not available
-- suffixes <.a;.so>
-- OPENSSL_INCLUDE_DIR = /usr/local/include
-- OPENSSL_LIBRARY = /usr/local/lib/libssl.a
-- CRYPTO_LIBRARY = /usr/local/lib/libcrypto.a
-- OPENSSL_MAJOR_VERSION = 1
-- SSL_LIBRARIES = imported_openssl;imported_crypto
-- EDITLINE_INCLUDE_DIR /usr/local/include/editline
-- EDITLINE_LIBRARY /usr/local/lib/libedit.so
-- LZ4_INCLUDE_DIR /usr/local/include
-- LZ4_LIBRARY /usr/local/lib/liblz4.so
-- CURL_LIBRARY = /usr/local/lib/libcurl.so
-- Creating LDAP authentication SASL client library.
CMake Error at libmysql/authentication_ldap/CMakeLists.txt:29 (MESSAGE):
  Required LBER library is missing.
Call Stack (most recent call first):
  libmysql/authentication_ldap/CMakeLists.txt:44 (CROAK_AND_RETURN)


-- MERGE_CONVENIENCE_LIBRARIES TARGET mysqlclient
-- MERGE_CONVENIENCE_LIBRARIES LIBS clientlib;dbug;strings;vio;mysys;mysys_ssl;/usr/lib/libz.so;imported_openssl;imported_crypto
-- Library mysqlclient depends on OSLIBS -pthread;/usr/lib/libz.so;m;rt;execinfo
-- MERGE_CONVENIENCE_LIBRARIES TARGET mysqlclient
-- MERGE_CONVENIENCE_LIBRARIES LIBS clientlib;dbug;strings;vio;mysys;mysys_ssl;/usr/lib/libz.so;imported_openssl;imported_crypto
-- MERGE_CONVENIENCE_LIBRARIES MYLIBS clientlib;dbug;strings;vio;mysys;mysys_ssl;imported_openssl;imported_crypto
-- The mysqlservices library is for server plugins only
CMake Deprecation Warning at scripts/CMakeLists.txt:320 (CMAKE_POLICY):
  The OLD behavior for policy CMP0007 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


-- INSTALL mysqlclient.pc /usr/local/libdata/pkgconfig
-- CMAKE_BUILD_TYPE: Release
-- COMPILE_DEFINITIONS: HAVE_CONFIG_H;HAVE_LIBEVENT2
-- CMAKE_C_FLAGS: -O2 -pipe  -fstack-protector -isystem /usr/local/include -fno-strict-aliasing -Wall -Wextra -Wformat-security -Wvla -Wwrite-strings -Wdeclaration-after-statement
-- CMAKE_CXX_FLAGS: -O2 -pipe -fstack-protector -isystem /usr/local/include -fno-strict-aliasing  -isystem /usr/local/include -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter -Wno-null-conversion -Wno-unused-private-field
-- CMAKE_C_LINK_FLAGS:
-- CMAKE_CXX_LINK_FLAGS:
-- CMAKE_C_FLAGS_RELEASE: -O2 -pipe  -fstack-protector -isystem /usr/local/include -fno-strict-aliasing -DDBUG_OFF
-- CMAKE_CXX_FLAGS_RELEASE: -O2 -pipe -fstack-protector -isystem /usr/local/include -fno-strict-aliasing  -isystem /usr/local/include -DDBUG_OFF
-- Configuring incomplete, errors occurred!
See also "/var/ports/basejail/usr/ports/databases/mysql57-client/work/.build/CMakeFiles/CMakeOutput.log".
See also "/var/ports/basejail/usr/ports/databases/mysql57-client/work/.build/CMakeFiles/CMakeError.log".
*** Error code 1

Stop.
make[3]: stopped in /basejail/usr/ports/databases/mysql57-client
*** Error code 1

Stop.
make[2]: stopped in /basejail/usr/ports/databases/mysql57-client
*** Error code 1

Stop.
make[1]: stopped in /basejail/usr/ports/databases/mysql57-server
*** Error code 1

Stop.
make: stopped in /basejail/usr/ports/databases/mysql57-server


I updated ports, packages, etc & re-tried the installation but I could not get to install the package from ports. "Pkg install mysql57-server" works though. But again, I could not get the database running. "Mysql_upgrade" and other mysql commands would return error that mysql is not running.

Please advise.
 

SirDice

Administrator
Staff member
Administrator
Moderator

Thanks: 6,335
Messages: 27,504

#2
But again, I could not get the database running
What are the errors you're getting? See /var/db/mysql/`hostname`.err. I've migrated various databases from 5.6 to 5.7 and I can remember some minor issues, I had to fix my.cnf for example to remove/adjust some deprecated options. But this is all mentioned in the error logs.
 
OP
OP
Lamia

Lamia

Active Member

Thanks: 23
Messages: 163

#3
Thanks SirDice. I gave up on it and reverted back to MySQL56. I noticed PHP installation sometimes fail too.
PHP71, for instance, could be installed via ports alongside Apache24 but mod_php71 won't. And when you install all via pkg, Apache24 won't start. At the end of the day, PHP70 installation via ports went well. PHP72, on the other hand, breaks the application - throwing JSONserializable error.
 
Top