Standard storage nodes or multiple TFTP servers in MPLS cloud?

[Tom Elliott]

@moses Are you running a firewall that’s blocking the node’s access to the FOG Server?

Is the storage nodes connected using fogstorage and the fogstorage password located on the main server at: FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER?

[moses]

@Tom-Elliott No firewall blocking, these are connected via MPLS on a clean Ubuntu 14.04 install.

I’ve got the user/pass for fogstorage from the main server, how would I go about checking to make sure that is set correctly on the node?

[Tom Elliott]

@moses What’s in the node’s config.class.php (/var/www/html/fog/lib/fog/config.class.php)

The account information should show up under the mysql information.

[Sebastian Roth]

@moses By using the mysql command like client: mysql --user root --password (enter PW when prompted)

[moses]

@Tom-Elliott Yes, the username and password for fogstorage match on the node/server.

[moses]

If it’s at all helpful, here’s a screenshot of the node’s configuration on the main server:

[Tom Elliott]

@moses The picture you provided is off the Storage node, that username and password are not the same as the fogstorage mysql user and password.

[Sebastian Roth]

@moses Did you try connecting to the DB using the mysql command line client yet? Login to the console of your storage node and run mysql --user root --password (enter PW when prompted)

[moses]

@Sebastian-Roth I never set a mysql password on the storage node. What or where is it?

@Tom-Elliott Maybe I don’t know which passwords to use. There appears to be a thousand different usernames/passwords and another thousand different references to them.

On the main server, I added the storage node using the “management” username and password that the node spat out when running the installer:

[Tom Elliott]

@Tom-Elliott said:

FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER

FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER

[Tom Elliott]

@moses Information was all correct.

The reason there was a problem was ubuntu using bind-address in the my.cnf file.

Commented that line and restarted mysql, and everything started working properly.

[Wayne Workman]

@Tom-Elliott added a bit to the wiki about this. https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#MySQL_credentials_for_FOG_Main_and_Storage_Nodes