lost web GUI on fog server

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