Problem adding hosts to a group

[networkguy]

When I try to add multiple hosts to a new group only one host is added. If I add hosts after the group is created it also seems to only keep one of the hosts in the group. I’m running git version 7659. I don’t see any errors in the apache error logs.

[Tom Elliott]

Update to the latest, I’m pretty sure the issue is addressed.

[networkguy]

I just updated to git version 7849 and am able to reproduce the problem. If there are any logs/screenshots that you would like me to include please let me know. Thanks!

[Tom Elliott]

@networkguy https://forums.fogproject.org/topic/7360/only-one-computer-in-group/15

[Tom Elliott]

It may require you editing a little bit manually then. I did add code to make the changes, but my guess it didn’t take.

[networkguy]

@Tom-Elliott

drop table groupMembers;
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
;

All is well now. Thanks again!

[Tom Elliott]

@networkguy Did you create a backup table first?

[networkguy]

@Tom-Elliott

I didn’t really have anything in there worth saving I don’t think. With deleting that table, might I run into key relationship issues with other tables? I have a full DB backup taken just before the upgrade about 30 minutes ago.

select statements taken moments before dropping the table.

mysql> select * from groupMembers;
+------+----------+-----------+
| gmID | gmHostID | gmGroupID |
+------+----------+-----------+
|    3 |        5 |         3 |
|    5 |       25 |         4 |
+------+----------+-----------+
2 rows in set (0.00 sec)
mysql> select * from groupMembers \G
*************************** 1. row ***************************
     gmID: 3
 gmHostID: 5
gmGroupID: 3
*************************** 2. row ***************************
     gmID: 5
 gmHostID: 25
gmGroupID: 4
2 rows in set (0.00 sec)

[Tom Elliott]

@networkguy Awesome that it worked.

I have now added more adjustment to basically recreate the group members table but backup the data that is already there.

[networkguy]

@Tom-Elliott Sounds good. I seem to have lost the ability to close the bug threads I’ve created. Call this one closed and thanks again!