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

lost web GUI on fog server

Scheduled Pinned Locked Moved Solved
FOG Problems
5
20
6.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.
  • T
    templink
    last edited by Apr 30, 2017, 10:10 PM

    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 May 1, 2017, 1:09 PM

      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!

      T 1 Reply Last reply May 1, 2017, 1:09 PM Reply Quote 0
      • G
        george1421 Moderator
        last edited by Apr 30, 2017, 11:08 PM

        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
        • T
          templink
          last edited by templink Apr 30, 2017, 5:44 PM Apr 30, 2017, 11:43 PM

          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
          • T
            Tom Elliott
            last edited by Apr 30, 2017, 11:45 PM

            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

            G 1 Reply Last reply May 1, 2017, 12:01 AM Reply Quote 1
            • T
              templink
              last edited by Apr 30, 2017, 11:50 PM

              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
              • G
                george1421 Moderator @Tom Elliott
                last edited by May 1, 2017, 12:01 AM

                @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!

                W 1 Reply Last reply May 1, 2017, 2:24 AM Reply Quote 0
                • T
                  Tom Elliott
                  last edited by May 1, 2017, 12:10 AM

                  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 May 1, 2017, 4:43 AM Reply Quote 1
                  • W
                    Wayne Workman @george1421
                    last edited by Wayne Workman Apr 30, 2017, 8:26 PM May 1, 2017, 2:24 AM

                    @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
                    • T
                      templink @Tom Elliott
                      last edited by May 1, 2017, 4:43 AM

                      @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
                      • T
                        Tom Elliott
                        last edited by May 1, 2017, 12:11 PM

                        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 May 1, 2017, 12:17 PM Reply Quote 0
                        • T
                          templink @Tom Elliott
                          last edited by May 1, 2017, 12:17 PM

                          @Tom-Elliott that is correct

                          T 1 Reply Last reply May 1, 2017, 12:18 PM Reply Quote 0
                          • T
                            Tom Elliott @templink
                            last edited by May 1, 2017, 12:18 PM

                            @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 May 1, 2017, 12:28 PM Reply Quote 0
                            • T
                              templink @Tom Elliott
                              last edited by May 1, 2017, 12:28 PM

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

                              T 1 Reply Last reply May 1, 2017, 12:34 PM Reply Quote 0
                              • T
                                Tom Elliott @templink
                                last edited by May 1, 2017, 12:34 PM

                                @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 May 1, 2017, 12:49 PM Reply Quote 0
                                • T
                                  templink @Tom Elliott
                                  last edited by May 1, 2017, 12:49 PM

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

                                  1 Reply Last reply Reply Quote 0
                                  • T
                                    Tom Elliott
                                    last edited by May 1, 2017, 1:09 PM

                                    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 Apr 24, 2018, 1:41 PM Reply Quote 0
                                    • T
                                      templink
                                      last edited by May 1, 2017, 1:09 PM

                                      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!

                                      T 1 Reply Last reply May 1, 2017, 1:09 PM Reply Quote 0
                                      • T
                                        Tom Elliott @templink
                                        last edited by May 1, 2017, 1:09 PM

                                        @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
                                          Tom Elliott
                                          last edited by May 1, 2017, 1:19 PM

                                          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
                                          • N
                                            NT_Tech @Tom Elliott
                                            last edited by Apr 24, 2018, 1:41 PM

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

                                            210

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project