Updated Ubuntu and now cannot get to fog gui

[IdahoTech]

Hello Everyone,

I did a sudo apt-get upgrade and let ubuntu do its thing but didn’t upgrade to the latest still on the same before issuing the command.

Now after restarting the server I try to go to the web gui and get

Database connection unavailable

What changed and how do I fix this so I can get back into my fog installation???

Help? Kind of a noob when it comes to linux but can limp along with it if get a little help.

Thanks for any help out there…

[Daniel Miller]

Was there a security update to mariadb in all that mess? May want to have a read through Ubuntu is FOG’s enemy.

[IdahoTech]

I do not know, there a way to view what was updated? I started it then had a call to take care of and when back it was done and rebooted it…

[Daniel Miller]

@IdahoTech apt logs should be in /var/log/apt/history.log and /var/log/apt/term.log

[Sebastian Roth]

@IdahoTech First check the DB actually runs: systemctl status mysql

Post output here.

[IdahoTech]

From what I can see it is running…not sure how to post the output here other than retyping it.

I do not see any errors or anything of that sort. Is there something specific that I should look for in the output?

[madeyem]

Sounds like it could be the problem described here:

https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy?page=1

[IdahoTech]

When I try to run mysql -u root -p and I set it up with no password it doesn’t work. Then when I try the password for the adminuser I have that is tied to root it doesn’t work either…before it did…does it reset the password or something?

[IdahoTech]

@madeyem THANK YOU !! That saved my bacon! So let me ask this to all who answered do you have a password on your sql? Seems to be a problem with ‘no password’ mysql installations…

Again Thank you for this…it is now working.

[george1421]

@IdahoTech said in Updated Ubuntu and now cannot get to fog gui:

So let me ask this to all who answered do you have a password on your sql? Seems to be a problem with ‘no password’ mysql installations…

Just as an FYI, this issue is being addressed in the soon to be released FOG version 1.5.8. In 1.5.8 there will be tighter controls on the database side. The downside is that the FOG admin will need to remember the root password for mysql since it won’t be recorded anywhere in FOG. FOG shouldn’t need the root user’s password for mysql except the first time FOG is installed, it need’s root’s password to setup the FOG database. After that there is a foguser created that interacts with the FOG database even during upgrades.