some global settings being cleared during group settings update

[gwhitfield]

@Wayne-Workman said in some global settings being cleared during group settings update:

select * from hosts where hostID=0 \G

No idea what I’m doing in MySQL but this is result:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
administrator@PC-FOGSERVER:/$ mysql -u root -p fog
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 101
Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu)

Copyright 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> select * from hosts where hostID=0 \G
Empty set (0.00 sec)

mysql>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[Wayne Workman]

@gwhitfield The output looks good. It was just a shot in the dark. I’m not sure what’s going on with your setup but if this was a bug in fog trunk, we would have many people saying the same thing… we’re not… so this leads me to believe there’s something in your DB that is causing this issue. If you have time, I’d be willing to look around and see if anything stands out via team viewer.

[gwhitfield]

@Wayne-Workman Wow, that’s very nice of you! I would be happy to let you look but I don’t know that it’s necessary for you to go through all that just yet considering I never really update the screen resolution settings. If you feel that it would be beneficial to YOU then I’m all for it but otherwise it’s not necessary for you to do that. I’ll explain -

I’m honestly not sure how I even stumbled on this though I WAS trying to figure out how the settings got cleared and I was clicking and checking everything until I found it. Seeing that I usually don’t touch that setting it was probably an accident that it happened at all. Sure, it’s reproduceable but I guess as long as I keep not touching that setting I shouldn’t have any further problems. The odd thing is that it seems to be a “feature” on each system of mine that I’ve checked, 3 or 4 out of 15. I’m going to check the rest, it may be a few days before I know the results.

Thank you again for your quick responses!!!

[gwhitfield]

@Wayne-Workman One other thought comes to mind. You mentioned possibly something in the DB. I did notice that on a couple recent SVN updates I was not prompted to update/upgrade the DB. Is this normal or should there ALWAYS be a DB update prompt when executing the install of new svn?

[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!!