FOG Project

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

    Solved Problems with DB setup during upgrade to 1.5.8

    FOG Problems
    2
    11
    455
    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.
    • H
      Hanz last edited by

      Server running Fedora 30 on Hyper-V VM and after being prompted to enter root passwordand hitting ENTER I get the following error…

      The current fogstorage database password does not meet high
         security standards. We will generate a new password and update
         all the settings on this FOG server for you. Please take note
         of the following credentials that you need to manually update
         on all your storage nodes' /opt/fog/.fogsettings configuration
         files and re-run (!) the FOG installer:
         snmysqluser='fogstorage'
         snmysqlpass='fIQ03SoTJxHjKD@0D0xL'
      
         Press [Enter] to proceed after you noted down the credentials.
      
       * Setting up MySQL user and database..........................Failed!
      [root@fog-server bin]#
      

      I’ve read that there are workarounds for blank passwords, but I can access mysql -u root -p correctly with password. Before and after attempted installation. Any suggestions ?

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

        After digging through the logs Hanz found that mysql_upgrade needed to be called to fix this issue. It’s very interesting we have not had too many people running into this but I am sure this is valuable information for others seeing this.

        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

        1 Reply Last reply Reply Quote 0
        • H
          Hanz @Sebastian Roth last edited by Hanz

          @Sebastian-Roth Error looks very similar, but doesn’t even get to the Setting up MySQL user and database

          I know there isn’t the whole log, but all other options either skipped or ok to this point.

          Foginstall.log

          The current *fogstorage* database password does not meet high
             security standards. We will generate a new password and update
             all the settings on this FOG server for you. Please take note
             of the following credentials that you need to manually update
             on all your storage nodes' /opt/fog/.fogsettings configuration
             files and re-run (!) the FOG installer:
             snmysqluser='fogstorage'
             snmysqlpass='5dpy!GfbeoTr3EPFmLVl'
          
             Press [Enter] to proceed after you noted down the credentials.
          
          Failed!
          

          Fog_Error_1.5.9-RC2.8.log

          chsh: Shell not changed.
          Changing shell for fogproject.
          New password: Retype new password: Changing password for user fogproject.
          passwd: all authentication tokens updated successfully.
          ERROR 1558 (HY000) at line 8: Column count of mysql.proc is wrong. Expected 21,>
          
          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator last edited by

            This is solved in latest dev-branch.

            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

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

              @Hanz Reaching out to you via chat.

              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

              1 Reply Last reply Reply Quote 1
              • H
                Hanz @Sebastian Roth last edited by

                @Sebastian-Roth typed

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

                  @Hanz When asked to type in the DB root password by the installer, do you copy&paste it or type it on the keyboard? I can imagine that copy&paste on some terminals doesn’t work. Not sure if it’s the case here but I have seen strange characters being added when copy&pasting text to some consoles, like 0~pastetext~1 or something similar.

                  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

                  H 1 Reply Last reply Reply Quote 0
                  • H
                    Hanz @Sebastian Roth last edited by Hanz

                    @Sebastian-Roth yessir, but not with blank password mysql -u root…

                    Does this look strange or anything ? this is under fog database

                    MariaDB [fog]> select user, password, host from mysql.user;
                    +------------+-------------------------------------------+------------+
                    | user       | password                                  | host       |
                    +------------+-------------------------------------------+------------+
                    | root       | (I removed)                               | localhost  |
                    | root       |                                           | fog-server |
                    | root       |                                           | 127.0.0.1  |
                    | root       |                                           | ::1        |
                    |            |                                           | localhost  |
                    |            |                                           | fog-server |
                    | fogstorage | (I removed)           t                   | %          |
                    +------------+-------------------------------------------+------------+
                    7 rows in set (0.000 sec)
                    
                    MariaDB [fog]>
                    
                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator last edited by

                      @Hanz But you are able to login to the DB using mysql -u root -p??

                      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

                      H 1 Reply Last reply Reply Quote 0
                      • H
                        Hanz @Sebastian Roth last edited by

                        @Sebastian-Roth

                         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:
                        
                           Failed! Terminating installer now.
                        [root@fog-server bin]#
                        

                        GNU nano 4.2 fog_error_1.5.8.19.log
                        xinetd-2.3.15-28.fc30.x86_64
                        xz-devel-5.2.4-5.fc30.x86_64
                        chsh: Shell not changed.
                        Changing shell for fogproject.
                        New password: Retype new password: Changing password for user fogproject.
                        passwd: all authentication tokens updated successfully.

                        error log posted above

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

                          @Hanz Would you please try the latest from dev-branch? https://github.com/FOGProject/fogproject/archive/dev-branch.zip

                          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

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

                          193
                          Online

                          10.2k
                          Users

                          16.3k
                          Topics

                          149.9k
                          Posts

                          Copyright © 2012-2020 FOG Project