1.3.0-RC-13 Can't import Hosts

[Wayne Workman]

I just tested host exporting and importing for the upcoming RC-14, it’s working for me.

If you PM me, I can give you instructions on how to move to the upcoming rc-14 so you can try it and maybe get this work done.

[FlareImp]

Doing the process you gave me did not change anything. It is still not importing hosts.

[Wayne Workman]

@FlareImp Ouch. That means your data is dirty somehow. Run these commands via CLI in MySQL, see if there is any output for any of them:

mysql -D fog

SELECT `hostID`, `hostName` FROM `hosts` WHERE `hostID` = '0';
SELECT * FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
SELECT * FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
SELECT * FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
SELECT * from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 

SELECT * FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`);
SELECT * FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
SELECT * FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
SELECT * FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);

quit

[FlareImp]

They all say “Empty Set”.

[Wayne Workman]

@FlareImp Also, I forgot to ask an important question. What sort of errors are you getting when you try to do your import?

[FlareImp]

@Wayne-Workman its not showing anthing, just flashes the screen and shows

Total Rows 0
Successful Hosts 0
Failed Hosts 0
Errors

[FlareImp]

I just wanted to give you an update. I ended up getting a copy of 1.3.0 RC11 and installing it. I was able to import my host list correctly now but now my clients are not changing their host names or adding to the domain. I copied all the settings from another fog server running the same software version and it works on that system. any ideas? Thanks!

[Wayne Workman]

@FlareImp I should have mentioned this earlier but I was too focused on your problem. When you move away from an old fog server to a new fog server, you now need to move the ssl folder too. Without this, all existing FOG Clients in the environment will distrust the new fog server and simply ignore it - because it didn’t authenticate as genuine. Also, you might think about if you installed the FOG Client using an IP or using a FQDN, because that can impact you moving to a new server too.

Here’s instructions on moving the old ssl folder to the new server:
https://wiki.fogproject.org/wiki/index.php?title=FOG_Client#Maintain_Control_Of_Hosts_When_Building_New_Server

In that same article, you’ll find lots of other information.

Also, anytime you ever have an issue with the FOG Client, ever - post the log. It’s here: C:\fog.log

[FlareImp]

@Wayne-Workman Well I completely reinstalled Ubuntu 16.04 and then installed Fog 1.3.0 RC11, imported my hosts, and all my clients are using the legacy service pointing to the IP Address of the fog server. would needing to move the SSL folder still apply?

[Wayne Workman]

@FlareImp Not for the legacy client. Please post the log from one of them.

[FlareImp]

@Wayne-Workman Here is the Log from one of the clients, I had to manully change the Host Name and add it to the domain. I changed the server IP and the MAC of the client for security reasons.

9/2/2016 11:38 AM FOG::HostnameChanger General Error Returned:
9/2/2016 11:38 AM FOG::HostnameChanger #!er:No Host Found
9/2/2016 11:38 AM FOG::HostnameChanger Host name was not found in the database.
9/2/2016 11:38 AM FOG::UserCleanup Starting user cleanup process…
9/2/2016 11:38 AM FOG::UserCleanup Attempting to connect to fog server…
9/2/2016 11:38 AM FOG::UserCleanup General Error Returned:
9/2/2016 11:38 AM FOG::UserCleanup #!er:No Host Found
9/2/2016 11:39 AM FOG::DirCleaner Starting directory cleaning process…
9/2/2016 11:39 AM FOG::DirCleaner Attempting to connect to fog server…
9/2/2016 11:39 AM FOG::DirCleaner Unknown error, module will exit.
9/2/2016 11:39 AM FOG::GreenFog Starting green fog…
9/2/2016 11:39 AM FOG::GreenFog Attempting to connect to fog server…
9/2/2016 11:39 AM FOG::GreenFog General Error Returned:
9/2/2016 11:39 AM FOG::GreenFog #!er:No Host Found
9/2/2016 11:40 AM FOG::MODDebug Reading config settings…
9/2/2016 11:40 AM FOG::MODDebug Reading of config settings passed.
9/2/2016 11:40 AM FOG::MODDebug Starting Core processing…
9/2/2016 11:40 AM FOG::MODDebug Operating System ID: 6
9/2/2016 11:40 AM FOG::MODDebug Operating System Minor: 1
9/2/2016 11:40 AM FOG::MODDebug MAC ID 00:00:00:00:00:00
9/2/2016 11:40 AM FOG::MODDebug MAC POST String: 00:00:00:00:00:00
9/2/2016 11:40 AM FOG::MODDebug A user is currently logged in
9/2/2016 11:40 AM FOG::MODDebug Username: Master\Administrator
9/2/2016 11:40 AM FOG::MODDebug Hostname: Master
9/2/2016 11:40 AM FOG::MODDebug Attempting to open connect to: http://1.1.1.1/fog/service/debug.php
9/2/2016 11:40 AM FOG::MODDebug Server responded with: Hello FOG Client
9/2/2016 11:40 AM FOG::MODDebug Module has finished work and will now exit.
9/2/2016 11:46 AM FOG::SnapinClient Attempting to connect to fog server…
9/2/2016 11:46 AM FOG::SnapinClient General Error Returned:
9/2/2016 11:46 AM FOG::SnapinClient #!er:No Host Found
9/2/2016 11:46 AM FOG::ClientUpdater Attempting to connect to fog server…
9/2/2016 11:46 AM FOG::ClientUpdater Unknown error, module will exit.
9/2/2016 11:46 AM FOG::ClientUpdater Client update will be applied during next service startup.
9/2/2016 11:46 AM FOG::ClientUpdater Client update process complete, exiting…
9/2/2016 11:51 AM FOG::SnapinClient Attempting to connect to fog server…
9/2/2016 11:51 AM FOG::SnapinClient General Error Returned:
9/2/2016 11:51 AM FOG::SnapinClient #!er:No Host Found

[Wayne Workman]

@FlareImp said in 1.3.0-RC-13 Can't import Hosts:

#!er:No Host Found

That’s the issue. Take this host’s MAC and use it to search in the web interface’s Host Management search box. See what comes up.

[Tom Elliott]

@Wayne-Workman Based on the error, I’ll guess nothing comes up.

[Tom Elliott]

Update to RC-14 and importing hosts will be fixed.

[FlareImp]

This post is deleted!

[FlareImp]

This post is deleted!

[Wayne Workman]

@FlareImp I can see the deleted messages, Just to clairify, is your host import working now?

[FlareImp]

I updated to RC-14, tried to import my hosts, its still showing 0 across the board. I then reinstalled Ubuntu, installed Fog RC-14, imported my hosts, 0 were imported.

[Wayne Workman]

@FlareImp I apologize for not looking at the file you sent me. I’m going to do that today. Something has got to be wrong with it.

[FlareImp]

@Wayne-Workman It’s the same file format I have used for my other fog servers. I have even tried using a file from another site that I know works.