• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

RC11 group membership

Scheduled Pinned Locked Moved Solved
Bug Reports
3
15
3.7k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A
    ablohowiak
    last edited by Sep 28, 2016, 6:38 PM

    Server
    • FOG Version: RC11
    • OS: Ubuntu 14.04
    Client
    • Service Version:
    • OS:
    Description

    The GUI is very responsive but, group membership times out and leaves a blank screen.

    PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/fog/lib/db/pdodb.class.php on line 544, referer: http://fog/fog/management/index.php?node=group&sub=edit&id=1552

    1 Reply Last reply Reply Quote 0
    • W
      Wayne Workman
      last edited by Wayne Workman Sep 28, 2016, 3:42 PM Sep 28, 2016, 9:42 PM

      How many hosts are in the group? What are the exact verbatim click-for-click steps to reproduce?

      Are you just clicking on Group Membership from a group?

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      A 1 Reply Last reply Sep 29, 2016, 11:59 AM Reply Quote 0
      • A
        ablohowiak @Wayne Workman
        last edited by Sep 29, 2016, 11:59 AM

        @Wayne-Workman
        Size doesn’t seem to matter, but I’ve used a group of 14 for this.
        0_1475149923562_upload-4c9984c9-0408-4b75-b509-9ba4f212494d

        Once the page for the group is up. Click on membership.
        0_1475150247180_upload-63e4862f-837d-499f-bd90-3a4d9870f3ca
        And the resultanting web page.
        0_1475150027763_upload-cbe29d40-9c92-4892-91dd-cf41d03d20e1

        The apache log has:
        PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/fog/lib/db/pdodb.class.php on line 544, referer: http://fog/fog/management/index.php?node=group&sub=edit&id=1559

        …along with endless entries of:
        PHP Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in /var/www/html/fog/lib/client/printerclient.class.php on line 146

        W 1 Reply Last reply Sep 29, 2016, 2:02 PM Reply Quote 0
        • W
          Wayne Workman @ablohowiak
          last edited by Sep 29, 2016, 2:02 PM

          @ablohowiak Can you run these queries and give us the output?

          mysql -D fog
          SELECT `hostID`, `hostName` FROM `hosts` WHERE `hostID` = '0';
          SELECT * FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
          SELECT * FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
          SELECT * FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
          SELECT * from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 
          quit
          

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          A 1 Reply Last reply Sep 29, 2016, 2:13 PM Reply Quote 0
          • A
            ablohowiak @Wayne Workman
            last edited by Sep 29, 2016, 2:13 PM

            @Wayne-Workman
            A few results.

            0_1475158364382_upload-05966270-53a2-438a-9deb-6721ec2e98c2

            W 1 Reply Last reply Sep 29, 2016, 4:01 PM Reply Quote 0
            • W
              Wayne Workman @ablohowiak
              last edited by Wayne Workman Sep 29, 2016, 2:09 PM Sep 29, 2016, 4:01 PM

              @ablohowiak Those returns from the previous statements are bad, and shouldn’t be there. you can change those selects to deletes to delete them. Like this:

              DELETE FROM `hosts` WHERE `hostID` = '0';
              DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
              DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
              DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
              DELETE FROM `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 
              

              Can you run these now?

              SELECT * FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`);
              SELECT * FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
              SELECT * FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
              SELECT * FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT hostID FROM hosts);
              

              —Fixed

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              A 2 Replies Last reply Sep 29, 2016, 5:54 PM Reply Quote 0
              • A
                ablohowiak @Wayne Workman
                last edited by Sep 29, 2016, 5:54 PM

                @Wayne-Workman There are more results than this.

                0_1475171206988_upload-74a3f4d5-1d69-4714-ac65-9981e35cbb11

                0_1475171258966_upload-ac3282d9-7673-458a-b00d-b0df031c7c47

                0_1475171346155_upload-3264c373-c74f-4a86-8a26-89096707d974

                1 Reply Last reply Reply Quote 0
                • T
                  Tom Elliott
                  last edited by Wayne Workman Sep 29, 2016, 2:09 PM Sep 29, 2016, 5:59 PM

                  Please try to create a backup then run:

                  DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`);
                  DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
                  DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
                  DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);
                  

                  ----Fixed

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                  A 1 Reply Last reply Sep 29, 2016, 6:49 PM Reply Quote 0
                  • A
                    ablohowiak @Tom Elliott
                    last edited by Sep 29, 2016, 6:49 PM

                    @Tom-Elliott
                    Should it be ‘gmHostID’ in the last line?

                    74 rows deleted. Membership is still behaving the same with the same error.

                    T 1 Reply Last reply Sep 29, 2016, 7:00 PM Reply Quote 0
                    • T
                      Tom Elliott @ablohowiak
                      last edited by Sep 29, 2016, 7:00 PM

                      @ablohowiak yes. Gm I copied from Wayne sorry lol

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • W
                        Wayne Workman
                        last edited by Wayne Workman Sep 29, 2016, 2:11 PM Sep 29, 2016, 8:06 PM

                        dang it, typos…

                        Well, do things work now?

                        –Edit, I didn’t see where you said it didn’t help you. Even after correcting the last SQL query and running it? I’m assuming you did this.

                        @Tom-Elliott any ideas?

                        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                        Daily Clean Installation Results:
                        https://fogtesting.fogproject.us/
                        FOG Reporting:
                        https://fog-external-reporting-results.fogproject.us/

                        T 1 Reply Last reply Sep 29, 2016, 8:21 PM Reply Quote 1
                        • T
                          Tom Elliott @Wayne Workman
                          last edited by Sep 29, 2016, 8:21 PM

                          @Wayne-Workman I suspect it’s the group thing and will be fixed. I say this as I cannot replicate even with a group of 12k hosts

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          A 1 Reply Last reply Sep 30, 2016, 12:23 PM Reply Quote 0
                          • A
                            ablohowiak @Tom Elliott
                            last edited by Sep 30, 2016, 12:23 PM

                            @Tom-Elliott I did run the query with the correction. Most of our groups are already built from this summer. RC11 has been very stable and responsive. I’ve reduced the client communication time from 900 to 300 with no impact to performance.

                            I think your team is in the “home stretch” with 1.3!

                            1 Reply Last reply Reply Quote 1
                            • A
                              ablohowiak @Wayne Workman
                              last edited by Oct 4, 2016, 1:49 PM

                              @Wayne-Workman I’ve had to rerun the delete query.

                              1 Reply Last reply Reply Quote 0
                              • T
                                Tom Elliott
                                last edited by Oct 10, 2016, 11:21 AM

                                I’m solving for now in that the group bad entries should he corrected for. I won’t know for sure until I get a bit more of a testbed but I still have had 0 luck in replicating since this was brought up and RC 11 was pushed out.

                                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                1 Reply Last reply Reply Quote 0
                                • 1 / 1
                                1 / 1
                                • First post
                                  3/15
                                  Last post

                                136

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project