Printers deleting unassigning themselves

[ryanlewis2010]

So ive used the printer feature fairly well especially after print nightmare. However ive ran into issues with some computers keeping their attached printers, Sometimes they stay on log enough to install but than uninstall within 30 minutes and others it removes them before it has a chance to install them. At first i thought it was group related so i pulled one of the offenders out of all the groups and manually assigned the printers and still happens.

Printer Service is enabled.
Printers do install on some of the PCs.
Fog Client is on 0.13
Fog server is 1.5.10

Printers are assigned, set as default and on fog managed only. After 2-15 minutes they are no longer showing on as assigned inside fog.

Is there any logs that would show who or what is unassigning them?

TIA

[Sebastian Roth]

@ryanlewis2010 Do I get this right? You say the printer assignment done in the FOG web UI magically vanishes after a random time (1-30 minutes)?? Sounds really strange. I don’t think I have ever seen this happen.

The assignments are simple database entries and there is no specific FOG log you can look at I think. But you can enable MySQL/MariaDB logging and try to figure out why this is happening. Will still be hard to find out what is causing this even if you see it in the logs.

Do you use the FOG API by any chance? Some kind of scripting to automate FOG stuff?

If not it’s probably best to manually check the database tables on your FOG server:

shell> mysql -u root

mysql> use fog;

mysql> SELECT * FROM printerAssoc WHERE paPrinterID NOT IN (SELECT pID FROM printers);

mysql> SELECT * FROM printerAssoc WHERE paHostID NOT IN (SELECT hostID FROM hosts);

The later two (select) queries should return an empty result set. If you get results it means that there are assignments still in the database for hosts or printers that do not exist anymore. While this is not a problem in general it would still be wise to clean that up.

Now you can start looking a a certain host having printers assigned by: SELECT * FROM printerAssoc WHERE paHostID=123456 (put in the host ID you see in the FOG web UI (parameter in the URL when editing this host)

See if the assignment is in the database compared to what you see in the web UI.