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

    mysql not starting when trying to install 2nd time

    Scheduled Pinned Locked Moved
    Linux Problems
    2
    8
    909
    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.
    • C
      chris_unit
      last edited by

      Hi there,

      i had a failed first time install becuase p5 by archiware uses port 9000.

      i’ve since moved that port and tried to install again and got an error saying mysql couldn’t start

      attached is the command line runinng the install script

      here’s the status of mysql service
      [root@backup bin]# systemctl status mysql
      ● mariadb.service - MariaDB database server
      Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Active: failed (Result: exit-code) since Mon 2021-07-19 17:33:55 BST; 2min 41s ago
      Process: 47476 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=1/FAILURE)

      Jul 19 17:33:55 backup systemd[1]: Starting MariaDB database server…
      Jul 19 17:33:55 backup mariadb-prepare-db-dir[47476]: The directory /var/log/mariadb does not exist.
      Jul 19 17:33:55 backup systemd[1]: mariadb.service: control process exited, code=exited status=1
      Jul 19 17:33:55 backup systemd[1]: Failed to start MariaDB database server.
      Jul 19 17:33:55 backup systemd[1]: Unit mariadb.service entered failed state.
      Jul 19 17:33:55 backup systemd[1]: mariadb.service failed.[0_1626712795281_install log01](Uploading 0%)

      Here’s the install log

      install log01.txt

      1 Reply Last reply Reply Quote 0
      • C
        chris_unit
        last edited by Sebastian Roth

        I"ve manged to get a bit further by removing mysql so that it could be installed fresh again

        now i have an issue with php?

         * Setting up fogproject user..................................Skipped
         * Locking fogproject as a system account......................OK
         * Setting up fogproject password..............................OK
         * Stopping FOGMulticastManager.service Service................OK
         * Stopping FOGImageReplicator.service Service.................OK
         * Stopping FOGSnapinReplicator.service Service................OK
         * Stopping FOGScheduler.service Service.......................OK
         * Stopping FOGPingHosts.service Service.......................OK
         * Stopping FOGSnapinHash.service Service......................OK
         * Stopping FOGImageSize.service Service.......................OK
         * Setting up and starting MySQL...............................OK
         * Setting up MySQL user and database..........................
           The installer detected a blank database *root* password. This
           is very common on a new install or if you upgrade from any
           version of FOG before 1.5.8. To improve overall security we ask
           you to supply an appropriate database *root* password now.
        
           NOTICE: Make sure you choose a good password but also one
           you can remember or use a password manager to store it.
           The installer won't store the given password in any place
           and it will be lost right after the installer finishes!
        
           Please enter a new database *root* password to be set:
        
        OK
         * Backing up user reports.....................................Done
         * Stopping web service........................................OK
         * Setting up Apache and PHP files.............................Failed
           ###########################################
           #                                         #
           #      PHP Failed to install properly     #
           #                                         #
           ###########################################
        
           Could not find /etc/php.ini!
        
        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by

          @chris_unit said in mysql not starting when trying to install 2nd time:

          i had a failed first time install becuase p5 by archiware uses port 9000.

          I am not sure I get what you mean by that!?

          What Linux OS and version do you use?

          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
          • C
            chris_unit
            last edited by

            Hi there

            it’s centos 7.2 and latest version of fog.

            our backup software must use multicasting but ive since moved that from the default port so that issue is resolved

            the issue now is the php issue during install

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

              @chris_unit Looking at Wayne’s automated Test install results I see CentOS 7 works just fine: http://fogtesting.theworkmans.us/

              So I guess there is something special with your setup. Did you manually add an external repository for PHP packages?

              Or do you have an existing settings file in /opt/fog/.fogsettings? If so, then post the contents of this file here in the forums.

              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

              C 1 Reply Last reply Reply Quote 0
              • C
                chris_unit @Sebastian Roth
                last edited by

                @sebastian-roth said in mysql not starting when trying to install 2nd time:

                /opt/fog/.fogsettings

                Hi there

                everything is set to default settings i dont make any custom changes.

                did you install on 7.2?

                unforutnatly /opt/fog/.fogsettings doesn’t exist

                1 Reply Last reply Reply Quote 0
                • C
                  chris_unit
                  last edited by

                  I’ve given up trying to get this installed on this particular server

                  i’m now running fog on a vm

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

                    @chris_unit said in mysql not starting when trying to install 2nd time:

                    did you install on 7.2?

                    I haven’t. Somehow thought this was a typo when you first mentioned version 7.2. Quoting from: https://mirrors.xtom.de/centos/7.2.1511/readme

                    This directory (and version of CentOS) is deprecated. For normal users,
                    you should use /7/ and not /7.2.1511/ in your path. Please see this FAQ
                    concerning the CentOS release scheme:

                    https://wiki.centos.org/FAQ/General

                    If you know what you are doing, and absolutely want to remain at the 7.2.1511
                    level, go to http://vault.centos.org/ for packages.

                    Please keep in mind that 7.2.1511 no longer gets any updates, nor
                    any security fix’s.

                    Sorry but we don’t have enough people to work on FOG for it to support officially deprecated OS versions.

                    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

                    159

                    Online

                    12.0k

                    Users

                    17.3k

                    Topics

                    155.2k

                    Posts
                    Copyright © 2012-2024 FOG Project