• 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

      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 ElliottT 1 Reply Last reply Reply Quote 0
        • george1421G
          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
          • 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
            • Tom ElliottT
              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

              george1421G 1 Reply Last reply Reply Quote 1
              • 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
                • george1421G
                  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 WorkmanW 1 Reply Last reply Reply Quote 0
                  • Tom ElliottT
                    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
                    • Wayne WorkmanW
                      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
                      • 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
                        • Tom ElliottT
                          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 that is correct

                            Tom ElliottT 1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              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 no I don’t. I tried the ALTER USER ‘root’… command from another post but got a syntax error. .

                                Tom ElliottT 1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  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
                                    @@version
                                    5.7.18-0ubuntu0.16.04.1
                                    1 row in set (0.00 sec)

                                    1 Reply Last reply Reply Quote 0
                                    • Tom ElliottT
                                      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
                                        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 ElliottT 1 Reply Last reply Reply Quote 0
                                        • Tom ElliottT
                                          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
                                          • Tom ElliottT
                                            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
                                            • 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
                                              • 1 / 1
                                              • First post
                                                Last post

                                              166

                                              Online

                                              12.0k

                                              Users

                                              17.3k

                                              Topics

                                              155.2k

                                              Posts
                                              Copyright © 2012-2024 FOG Project