Database Schema Installer / Updater

[SOL]

@Tom-Elliott I did sudo mysql before running command.

Is it possible that the fog user disappeared by itself ? It was working just fine until this morning and no one touches that server other than me. So if I create the user that should fix it ?

[SOL]

@Tom-Elliott I did create the user and I was able to reset its password and restarted the service but still getting same error

[Tom Elliott]

@SOL FOG, when it runs the installer, does not create a “fog” user for the DB Connectivity. It usually uses ‘root’. So unless somebody totally changed how the installer works, I have doubts that it was setup properly when you looked into a “problem”.

[SOL]

@Tom-Elliott I guess I am confused. Everything was working fine until today. No changes have been made. Are you saying fog was not setup properly when installed ? When I installed fog I pretty much used defaults as far as I can remember.
Is there a way to get it to work again ?

[Tom Elliott]

@SOL I’ll guarantee something changed. FOG didn’t do it, but something got updated/changed/moved what ever the case.

All you need to do is get the ALTER Command to work on your 'root'@'localhost' because if you set it pretty much default, the 'fog'@'localhost' has no bearing at all.

[SOL]

@Tom-Elliott I set the root user password to blank and I am able to use web gui again. I disabled system auto updates just in case for the future.

Thanks for your help!

[fredlwal]

I"m also getting this same issue this morning, I restarted MySQL but no luck still the same error.

[fredlwal]

@SOL how do you set the root password to blank?

[SOL]

@fredlwal instead of ‘password’ type ‘’ (basically nothing in between)

I used this as reference

https://wiki.fogproject.org/wiki/index.php?title=Password_Central

[Tom Elliott]

The quickest and simplest fix is to simply re-run the fog installer.

Unfortunately I don’t have control over ubuntu’s Security update system so that’s left to the admin’s of the machines to fix.

[fredlwal]

@SOL using the ALTER?

[SOL]

@fredlwal Yes

[fredlwal]

@Tom-Elliott is there a way to do something like a system restore to previous settings instead of doing a reinstall?

[Tom Elliott]

@fredlwal that’s basically what a reinstall does.