@Tom-Elliott

Organization Name: IUT de Bordeaux
Location : Bordeaux, France
Approximate Number of systems: ~50 for now. Will increase to 1000
Since 2016/11

@sebastian-roth thanks

Perhaps we have a problem with our database. I have activated MySQL log and I can see a lot of theses warnings even il no task is active.

171204 17:16:13 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `hosts` (`hostID`,`hostName`,`hostDesc`,`hostIP`,`hostImage`,`hostBuilding`,`hostCreateDate`,`hostLastDeploy`,`hostCreateBy`,`hostUseAD`,`hostADDomain`,`hostADOU`,`hostADUser`,`hostADPass`,`hostADPassLegacy`,`hostProductKey`,`hostPrinterLevel`,`hostKernelArgs`,`hostKernel`,`hostDevice`,`hostInit`,`hostPending`,`hostPubKey`,`hostSecToken`,`hostSecTime`,`hostPingCode`,`hostExitBios`,`hostExitEfi`,`hostEnforce`) VALUES ('613','GMP-ONEWAY','Created by FOG Reg on November 23, 2017, 6:01 pm','','12','0','2017-11-23 18:01:46','2017-11-27 14:44:04',...

And this one exactly when FOG fails to get host data

71204 17:22:44 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `imageGroupAssoc` (`igaImageID`,`igaStorageGroupID`,`igaPrimary`) VALUES ('','1','') ON DUPLICATE KEY UPDATE `igaImageID`=VALUES(`igaImageID`),`igaStorageGroupID`=VALUES(`igaStorageGroupID`),`igaPrimary`=VALUES(`igaPrimary`)

@Sebastian-Roth ok done
https://forums.fogproject.org/topic/13329/1-5-6-small-local-disk-and-the-rest-unallocated

Hi

Following this post : https://forums.fogproject.org/topic/13260/small-local-disk-and-the-rest-unallocated/6

Since FOG upgrade 1.5.4 to 1.5.6 the partitions are randomly often badly resized.

We have test with the new init.xz and init_32.xz and the FOG settings (FTP Server and increase KERNEL RAMDISK SIZE from 127000 to 275000) with no change.

We have rollback to 1.5.4, it’s working.

d1.partitions

label: gpt
label-id: 342E0E46-FCE0-493B-B86B-CCD863B21A14
device: /dev/sda
unit: sectors
first-lba: 34
last-lba: 134217694

/dev/sda1 : start=        2048, size=     1021952, type=DE94BBA4-06D1-4D40-A16A-BFD50179D6AC, uuid=5219620A-6815-455F-B2AC-90053839B61B, name="Basic data partition", attrs="RequiredPartition GUID:63"
/dev/sda2 : start=     1024000, size=      204800, type=C12A7328-F81F-11D2-BA4B-00A0C93EC93B, uuid=CCB33AC5-D395-4B86-9429-FC1DF03DA6DF, name="EFI system partition", attrs="GUID:63"
/dev/sda3 : start=     1228800, size=       32768, type=E3C9E316-0B5C-4DB8-817D-F92DF00215AE, uuid=E12B2745-C17B-4AFD-AF85-EC7B8024826E, name="Microsoft reserved partition", attrs="GUID:63"
/dev/sda4 : start=     1261568, size=   132954112, type=EBD0A0A2-B9E5-4433-87C0-68B6B72699C7, uuid=51D443EE-8D96-4A4C-99A1-36F5B34FD10E, name="Basic data partition"

d1.minimum.partitions

label: gpt
label-id: 342E0E46-FCE0-493B-B86B-CCD863B21A14
device: /dev/sda
unit: sectors
first-lba: 34
last-lba: 134217694

/dev/sda1 : start=        2048, size=       26234, type=DE94BBA4-06D1-4D40-A16A-BFD50179D6AC, uuid=5219620A-6815-455F-B2AC-90053839B61B, name="Basic data partition", attrs="RequiredPartition GUID:63"
/dev/sda2 : start=     1024000, size=      204800, type=C12A7328-F81F-11D2-BA4B-00A0C93EC93B, uuid=CCB33AC5-D395-4B86-9429-FC1DF03DA6DF, name="EFI system partition", attrs="GUID:63"
/dev/sda3 : start=     1228800, size=       32768, type=E3C9E316-0B5C-4DB8-817D-F92DF00215AE, uuid=E12B2745-C17B-4AFD-AF85-EC7B8024826E, name="Microsoft reserved partition", attrs="GUID:63"
/dev/sda4 : start=     1261568, size=    50129436, type=EBD0A0A2-B9E5-4433-87C0-68B6B72699C7, uuid=51D443EE-8D96-4A4C-99A1-36F5B34FD10E, name="Basic data partition"

d1.fixed_size_partitions

:2:3

Hi

We face the same problem.
I have installed the new init files and modified the ramdisk size but nothing change.

Here is Gparted after cloning

@kagashe I had the same issue but the patch worked in my case.

Just I have uninstalled the plugin before applying the patch.

Just to be sure that you have the good file in place, can you do this ?

cd ~
wget https://raw.githubusercontent.com/FOGProject/fogproject/6717f382177e714c1bd22eb11627133cfd4e0ebe/packages/web/lib/fog/plugin.class.php
diff ~/plugin.class.php /var/www/fog/lib/fog/plugin.class.php

@sebastian-roth No problem

We have tested with 3 clients and then 1 client. All client were booted.

But today, it’s working… I think it’s not a FOG problem but our router and IGMP proxy.

I will look to it.

Thanks for your help

I have :

• followed this docs https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL and done all the Database Maintenance Commands
• relaunched foginstaller.sh

And now it hangs on partclone

I have also given a password to mysql root user. It’s a clue ?

Thanks

@sebastian-roth here it is :

mysql> desc hosts;
+------------------+---------------+------+-----+---------------------+----------------+
| Field            | Type          | Null | Key | Default             | Extra          |
+------------------+---------------+------+-----+---------------------+----------------+
| hostID           | int(11)       | NO   | PRI | NULL                | auto_increment |
| hostName         | varchar(16)   | NO   | UNI | NULL                |                |
| hostDesc         | longtext      | NO   |     | NULL                |                |
| hostIP           | varchar(25)   | NO   | MUL | NULL                |                |
| hostImage        | int(11)       | NO   |     | NULL                |                |
| hostBuilding     | int(11)       | NO   |     | NULL                |                |
| hostCreateDate   | timestamp     | NO   |     | CURRENT_TIMESTAMP   |                |
| hostLastDeploy   | datetime      | NO   |     | NULL                |                |
| hostCreateBy     | varchar(50)   | NO   |     | NULL                |                |
| hostUseAD        | char(1)       | NO   | MUL | NULL                |                |
| hostADDomain     | varchar(250)  | NO   |     | NULL                |                |
| hostADOU         | longtext      | NO   |     | NULL                |                |
| hostADUser       | varchar(250)  | NO   |     | NULL                |                |
| hostADPass       | varchar(250)  | NO   |     | NULL                |                |
| hostADPassLegacy | longtext      | NO   |     | NULL                |                |
| hostProductKey   | longtext      | YES  |     | NULL                |                |
| hostPrinterLevel | varchar(2)    | NO   |     | NULL                |                |
| hostKernelArgs   | varchar(250)  | NO   |     | NULL                |                |
| hostKernel       | varchar(250)  | NO   |     | NULL                |                |
| hostDevice       | varchar(250)  | NO   |     | NULL                |                |
| hostInit         | longtext      | YES  |     | NULL                |                |
| hostPending      | enum('0','1') | NO   |     | NULL                |                |
| hostPubKey       | longtext      | NO   |     | NULL                |                |
| hostSecToken     | longtext      | NO   |     | NULL                |                |
| hostSecTime      | timestamp     | NO   |     | 0000-00-00 00:00:00 |                |
| hostPingCode     | varchar(20)   | YES  |     | NULL                |                |
| hostExitBios     | longtext      | YES  |     | NULL                |                |
| hostExitEfi      | longtext      | YES  |     | NULL                |                |
| hostEnforce      | enum('0','1') | NO   |     | 1                   |                |
+------------------+---------------+------+-----+---------------------+----------------+
29 rows in set (0.00 sec)

mysql> desc imageGroupAssoc;
+-------------------+---------------+------+-----+---------+----------------+
| Field             | Type          | Null | Key | Default | Extra          |
+-------------------+---------------+------+-----+---------+----------------+
| igaID             | mediumint(9)  | NO   | PRI | NULL    | auto_increment |
| igaImageID        | mediumint(9)  | NO   | MUL | NULL    |                |
| igaStorageGroupID | mediumint(9)  | NO   |     | NULL    |                |
| igaPrimary        | enum('0','1') | NO   |     | NULL    |                |
+-------------------+---------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

@sebastian-roth thanks

Perhaps we have a problem with our database. I have activated MySQL log and I can see a lot of theses warnings even il no task is active.

171204 17:16:13 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `hosts` (`hostID`,`hostName`,`hostDesc`,`hostIP`,`hostImage`,`hostBuilding`,`hostCreateDate`,`hostLastDeploy`,`hostCreateBy`,`hostUseAD`,`hostADDomain`,`hostADOU`,`hostADUser`,`hostADPass`,`hostADPassLegacy`,`hostProductKey`,`hostPrinterLevel`,`hostKernelArgs`,`hostKernel`,`hostDevice`,`hostInit`,`hostPending`,`hostPubKey`,`hostSecToken`,`hostSecTime`,`hostPingCode`,`hostExitBios`,`hostExitEfi`,`hostEnforce`) VALUES ('613','GMP-ONEWAY','Created by FOG Reg on November 23, 2017, 6:01 pm','','12','0','2017-11-23 18:01:46','2017-11-27 14:44:04',...

And this one exactly when FOG fails to get host data

71204 17:22:44 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `imageGroupAssoc` (`igaImageID`,`igaStorageGroupID`,`igaPrimary`) VALUES ('','1','') ON DUPLICATE KEY UPDATE `igaImageID`=VALUES(`igaImageID`),`igaStorageGroupID`=VALUES(`igaStorageGroupID`),`igaPrimary`=VALUES(`igaPrimary`)

Hi.

No idea ?

Thanks for your help.

The line 97 in /var/www/fog/service/hostinfo.php is “->get(‘type’)”

    $img = $Image
        ->get('path');
    $imgFormat = $Image
        ->get('format');
    $imgType = $Image
        ->getImageType()
        ->get('type');
    $imgPartitionType = $Image
        ->getImagePartitionType()
        ->get('type');
    $imgid = $Image
        ->get('id');
    $PIGZ_COMP = $Image
        ->get('compress');
    $shutdown = intval(
        (bool)$Task
        ->get('shutdown')