@Wayne-Workman Thanks for this, although when running the script I receive the following errors:

The blanked out part of line 23 is the password. Yet when running:

mysql -h localhost -u root -p"password" -D fog

I’m able to log-in perfectly fine.

@Wayne-Workman

I also restored the FOG VM from a checkpoint before attempting this, so we’re essentially working with a FOG server before I started dabbling into this SQL side of things.

@Wayne-Workman Sorry, it was a typo when I was writing it up on here. Here’s the screenshot to confirm what I’ve typed in:

@Wayne-Workman Thanks! Extremely helpful, although I’m running into an issue when running “UPDATE images SET imageID - imageID -4 ;” that says:

ERROR 1062 (23000): Duplicate entry ‘25’ for key ‘PRIMARY’.

I’m not overly familiar with SQL, so I’m unsure what this means.

Server

• FOG Version: 5962
• OS: Ubuntu 14.04

Client

• Service Version:
• OS:

Description

Hi all,

Is there a way to change the image ID numbers? I’ve spent some time taking images down and uploading new ones that I’m now on image 30, even though I only have about 14. It’s not a major issue, but it’s just a nice one to check off the list.

@Wayne-Workman Many thanks, gents. It all seems to be working here in the UK so I’ll ship it out tomorrow and hopefully set up the new VM later on this week/next week.
If I run into any issues I’ll post back

@Wayne-Workman I’d prefer to use a static IP if possible (but am open to using a DHCP assigned IP if it’s easier to do). I followed this: https://wiki.fogproject.org/wiki/index.php/Change_FOG_Server_IP_Address and am currently updating the US FOG server to the latest version of trunk with the new settings. Would this suffice, or would I need to do additional configuration with the server?

@george1421 Thanks for the help It really is appreciated!

I thought it might be easier to export my current FOG server, change the settings to match the US site (i.e. IP address, default gateway, etc.) and then send it to them on a USB.
Are there any FOG settings I would need to change? Obviously on the VM itself I need to change the host name and network settings.

@george1421 Thanks for the detailed explanation, George.
It sounds interesting and could be useful to us. However, what if I wanted to schedule an image to be done for the US at a certain time (that’s convenient for them)? Would I then have to log-in to their FOG server to schedule it, or could I log-in to the main UK-based FOG server and schedule it? And if they register any new hosts, would that then come back to the main FOG server and be listed in the web GUI?

Finally, is there a way of checking the image replication on the storage node? I’ve currently got a ‘test storage node’ up and running, and I’ve joined it as well as a few images to the same group (Test-US), but I can’t actually see if the images are on the node or not. I just want to ensure that when the US does image a computer, it’s going to go from their storage node instead of across the VPN.

@Wayne-Workman Indeed - many thanks for your help

@Tom-Elliott Excellent - that’s fixed it! Many thanks

@Tom-Elliott Ah, thanks for that. I can now run: mysql -h hostHere -u userHere -pPasswordhere -D fog on the node and connect in to the database on the FOG server. However, it’s still not showing correctly on the GUI… it’s still showing the same thing, even when using the same credentials to add the storage node.

@Tom-Elliott I tried doing that, but I receive the following error:

As you can see, I then tried to find the file it referenced, but it seems like it hasn’t been installed… have I installed the FOG node wrong somehow?

@Tom-Elliott

bind-address already seems to be commented out. Is there anything else I can check?
And yes, I can ping the server perfectly fine from the problematic node.

I wonder if it’s the way I installed the storage node? I did:

cd /opt
sudo wget http://downloads.sourceforge.net/freeghost/fog_1.2.0.tar.gz
sudo tar -xvzf fog_1.2.0.tar.gz
cd fog_1.2.0/
cd bin
sudo ./installfog.sh

And then from the installation menu, selected to install the node.
I’m currently running Ubuntu 14.04, the same as my FOG server.
Perhaps I need to update the version of the FOG storage node? Is it the same process as updating the FOG server?

@Wayne-Workman
Yes, this is the message I receive:

I can confirm that username and password is the same as what’s listed in the FOG Configuration settings. The IP address is also that of the main FOG server.

@george1421 Thanks for this, guys.
My main concern is when I update the images and then want the nodes to update the images they have stored as well. For example, if I update an 80GB image here in the UK, it will take quite a while for the node in the US to update. Is there any workaround to this? Or would I just have to bare with it and try not to update the images as much as I can?

The second option you mention sounds like something we could make use of. Is this process documented anywhere? I’m not familiar with exporting the image definitions and then upload them on the remote FOG server. I’m keen to test this, so will probably do so on Monday to see if it would work for us.

Thanks for the suggestions, gents! Much appreciated as always

@Wayne-Workman Hi all, apologies about the delay in getting back to you.
I’ve gone through Wayne’s suggestions and yes, I can confirm I used the fog installer to setup the storage node.

I ran the cat /var/www/html/fog/lib/fog/config.class.php command, but couldn’t see snmysqlhost, snmysqluser or snmysqlpass there at all near the top. Instead, I saw define “(‘DATABASE_HOST’,),” and the same for the database username and password. There was no record of snmysqlhost, so I’m not sure if this is an issue itself?

I tried running the test with the information I did have, but that came back with an error 2003(hy000) which, after a Google search, shows that the connection isn’t working correctly.

Finally, the getversion file does seem to be missing. After running your suggested command, nothing was returned at all.

Hi all,

We’ve been using FOG in our UK site for some time now (I introduced the company to it and they love it!). Now, we want to roll this out to the US.
I’d ideally like to replicate the images we have on our UK-based FOG server across to the US installation. I’m wondering if a storage node would work for them (if I install tftp and pxe on there, as suggested here: https://wiki.fogproject.org/wiki/index.php?title=Multiple_TFTP_servers) or if there’s a way of installing a separate FOG server whilst being able to manage it through the GUI of the UK-based instance? What would you guys suggest doing?

Also, how viable is it to update the images over site-to-site VPN? Ideally I’d like to be managing everything through one web gui instead of multiple for different sites.

Any help with this would be appreciated.

@Wayne-Workman It seems it’s the latter. I’ve restarted both the FOG server and the master node. Both can definitely ping one another.
Is there a way of diagnosing why the DB connection isn’t working? Does it matter that the file it mentions is actually missing from the node?

Server

• FOG Version: 1.3.0-RC-8
• OS: Ubuntu Server 14.04

Client

• Service Version:
• OS:

Description

Hi all,

I’ve just set-up my FOG storage node, although I can’t seem to see it from the web gui dashboard. When selecting it, I see a long line of text that says:

“The requested URL /fog/service/getversion.php was not found on this server.”
Would anyone be able to tell me where I can get this from or what I need to do to ensure it shows up correctly on the GUI?

Any help with this would be greatly appreciated.