@Wayne-Workman
Alright good news, I got everything working! First thing, connecting to the mysql server as ‘fogstorage’ on the main server will not work, fogstorage has host access from % (which includes all IP addresses except for localhost.) In order to get this working, this is what I had done (in-case anyone else runs into this)
- Verify that the node cannot communicate with the main MySQL server
mysql -u fogstorage -h (your main servers DNS/IP address) -p
enter your fogstorage password and hit enter - If you do not successfully log in, then you need to change your passwords.
- Go to the webpage of the main fog server and go to Fog Configuration->Fog Settings->Configure Storage Nodes
- Set the username to fogstorage and the password to whatever you want
- SSH into the main fog server
- Connect to the local MySQL server as root
mysql -u root -p
enter password (default is a blank password) and hit enter - Change the fogstorage user password
use fog;
UPDATE mysql.user SET Password=PASSWORD(‘the new passord’) WHERE User=‘fogstorage’;
FLUSH PRIVILEGES;
exit; - Test that you can connect to the mysql server by doing step 1 again.
- If you can connect successfully now, you should be working, if not please try removing and reinstalling fog and ensuring you use the correct mysql username and password during the install phase