Custombuild ot MySQL 8.0 failing

[Joob]

Hey guys and gals!

We are trying to upgrade MySQL to version 8.0 from 5.7, but the custom build fails. The best source we could find on this procedure is the following forum post: https://forum.directadmin.com/threads/upgrade-mysql-5-to-8.57533/

We have done the following procedure:

cd /usr/local/directadmin/custombuild
./build set mysql 8.0
./build mysql

This results in systemd not being able to start the MySQL installation due to missing binaries. It seems the installation is never able to complete. I have attached the output logs of the build command and the systemd logs. Am I doing something wrong? How can I proceed?

Also please find the following command output:

[root@server1 custombuild]#  cat /etc/*-release
CentOS Linux release 7.8.2003 (Core)
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

CentOS Linux release 7.8.2003 (Core)
CentOS Linux release 7.8.2003 (Core)

[root@server1 custombuild]# /usr/local/directadmin/directadmin o
Compiled on 'CentOS 7.0 64-Bit'
Compile time: Sep 29 2020 at 15:06:02
Timestamp: '1601413529'
Compiled with IPv6
Static binary: yes
commit sha: 207ef07
gettext support: yes
gettext path: /usr/local/directadmin/data/lang

 

[factor]

You might try

cd /usr/local/directadmin/custombuild
./build set mysql 8.0
./build set_fastest
./build clean
./build update
./build mysql

 

[Joob]

Thank you for your reply!

Unfortunately, the issue persists, the output of the build command is identical and it seems that the binaries are still missing. Especiially the systemd output shows that the binaries cannot be found:

Dec 16 10:58:02 server1 systemd: Failed at step EXEC spawning /usr/bin/mysqld_pre_systemd: No such file or directory
Dec 16 10:58:02 server1 systemd: mysqld.service: control process exited, code=exited status=203

[root@server1 custombuild]# which mysqld
/usr/bin/which: no mysqld in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)

It looks like the custom build is failing to install MySQL. The loggin is not very verbose and doesn't really output any additional errors.

 

[factor]

Ok let's back up a bit.
When was the last time you ran

cd /usr/local/directadmin/custombuild
./build clean
./build update
./build all

You also might have issues with your /etc/my.cnf

Upgrade MySql 5 to 8?

Ah - you got me! I thought this was fixed in 1.57.1 (which I was running)... but the upgrade to 1.57.2 got it working. Thanks @smtalk - sorry for the bother :)

forum.directadmin.com

Also you might want to look at this and see if it set

Upgrade MySql 5 to 8?

How can I upgrade from mysql 5.5 to 8? some more info php 7.3 and 5.6 centos 6.9 64bit all my server and directadmin is uptodate... my website is very important for me... can i upgrade it without any problem?

forum.directadmin.com

 

[warg]

Just tried this on Debian 10 - worked like a charm; issue must be CentOS specific.