lnmp1.5升级MySQL到8.0.12失败

buxuhunao

Stoping LNMP...
Stoping nginx...  done
Shutting down MySQL.. SUCCESS!
Gracefully shutting down php-fpm . done
[+] Installing boost_1_59_0
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package python-devel-2.7.5-69.el7_5.x86_64 already installed and latest version
Nothing to do
boost_1_66_0.tar.bz2 [found]
Uncompress boost_1_66_0.tar.bz2...
cd boost_1_66_0...
Starting upgrade MySQL...
Uncompress mysql-8.0.12.tar.gz...
cd mysql-8.0.12...
-- Running cmake version 2.8.12.2
-- Found Git: /bin/git (found version "1.8.3.1")
-- Configuring with MAX_INDEXES = 64U
-- This is Linux version 3.10.0-693.2.2.el7.x86_64
-- gcc is /bin/gcc
-- We probably need /opt/rh/devtoolset-7/root/usr/bin/gcc
-- /bin/gcc is version 4.8.5

CMake Warning at CMakeLists.txt:185 (MESSAGE):
  Could not find devtoolset gcc


-- The C compiler identification is GNU 4.8.5
-- The CXX compiler identification is GNU 4.8.5
-- Check for working C compiler: /bin/cc
-- Check for working C compiler: /bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /bin/c++
-- Check for working CXX compiler: /bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- CMAKE_GENERATOR: Unix Makefiles
-- Looking for SHM_HUGETLB
-- Looking for SHM_HUGETLB - found
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- SIZEOF_VOIDP 8
-- Performing Test HAVE_NOT_C_BUG_LOOP_VECTORIZE
-- Performing Test HAVE_NOT_C_BUG_LOOP_VECTORIZE - Success
-- Performing Test HAVE_NOT_CXX_BUG_LOOP_VECTORIZE
-- Performing Test HAVE_NOT_CXX_BUG_LOOP_VECTORIZE - Success
-- Performing Test HAVE_NOT_C_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_NOT_C_SHIFT_OR_OPTIMIZATION_BUG - Success
-- Performing Test HAVE_NOT_CXX_SHIFT_OR_OPTIMIZATION_BUG
-- Performing Test HAVE_NOT_CXX_SHIFT_OR_OPTIMIZATION_BUG - Success
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_C_FLOATING_POINT_FUSED_MADD - Failed
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD
-- Performing Test HAVE_CXX_FLOATING_POINT_FUSED_MADD - Failed
-- MySQL 8.0.12
-- Packaging as: mysql-8.0.12-Linux-x86_64
-- Performing Test C_LD_GOLD_RESULT
-- Performing Test C_LD_GOLD_RESULT - Success
-- Performing Test CXX_LD_GOLD_RESULT
-- Performing Test CXX_LD_GOLD_RESULT - Success
-- Local boost dir /usr/local/src/lnmp1.5-full/src/boost_1_66_0
-- Found /usr/local/src/lnmp1.5-full/src/boost_1_66_0/boost/version.hpp
-- BOOST_VERSION_NUMBER is #define BOOST_VERSION 106600
CMake Warning at cmake/boost.cmake:286 (MESSAGE):
  Boost minor version found is 66 we need 67
Call Stack (most recent call first):
  CMakeLists.txt:685 (INCLUDE)


-- BOOST_INCLUDE_DIR /usr/local/src/lnmp1.5-full/src/boost_1_66_0
-- LOCAL_BOOST_DIR /usr/local/src/lnmp1.5-full/src/boost_1_66_0
-- LOCAL_BOOST_ZIP LOCAL_BOOST_ZIP-NOTFOUND
-- Could not find (the correct version of) boost.
-- MySQL currently requires boost_1_67_0

CMake Error at cmake/boost.cmake:101 (MESSAGE):
  You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=<directory>

  This CMake script will look for boost in <directory>.  If it is not there,
  it will download and unpack it (in that directory) for you.

  If you are inside a firewall, you may need to use an https proxy:

  export https_proxy=http://example.com:80

Call Stack (most recent call first):
  cmake/boost.cmake:289 (COULD_NOT_FIND_BOOST)
  CMakeLists.txt:685 (INCLUDE)


-- Configuring incomplete, errors occurred!
See also "/usr/local/src/lnmp1.5-full/src/mysql-8.0.12/CMakeFiles/CMakeOutput.log".
See also "/usr/local/src/lnmp1.5-full/src/mysql-8.0.12/CMakeFiles/CMakeError.log".
make: *** No targets specified and no makefile found.  Stop.
make: *** No targets specified and no makefile found.  Stop.
make: *** No rule to make target `install'.  Stop.
groupadd: group 'mysql' already exists
useradd: user 'mysql' already exists
include/upgrade_mysql.sh: line 531: /usr/local/mysql/bin/mysqld: No such file or directory
cp: cannot stat ‘/usr/local/src/lnmp1.5-full/src/mysql-8.0.12/support-files/mysql.server’: No such file or directory
chmod: cannot access ‘/etc/init.d/mysql’: No such file or directory
Failed to execute operation: No such file or directory
include/mysql.sh: line 39: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 47: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 50: /usr/local/mysql/bin/mysqladmin: No such file or directory
failed, try other way...
include/mysql.sh: line 53: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 63: /usr/local/mysql/bin/mysql: No such file or directory
Set password failed!
include/mysql.sh: line 73: /etc/init.d/mysql: No such file or directory
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
Update root password...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove anonymous users...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Disallow root login remotely...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Remove test database...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
Reload privilege tables...
include/main.sh: line 667: /usr/local/mysql/bin/mysql: No such file or directory
... Failed!
include/mysql.sh: line 103: /etc/init.d/mysql: No such file or directory
include/mysql.sh: line 104: /etc/init.d/mysql: No such file or directory
include/upgrade_mysql.sh: line 552: /etc/init.d/mysql: No such file or directory
Restore backup databases...
include/upgrade_mysql.sh: line 555: /usr/local/mysql/bin/mysql: No such file or directory
Repair databases...
include/upgrade_mysql.sh: line 557: /usr/local/mysql/bin/mysql_upgrade: No such file or directory
include/upgrade_mysql.sh: line 559: /etc/init.d/mysql: No such file or directory
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Starting LNMP...
Starting nginx...  done
/bin/lnmp: line 26: /etc/init.d/mysql: No such file or directory
Starting php-fpm  done
======== upgrade MySQL failed ======
upgrade MySQL log: /root/upgrade_mysql.log
You upload upgrade_mysql.log to LNMP Forum for help.

licess

不同版本对boost版本的依赖是不一样的，mysql 8.0.12 又变了，按前面的提示将include/version.sh 将 Boost_New_Ver='boost_1_66_0' 改成 Boost_New_Ver='boost_1_67_0'
并下载好该版本对应的，tar.bz2的源码包至src目录下

buxuhunao

好的，谢谢军哥:loveliness: :loveliness: