Standard storage nodes or multiple TFTP servers in MPLS cloud?

[Tom Elliott]

@moses said:

[Wed Feb 24 16:19:26.046943 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning: mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 30

The quoted line is of concern.

As @Sebastian-Roth requested, can you restart mysql service? Also, can you double check disk usage on the server with df -h?

[moses]

@Sebastian-Roth I can access the web interface on the main FOG server with no issues, and there are no problems there. Mysql is confirmed to be running. This issue is with a storage node, and the web interface is disabled with the “This is a storage node, please do not access the web ui here!” message.

@Tom-Elliott Plenty of storage space to go around on the node, so no problems there. This the df -h output on the node, the main server is pretty much the same, with about 30 GB of images taken up on sda1:

Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G  4.0K  1.9G   1% /dev
tmpfs           381M  860K  381M   1% /run
/dev/sda1       290G  3.6G  272G   2% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
none            5.0M     0  5.0M   0% /run/lock
none            1.9G     0  1.9G   0% /run/shm
none            100M     0  100M   0% /run/user

[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