Fog TFTP Storge Node Trunk 6455

[jheikkila54]

@Tom-Elliott
Both are disabled, I have followed your guide religiously and verified everything.

[Tom Elliott]

@jheikkila54 on the node for MySQL user info you used the fogstorage user and password or root?

[jheikkila54]

@Tom-Elliott I used the fogstorage user and password, I believe. I set this up a week ago and followed the instructions in the install script.

[Tom Elliott]

@jheikkila54 I understand just trying to get the full picture.

[jheikkila54]

@Tom-Elliott No problem! I appreciate your help with this! I do know that TFTP-server was not installed on the storage node, so that is an obvious key, but how to go about adding it to the install script and config file for Redhat, is the question. The guide on the Wiki for completing that is now invalid.

[Tom Elliott]

@jheikkila54 I believe it should do this automatically but I don’t remember when I added it to the installer. That, however, is not what’s wrong currently. It appears that the node can’t communicate with the main right now. @wayne-workman would you mind posting the old password thing we needed to do on your server?

[jheikkila54]

@Tom-Elliott The main replicated the images to the storage node though, is that different from the line of communication you are talking about?

[Tom Elliott]

@jheikkila54 yes. Replication happens over ftp while node to main happens over MySQL.

[Wayne Workman]

@Tom-Elliott said:

@jheikkila54 I believe it should do this automatically but I don’t remember when I added it to the installer. That, however, is not what’s wrong currently. It appears that the node can’t communicate with the main right now. @wayne-workman would you mind posting the old password thing we needed to do on your server?

I can’t find the exact link, but all these say the same thing.

http://www.hostdime.com/resources/mysql-password-hashes/

http://code.openark.org/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords

https://dev.mysql.com/doc/refman/5.6/en/account-upgrades.html

https://forums.cpanel.net/threads/mysql-5-0-5-1-and-doing-away-with-old-style-passwords.258412/

http://kb.odin.com/en/114200

[jheikkila54]

@Tom-Elliott Ahh, makes sense!

[jheikkila54]

This post is deleted!

[jheikkila54]

@Tom-Elliott Alright I upgraded my main to 6559, set the fogstorage password via the configuration page, created a new storage node with 6559 and set the mysql user to fogstorage and set the password to the same as the configuration page. I then put the username and password, supplied at the end of the install, into the management credentials when adding the new storage node. The images are replicating now but it appears that they are still not communicating as the boot.php page looks the same as before.

The old_password links below do not apply as the password for user fogstorage is not the “old way.” Any other thoughts?

[Wayne Workman]

@jheikkila54 Log into the storage node via ssh, and use the fogstorage username and password to remotely connect to the main server’s DB. You can find an example of the commands you would use in our “Troubleshoot MySQL” wiki article, here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Testing_MySQL

I’m expecting that this won’t work. If it does, then probably there was a password fat-fingered somewhere along the lines of setting up the storage node.

[jheikkila54]

@Wayne-Workman Alright, it does not work, with fogstorage or root (root has no password)…

[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