lost web GUI on fog server



  • 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.


  • Senior Developer

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


  • Senior Developer

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



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


  • Senior Developer

    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.



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


  • Senior Developer

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

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



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


  • Senior Developer

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



  • @Tom-Elliott that is correct


  • Senior Developer

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



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


  • Moderator

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


  • Senior Developer

    What version of FOG are you running?

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


  • Moderator

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



  • 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


  • Senior Developer

    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”)



  • 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?


  • Moderator

    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.


Log in to reply
 

358
Online

39.5k
Users

11.1k
Topics

105.6k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.