I’m on fire today guys… I apologize for all of these mis-posts… The reason why my FOG hosts aren’t getting jobs is because my old server is still online… I was running an old image that had my previous server IP on it for the client…
Boy oh boy! Glad it was that simple. I believe that is the end of it.
Please mark this as solved.
@Fernando-Gietz
@Sebastian-Roth
@Tom-Elliott
FOG Ver. : 1.5.6.4
FOG OS: Centos 7
I have been experincing an issue with my DB. We determined I was on an older version from when FOG Working-1.6 was out there. I am experiencing an issue where Snap-In’s are not deploying via Group settings. When I look at the Fog.log on the hosts I see SnapinClient == Response No snapins. I also do not see anything under Task Management. When I go into the DB their are numerous entries in snapinJobs and snapinTasks.
I’m assuming this goes back to the issues I was having with my database schema…
Anyhow an ideas on how to fix this would be great!
I appreciate everything the FOG team does!
Cheers!
Joe Gill
Nevermind!!! My browser must have been being an issue…
Disregard this thread. SMH…
Ha!
@Sebastian-Roth
@Fernando-Gietz
@Tom-Elliott
Well I found more issues with my Database… The snap-in’s won’t update for the hosts. I tried adding a snap-in to a host and it would not. I also tried removing a snap-in and it would not remove either. Yikes.
But Multi-Tasking is working! Ha!
Let me know any ideas for DB commands or log files that might be useful. This has to be tied to my other Schema issues from using the 1.6–Working…
Thanks!
@Fernando-Gietz
@Sebastian-Roth
Fernando’s fix takes it! That worked!
The first statement didn’t produce any results. But the second one did and after I restarted Multicasting, things are working again! Woo Whoo!
Thanks guys! I owe you both a beer!
Cheers!
For the record, if anyone else has this issue…
This was the fix…
ALTER TABLE multicastSessions
ADD COLUMN msAnon4 VARCHAR(250) AFTER msAnon3;
@Sebastian-Roth
@Fernando-Gietz
Any advice on how to manually reverse the last few schema changes?
Thanks!
Yes, I have used Tom’s working-1.6 branch. I’ll check out the link you posted from github and see if I can’t figure things out.
Thanks for looking at it!
Enjoy your travels!
I’d need a bit of guidance there as I have little experience working in the DB. But I’m willing to try anything. I have a backup. Ha!
I blame @Tom-Elliott ! Ha! He helped me with it last year and the past few years.
MariaDB [fog]> desc multicastSessions;
+--------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------+------+-----+---------+----------------+
| msID | int(11) | NO | PRI | NULL | auto_increment |
| msName | varchar(250) | NO | | NULL | |
| msBasePort | int(11) | NO | | NULL | |
| msLogPath | longtext | NO | | NULL | |
| msImage | longtext | NO | | NULL | |
| msClients | int(11) | NO | | NULL | |
| msSessClients | int(11) | NO | | NULL | |
| msInterface | varchar(250) | NO | | NULL | |
| msStartDateTime | datetime | NO | | NULL | |
| msPercent | int(11) | NO | | NULL | |
| msState | int(11) | NO | | NULL | |
| msCompleteDateTime | datetime | NO | | NULL | |
| msIsDD | int(11) | NO | | NULL | |
| msNFSGroupID | int(11) | NO | MUL | NULL | |
| msShutdown | enum('0','1') | NO | | 0 | |
| msMaxwait | int(11) | NO | | NULL | |
| msAnon5 | varchar(250) | NO | | NULL | |
+--------------------+---------------+------+-----+---------+----------------+
17 rows in set (0.01 sec)
MariaDB [fog]>