Your database connection appears to be invalid

[Wayne Workman]

Both of you, Try to restart mysql.

service mysql restart
Then check status:
service mysql status
Also look through this, try the tests:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

[shanerlevy]

I am facing the same issue. FOG version 1.3.0 and Ubuntu Server version 16.04. MySQL service is up and running as well.

[Wayne Workman]

Related: https://forums.fogproject.org/topic/9345/database-connection-appears-to-be-invalid

[Wayne Workman]

@Tom-Elliott @Developers @Moderators @Testers

This is the fourth report today of this - does anyone know anything?

FOG Versions are different, 1.3.0, 1.3.3, and 1.3.0 RC 19. The only thing in common is Ubuntu 16.04. Did an OS update break something?

[egregers]

@Wayne-Workman

I restarted MySQL and now the web interface is just blank. nothing on it. going tread through the document.

[Tom Elliott]

@egregers remove PHP version stuff from fog settings. Remove packages from fog settings. Rerun installer

[Wayne Workman]

@egregers This sounds more like a PHP issue than a DB one. Look in the apache error logs.

[dbakerwardog]

@Tom-Elliott what steps or terminal commands would I need to do to remove though items?
Thanks

[Wayne Workman]

@dbakerwardog

cd /opt/fog
vim .fogsettings  #or nano

locate the line that begins with packages and ver and veradds and remove those lines, save, then re-run the fog installer.

Reference:
https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
and:
https://wiki.fogproject.org/wiki/index.php?title=Vi

[shanerlevy]

@Wayne-Workman This seemed to have fixed my issue, thank you very much.

[FlareImp]

This also took care of my issue. Do we know what the cause was so it doesn’t happen again?

[Wayne Workman]

@FlareImp Turn off automatic updates - I suspect an automatic OS update is what broke it.

[egregers]

This post is deleted!

[FlareImp]

@Wayne-Workman Automatic Updates are already disabled on my servers. I do not update the OS once fog has been installed. It tends to break things.

[egregers]

@Tom-Elliott

This fixed it. I can login to the dashboard now. Thanks!!!

[Wayne Workman]

@FlareImp said in Your database connection appears to be invalid:

@Wayne-Workman Automatic Updates are already disabled on my servers. I do not update the OS once fog has been installed. It tends to break things.

Check again. All these different versions of FOG all stopped working for 4 different people… Today. The only thing in common is Ubuntu 16.04. It’s almost surely an OS update that broke it. It really couldn’t have been anything else.

[Tom Elliott]

https://news.fogproject.org/fog-1-3-4-rc-1/

[Trev-lchs]

@egregers what fixed it?

[Sebastian Roth]

@Trev-lchs Please open a new topic and post all your details: FOG version, exact error message (best a picture) and so on!

[Trev-lchs]

@Sebastian-Roth Hi Thanks Sebastian, i have solved this now, i made the mistake of updating the OS which broke fog, i then reran the installer which worked a magic fix and now this all works, i have now updated to the very latest version of fog