Multicast error : Get Fog Host data

[marcolefo]

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')

[marcolefo]

Hi.

No idea ?

Thanks for your help.

[Sebastian Roth]

@marcolefo Sorry we didn’t have time to look into this yet. I’ll mark this unread for now and will look into it tonight.

[marcolefo]

@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]

@marcolefo said in Multicast error : Get Fog Host data:

on a table with more than one UNIQUE KEY is unsafe Statement

I am not too sure if those warnings are really an issue. Let’s see if your DB structure is different to what it should be like.

shell> mysql -u root -p
Enter password:
mysql> use fog;
...
mysql> desc hosts;
...
mysql> desc imageGroupAssoc;
...
mysql> exit
shell>

Run those commands and post the full output you get here.

[marcolefo]

@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)

[marcolefo]

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]

@marcolefo I am sorry I’ve lost track of this with just to many other things on my list. Great to hear you got this solved by cleaning the DB and re-running the installer. About the hanging partclone: How many clients are involved in this task? Are you absolutely sure all clients booted up to the partclone screen? If only a single one is missing it won’t start.

As well you might need to clear the tasks in the web UI, restart FOGMulticastManager service and try again. If that does not help please take a look at /opt/fog/log/multicast.log and post what you have in there.

[marcolefo]

@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

[Sebastian Roth]

@marcolefo Ok, thanks for letting us know. Marking this solved now. If you have issues again, just let us know.