no valid Db connection from storage node after upgrade to 1.5.4

[CoxM]

Hi All,

As the title says I have no valid DB connection from my newly upgraded storage node.

So far I have updated the master fog server to 1.5.4 (from 1.5.3) and one node, which is the one I have this error on.

I have had this before and needed to get the various passwords configured correctly across the servers but from what I can see the fogsettings file is correct.

Any advice on where best to start looking for the problem?

Thanks,

Matt

[Sebastian Roth]

@CoxM Please check your config on the updated storage node: /var/www/fog/lib/fog/config.class.php
Then see if you can connect to the master server’s database using those credentials with the mysql command line client on the storage node:

mysql -h POR-FOG -u fogstorage -D fog -p
Password:
...

This will probably fail. As the other 1.5.3 node you have is not showing the error I kind of doubt the issue is on the master node. But you can still try to reset the credentials in your master node’s database like that:

mysql -u root -D mysql -p
Password:
...
ALTER USER 'fogstorage'@'%' IDENTIFIED WITH mysql_native_password BY 'put_password_here';

Please let us know what the issue was. I am wondering if this is something other people run into as well.

[Sebastian Roth]

@CoxM Are you on Ubuntu? Possibly this is what has wrecked your DB connection: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

As well you want to work through this wiki article: https://wiki.fogproject.org/wiki/index.php/Password_Central

[CoxM]

Thanks for the info @Sebastian-Roth. I have tried both re-running the installer and manually issuing the ALTER commands. They appear to run correctly but not resolve the issue.

Fora little more background.
I do have another storage node (SN), as yet not upgraded that is still running fine, it’s only the SN I upgraded that’s failing. however, the fogsettings file on both the working and failed SN are the same bar the version and IP details, all the mysql info is the same and is mirrored by the master node.
From previous troubleshooting I recall there being another file which contains credential info, is that correct? If so, where is it, might it be the problem?

Thanks,
Matt.

[Padcotton]

@CoxM Who are you thinking ?
What im guessing is that they removed their comment because it was a pile of poop.
Interesting though.

[CoxM]

@Padcotton Sorry, I don’t understand your comment. I was replying to @Sebastian-Roth, no one else.

[Sebastian Roth]

@CoxM Where exactly do you see the failed DB connection error? Can you please take a picture and post here?

[CoxM]

[Sebastian Roth]

@CoxM Strange thing. Can you please run the following command on your storage node and post results here:

find /var/www/fog -type f -exec grep "FOG_VERSION" {} /dev/null \;

[CoxM]

@Sebastian-Roth

[Sebastian Roth]

@CoxM This is strange, not what I expected, can’t replicate the issue and can’t figure out where the message is coming from. Will look into it again.

[CoxM]

@Sebastian-Roth Thanks

[Sebastian Roth]

@CoxM Please check your config on the updated storage node: /var/www/fog/lib/fog/config.class.php
Then see if you can connect to the master server’s database using those credentials with the mysql command line client on the storage node:

mysql -h POR-FOG -u fogstorage -D fog -p
Password:
...

This will probably fail. As the other 1.5.3 node you have is not showing the error I kind of doubt the issue is on the master node. But you can still try to reset the credentials in your master node’s database like that:

mysql -u root -D mysql -p
Password:
...
ALTER USER 'fogstorage'@'%' IDENTIFIED WITH mysql_native_password BY 'put_password_here';

Please let us know what the issue was. I am wondering if this is something other people run into as well.

[CoxM]

@Sebastian-Roth Thanks for all your help.

The issues turned out to be the mysql credentials held in the config.class.php file. They had been reset and needed the correct details manually adding. Once that was done all worked fine.

Thanks again,
Matt.

[Sebastian Roth]

@CoxM What were the credentials set to. Can you figure out what was wrong. Or did you reset the credentials in the DB to make it work?

[george1421]

@Sebastian-Roth Is this db information stored in the .fogsettings file? My thinking is that maybe it was changed/reset in the system before 1.5.4 was installed and the fog installer reset things to the way they were set according to the .fogsettings file(??)

[CoxM]

@Sebastian-Roth It had reset the user to ‘root’ and the password blank. I have run the ALTER USER commands previously so perhaps that did it.

Once I had manually entered the correct username “fogstorage” and the password, which I still had from the working node, I was up and running.

Thanks,

Matt.