lost web GUI on fog server

[george1421]

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.

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

[Tom Elliott]

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

[templink]

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

[george1421]

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

[Tom Elliott]

What version of FOG are you running?

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

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

[templink]

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

[Tom Elliott]

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

[templink]

@Tom-Elliott that is correct

[Tom Elliott]

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

[templink]

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

[Tom Elliott]

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

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

[templink]

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

[Tom Elliott]

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.

[templink]

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]

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

[Tom Elliott]

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

[NT_Tech]

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!