Cant access management portal

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.

@CoxM The message ... Uncaught Error: Call to a member function lastInsertId() ... in the logs most certainly means that the database connection information set in /var/www/fog/lib/fog/config.class.php is not correct and therefore the PHP web UI cannot connect to the database!

Did you follow Tom’s suggestions on altering/resetting the database passwords (... mysql_native_password ...) as well as comparing the username/password in the mentioned files? Your answer to that was “No luck”. But what did you do and what happened. We can’t really help if we don’t know what exactly you tried and why it did not work from your point of view.

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

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