• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Multicast error : Get Fog Host data

Scheduled Pinned Locked Moved Solved
FOG Problems
2
11
1.6k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    marcolefo
    last edited by Nov 27, 2017, 2:30 PM

    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

    FOG : 1.5.10.1655
    OS : Debian GNU/Linux 12

    1 Reply Last reply Reply Quote 0
    • M
      marcolefo
      last edited by marcolefo Nov 27, 2017, 8:33 AM Nov 27, 2017, 2:33 PM

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

      FOG : 1.5.10.1655
      OS : Debian GNU/Linux 12

      1 Reply Last reply Reply Quote 0
      • M
        marcolefo
        last edited by Dec 4, 2017, 10:43 AM

        Hi.

        No idea ?

        Thanks for your help.

        FOG : 1.5.10.1655
        OS : Debian GNU/Linux 12

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Dec 4, 2017, 3:42 PM

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

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          M 1 Reply Last reply Dec 4, 2017, 4:26 PM Reply Quote 0
          • M
            marcolefo @Sebastian Roth
            last edited by marcolefo Dec 4, 2017, 10:27 AM Dec 4, 2017, 4:26 PM

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

            FOG : 1.5.10.1655
            OS : Debian GNU/Linux 12

            1 Reply Last reply Reply Quote 1
            • S
              Sebastian Roth Moderator
              last edited by Dec 4, 2017, 8:49 PM

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

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              M 1 Reply Last reply Dec 5, 2017, 8:43 AM Reply Quote 0
              • M
                marcolefo @Sebastian Roth
                last edited by Sebastian Roth Dec 5, 2017, 3:17 AM Dec 5, 2017, 8:43 AM

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

                FOG : 1.5.10.1655
                OS : Debian GNU/Linux 12

                M 1 Reply Last reply Dec 13, 2017, 6:21 PM Reply Quote 0
                • M
                  marcolefo @marcolefo
                  last edited by Dec 13, 2017, 6:21 PM

                  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 partclonetext alternatif

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

                  Thanks

                  FOG : 1.5.10.1655
                  OS : Debian GNU/Linux 12

                  1 Reply Last reply Reply Quote 0
                  • S
                    Sebastian Roth Moderator
                    last edited by Dec 13, 2017, 9:39 PM

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

                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                    M 1 Reply Last reply Dec 14, 2017, 10:14 AM Reply Quote 0
                    • M
                      marcolefo @Sebastian Roth
                      last edited by Dec 14, 2017, 10:14 AM

                      @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

                      FOG : 1.5.10.1655
                      OS : Debian GNU/Linux 12

                      1 Reply Last reply Reply Quote 0
                      • S
                        Sebastian Roth Moderator
                        last edited by Dec 14, 2017, 1:27 PM

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

                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post

                        197

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project