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

    FOG installation errors

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    54
    10.4k
    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.
    • T
      TaTa @Sebastian Roth
      last edited by

      @Sebastian-Roth Thank you! I’m getting a bit further. The installer can’t set a password for fogproject account due New password: BAD PASSWORD: The password is shorter than 14 characters. Is there a way I can set it manually or change password length in the script so will be 14 characters or more?

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

        @TaTa Take a look at fogproject/lib/common/functions.sh line 1261. At the end of the line where it says .../dev/urandom | fold -w12 | head -n1) change the figure 12 to a higher value.

        By the way. If you want to install with a proper root password set for the database you will run into an issue with the current version. I hope to get this fixed soon!

        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

        T 1 Reply Last reply Reply Quote 0
        • T
          TaTa @Sebastian Roth
          last edited by

          @Sebastian-Roth I changed it to 14 and 16 but is getting this error. Looks like password is not complex enough

          Changing shell for fogproject.
          New password: BAD PASSWORD: The password contains less than 1 digits
          Retype new password: BAD PASSWORD: is too simple
          Retype new password: Password change aborted.
          New password: Password change aborted.
          New password: Password change aborted.
          passwd: Have exhausted maximum number of retries for service
          Changing password for user fogproject.
          New password: Retype new password: Retype new password: Password change aborted.
          New password: Password change aborted.
          New password: Password change aborted.
          passwd: Have exhausted maximum number of retries for service
          New password: BAD PASSWORD: The password contains less than 1 uppercase letters
          Retype new password: BAD PASSWORD: is too simple
          Retype new password: Password change aborted.
          New password: Password change aborted.
          New password: Password change aborted.
          passwd: Have exhausted maximum number of retries for service
          Changing password for user fogproject.
          New password: Retype new password: Retype new password: Password change aborted.
          New password: Password change aborted.
          New password: Password change aborted.
          passwd: Have exhausted maximum number of retries for service
          Changing password for user fogproject.
          New password: Retype new password: Retype new password: Password change aborted.
          New password: Password change aborted.
          New password: Password change aborted.
          passwd: Have exhausted maximum number of retries for service
          Changing password for user fogproject.
          
          D 1 Reply Last reply Reply Quote 0
          • D
            Daniel Miller @TaTa
            last edited by Daniel Miller

            @TaTa The data being pulled in for the password is out of urandom, so it is not implausible that, as the log indicates, a given line may not include a digit or upper case letter. You may be able to run the installer a few more times and get a random password that conforms to the system’s password requirements. You may also be able to create a partial /opt/fog/.fogsettings with strong passwords compliant with your systems password policies. Format and settings are available in the Wiki. I haven’t tested this, but my understanding is that anything not set in .fogsettings is requested by the installer.

            Edit: the setting you are likely interested in is password=.

            T 1 Reply Last reply Reply Quote 1
            • T
              TaTa @Daniel Miller
              last edited by

              @Daniel-Miller I created the files but it’s still not working. This is a new installation. I don’t think it looks into .fogsettings before creating this new account.

              1 Reply Last reply Reply Quote 0
              • T
                TaTa
                last edited by TaTa

                I no longer getting password too simple. It looks like it’s not accepting the password. I can set password for fogproject manually but the installation does not like this account created beforehand.

                Changing password for user fogproject.
                New password: Retype new password: Retype new password: Password change aborted.
                New password: Password change aborted.
                New password: Password change aborted.
                passwd: Have exhausted maximum number of retries for service
                Changing password for user fogproject.
                New password: Retype new password: Retype new password: Password change aborted.
                New password: Password change aborted.
                New password: Password change aborted.
                passwd: Have exhausted maximum number of retries for service
                Changing password for user fogproject.
                
                D 2 Replies Last reply Reply Quote 0
                • D
                  Daniel Miller @TaTa
                  last edited by

                  @TaTa hmm … weird. You might try using chpasswd instead of passwd. I think that is available in RHEL … maybe by default. If it is, in functions.sh#L1262, change:

                  echo -e "$password\n$password" | passwd $username >>$workingdir/error_logs/fog_error_${version}.log 2>&1
                  

                  to

                  echo -e "$username:$password" | chpasswd >>$workingdir/error_logs/fog_error_${version}.log 2>&1
                  

                  Don’t have a RHEL system handy to test it with, however.

                  1 Reply Last reply Reply Quote 0
                  • D
                    Daniel Miller @TaTa
                    last edited by

                    @TaTa Actually, what is the result of getenforce?

                    Was searching around a bit and apparently, SELinux can cause some strange behavior…
                    https://forums.fogproject.org/topic/6926/setting-up-fog-password-fails-on-clean-new-centos-7-install

                    Instructions for setting SELinux to permissive or disabled can be found at https://wiki.fogproject.org/wiki/index.php?title=CentOS_7

                    T 1 Reply Last reply Reply Quote 0
                    • T
                      TaTa @Daniel Miller
                      last edited by TaTa

                      @Daniel-Miller Thank you for your replies. I already set it to permissive. Changing line 1262 toecho -e "$username:$password" | chpasswd >>$workingdir/error_logs/fog_error_${version}.log 2>&1 solved setting up passsword issue for fogproject account.

                      I went to update database schema but getting Database connection unavailable. It looks like mysqld is not starting. In /etc/my.cnf files (I can’t find /etc/mysql/my.cnf), socket is pointing to /var/lib/mysql/mysql.sock. I checked mysql.sock and the file exists.

                      mysql -u root and mysql -u root -p gave me ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

                      Trying to restart mysql gave me this error: Redirecting to /bin/systemctl restart mysql.service Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

                      D 1 Reply Last reply Reply Quote 0
                      • D
                        Daniel Miller @TaTa
                        last edited by

                        @TaTa I think your server config file should be at /etc/my.cnf.d/server.cnf.
                        Can you post the output of systemctl status mysqld.service and journalctl -xe?

                        1 Reply Last reply Reply Quote 0
                        • T
                          TaTa
                          last edited by TaTa

                          /etc/my.cnf.d/ exists but it contains no files.

                          systemctl status mysqld.service
                          ● mysqld.service - MySQL Server
                             Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
                             Active: activating (start) since Wed 2019-11-13 11:34:24 EST; 3s ago
                               Docs: man:mysqld(8)
                                     http://dev.mysql.com/doc/refman/en/using-systemd.html
                            Process: 44776 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
                            Control: 44806 (mysqld)
                             CGroup: /system.slice/mysqld.service
                                     ├─44806 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --skip...
                                     └─44809 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --skip...
                          
                          Nov 13 11:34:24 fogprodapp01 systemd[1]: Starting MySQL Server...
                          
                          
                          -- Unit mysqld.service has failed.
                          --
                          -- The result is failed.
                          Nov 13 11:35:30 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state.
                          Nov 13 11:35:30 fogprodapp01 systemd[1]: mysqld.service failed.
                          Nov 13 11:35:30 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart.
                          Nov 13 11:35:30 fogprodapp01 systemd[1]: Stopped MySQL Server.
                          -- Subject: Unit mysqld.service has finished shutting down
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has finished shutting down.
                          Nov 13 11:35:30 fogprodapp01 systemd[1]: Starting MySQL Server...
                          -- Subject: Unit mysqld.service has begun start-up
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has begun starting up.
                          Nov 13 11:35:33 fogprodapp01 nrpe[45775]: warning: /etc/hosts.deny, line 13: missing newline or
                          Nov 13 11:35:34 fogprodapp01 mysqld[45781]: Unable to determine if daemon is running: No such f
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service: control process exited, code=exited st
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: Failed to start MySQL Server.
                          -- Subject: Unit mysqld.service has failed
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has failed.
                          --
                          -- The result is failed.
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state.
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service failed.
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart.
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: Stopped MySQL Server.
                          -- Subject: Unit mysqld.service has finished shutting down
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has finished shutting down.
                          Nov 13 11:35:34 fogprodapp01 systemd[1]: Starting MySQL Server...
                          -- Subject: Unit mysqld.service has begun start-up
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has begun starting up.
                          [root@fogprodapp01 my.cnf.d]#
                          [root@fogprodapp01 my.cnf.d]# clear
                          [root@fogprodapp01 my.cnf.d]# journalctl -xe
                          -- Subject: Unit mysqld.service has failed
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has failed.
                          --
                          -- The result is failed.
                          Nov 13 11:36:00 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state.
                          Nov 13 11:36:00 fogprodapp01 systemd[1]: mysqld.service failed.
                          Nov 13 11:36:00 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart.
                          Nov 13 11:36:00 fogprodapp01 systemd[1]: Stopped MySQL Server.
                          -- Subject: Unit mysqld.service has finished shutting down
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has finished shutting down.
                          Nov 13 11:36:00 fogprodapp01 systemd[1]: Starting MySQL Server...
                          -- Subject: Unit mysqld.service has begun start-up
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has begun starting up.
                          Nov 13 11:36:04 fogprodapp01 mysqld[46228]: Unable to determine if daemon is running: No such f
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service: control process exited, code=exited st
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: Failed to start MySQL Server.
                          -- Subject: Unit mysqld.service has failed
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has failed.
                          --
                          -- The result is failed.
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: Unit mysqld.service entered failed state.
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service failed.
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: mysqld.service holdoff time over, scheduling restart.
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: Stopped MySQL Server.
                          -- Subject: Unit mysqld.service has finished shutting down
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has finished shutting down.
                          Nov 13 11:36:04 fogprodapp01 systemd[1]: Starting MySQL Server...
                          -- Subject: Unit mysqld.service has begun start-up
                          -- Defined-By: systemd
                          -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
                          --
                          -- Unit mysqld.service has begun starting up.
                          
                          
                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by

                            @TaTa There should be a log file somewhere in /var/log/mysql/error.log or similar. Please take a look to see why it doesn’t seem to properly start.

                            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

                            T 1 Reply Last reply Reply Quote 0
                            • T
                              TaTa @Sebastian Roth
                              last edited by

                              @Sebastian-Roth Thank you for pointing me to the right direction. It was mysqld.pid file that was missing. I created it and re-ran the installation and reached to the point where it asks to update database schema but getting Schema Update Fail. Unable to update schema. I put in the same password during the installation where it asked “Is the MySQL password blank?”. I’m able to mysql -u root -p and put in that same password.

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

                                @TaTa said in FOG installation errors:

                                Schema Update Fail. Unable to update schema

                                Any more information you get about why it fails? Error logs?

                                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

                                T 1 Reply Last reply Reply Quote 0
                                • T
                                  TaTa @Sebastian Roth
                                  last edited by

                                  @Sebastian-Roth No error in mysqld log.

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

                                    @TaTa What about Apache und PHP logs?

                                    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
                                    • D
                                      Daniel Miller
                                      last edited by

                                      You may also have a fog_schema_update_error.log someplace. It looks like schemaupdaterpage.page.php drops that if it encounters an error. I’m not entirely sure where it would drop it, however.

                                      T 1 Reply Last reply Reply Quote 0
                                      • T
                                        TaTa @Daniel Miller
                                        last edited by

                                        @Daniel-Miller fog schema update or similar name does not exist in /var/log/fog. Could it be somewhere that I’m not aware of?

                                        Tom ElliottT 1 Reply Last reply Reply Quote 0
                                        • Tom ElliottT
                                          Tom Elliott @TaTa
                                          last edited by

                                          @TaTa under /var/www/fog

                                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                          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

                                          T 1 Reply Last reply Reply Quote 0
                                          • T
                                            TaTa @Tom Elliott
                                            last edited by TaTa

                                            @Tom-Elliott Thank you Tom. It looks like password for fogstorage account password does not meet password policy requirement. Where do I go to change it? I searched in the forums and it looks like there is a fix for it by disabling password validation in mysql https://forums.fogproject.org/topic/11378/fog-show-me-blank-page-on-fresh-install-ubuntu-16-04/12. It would be more ideal if I can change it to a stronger password to meet password policy.

                                            Update ID: 16
                                            Database Error: Failed to query: Error: SQLSTATE[HY000]: General error: 1819 Your password does not satisfy the current policy requirements Error Message: Error Code: "HY000", Error Message: ["HY000",1819,"Your password does not satisfy the current policy requirements"], Debug: SQL: [58] CREATE USER 'fogstorage'@'%' IDENTIFIED BY 'fs30609984138'
                                            Params:  0
                                            
                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 2 / 3
                                            • First post
                                              Last post

                                            229

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project