"Database connection unavailable"

[fishfox]

Fog server was working fine yesterday but today I’m getting “Database connection unavailable”.

mysql systemd unit is running fine on Ubuntu 16.04.

Any ideas?

[fishfox]

Fixed for now: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy
Had to reblank the root password

Is there a way to put a password in FOG so the password doesn’t have to be blank?

[george1421]

@fishfox Yes, if before you install FOG you configure the mysql database root’s password to something other than blank, then install FOG. DUring the fog installation it will ask if root’s password has been changed from the default value. Answer yes here and then give the installer roots password for mysql.

[fishfox]

@george1421 Excellent…uhh…how do I mark this as solved?

[Tom Elliott]

@fishfox just ask!

[fishfox]

@tom-elliott Thanks

[EricZ]

@george1421 I’m getting the same error during installation. I previously left the password blank for SQL and the webpage wouldn’t even work. When I have it the same password as Root, I get the “database connection unavailable” message and I can’t continue with FOG install. Help!

[george1421]

@EricZ Is this a ubuntu box? What fog working one day and then the next with no changes it stopped?

If so take a look at this article: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

In an upcoming release of FOG the developers are going to address this issue by moving away from the root user for schema updates. But for now we’ll have to manage with that article.

Edit: Ah I see I linked that article in already. For now the password for root in mysql needs to be blank to get things working again.

[EricZ]

@george1421 This is a new installation using CentOS 8. I followed the WIKI for CentOS 7 as there is no guide for 8. At the point where I need to configure the database in the FOG installation process I get the error “Database connection unavailable”. I don’t know a lot about Linux. My only experience was with MacOS X and a training class I took about 12 years ago.

[george1421]

@EricZ said in "Database connection unavailable":

new installation using CentOS 8

Oh, no you didn’t…

FOG 1.5.7 does not support Centos 8 just yet. You can get to a point where you can install FOG as long as you use the git method.

If you are using the git method change into the base of the fogproject directory and issue the following command git checkout dev-branch
Then issue a git pull and finally change to the bin directory and reinstall fog by keying in ./installfog.sh This will install fog 1.5.7.49.<something> Which is compatible with Centos 8

[EricZ]

@george1421 I navigated to /Home/fogproject and ran the “git checkout dev-branch” and got “not a git repository” error message. This is all so over my head. Maybe I’ll just see if I can download CentOS 7 and try to get it to work. A friend told me this was easy to setup but it seems you really have to know a lot about linux. I’m from the Windows and Mac world where you just install it and it goes.

[george1421]

@EricZ said in "Database connection unavailable":

“git checkout dev-branch”

Hmm. Maybe I’m having a senior moment here… Lets try git checkout working . Its not that hard to do if someone gives you good directions.

Interesting, I’m not totally crazy: https://forums.fogproject.org/topic/13895/install-fog-1-5-7-on-centos-8/2

[george1421]

@EricZ said in "Database connection unavailable":

“git checkout dev-branch” and got “not a git repository”

The dev-branch is the right branch to be on. I just looked back at my chat session with the developers. So, how did you initially install fog? Did you use the git method or did you download the .gz (tarball) file and extract it?

[EricZ]

@george1421 So “git checkout working” gives me the same error. I tried running the commands from the link below and got this:
mysql -u root -p
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> drop database fog
-> exit
-> exit
->
It won’t exit.

[george1421]

@EricZ exit;

[EricZ]

@george1421 I’m in the management console! Thank You!!!

[george1421]

@EricZ said in "Database connection unavailable":

I’m in the management console! Thank You!!!

Sometimes when you do bleeding edge things, you happen to get bloody every once and a while. I’m glad you have it going now.

[Sebastian Roth]

@EricZ said in "Database connection unavailable":

I navigated to /Home/fogproject and ran the “git checkout dev-branch” and got “not a git repository” error message.

Then you are not using git source code but downloaded tar.gz/ZIP I suppose. While this isn’t wrong it’s just that you cannot switch between development and master branch as mentioned.

As well I am wondering if you are using the fogproject user to login? Don’t do that! It’s intended to be a service account and should not be used!