Cant access management portal

[CoxM]

Hey all,
My FOG has been running great for some time. Recently we had some drama on the network (long story!) which meant we have to just turn off FOG asap, no grace nothing, just end the VM. This had to be done due to domain membership changes.

I have now started the server again with a disabled virtual network card so that I can go in and adjust the AD domain details. unfortunately even going to 127.0.0.1 it wont load the portal. I just get a blank white screen.

Any thoughts?
Thanks

[CoxM]

Just to add to this issue

When I type in 127.0.0.1/fog/management it changes the url to 127.0.0.1/fog/management/?node=schema

If i disable the apache2 service it doesn’t change the url, restart it and it does again so something is working right, just not showing me the portal!

[CoxM]

also found the mysql service is not running and failing to start, should it be running?

[Sebastian Roth]

@CoxM Yes mysql should definitely be running. What version of FOG and which Linux do you use? Please post the errors here and we sure can help.

[CoxM]

@sebastian-roth Here is what I am getting
image url)

[Tom Elliott]

@coxm What’s output of:

df -h

[CoxM]

@tom-elliott

[Tom Elliott]

What’s output of systemctl status -l mysql

[CoxM]

@tom-elliott

[CoxM]

@Tom-Elliott I have ow had some progress, turns out MySQL wouldn’t start due to the local nic being disabled and therefore couldn’t bind. This is now resolved but still I get an empty white screen from the fog management url.

[Sebastian Roth]

@CoxM Check the apache logs. See my signature on where to find those.

[CoxM]

@sebastian-roth @Tom-Elliott
thanks for the help, I was out the office for a few days but back now and really need to get this sorted… Apache2 error…

[Sebastian Roth]

@CoxM Check out this article in our wiki: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

[CoxM]

@sebastian-roth Thanks, any pointers what to look for, there is alot of info on that link.

[CoxM]

@sebastian-roth That doesn’t seem to have resolved it.
Do you think its still a mysql issue? The MySQL error appears to have gone away and the service has started. I ran the repair sql command but all came back with status of ok.

[Sebastian Roth]

@CoxM But from the apache error look it seems like the mysql connection information (username, password) do not match. Check /opt/fog/.fogsettings plus /var/www/fog/lib/fog/config.class.php for mysql connection info. Then try to connect to the database using the command line tool as described in the wiki page to see if the credentials are correct.

[CoxM]

@sebastian-roth ok cool, that makes sense. Where can I take the correct sql credentials from? .fogsettings?

Thanks,

Matt

[Sebastian Roth]

@CoxM Those all need to match up! .fogsettings is what the installer uses, config.class.php is used by the web UI… (and should be generated by the installer).

[CoxM]

@sebastian-roth Thanks. I did have some issues with username and password matching when configuring a new storage node but it still worked after that.

I can see in .fogsettings I have the username and password field which appears to be what I use to login to the fog web ui. then there is snmysqluser, snmysqlpass and snmysqlhost. currently thats “root”, blank and “localhost”. Is that correct?

Any further guidance this would be amazing.

Thanks,

Matt

[CoxM]

@sebastian-roth
This is what happens when using the username “root” and the same password as I would use to log into the fog web ui