FOGImagereplicator not working

[Neil Underwood]

Here’s another side-effect of whatever is ailing my server here:

All of the nodes now show (#!db) instead of whatever it’s supposed to show (version number I think?)
Could it be a corrupt database that’s causing all of this?

[Wayne Workman]

Looking at that picture, this issue is possibly related: https://forums.fogproject.org/topic/7825/db/17

[Neil Underwood]

@Wayne-Workman said in FOGImagereplicator not working:

Looking at that picture, this issue is possibly related: https://forums.fogproject.org/topic/7825/db/17

You know, that prompted me to look at class.config.php and I think the DATABASE_HOST value is wrong, but I really don’t know. Can you verify this is correct? Should the “p:” be in there proceeding the IP address?

define('DATABASE_HOST','p:127.0.0.1');

I tried changing it and removing the “p:” and nothing seemed to change (after restarting php, mysql & apache just to be sure)

[Wayne Workman]

@Neil-Underwood so, for the main server that hosts the DB, that is correct. For all nodes, it is wrong.

[Neil Underwood]

OK, so now I’m seeing that I can’t connect to the master storage node DB from the remote storage nodes. I know as much about SQL commands and permissions as my left shoe. How do I fix this? And how in the heck did it break in the first place?

[Wayne Workman]

@Neil-Underwood said in FOGImagereplicator not working:

w do I fix this? And how in the heck did it break in the first place?

Probably the server is only allowing local connections. There’s stuff about that in here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

“Enable Remote MySQL Access”

[Neil Underwood]

@Wayne-Workman said in FOGImagereplicator not working:

@Neil-Underwood said in FOGImagereplicator not working:

w do I fix this? And how in the heck did it break in the first place?

Probably the server is only allowing local connections. There’s stuff about that in here:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

“Enable Remote MySQL Access”

I must have overlooked the part about remote access because I visited this page earlier this morning. I fixed the remote permissions and now everything is able to see the DB. Thanks for that. I did do an OS upgrade that probably changed mysql versions. I’m betting that’s what screwed it up.

The mystery of where my log info is going still remains, however.

Also, on the dashboard the replicator appears to be working, based on the graph. But running jnettop from the master storage node doesn’t show any replication activity. If I can get my logs working again I’m certain I can figure out what the problem is.

[Wayne Workman]

@Neil-Underwood sometimes it takes a hot second for replication to kick in, even if the log says it’s going. Just be patient. Tomorrow morning you’ll be able to tell if everything is right or not.

Also, the logs might be fixed by re-running the installer on all the nodes, since it can now actually communicate with the DB.

[Neil Underwood]

OK so I’m updated to 8215 now and everything seems to be able to see each other. It looks like the main server is pushing our the smartinstaller.exe to all the clients and that’s the activity I’ve been seeing on the graph. Hard to catch that using jnettop at first.

Thanks for all the assistance with this. I’ll open a separate thread for the log issue and another for the bzImage problem.

One more quick question though. What are these values used for?

startrange='192.168.19.10'
endrange='192.168.19.254'

[Tom Elliott]

@Neil-Underwood DHCP Server if FOG is to be the dhcp server.

It defines the start and end range of DHCP.

[Neil Underwood]

@Tom-Elliott said in FOGImagereplicator not working:

@Neil-Underwood DHCP Server if FOG is to be the dhcp server.

It defines the start and end range of DHCP.

Got it. So this does not apply to my setup then. Must have been defined a long time ago when I was playing with that. Thanks!