Okay nothing to do with FOG 
ALTER TABLE mysql.column_stats MODIFY histogram longblob;
ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');
Sorry for the noise
M
Posts made by marcolefo
-
RE: Mariadb : Incorrect definition of table mysql.column_statsposted in FOG Problems
-
RE: Mariadb : Incorrect definition of table mysql.column_statsposted in FOG Problems
@marcolefo said in Mariadb : Incorrect definition of table mysql.column_stats:
Incorrect definition of table mysql.column_stats
Oh ! There was an update of Mariadb
2025-04-03 12:28:20 status installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 2025-04-03 12:28:20 remove mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 <none> 2025-04-03 12:28:20 status half-configured mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 2025-04-03 12:28:20 status half-installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 2025-04-03 12:28:20 status config-files mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1I will check that
-
Mariadb : Incorrect definition of table mysql.column_statsposted in FOG Problems
Hi
Since 3 days I have this error in /var/log/mysql/error.log 3 times by second :
2025-04-03 12:11:38 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255). 2025-04-03 12:11:38 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').I have done what I have written here :
https://forums.fogproject.org/topic/17849/fogtaskscheduler-100-cpuDo you think there is a link ?
Other symptom, after clone a system to the server, the image stays in /images/dev/<@mac> and doesn’t go to /images/.
Thanks
-
RE: FOGTaskScheduler 100% CPUposted in FOG Problems
So I have deleted the entry with no data
DELETE FROM powerManagement WHERE pmMin = '' OR pmHour = '';The problem is resolved.
I have backed up the table before -
RE: FOGTaskScheduler 100% CPUposted in FOG Problems
Maybe it’s a problem ?
MariaDB [fog]> SELECT * FROM powerManagement WHERE pmAction LIKE '%wol%'; +-------+----------+-------+--------+-------+---------+-------+----------+------------+ | pmID | pmHostID | pmMin | pmHour | pmDom | pmMonth | pmDow | pmAction | pmOndemand | +-------+----------+-------+--------+-------+---------+-------+----------+------------+ | 15414 | 3756 | | 6 | | | | wol | 0 | | 15392 | 3464 | | | | | | wol | 0 | | 15422 | 3749 | | 6 | | | | wol | 0 | | 15405 | 3751 | 0 | | * | * | * | wol | 0 | | 15406 | 3750 | 0 | | * | * | * | wol | 0 | | 15402 | 3754 | 0 | | * | * | * | wol | 0 | | 15403 | 3753 | 0 | | * | * | * | wol | 0 | | 15376 | 3451 | | | | | | wol | 0 | | 15412 | 3758 | 0 | | * | * | * | wol | 0 | | 15411 | 3757 | 0 | | * | * | * | wol | 0 | | 15423 | 3747 | | 6 | | | | wol | 0 | | 15371 | 3598 | | | | | | wol | 0 | | 15361 | 3594 | | | | | | wol | 0 | | 15362 | 3586 | | | | | | wol | 0 | | 15358 | 3587 | | | | | | wol | 0 | | 15359 | 3585 | | | | | | wol | 0 | | 15394 | 3475 | | | | | | wol | 0 | | 15395 | 3471 | | | | | | wol | 0 | | 15380 | 3474 | | | | | | wol | 0 | | 15408 | 3749 | 0 | | * | * | * | wol | 0 | | 15409 | 3747 | 0 | | * | * | * | wol | 0 | | 15373 | 3454 | | | | | | wol | 0 | | 15427 | 3759 | | 6 | | | | wol | 0 | | 15417 | 3753 | | 6 | | | | wol | 0 | | 15418 | 3752 | | 6 | | | | wol | 0 | | 15360 | 3584 | | | | | | wol | 0 | | 15421 | 3748 | | 6 | | | | wol | 0 | | 15391 | 3463 | | | | | | wol | 0 | | 15370 | 3596 | | | | | | wol | 0 | | 15419 | 3751 | | 6 | | | | wol | 0 | | 15377 | 3450 | | | | | | wol | 0 | | 15385 | 3455 | | | | | | wol | 0 | | 15386 | 3460 | | | | | | wol | 0 | | 15387 | 3465 | | | | | | wol | 0 | | 15388 | 3461 | | | | | | wol | 0 | | 15389 | 3473 | | | | | | wol | 0 | | 15390 | 3462 | | | | | | wol | 0 | | 15396 | 3472 | | | | | | wol | 0 | | 15397 | 3468 | | | | | | wol | 0 | | 15410 | 3746 | 0 | | * | * | * | wol | 0 | | 15407 | 3748 | 0 | | * | * | * | wol | 0 | | 15416 | 3754 | | 6 | | | | wol | 0 | | 15398 | 3469 | | | | | | wol | 0 | | 15399 | 3467 | | | | | | wol | 0 | | 15400 | 3756 | 0 | | * | * | * | wol | 0 | | 15375 | 3453 | | | | | | wol | 0 | | 15357 | 3593 | | | | | | wol | 0 | | 15413 | 3759 | 0 | | * | * | * | wol | 0 | | 15393 | 3470 | | | | | | wol | 0 | | 15401 | 3755 | 0 | | * | * | * | wol | 0 | | 15374 | 3449 | | | | | | wol | 0 | | 15364 | 3588 | | | | | | wol | 0 | | 15365 | 3595 | | | | | | wol | 0 | | 15366 | 3591 | | | | | | wol | 0 | | 15367 | 3590 | | | | | | wol | 0 | | 15368 | 3583 | | | | | | wol | 0 | | 15369 | 3592 | | | | | | wol | 0 | | 15404 | 3752 | 0 | | * | * | * | wol | 0 | | 15424 | 3746 | | 6 | | | | wol | 0 | | 15425 | 3757 | | 6 | | | | wol | 0 | | 15420 | 3750 | | 6 | | | | wol | 0 | | 15415 | 3755 | | 6 | | | | wol | 0 | | 15382 | 3466 | | | | | | wol | 0 | | 15383 | 3457 | | | | | | wol | 0 | | 15384 | 3456 | | | | | | wol | 0 | | 15378 | 3452 | | | | | | wol | 0 | | 15379 | 3459 | | | | | | wol | 0 | | 15426 | 3758 | | 6 | | | | wol | 0 | | 15381 | 3458 | | | | | | wol | 0 | | 15363 | 3589 | | | | | | wol | 0 | +-------+----------+-------+--------+-------+---------+-------+----------+------------+ 70 rows in set (0,001 sec) -
FOGTaskScheduler 100% CPUposted in FOG Problems
Hi
When my FOG do nothing (no task scheduled, no task active) I have a CPU at 100% with FOGTaskScheduler.
I have read this forum, it seems it’s not normal
But I didnot find a way to repair this.The fogscheduler.log :
cat /var/log/fog/fogscheduler.log [04-03-25 10:31:46 am] ================================== === ==== ===== ==== === ========= == === == === === ======== ==== == ==== === === ======== ==== == ========= === ==== ==== == ========= === ======== ==== == === === === ======== ==== == ==== === === ========= == === == === === ========== ===== ==== ================================== ===== Free Opensource Ghost ====== ================================== ============ Credits ============= = https://fogproject.org/Credits = ================================== == Released under GPL Version 3 == ================================== [04-03-25 10:31:46 am] Interface Ready with IP Address: 127.0.0.1 [04-03-25 10:31:46 am] Interface Ready with IP Address: 127.0.1.1 [04-03-25 10:31:46 am] Interface Ready with IP Address: X.X.X.X [04-03-25 10:31:46 am] Interface Ready with IP Address: fog.local [04-03-25 10:31:46 am] * Starting TaskScheduler Service [04-03-25 10:31:46 am] * Checking for new items every 60 seconds [04-03-25 10:31:46 am] * Starting service loop [04-03-25 10:31:46 am] * 70 tasks found. [04-03-25 10:31:46 am] * 0 scheduled task(s) to run. [04-03-25 10:31:46 am] * 70 power management task(s) to run.I don’t understant where are these 70 tasks.
Do you see the problem ?
-
1.5.6 : Small local disk and the rest unallocatedposted in FOG Problems
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 -
RE: Small local disk and the rest unallocatedposted in FOG Problems
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
-
RE: Issues after upgrading from 1.4.3 to 1.4.4posted in Bug Reports
@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 -
RE: Multicast error : Get Fog Host dataposted in FOG Problems
@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
-
RE: Multicast error : Get Fog Host dataposted in FOG Problems
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
-
RE: Multicast error : Get Fog Host dataposted in FOG Problems
@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) -
RE: Multicast error : Get Fog Host dataposted in FOG Problems
@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`) -
RE: Multicast error : Get Fog Host dataposted in FOG Problems
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') -
Multicast error : Get Fog Host dataposted in FOG Problems
FOG server 1.4.4 on Debian 8
Strange problem with multicast deployment.
After deploying the host cannot get his information. It displays :Get FOG host datas... wget : server returned error : HTTP/1.0 500 Internal Server ErrorIn /var/log/apache2/error.log :
[Mon Nov 27 14:27:23.808904 2017] [:error] [pid 1378] [client 192.168.4.184:34648] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97 [Mon Nov 27 14:27:23.822002 2017] [:error] [pid 756] [client 192.168.4.187:45862] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97 [Mon Nov 27 14:27:23.826015 2017] [:error] [pid 654] [client 192.168.4.179:55746] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97 [Mon Nov 27 14:27:23.990248 2017] [:error] [pid 1513] [client 192.168.4.185:38952] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97 [Mon Nov 27 14:27:24.118431 2017] [:error] [pid 757] [client 192.168.4.183:44258] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97 [Mon Nov 27 14:27:24.224749 2017] [:error] [pid 756] [client 192.168.4.186:48876] PHP Fatal error: Call to a member function get() on null in /var/www/fog/service/hostinfo.php on line 97No problem when deploying on this hosts with unicast method.
Thanks.
Marc -
RE: Organizations Using FOGposted in General
Organization Name: IUT de Bordeaux
Location : Bordeaux, France
Approximate Number of systems: ~50 for now. Will increase to 1000
Since 2016/11 -
Upgrade 1.3.1 RC5 to 1.3.1posted in Bug Reports
Server
- FOG Version: 1.3.1 (6053)
- OS: Debian 8 Jessie
Description
I don’t know if it is a real problem, but just in case…
When upgrading 1.3.1 rc5 to 1.3.1 :* You still need to install/update your database schema. * This can be done by opening a web browser and going to: http://192.168.98.12/fog/management * Press [Enter] key when database is updated/installed. * Setting up storage............................................/lib/common/functions.sh: ligne 1076: /images/dev/postdownloadscripts/fog.postinit: Aucun fichier ou dossier de ce type OKFOG seems normal for now. I will post here if we encounter problem.
Have a nice day.