Storage node testing and disk information not displayed

[Tom Elliott]

If you’re comfortable with the mysql syntax, you’re more likely going to have to change the fogstorage password in the db then.

To do this the syntax should be:
[code]SET PASSWORD FOR ‘fogstorage’@‘%’ = PASSWORD(‘new-password-here’); FLUSH PRIVILEGES;[/code]

This should help out.

[cassie_280]

Where do I enter that?

[Tom Elliott]

You need to login to the mysql instance. From a terminal on the FOG server run the command:

[code]mysql -u root fog[/code]

Then run the above command.

[cassie_280]

Return said “Query OK, 0 rows affected (0.00 sec)”
I restarted mysql and I’m still having the same issue.

Is it possible that I could just change the password in the GUI and in the node back to the default (whatever that is)?
The only reason I changed it was because I had no idea what it was and it was in hidden characters.

[Tom Elliott]

The default is a randomly generated one performed at install time. It only happens the first install.

The fact that it reports 0 rows affect tells me, it seems, that updating this field is working properly as well.

A test you could do could be to sign in to mysql using the password you set and the same info:

[code]mysql -u fogstorage -p’<your-fogstorage-pass-here>’ fog[/code]

Does it allow you in with this? Also, is the /etc/my.cnf bind-address commented out?

[cassie_280]

Yes, I was able to log in with those credentials, and yes the bind-address is commented out.
I restarted the mysql service and I still get the failed to connect error.

[Tom Elliott]

Now,

From the storage node, can you perform the same command, just adding -h’IPOFFOGSERVER’

[cassie_280]

I was able to fix it.
Turns out I had had changed the user and password in the config.class.php file when I was testing to see if that’s what the problem was. I changed it back to fogstorage and password and now it’s working.

My issue was just that the mysql db needed updated.

Thank You so much!

[Tom Elliott]

No problem.

[Lombard]

Hello,
I have the same problem, and nothing work.
I have a ubuntu 14.04 server and fog 1.2.
Thanks

[Lombard]

[LEFT]Does it encrypt the password in GUI “FOG_STORAGENODE_MYSQLPASS” ?
[/LEFT]

[Wolfbane8653]

No the webgui is not encrypted.

[Troy]

@Ben-Warfield

Thank you Ben, just updating, simply comment de bind address on my.cnf solves the issue.