Multicast error : Get Fog Host data



  • 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 Error
    

    In /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 97
    

    No problem when deploying on this hosts with unicast method.

    Thanks.
    Marc



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

  • Developer

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



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

  • Developer

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



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

Log in to reply
 

385
Online

39.4k
Users

11.1k
Topics

105.3k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.