Fog TFTP Storge Node Trunk 6455

[Wayne Workman]

@jheikkila54 ok then the next test is to ssh into the main server and attempt to connect to the local MySQL instance using the fogstorage username and it’s password.

[Tom Elliott]

@jheikkila54 when you disabled Selinux did you actually restart the system

[jheikkila54]

@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)

1. 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
2. If you do not successfully log in, then you need to change your passwords.
3. Go to the webpage of the main fog server and go to Fog Configuration->Fog Settings->Configure Storage Nodes
4. Set the username to fogstorage and the password to whatever you want
5. SSH into the main fog server
6. Connect to the local MySQL server as root
   mysql -u root -p
   enter password (default is a blank password) and hit enter
7. Change the fogstorage user password
   use fog;
   UPDATE mysql.user SET Password=PASSWORD(‘the new passord’) WHERE User=‘fogstorage’;
   FLUSH PRIVILEGES;
   exit;
8. Test that you can connect to the mysql server by doing step 1 again.
9. 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

[Wayne Workman]

@jheikkila54 said:

@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)

1. 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
2. If you do not successfully log in, then you need to change your passwords.
3. Go to the webpage of the main fog server and go to Fog Configuration->Fog Settings->Configure Storage Nodes
4. Set the username to fogstorage and the password to whatever you want
5. SSH into the main fog server
6. Connect to the local MySQL server as root
   mysql -u root -p
   enter password (default is a blank password) and hit enter
7. Change the fogstorage user password
   use fog;
   UPDATE mysql.user SET Password=PASSWORD(‘the new passord’) WHERE User=‘fogstorage’;
   FLUSH PRIVILEGES;
   exit;
8. Test that you can connect to the mysql server by doing step 1 again.
9. 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

This is already covered here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Enable_remote_mysql_access