Disappearing hosts from host list

[Foglalt]

@wayne-workman but how? Anyway it doesnt change the mysterious disappearing sadly

[Wayne Workman]

@developers the pattern I thought I found earlier no longer holds with this 3rd log.

[Foglalt]

As i am a regular user for detecting and killing hosts with missing primary mac, unfortunatelly, may i use stored procedures for this? does it have any problem with fog database? will it be wiped with fog upgrade? i am trying to find a proper way for colleague to kill issue without me if i am out of office, and for this i am thinking about using stored procedures (well, same for other database commands we may use to maintenance in fog maybe nice)

is it a source of problem or i may use them?

[Tom Elliott]

@foglalt fog doesn’t do any removing or adding or triggers or procedures so if you can think of one to write that can help fix the issue for you then I say go for it. Please, if you’re feeling kind, post it here and maybe what you write might be able to allow me to apply a more direct fix to the core of fog. I’m hoping with 1.6, however, that this may be fixed due to how we’re approaching Mac addresses.

[Foglalt]

@Tom-Elliott nothing special i would do, just like looking up missig primary mac host and killing the orphans so practically i would move my garbadge collection scripts to database. Maybe i put some authentication before it and let others use it, colleaguea i mean. So nothing new at all.

[Wayne Workman]

@foglalt You could alter the script you have for detecting them to fix them. FOG wouldn’t touch cron or the script.

[Foglalt]

The plan is that i will make some extra scripts for my colleague and for some logging, and if all the goes to database as stored procs, maybe script to detect ajd delete disabled ones go there too. But deleting is what i like to have more control, dont want make fixing with deletion with script.

But… As a second thought, what if we check if missing ones have actual mac address but flag is missing only for primary mac. If i set primary mac back to 1 nstead of simply deleting the host as before, will they come back “online” maybe?

[Wayne Workman]

@foglalt said in Disappearing hosts from host list:

But… As a second thought, what if we check if missing ones have actual mac address but flag is missing only for primary mac. If i set primary mac back to 1 nstead of simply deleting the host as before, will they come back “online” maybe?

Sounds reasonable to me. Try it.

[Foglalt]

Normally the issue happens when a host mac is updated (primary mac field is selected with ctrl+a, then entered the new mac). we never use intentionaly more mac on a host (and they dont have any more interface, not like laptops with wifi, eth, whatever simultaneously). How can a host have secondary mac in database? When i first saw such i asked colleagues how they did, and some faint memory i have about it whuch tells when updated, the previouly overwritten mac becames secondary. But it is far from intentional, those are pc-s, with 1 mac only.

Can it be a clue to the investigation…?

like this:

MariaDB [fog]> select * from hostMAC where hmHostID=37;
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
| hmID | hmHostID | hmMAC             | hmDesc | hmPrimary | hmPending | hmIgnoreClient | hmIgnoreImaging |
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
|  170 |       37 | 8c:89:a5:53:1b:f5 |        | 0         | 0         | 0              | 0               |
|  298 |       37 | 6c:4b:90:4e:53:9e |        | 1         |           | 0              | 0               |
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+

As you may see, the primary mac has a strange difference from additional (298 is the primary, 170 is the additional mac id). why it has no zero at pending and why has the other a zero? That field is not manually edited, so the software logic updates that field. But why differently? I still have a feeling that this issue is connected with “pending mac”…

[Tom Elliott]

@foglalt no the pending Mac is not the issue. It looks up pending macs based on a 1 on the pending.

The issue, it seems, is a primary Mac is changing for a host. The primary should move to additional macs and the new primary should become primary. However the move is probably happening before setting the new primary Mac causing fog to think the host is no longer valid.

[Foglalt]

Guys, during the struggle to reproduce the issue somehow i found something strange. Let me describe it.

Starting point: host has a valid mac, up to date. i want to change mac. It can cause 2 different output, and i think it can cause the result somehow (i will do more tests to see if it really happens, but the difference made me curious).

mac update method1: host primary mac field is the only field, no additional field. i select the full field, then overwrite mac. result is a new mac on primary and an additional mac field appears with the previous mac address (which is wrong, as it has no another, but a new mac actually)

mac update method2: same starting point, but i only use mouse click to the end of the field, without selection of any char i use backspace, for like 1 char, and type another char instead of the deleted one. here NO additional mac field comes to existence. why? if i change the mac any method i want to change it, not add a new one (i will make test with it, maybe this way it will disappear somehow)

EDIT: sorry, somehow i did not notice what you wrote before me.