• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    1.5.9 installed failed: setting up and starting mysql failed!

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    5
    381
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      Mike Fahey
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator
        last edited by

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

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        1 Reply Last reply Reply Quote 0
        • M
          Mike Fahey
          last edited by Sebastian Roth

          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
          
          1 Reply Last reply Reply Quote 0
          • M
            Mike Fahey
            last edited by

            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.

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by

              @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"
              

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post

              166

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project