Your database connection appears to be invalid

[egregers]

Server

• FOG Version: 1.3.0 RC19
• OS: Ubuntu 16.04

Client

• Service Version:
• OS:

Description

I get this message when I try and access the fog web page.
Database Schema Installer / Updater

Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and if the Database service is running, check to ensure your filesystem has enough space.

The system has enough space and it was working up until today.

Also what do I need to do to upgrade to the lates version of fog?

Thanks

[dbakerwardog]

I am facing this error as well all things were fine until today, Please help!!
Fog version 1.3.0
OS: Ubuntu 16.04 LTS

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