Host/Group replication between FOG Servers

[adukes40]

Ubuntu 14.04 LTS

Fog 7713

Fresh installed last night… between 8pm - 11pm EST.

[Wayne Workman]

@adukes40 Are the storage nodes the same version of FOG? It does matter. Also, you said you previously had a full fog server at each site? Are you using those or did you build fresh?

[Wayne Workman]

Also, to see if FTP credentials are right and pathing is correct, security is correct, firewall is correct, you can connect from the main fog server to the node via FTP to test credentials.

https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP

[adukes40]

@Wayne-Workman I shut off any other instances of FOG last night. there are currently only 2 instances running, The main server which is across town, and the storage instance located here at my shop. the 10.103 address is the main server, and the 10.106 address is the storage location at my location. both were setup exactly the same. Only difference is the DCHP server address, gateway, and local IP of the fog servers themselves. both runnin Ubuntu 14.04, FOG 7713. I was making them side by side last night to hopefully keep them the same version and they are. I download the install using this:
sudo svn co http://svn.code.sf.net/p/freeghost/code/trunk I left the mysql password blank when setting up the Main as well.

[adukes40]

Here is what the permissions look like on the Main:

and here is the storage only:

[adukes40]

it looks like firewall is disbaled, I was able to send a file from the remote server to the main server manually. this is what i get for the remote location still:

Error communicating with the database. Error: SQLSTATE[HY000] [1045] Access denied for user ‘fogstorage’@‘localhost’ (using password: YES)

[Wayne Workman]

@adukes40 make sure the fog storage password is correct on the storage node. If it’s not, change it in /opt/fog/.fogsettings and rerun the installer on the storage node.

You can test MySQL credentials from the node to the main by connecting to it via something like this:

MySQL -u fogstorage -h x.x.x.x -p

Not sure if that syntax is right but its close. you can Google examples.

[Wayne Workman]

Also to clarify, for the ftp test, you should have been on the main server testing ftp ccredentials to the node. Testing from the node to the main doesn’t tell you if the nodes ftp credentials are good because you weren’t testing them.

And, the MySQL test should be run from the node.

You can use SSH to be “in” whatever server you need to run the tests.

[Wayne Workman]

@adukes40 I gave you the long explanation because you seem detail oriented but I’ll put it more plainly.

In a multi-server setup with one main tied to one or many nodes, all registrations are stored in one place. On the main. Everything is managed from one place, on the main. Everything is contained in one spot, on the main. If a host is registered anywhere, it’s registered everywhere. Because the main holds everything and is the controller for everything, and the communication point for everything everywhere.

The point of nodes is to increase imaging capacity, decrease load over the WAN, and to overcome broadcast domain related issues.

[adukes40]

when the storage node installed it gave me that long password, is that the password to use, or do i need to change it to the long password the Main uses? right now they are different.

[adukes40]

Ok, i just conducted ftp from the main to the node. i created a test.txt on the node, then on the main i used ftp to view the file directory, then delete the file, the dir again to verify it is gone.:

techinstall@MSDCATS09:/$ ftp
ftp> open 10.106.2.149
Connected to 10.106.2.149.
220 (vsFTPd 3.0.2)
Name (10.106.2.149:techinstall): fog
331 Please specify the password.
Password: <long password from setting up node>
230 Login successful.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> cd /images
250 Directory successfully changed.
ftp> dir
200 PORT command successful. Consider using PASV.
150 Here comes the directory listing.
drwxrwxrwx 2 0 0 4096 May 19 02:34 dev
drwxrwxrwx 2 0 0 4096 May 19 02:34 postdownloadscripts
-rw-rw-r-- 1 1000 1000 7 May 19 19:58 test.txt
226 Directory send OK.
ftp> del test.txt
250 Delete operation successful.
ftp> dir
200 PORT command successful. Consider using PASV.
150 Here comes the directory listing.
drwxrwxrwx 2 0 0 4096 May 19 02:34 dev
drwxrwxrwx 2 0 0 4096 May 19 02:34 postdownloadscripts
226 Directory send OK.
ftp> exit
221 Goodbye.
techinstall@MSDCATS09:/$

[adukes40]

now i get this for the storage node

Error communicating with the database. Error: SQLSTATE[HY000] [2002] Connection refused

I think i will update the Main, and do another fresh install of the node and see what happens.

[adukes40]

Just rebuilt it, looking like it is connecting now as well. I will keep updating.

[adukes40]

Here is what I am getting now:

[Wayne Workman]

@adukes40 the last url in the photo, visit it via browser but add this in the end of it.

?mac=b8:ac:6f:3d:6e:a4

[adukes40]

@Wayne-Workman said in Host/Group replication between FOG Servers:

?mac=b8:ac:6f:3d:6e:a4

telling me line:

1179 response_rc = -EIO_5XX;

not sure what that is telling me though.

[adukes40]

Actually I think this is what you were requesting:

#!ipxe
set fog-ip
set fog-webroot
set boot-url http://${fog-ip}/${fog-webroot}

Here is SS

[Tom Elliott]

@adukes40 What version of FOG are you running? I’m pretty sure this is a trunk version, but the one you’re currently on is older. I have since fixed this particular (and a few more) issue I want to say since Monday.

[adukes40]

@Tom-Elliott I just upgraded the Main and reinstalled the storage node yesterday afternoon

[Wayne Workman]

@adukes40 You found the right page in that second post. The page should have a lot more. For instance, it should tell if the host is registered or not, and give a lot more information…

Now, swap the IP with the main server’s IP and try the URL again. There should be a lot more displayed.

Also, I think this issue is being caused by mysql credentials somehow being bad.

I have an idea… try to manually re-set the fogstorage mysql password using this:

'fogstorage'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
Then ensure remote access is enabled for the fogstorage account with this:
GRANT ALL PRIVILEGES ON fog.* TO 'fogstorage'@'%' IDENTIFIED WITH mysql_native_password BY '' WITH GRANT OPTION;

Then, set the mysql password in the node’s /opt/fog/.fogsettings file to just blank, like empty quotes or whatever the wrapper is. Then re-run the installer you have on the node again, and see what happens - also re-try manually connecting to the DB on the main server FROM the storage node, using a blank password.

Of course, this is temporary - you may set a password later. I just want to get it working for troubleshooting purposes.