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

Creating Group from Host Management Page

Scheduled Pinned Locked Moved Solved
Bug Reports
3
6
1.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.
  • J
    jburleson
    last edited by Jul 5, 2016, 5:23 PM

    FOG:
    Running Version 8355
    SVN Revision: 5805

    Creating groups from the Host Management page adds a phantom Group Member.

    Steps to reproduce:

    1. Go to the Hosts Management Page
    2. Search for a host or hosts
    3. Select the host
    4. Scroll to the bottom and Create a new group
    5. Switch to the Group Management Page and take a look at the group you just created. The numbers of members listed in the bottom left will be 1 more than the actual numbers of members listed on the Membership page.

    This only occurs if you create the group from the Host Management page. If you create the group from the Group Management page and then add hosts from either the Group page or the Host Management page, the member number is correct.

    1 Reply Last reply Reply Quote 1
    • W
      Wayne Workman
      last edited by Jul 5, 2016, 5:24 PM

      Very nice attention to detail. Moving this to bugs.

      How are you with SQL? Can you figure out what the phantom member is?

      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/

      1 Reply Last reply Reply Quote 0
      • J
        jburleson
        last edited by Jul 5, 2016, 5:37 PM

        Here is what I found from the database tables. Here is the list of members from a group that I create with just two hosts.

        mysql> select * from groupMembers where gmGroupID=68;
        +------+----------+-----------+
        | gmID | gmHostID | gmGroupID |
        +------+----------+-----------+
        | 1911 |      880 |        68 |
        | 1910 |        0 |        68 |
        | 1912 |      879 |        68 |
        +------+----------+-----------+
        3 rows in set (0.00 sec)
        

        HostIDs 880 and 879 real host. It is the second entry (HostID 0) that is for a fake host.

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

        Might be a loop iteration issue.

        1 Reply Last reply Reply Quote 0
        • T
          Tom Elliott
          last edited by Jul 5, 2016, 5:45 PM

          This I found and fixed this morning. Please update. YOu may need to run:

          delete from groupMembers where gmHostID=0;

          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 1
          • T
            Tom Elliott
            last edited by Jul 5, 2016, 5:46 PM

            The phantom member is 0.

            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 1
            • J
              jburleson
              last edited by Jul 5, 2016, 6:02 PM

              Sweet. Ran the delete statement and it fixed the issue. I will pull the latest version down in the morning and rerun the installer.

              Thanks for the quick response everyone!

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              1 / 1
              • First post
                1/6
                Last post

              170

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project