Posts made by Maorui2k

Here is the output, seems no hostID=0 record. I de-registered and re-registered, same error message. I also reinstalled the Ubuntu & fog server, the result is same.

mysql> select * from 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 |
+--------+--------------+--------------------------------------------------+--------+-----------+--------------+---------------------+---------------------+--------------+-----------+--------------+----------+------------+------------+------------------+----------------+------------------+----------------+------------+------------+----------+-------------+------------+--------------+---------------------+--------------+--------------+-------------+-------------+
|      1 | 00e04c6939cd | Created by FOG Reg on December 13, 2016, 5:00 am |        |         0 |            0 | 2016-12-13 05:00:40 | 0000-00-00 00:00:00 | fog          |           |              |          |            |            |                  |                |                  |                |            |            |          |             |            |              | 0000-00-00 00:00:00 |              |              |             |             |
+--------+--------------+--------------------------------------------------+--------+-----------+--------------+---------------------+---------------------+--------------+-----------+--------------+----------+------------+------------+------------------+----------------+------------------+----------------+------------+------------+----------+-------------+------------+--------------+---------------------+--------------+--------------+-------------+-------------+
1 row in set (0.00 sec)

mysql> 
mysql> DELETE FROM `hosts` WHERE `hostID` = '0';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`);
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

I meant to register a host to fog… I tried again, same result, but syslog had no error messages.

I can find the host in management GUI, but except MAC address, all other fields are empty, not sure if this is right.

Server

• FOG Version: 1.3.0-RC30
• OS: Ubuntu 16.04

Client

• Service Version: Not installed yet
• OS: Windows 7 Pro

Description

I tried to register the node via iPXE, but failed at the last moment.

The node’s screen showed few lines of “Attempting to send inventory…failed” and “Rebooting system as task is completed”. And then the node just hung there.

The server syslog has following lines:
Dec 9 17:00:46 relay FOGPingHosts[11744]: PHP Fatal error: Uncaught Error: Cannot unset string offsets in /var/www/fog/lib/service/pinghosts.class.php:180
Dec 9 17:00:46 relay FOGPingHosts[11744]: Stack trace:
Dec 9 17:00:46 relay FOGPingHosts[11744]: #0 /var/www/fog/lib/service/pinghosts.class.php(209): PingHosts->_commonOutput()
Dec 9 17:00:46 relay FOGPingHosts[11744]: #1 /opt/fog/service/FOGPingHosts/FOGPingHosts(34): PingHosts->serviceRun()
Dec 9 17:00:46 relay FOGPingHosts[11744]: #2 {main}
Dec 9 17:00:46 relay FOGPingHosts[11744]: thrown in /var/www/fog/lib/service/pinghosts.class.php on line 180