Best posts made by Claude Girard

@Matthieu-Jacquart said:

I updated and restore database from last save (last week-end), and 1 hour later at least 3 hosts disappear, on 3 different groups, I made no changes…

edit : we forgive you, you all make great job

I can confirm this bad news.
I wanted to control my database, and I made this request in phpmyadmin:
SELECT * FROM hosts WHERE hostID NOT IN (SELECT hmhostID FROM hostMAC)
It returned 93 results
10 minutes later, the same request returned 101 results.
No operation made on fog interface between the requests.

Do I need to upgrade client too ? I don’t think so, some disappeared computers have legacy client installed

@Claude-Girard And good news:
My sql request:
SELECT * FROM hosts WHERE hostID NOT IN (SELECT hmhostID FROM hostMAC)
hours ago !!!
returns 0 rows since last fog update,

Hopefully by the time i get in to work tomorrow I can put a solve setting on this thread.

Yes I think you can.
Hosts are still here !!!
I can’t reproduce group issue, during 1 hour I delete hosts from groups, include them in existing or new groups, modify by group image association, service settings, active directory, and snapins.
I lost 1 member in a group only one time, 66 members at start, and 65 after modifying settings in the group, not sure but I think after active directory settings.

I decided to do that because I thought that after this bug my database was in an inconsistancy state.

I sent these 3 requests to my database:
SELECT * FROM hosts WHERE hostID NOT IN (SELECT hmhostID FROM hostMAC)
Before update, I had a lot of rows in result, and growing. But now it’s ok.

SELECT * FROM hostMAC WHERE hmhostID NOT IN (SELECT hostID FROM hosts)
Never had result, was ok and is still ok

SELECT * FROM snapinAssoc WHERE saHostID NOT IN (SELECT hostID FROM hosts)
Returned a few rows in result, maybe not directly due to this bug, maybe this table was corrupted before.

I think that tables refer to hosts by Mac adresses, except snapinAssoc table. Is it right ?
So with these 3 requests, I can find bad hosts and bad snapin assoc, and I delete them from database.
But maybe I forgot one or several tables to check ?

Thank you for you job !

Hi,

Rev 5968 but this issue seems to be present since Rev 5909 commit 2872cf5e99f0cba6f3cdcbe18d8dd1ab40347b4c

When deploying an image, fog doesn’t find mbr file.
In deploy debug mode, mbrfile is empty.
I saw this issue with os type = linux. If I change this in os type= windows 8.1, mbr file is found.

In funcs.sh, test on os type is made only for 1, 2 , 5 , 6 ,7 and 9 os type.

I don’t know from which rev, but this issue is solved

@Tom-Elliott said in Imaging log not displaying logs:

Confirmed and fixed in latest.

Yes but now all imaging tasks are seen, not only those between start and end date

And in snapins log, only today log is correct.
With a start and end date, even if they are the same, result is not at specified dates