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

    Unable to see current FoG Version Info After Upgrading Debian from 8 to 9, then from 9 to 10

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    21
    2.8k
    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.
    • george1421G
      george1421 Moderator @carl.d
      last edited by

      @carl-d Just to be clear you installed FOG 1.5.9.110 or later from the dev branch and not 1.5.9GA?

      I will spin up a test debian 11 instance tonight and test to see if I get the same error during an install. Your issues are new so I’m concerned that something got missed. I’ll let you know what I find.

      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!

      C 1 Reply Last reply Reply Quote 0
      • C
        carl.d @george1421
        last edited by

        @george1421
        Yes, I installed FOG 1.5.9.xxx from the dev branch - what command can I run to confirm the fogserver version?

        I updated the password to the fogstorage user, in the /opt/fog/.fogsettings file because it didn’t match what I was given during the upgrade.

        After doing that, I can get to the schema update page however I get the following errors when trying to update the schema:

        Database Error:

        Failed to query: Error: SQLSTATE[42000]: Syntax error or access violation: 1142 UPDATE command denied to user ‘fogstorage’@‘localhost’ for table ‘globalSettings’ Error Message: Error Code: “42000”, Error Message: [“42000”,1142,“UPDATE command denied to user ‘fogstorage’@‘localhost’ for table ‘globalSettings’”], Debug: SQL: [266] UPDATE globalSettings SET settingDesc='Email address(s) to send the reports to. Separate multiple emails by comma (e.g. user_a@domain.com, user_b@domain2.com). Token ${user-name} is replaced by the task creators username.'WHERE settingKey=‘FOG_EMAIL_ADDRESS’
        Params: 0
        Variable contains:

        Array
        ( [0] => UPDATE globalSettings SET settingDesc='Email address(s) to send the reports to. Separate multiple emails by comma (e.g. user_a@domain.com, user_b@domain2.com). Token ${user-name} is replaced by the task creators username.'WHERE settingKey=‘FOG_EMAIL_ADDRESS’
        )
        Database SQL:

        UPDATE globalSettings SET settingDesc='Email address(s) to send the reports to. Separate multiple emails by comma (e.g. user_a@domain.com, user_b@domain2.com). Token ${user-name} is replaced by the task creators username.'WHERE settingKey=‘FOG_EMAIL_ADDRESS’

        george1421G 1 Reply Last reply Reply Quote 0
        • george1421G
          george1421 Moderator @carl.d
          last edited by

          @carl-d said in Unable to see current FoG Version Info After Upgrading Debian from 8 to 9, then from 9 to 10:

          “UPDATE command denied to user ‘fogstorage’@‘localhost’ for table ‘globalSettings’”

          This tells me the password you configured for fogstorage doesn’t match what the install created in the database.

          Something bad happened during the install. Its going to be tough to fix but not impossible.

          On the fog server linux console, switch to root with
          sudo su -
          Then we are going to follow this document https://linuxize.com/post/how-to-change-mysql-user-password/

          Login to the mysql database as root
          mysql -u root -p

          then in mysql we will need to issue this command
          ALTER USER 'fogstorage'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
          FLUSH PRIVILEGES;
          GRANT ALL PRIVILEGES ON fog.* TO 'fogstorage'@'localhost';

          Where NEW_USER_PASSWORD is the password you changed into the .fogsettings file.

          That should fix the mysql access permissions.

          …
          For some reason fogstorage looks wrong. The next bit was I was going to check what password the fog program uses to talk to the database. Looking at /var/www/html/fog/lib/fog/config.class.php I see the fog php code uses the fogmaster user account not fogstorage. I wonder if its going to be easier to fix this by blowing away the current fog install and reinstalling things again. The install of 1.5.9.110 or later should install cleanly on debian 11. So I’m not sure which will be quicker, trying to fix a botched install or just starting over again.

          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!

          C 1 Reply Last reply Reply Quote 0
          • C
            carl.d @george1421
            last edited by

            @george1421
            Ahhhh George thank you so much!!!

            I had to create the fogstorage account within mysql and then apply the password, but after doing so I was able to update the schema and now I’m also able to login!

            I’m going to download and upload a couple of images to test that functionality but this is further than I’ve gotten and it feels great!

            I greatly appreciate your assistance!

            C 1 Reply Last reply Reply Quote 0
            • C
              carl.d @carl.d
              last edited by carl.d

              @george1421

              I’m getting ready to test download & capture (upload), though I did notice the storage usage chart in the upper right corner of the dashboard has gone missing.

              Also, from within the FoG configuration page the kernel update, and log viewer, sub-pages give me a 500 error. From the home section of the fog configuration page, the fog version information section reads “Failed to get version info”.

              These are mere annoyances that I can certainly live without as long as I’m able to image new machines and upload new images.

              C 1 Reply Last reply Reply Quote 0
              • C
                carl.d @carl.d
                last edited by

                @george1421

                I had a capture already in progress from last night that was failing (it couldn’t write back to the database that the capture task had completed, so it was stuck in a loop of uploading and then failing to update the task status then rebooting and uploading again), it succeeded!

                This failure was the catalyst for me trying to upgrade to Debian 11 and FoG 1.5.9. So I’m very happy with this result.

                I see now that when I click the blue task button to begin a download or upload task, the task gets created but I’m taken to a broken page (500 error). So I hit my back button and went back to my hosts that way.

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

                  @carl-d said in Unable to see current FoG Version Info After Upgrading Debian from 8 to 9, then from 9 to 10:

                  I see now that when I click the blue task button to begin a download or upload task, the task gets created but I’m taken to a broken page (500 error).

                  Please check the apache and PHP logs (see my signature) and post relevant information 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

                  C 1 Reply Last reply Reply Quote 0
                  • C
                    carl.d @Sebastian Roth
                    last edited by carl.d

                    @sebastian-roth

                    Here’s what I’m seeing in the Apache2 error.log:

                    %Date&TimeStamp% [proxy_fcgi:error] [pid ####] [client LAN-IP:port] AH01071: Got error ‘PHP message: PHP Warning: Use of undefined constant CURLOPT_SSL_VERIFYPEER - assumed ‘CURLOPT_SSL_VERIFYPEER’ (this will throw an Error in future version of PHP) in /var/www/html/fog/lib/fog/fogbase.class.php on line 481PHP message: PHP Warning: Use of undefined constant CURLOPT_SSL_VERIFYHOST -assumed ‘CURLOPT_SSL_SERIFYHOST’ (this will throw an Error in a future version of PHP) in /var/www/html/fog/lib/fog/fogbase.class.php on line 481PHP message: PHP Warning: Use of undefined constant CURLOPT_RETURNTRANSFER - assumed ‘CURLOPT_RETURNTRANSFER’ (this will throw an Error in a future version of PHP) in /var/www//html/fog/lib/fog/fogbase.class.php on line 481PHP message: PHP Warning: Use of undefined constant ‘CURLOPT_CONNECTTIMEOUT - assumed ‘CURLOPT_CONNECTTIMEOUT’ (this will throw an Error in a future version of PHP) in /var/www/html/fog/lib/fog/fogurlrequests.class.php on line 146PHP message: PHP Warning: Use of undefined constant CURLOPT_TIMEOUT -assumed ‘CURLOPT_TIMEOUT’ (this will throw an Error in a future version of PHP) in /var/www//html/fog/lib/fog/fogurlrequests.class.php on line 147PHP message: PHP Warning: Use of undefined constant CURLOPT_SSL_VERIFYPEER’ (this will throw an Error in future version of PHP) /var/www//html/fog/lib/fog/fogbase.class.php on line 158PHP message: PHP Warning CURLOPT_SSL_VERIFYHOST -assumed ‘CURLOPT_SSL_SERIFYHOST’ (this will throw an Error in a future version of PHP) in /var/www//html/fog/lib/fog/fogurlrequests.class.php on line 159PHP message: PHP Warning: Use of undefined constant CURLOPT_RETURNTRANSFER - assumed ‘CURLOPT_RETURNTRANSFER’ (this will throw an Error in a future version of PHP) in /var/www//html/fog/lib/fog/fogurlrequests.class.php on line 160’

                    Checking PHP 7.4 logs, not much there but here are the last two lines;
                    %Date&TimeStamp% NOTICE: [pool www] child 22019 exited with code 0 after 1476.###### seconds >
                    %Date&TimeStamp% NOTICE: [pool www] child 24654 started

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

                      @carl-d said in Unable to see current FoG Version Info After Upgrading Debian from 8 to 9, then from 9 to 10:

                      Use of undefined constant CURLOPT_SSL_VERIFYPEER

                      Please make sure the package php-curl is being installed: dpkg | grep curl and if you don’t see the package to be installed then apt install php-curl (restart your FOG server after that).

                      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
                        carl.d @Sebastian Roth
                        last edited by

                        @sebastian-roth

                        I did have to install php-curl, and now everything is working properly. Thank you very, very much sebastian-roth! I greatly appreciate your help!

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

                          @carl-d said in Unable to see current FoG Version Info After Upgrading Debian from 8 to 9, then from 9 to 10:

                          I did have to install php-curl, and now everything is working properly.

                          Probably a good idea to manually edit the “packages” line in /opt/fog/.fogsettings and add the php-curl to that as well.

                          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
                          • 2
                          • 1 / 2
                          • First post
                            Last post

                          196

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project