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

Only one computer in group

Scheduled Pinned Locked Moved Solved
FOG Problems
8
25
6.9k
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.
  • W
    Wayne Workman @Zaarin
    last edited by Wayne Workman May 10, 2016, 7:36 AM May 10, 2016, 1:36 PM

    @Zaarin The problem is likely the data in the tables, not the tables themselves.

    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
    • Z
      Zaarin
      last edited by May 10, 2016, 1:39 PM

      I removed the \G. Empy result is returned.

      T 1 Reply Last reply May 10, 2016, 1:41 PM Reply Quote 0
      • T
        Tom Elliott @Zaarin
        last edited by May 10, 2016, 1:41 PM

        @Zaarin Why’d you remove the \G? That’s valid. And prints data much nicer especially when the output to the screen.

        Can you get us a copy of the Statement with the \G AND without the WHERE clause(s)?

        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

        W 1 Reply Last reply May 11, 2016, 12:47 AM Reply Quote 0
        • Z
          Zaarin
          last edited by May 10, 2016, 1:44 PM

          I agree with you for the unique key gmHostID_2 but not for the index: gmHostID. With that index only one group is allowed with one member.

          \G is not recognized in phpmyadmin. I took the mysql console. Here is what you want.

          mysql> SELECT * FROM `fog`.`groupMembers` \G
          *************************** 1. row ***************************
               gmID: 1
           gmHostID: 6
          gmGroupID: 1
          *************************** 2. row ***************************
               gmID: 3
           gmHostID: 7
          gmGroupID: 3
          *************************** 3. row ***************************
               gmID: 4
           gmHostID: 2
          gmGroupID: 4
          3 rows in set (0.00 sec)
          

          Thanks for your time,

          Zaza.

          T 2 Replies Last reply May 10, 2016, 1:47 PM Reply Quote 0
          • T
            Tom Elliott @Zaarin
            last edited by May 10, 2016, 1:47 PM

            @Zaarin No, it’s not. If it were the case, ALL users of trunk would be seeing EXACTLY the same problems.

            Maybe the issue is the schema that performed didn’t update properly? I don’t know.

            You can try to alter the unique indexes if you want though. I don’t know what you’d do. Maybe for now just remove the unique index’s and keys?

            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
            • T
              Tom Elliott @Zaarin
              last edited by May 10, 2016, 1:49 PM

              @Zaarin What version of MySQL are you running?

              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
              • Z
                Zaarin
                last edited by May 10, 2016, 2:00 PM

                5.5.49-0ubuntu0.14.04.1

                I had problem with database update but it was some version before. I agree with you that all users will see exactly the same problem.

                The only way to check is to compare with yours: Do you have the same structure?

                Once again thanks for all your time,

                Zaza from Luxembourg.

                1 Reply Last reply Reply Quote 0
                • T
                  Tom Elliott @Zaarin
                  last edited by May 10, 2016, 2:17 PM

                  @Zaarin

                  CREATE TABLE `groupMembers` (
                    `gmID` int(11) NOT NULL AUTO_INCREMENT,
                    `gmHostID` int(11) NOT NULL,
                    `gmGroupID` int(11) NOT NULL,
                    PRIMARY KEY (`gmID`),
                    UNIQUE KEY `gmHostID` (`gmHostID`,`gmGroupID`),
                    UNIQUE KEY `gmHostID_2` (`gmHostID`,`gmGroupID`),
                    KEY `new_index` (`gmHostID`),
                    KEY `new_index1` (`gmGroupID`)
                  ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
                  

                  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

                  T 1 Reply Last reply May 10, 2016, 2:18 PM Reply Quote 0
                  • T
                    Tom Elliott @Tom Elliott
                    last edited by May 10, 2016, 2:18 PM

                    @Tom-Elliott The only difference I see is the KEY’s aren’t adjusted for in yours where mine 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! 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
                    • Z
                      Zaarin
                      last edited by May 10, 2016, 2:29 PM

                      I alter the table indexes like yours. It works like a charm now. I have my 7 computers in one group. 🙂

                      This topic can be closed.

                      Thanks you,

                      Zaza.

                      1 Reply Last reply Reply Quote 0
                      • W
                        Wayne Workman @Tom Elliott
                        last edited by May 11, 2016, 12:47 AM

                        @Tom-Elliott said in Only one computer in group:

                        Why’d you remove the \G? That’s valid.

                        Not on every system. I’ve had it throw syntax errors before.

                        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
                        • ?
                          A Former User
                          last edited by May 24, 2016, 8:12 PM

                          I’ve been getting the same problem with a fresh install on an ubuntu 14.04.3 x64. I used the git trunk version.
                          The only way I find to get rid of it is to delete the table groupMembers and recreate it with the create table find here. The other way for a fresh install is to install the stable 1.2.0 version first (which create the database) and installing the trunk version after. There is something with the database creation of the git trunk version. I repeated it today and I got the same issue.

                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by May 24, 2016, 9:42 PM

                            @lemxseb thanks a lot for testing and reporting. May I ask you some question:

                            I repeated it today and I got the same issue.

                            Did you remove the DB completely (purge the package plus delete the DB files in /var/lib/)?

                            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
                            • A
                              abos_systemax
                              last edited by May 25, 2016, 7:00 AM

                              We are having the same issues here, on Trunk version 7843.
                              We’ve just updated and did not yet perform a removal of the dbase

                              A 1 Reply Last reply May 25, 2016, 7:09 AM Reply Quote 0
                              • A
                                abos_systemax @abos_systemax
                                last edited by May 25, 2016, 7:09 AM

                                @abos_systemax said in Only one computer in group:

                                We are having the same issues here, on Trunk version 7843.
                                We’ve just updated and did not yet perform a removal of the dbase

                                With the new group table SQL from earlier this thread, it is resolved.

                                1 Reply Last reply Reply Quote 0
                                • M
                                  mccabem
                                  last edited by mccabem Jun 3, 2016, 12:12 PM Jun 3, 2016, 5:50 PM

                                  Hey guys i’m seeing this exact problem. I did a fresh install of the trunk a week or two ago, i’m on version 7519. I’m on Ubuntu 14.04.

                                  I did re-import my hosts from my 1.2.0 server, not sure if this is causing it or not.

                                  I see you guys got it fixed by creating the new group table, but i’m concerned i’ll lose all of my hosts when i do that? If it won’t mess with my hosts, can someone give me some direction on how exactly i run that create table command? i’m not very linux or mysql savvy 😞 Thank you!!

                                  Edit: I just checked a second site that i have on the trunked version, and it is doing the same thing except it shows 0 new members after I try to put computers in the group. I get no error, just no members. This site is running 7851 on 14.04 and i did NOT restore any type of hosts, this was a fresh install… ugh please help 😞

                                  R 1 Reply Last reply Jun 3, 2016, 6:29 PM Reply Quote 0
                                  • R
                                    RLane @mccabem
                                    last edited by RLane Jun 3, 2016, 12:30 PM Jun 3, 2016, 6:29 PM

                                    @mccabem Upgrade to the latest version of the trunk. I’m using 7959 and it works fine.

                                    I believe @Tom-Elliott fixed this issue in a 79xx version of the trunk.

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

                                    197

                                    Online

                                    12.0k

                                    Users

                                    17.3k

                                    Topics

                                    155.2k

                                    Posts
                                    Copyright © 2012-2024 FOG Project