some global settings being cleared during group settings update

[Tom Elliott]

What if you run:

DELETE FROM hostMAC WHERE hmHostID NOT IN (SELECT hostID FROM hosts)

You may also need to delete invalid host entries (without a hostname, or now a hostname without a proper MAC address). To do so, run:

DELETE FROM hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC)

[gwhitfield]

@Tom-Elliott - Since I know zilch about MySQL I can’t talk what-ifs but I take it on faith so I’ll give that a try tomorrow.I’ll send the response as soon as I get a chance to do this step.

[Wayne Workman]

@gwhitfield said in some global settings being cleared during group settings update:

Is this normal or should there ALWAYS be a DB update prompt when executing the install of new svn?

It’s normal.

And Tom might be on to something, that’s the command we came up with way back where there was an issue with hosts disappearing…

[Tom Elliott]

I’ve found the issue as described and it is now fixed in the latest.

[gwhitfield]

@Tom-Elliott @Wayne-Workman - No way!! That was like watching a sweet give-an-go with a slam dunk finish. SCORE!! Can’t wait to try it out, thanks guys!!!

[gwhitfield]

@Tom-Elliott - Tried it out this morning and the general settings stay when host screen resolution is updated in group settings. However, something else is now happening, the AD settings for all group members are being wiped out screenshot below):

Here are Apache error logs:
…
[Tue May 17 08:29:19.953590 2016] [evasive20:error] [pid 5543] [client 192.168.0.112:59972] client denied by server configuration: /var/www/html/fog/service/updates.php
[Tue May 17 08:31:09.092720 2016] [mpm_prefork:notice] [pid 5539] AH00169: caught SIGTERM, shutting down
[Tue May 17 08:31:42.023880 2016] [mpm_prefork:notice] [pid 1080] AH00163: Apache/2.4.20 (Ubuntu) OpenSSL/1.0.2h configured – resuming normal operations
[Tue May 17 08:31:42.038242 2016] [core:notice] [pid 1080] AH00094: Command line: ‘/usr/sbin/apache2’
[Tue May 17 08:38:17.629592 2016] [:error] [pid 1103] [client 192.168.1.251:56181] PHP Warning: Missing argument 4 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:17.629634 2016] [:error] [pid 1103] [client 192.168.1.251:56181] PHP Warning: Missing argument 5 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:17.629644 2016] [:error] [pid 1103] [client 192.168.1.251:56181] PHP Warning: Missing argument 6 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:17.629653 2016] [:error] [pid 1103] [client 192.168.1.251:56181] PHP Warning: Missing argument 7 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:58.572637 2016] [:error] [pid 1102] [client 192.168.1.251:56202] PHP Warning: Missing argument 4 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:58.572683 2016] [:error] [pid 1102] [client 192.168.1.251:56202] PHP Warning: Missing argument 5 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:58.572693 2016] [:error] [pid 1102] [client 192.168.1.251:56202] PHP Warning: Missing argument 6 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
[Tue May 17 08:38:58.572702 2016] [:error] [pid 1102] [client 192.168.1.251:56202] PHP Warning: Missing argument 7 for Group::setAD(), called in /var/www/html/fog/lib/pages/groupmanagementpage.class.php on line 490 and defined in /var/www/html/fog/lib/fog/group.class.php on line 163, referer: http://192.168.1.53/fog/management/index.php?node=group&sub=edit&id=3
…

Edit: For clarity sake, the AD settings are wiped out only when the host screen resolution settings are updated, not when the general settings are updated.

[gwhitfield]

Any ideas on what can be done to correct this new wrinkle?

[Tom Elliott]

@gwhitfield Almost have a fix.

[Tom Elliott]

@Tom-Elliott Fix pushed.

[gwhitfield]

@Tom-Elliott - THANK YOU!!