Fog TFTP Storge Node Trunk 6455
-
@Tom-Elliott The main replicated the images to the storage node though, is that different from the line of communication you are talking about?
-
@jheikkila54 yes. Replication happens over ftp while node to main happens over MySQL.
-
@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/
-
@Tom-Elliott Ahh, makes sense!
-
This post is deleted! -
@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?
-
@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_MySQLI’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.
-
@Wayne-Workman Alright, it does not work, with fogstorage or root (root has no password)…
-
@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.
-
@jheikkila54 when you disabled Selinux did you actually restart the system
-
@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
- Verify that the node cannot communicate with the main MySQL server
-
@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)- 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
This is already covered here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Enable_remote_mysql_access - Verify that the node cannot communicate with the main MySQL server
