I tried upgrading mysql today but got the below error:
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.
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.