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

    Solved lost web GUI on fog server

    FOG Problems
    5
    20
    6091
    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
      templink last edited by

      blank screen on fog server after updating Ubuntu.
      When I try to launch http://localhost/fog/management/index.php?node=schema on the fog server (locally), nothing comes up. This was working recently. I also patched Ubuntu 16.04 LTS with apt-get.

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

        I inserted “BY” without the quotes and avoided the previous syntax errors:

        mysql> ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘’;
        Query OK, 0 rows affected (0.00 sec)

        mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;
        Query OK, 0 rows affected (0.00 sec)

        relaunched Firefox to GUI, success!

        Tom Elliott 1 Reply Last reply Reply Quote 0
        • N
          NT_Tech @Tom Elliott last edited by

          Thanks! @tom-elliott

          Just had this issue with Ubuntu 16.04 and Fog 1.4.4

          Followed these steps and I am back in business!

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

            Altered my posting to have these changes as well, thanks for the information.

            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
            • Tom Elliott
              Tom Elliott @templink last edited by

              @templink Then forget my last statement. I suppose it could be useful but just making sure.

              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
              • T
                templink last edited by

                I inserted “BY” without the quotes and avoided the previous syntax errors:

                mysql> ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘’;
                Query OK, 0 rows affected (0.00 sec)

                mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘’;
                Query OK, 0 rows affected (0.00 sec)

                relaunched Firefox to GUI, success!

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

                  Can you grab a backup of your current SQL data?

                  You’d likely need to do mysqldump from the command line.

                  sudo mysqldump -u root fog >~/fog_backup_beforepurge.sql
                  

                  Then purge all php apache and mysql stuff:

                  sudo rm -rf /etc/php* /etc/apache2*
                  sudo rm -rf /etc/mysql* /var/lib/mysql*
                  sudo DEBIAN_FRONTEND=noninteractive apt-get purge -yq 'apache2*' 'php5*' 'php7*' 'libapache*' 'mysql*'
                  sudo apt-get clean -yq
                  

                  This is kind of a direct thing to do, so please, by all means, make sure you have a backup of your sql file. There should be some backups in /home/fogDBbackups but I don’t want to trust that the installer was working right now.

                  Edit the /opt/fog/.fogsettings file and remove the php_ver and php_verAdds, and packages lines please.

                  Essentially what these steps will do is remove all traces of PHP, Apache, and MySQL in an attempt to get the Ubuntu 16.04 system to reinstall freshly.

                  Once all is ready, re-run the installer. (make sure you have your copy ready to go).

                  Once the installer completes. You’ll need to restore the backup db you grabbed before beginning.

                  You can reapply this sql file with:

                  sudo mysql -u root fog < ~/fog_backup_beforepurge.sql
                  

                  With any luck this will help fix any missing packages and make sure all mysql is ready to go.

                  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

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

                    @Tom-Elliott
                    @@version
                    5.7.18-0ubuntu0.16.04.1
                    1 row in set (0.00 sec)

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

                      @templink it sounds like the version of mysql is old then.

                      Can you get output of: SELECT @@version; from the mysql cli?

                      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
                        templink @Tom Elliott last edited by

                        @Tom-Elliott no I don’t. I tried the ALTER USER ‘root’… command from another post but got a syntax error. .

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

                          @templink Do you have a password defined for your MySQL user?

                          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
                            templink @Tom Elliott last edited by

                            @Tom-Elliott that is correct

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

                              So the installer is running all the way through, just when you try to go to the UI you run into issues?

                              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
                                templink @Tom Elliott last edited by

                                @Tom-Elliott just upgraded to Version: 1.4.0-RC-9.2 (several times just to be sure). That didn’t fix it.

                                1 Reply Last reply Reply Quote 0
                                • Wayne Workman
                                  Wayne Workman @george1421 last edited by Wayne Workman

                                  @george1421 It wouldn’t help if they don’t run it from root, as root. Also, I don’t think the recent Ubuntu issue is the problem here. The ubuntu issue results in a “couldn’t establish connection” problem. This is different, he gets a blank screen - or in other words a plain white screen. This is a PHP syntax issue or bad variable or something with Apache or PHP.

                                  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!
                                  Daily Clean Installation Results:
                                  https://fogtesting.fogproject.us/
                                  FOG Reporting:
                                  https://fog-external-reporting-results.fogproject.us/

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

                                    What version of FOG are you running?

                                    If you reran the installer, this problem should’ve failed to complete installing.

                                    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 1
                                    • george1421
                                      george1421 Moderator @Tom Elliott last edited by

                                      @Tom-Elliott Tom, is there a way the FOG Project can create that as a .sql script that we direct people to download with a wget command from the repository? I think there is a back tick, quote, double quote issue here? Or is the right solution to direct the posters to just rerun 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!

                                      Wayne Workman 1 Reply Last reply Reply Quote 0
                                      • T
                                        templink last edited by

                                        yes I ran mysql as root. I also re-ran the fog installer and rebooted the box.

                                        Apache error log shows repeated entry:
                                        [Sun Apr 30 18:06:56.749350 2017] [php7:error] [pid 26075] [client 127.0.0.1:36406] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/html/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/html/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/html/fog/lib/fog/hookmanager.class.php(176): FOGController->save()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/html/fog/lib/fog/fogbase.class.php(445): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/html/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/html/fog/lib/db/pdodb.class.php on line 443

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

                                          did you run the mysql command as root?

                                          Have you tried re-running the fog installer?

                                          What’s in your apache error logs? (Basing this on “nothing comes up”)

                                          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

                                          george1421 1 Reply Last reply Reply Quote 1
                                          • T
                                            templink last edited by templink

                                            That did not fix my problem.
                                            when I go into MySql and paste in those two commands, I get a syntax error:

                                            mysql> ALTER USER ‘root’@‘127.0.0.1’ IDENTIFIED WITH mysql_native_password ‘’;
                                            ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’‘’ at line 1
                                            mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password ‘’;
                                            ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’‘’ at line 1
                                            mysql>

                                            Any more suggestions? I appreciate it. Did I type something wrong?

                                            1 Reply Last reply Reply Quote 0
                                            • george1421
                                              george1421 Moderator last edited by

                                              https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

                                              You might want to review the link above. It appears that ubuntu did something not to nice.

                                              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!

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

                                              188
                                              Online

                                              10.4k
                                              Users

                                              16.4k
                                              Topics

                                              150.5k
                                              Posts

                                              Copyright © 2012-2023 FOG Project