7703 - Groups Bugged

[RLane]

@Tom-Elliott define(‘DATABASE_HOST’,‘p:127.0.0.1’);
define(‘DATABASE_NAME’,‘fog’);
define(‘DATABASE_USERNAME’,‘root’);
define(‘DATABASE_PASSWORD’,“”);
}
/** @function svc_setting() Defines the service settings
* (e.g. FOGMulticastManager)
* @return void
/
private static function svc_setting() {
define(‘UDPSENDERPATH’,‘/usr/local/sbin/udp-sender’);
define(‘MULTICASTINTERFACE’,‘ens160’);
define(‘UDPSENDER_MAXWAIT’,null);
}
/* @function init_setting() Initial values if fresh install are set here
* NOTE: These values are only used on initial
* installation to set the database values.
* If this is an upgrade, they do not change
* the values within the Database.
* Please use FOG Configuration->FOG Settings
* to change these values after everything is
* setup.
* @return void
*/
private static function init_setting() {
define(‘TFTP_HOST’, “10.5.1.20”);
define(‘TFTP_FTP_USERNAME’, “fog”);
define(‘TFTP_FTP_PASSWORD’, “VqafHBSMk0WMSiwwXUnU41isjEkDj/jrx5CQh5LuVPI=”);
define(‘TFTP_PXE_KERNEL_DIR’, “/var/www/html/fog//service/ipxe/”);
define(‘PXE_KERNEL’, ‘bzImage’);
define(‘PXE_KERNEL_RAMDISK’,127000);
define(‘USE_SLOPPY_NAME_LOOKUPS’,true);
define(‘MEMTEST_KERNEL’, ‘memtest.bin’);
define(‘PXE_IMAGE’, ‘init.xz’);
define(‘PXE_IMAGE_DNSADDRESS’, “10.5.1.12”);
define(‘STORAGE_HOST’, “10.5.1.20”);
define(‘STORAGE_FTP_USERNAME’, “fog”);
define(‘STORAGE_FTP_PASSWORD’, “VqafHBSMk0WMSiwwXUnU41isjEkDj/jrx5CQh5LuVPI=”);
define(‘STORAGE_DATADIR’, ‘/images/’);
define(‘STORAGE_DATADIR_UPLOAD’, ‘/images/dev’);
define(‘STORAGE_BANDWIDTHPATH’, ‘/fog/status/bandwidth.php’);
define(‘STORAGE_INTERFACE’,‘ens160’);
define(‘UPLOADRESIZEPCT’,5);
define(‘WEB_HOST’, “10.5.1.20”);
define(‘WOL_HOST’, “10.5.1.20”);
define(‘WOL_PATH’, ‘/fog/wol/wol.php’);
define(‘WOL_INTERFACE’, “ens160”);
define(‘SNAPINDIR’, “/opt/fog/snapins/”);
define(‘QUEUESIZE’, ‘10’);
define(‘CHECKIN_TIMEOUT’,600);
define(‘USER_MINPASSLENGTH’,4);
define(‘USER_VALIDPASSCHARS’,‘1234567890ABCDEFGHIJKLMNOPQRSTUVWZXYabcdefghijklmnopqrstuvwxyz_()^!#-’);
define(‘NFS_ETH_MONITOR’, “ens160”);
define(‘UDPCAST_INTERFACE’, “ens160”);
define(‘UDPCAST_STARTINGPORT’, 63100 ); // Must be an even number! recommended between 49152 to 65535
define(‘FOG_MULTICAST_MAX_SESSIONS’,64);
define(‘FOG_JPGRAPH_VERSION’, ‘2.3’);
define(‘FOG_REPORT_DIR’, ‘./reports/’);
define(‘FOG_UPLOADIGNOREPAGEHIBER’,true);
define(‘FOG_DONATE_MINING’, “0”);
}
}

When you and I were troubleshooting the original error, was something changed in this file? Perhaps that is why it is not working as properly.

[Tom Elliott]

@RLane Something was changed somewhere.

However, if you’ve updated, this shouldn’t even be a problem.

Are you doing updates from git or svn?

[RLane]

@Tom-Elliott SVN on CentOS7 x64

[Tom Elliott]

@RLane can you delete the folder and re-checkout?
mv trunk trunk_old
svn co https://svn.code.sf.net/p/freeghost/code/trunk

[RLane]

@Tom-Elliott said in 7703 - Groups Bugged:

svn co https://svn.code.sf.net/p/freeghost/code/trunk

Still have the same issue, since this is not the production FOG server I use daily, I will delete and rebuild from scratch… especially if nobody else is having these issues.

[mclapper68]

I am having the same issue. I am running Fedora workstation 23 with Fog Git version 7795. This is from an upgrade from Fog version .32. I can not add more than one host to a group.

[Tom Elliott]

@mclapper68 As bad as it sounds, you will likely have to delete the groups, and re-add them. It shouldn’t be impacting anything severly as you can’t use the group currently anyway.

[mclapper68]

I deleted all of my groups. Created a new test group then selected the dozen hosts I wanted. Unfortunately, only one host is in my list. If I add a new host to the group it replaces the one that is in the list.

[URfog]

Are you trying it on a Debian 8.4? If so I had to touch the groupMembers

UNIQUE KEY gmHostID (gmHostID,gmGroupID),

because it was originally UNIQUE KEY gmHostID (gmGroupID),

Hope it helps

[Tom Elliott]

@URfog,

Thanks for posting this.

I’ve added this as a schema update as I think you’re correct in what the issue is.

Hopefully this will help both of the users and it’s in the base code so no more “tricks” to try to get it to work.

[mclapper68]

Thanks to the both of you (Tom and URfog) for the help. But I am not sure what I am to do to correct the problem. Do I need to update fog again or make a change to my fog database?

[URfog]

It’s just a revision update @mclapper68

[mclapper68]

I updated to the latest revision 7853 then updated the database scheme. Deleted all my groups. Created a new test group and tried to add some hosts, but now it will not add any hosts to the groups.

[Wayne Workman]

Just tested this on 7853 with Fedora 23, all seems fine for me.

Since that’s the same version you tried, there is probably something wrong in the DB.

Can you describe, click-for-click, how you are adding them to the group?

[Tom Elliott]

Yeah, I need more information if possible.

If it’s any help, I’ve now added two bits of information to update and help maintain and keep this from happening. If you’re doing the schema updates, and these aren’t happening properly. Is there any error’s reported in the gui when you ran the schema update?

What happens if you change the DB schema to 218?

mysql -u root fog
UPDATE schemaVersion SET vValue=218 where vID=1;
exit

[mclapper68]

I click on the Host Manager in the Fog gui. Then I select List All Hosts then check the ones I want to add to a goup then I choose Create New Group then enter the name. When I go to the Group Managemnet and List All Groups my group is membership is zero. I ran the db schema update to 218 and I did not receive any errors in the gui. I believe my problem maybe related to FogProject Topic 7360.

[Wayne Workman]

@mclapper68 Immediately after reproducing the problem, can you check for apache errors?
Web interface -> FOG Configuration -> Log Viewer -> Apache error log

Look at the timestamps on the entries and post any relevant ones.

[michael_f]

@Wayne-Workman Same problem here: since I upgraded to 7853 all groups are empty and no client can be added.
Also existing groups with members have been emptied.
Apache error log doesn’t shown any errors when attempting to add clients.
Updating to lastest trunk didn’t solve the problem.
Tried to delete all groups and set DB-Schema as Tom Elliot suggested. When doing a schema update i get the error message

PHP Strict Standards: Only variables should be passed by reference in /var/www/fog/lib/pages/schemaupdaterpage.class.php on line 48, referer: http://172.16.0.231/fog/management/?node=schema

[goempie]

Same problem here

[michael_f]

@michael_f The schema update is broken,the table groupMembers is missing in my DB