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

    Upgrade Gone Wrong......

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    18
    2.9k
    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.
    • S
      Sebastian Roth Moderator
      last edited by

      @Arsenal101 said:

      PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php

      You DB does not seem to run properly. service mysql status, ps aux | grep mysql and see if you are able to connect using the command line client mysql -u root -p

      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

      A 2 Replies Last reply Reply Quote 0
      • A
        Arsenal101 @Sebastian Roth
        last edited by

        @Sebastian-Roth When I run the first command you mentioned It says:

        root@SAU-FOG:~/fogproject/bin# service mysql, ps aux | grep mysql
        utility, e.g. service mysql ps
        The script you are attempting to invoke has been converted to an Upstart
        job, but ps is not supported for Upstart jobs.

        Maybe I am entering it wrong. Still kind of lame at linux

        Q 1 Reply Last reply Reply Quote 0
        • A
          Arsenal101 @Sebastian Roth
          last edited by

          @Sebastian-Roth I can connect to mysql no problem though.

          1 Reply Last reply Reply Quote 0
          • Q
            Quazz Moderator @Arsenal101
            last edited by

            @Arsenal101 They’re two separate commands.

            A 1 Reply Last reply Reply Quote 0
            • A
              Arsenal101 @Quazz
              last edited by

              @Quazz Still doesnt like it… I have tried Service mysql status - comes back with service running and the PID,

              service mysql ps aux comes back with the upstart job error.
              service mysql ps same…
              service mysql aux same…

              I am at a loss

              If I do a tail /var/log/apache2/error.log i get serveral lines all the same error PHP Fatal Error Class 'System" not found in /var/www/fog/commons/init.php

              ???

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

                @Arsenal101 What version did you install?

                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

                A 1 Reply Last reply Reply Quote 0
                • A
                  Arsenal101 @Tom Elliott
                  last edited by

                  @Tom-Elliott Should be the latest SVN 5705 i think.

                  I just found this https://forums.fogproject.org/topic/6298/fatal-error-message-when-opening-the-fog-page-http-ip-fog-management

                  Which looks like the problem I am having? I am just not sure exactly how to remedy it.

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

                    @Arsenal101 You think?

                    What does it show on the GUI? Top left next to (maybe inside) the cloud.

                    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

                    A 1 Reply Last reply Reply Quote 0
                    • A
                      Arsenal101 @Tom Elliott
                      last edited by

                      @Tom-Elliott I can’t get to the GUI… I get a PHP error 500 and the page wont load. So I am not sure.

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

                        @Arsenal101 Okay, try this:

                        rm -rf /var/www/fog /var/www/html/fog
                        

                        Re-run the installer.

                        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

                        A 1 Reply Last reply Reply Quote 0
                        • A
                          Arsenal101 @Tom Elliott
                          last edited by

                          @Tom-Elliott You’re then MAN!!!

                          That did it. Once I was able to get the GUI back up it said that It couldn’t communicate with the database. I was able to connect with the database using root and blank password but when I checked the config.class.php I had some text where the password field is. I wiped that out, saved it and refreshed the page and it was asking me to update the database Schema which it should. I took a SQL backup and updated it.

                          Should be back up and running. downloading an image now! Maybe that will fix my slow imaging problem too who knows.

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

                            @Arsenal101 To ensure all goes smoothly on the next upgrade, edit the /opt/fog/.fogsettings file.

                            Look at the snmysqluser= snmysqlpass= and snmysqlhost fields and make sure they’re set properly.

                            In your case:

                            snmysqluser='root'
                            snmysqlpass=''
                            snmysqlhost='IP/Hostname of FOG here'

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

                            241

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project