1.5.9 installed failed: setting up and starting mysql failed!

[Mike Fahey]

I get the following error when running install.
This is an upgrade FYI.

Setting up and starting MySQL…Failed!

System is “Ubuntu” 18.04 LTS

nothing really in the logs:
ii liblzma-dev:amd64 5.2.2-1.3 amd64 XZ-format compression library - development files
ii m4 1.4.18-1 amd64 macro processing language
ii mysql-client 5.7.24-0ubuntu0.18.04.1 all MySQL database client (metapackage depending on the latest version)
ii mysql-server 5.7.24-0ubuntu0.18.04.1 all MySQL database server (metapackage depending on the latest version)
ii net-tools 1.60+git20161116.90da8a0-1ubuntu1 amd64 NET-3 networking toolkit
ii nfs-kernel-server 1:1.3.4-2.1ubuntu5 amd64 support for NFS kernel server
ii openssh-server 1:7.6p1-4 amd64 secure shell (SSH) server, for secure access from remote machines
ii php7.2 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 all server-side, HTML-embedded scripting language (metapackage)
ii php7.2-bcmath 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 Bcmath module for PHP
ii php7.2-cli 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 command-line interpreter for the PHP scripting language
ii php7.2-curl 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 CURL module for PHP
ii php7.2-fpm 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary)
ii php7.2-gd 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 GD module for PHP
ii php7.2-json 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 JSON module for PHP
ii php7.2-ldap 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 LDAP module for PHP
ii php7.2-mbstring 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 MBSTRING module for PHP
ii php7.2-mysql 7.2.34-22+ubuntu18.04.1+deb.sury.org+1 amd64 MySQL module for PHP
ii php-gettext 1.0.12-0.1 all transitional dummy package for php-php-gettext
ii tar 1.29b-2 amd64 GNU version of the tar archiving utility
ii tftpd-hpa 5.2+20150808-1ubuntu3 amd64 HPA’s tftp server
ii tftp-hpa 5.2+20150808-1ubuntu3 amd64 HPA’s tftp client
ii unzip 6.0-21ubuntu1 amd64 De-archiver for .zip files
ii vsftpd 3.0.3-9build1 amd64 lightweight, efficient FTP server written for security
ii wget 1.19.4-1ubuntu2.1 amd64 retrieves files from the web
ii xinetd 1:2.3.15.3-1 amd64 replacement for inetd with many enhancements
ii zlib1g:amd64 1:1.2.11.dfsg-0ubuntu2 amd64 compression library - runtime
Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully

[Sebastian Roth]

@Mike-Fahey Is the mysql service up and running? Run sudo systemctl status mysql and post output here.

[Mike Fahey]

It is running. I looked at the configureMySql function in functions.sh and im not sure why its failing. I’m assuming its in the first 20 lines of code but can’t pinpoint the issue.

 mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2021-06-16 16:37:46 EDT; 16h ago
  Process: 8805 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=0/SUCCESS)
  Process: 8783 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 8807 (mysqld)
    Tasks: 28 (limit: 1096)
   CGroup: /system.slice/mysql.service
           └─8807 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

[Mike Fahey]

Now I get the following.

I’m typing the correct password. I can connect from command line.

nothing in the log.

To improve the overall security the installer will create an
unpriviledged database user account for FOG’s database access.
Please provide the database root user password. Be asured
that this password will only be used while the FOG installer
is running and won’t be stored anywhere:

Unable to connect to the database using the given password!
Try again:
Failed! Terminating installer now.

[Sebastian Roth]

@Mike-Fahey Which mysql command do you use to connect to the database?

The installer uses the following command to login and check if it was successful:

mysql --host=localhost --user=root --password="yoursecurepassword" --execute="quit"
[[ $? -ne 0 ]] && echo "Connection failed" || echo "Connection succeeded"