1.3.0-RC-13 Can't import Hosts

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

[Wayne Workman]

@FlareImp Are you sure you’re on rc-14? What does the cloud say in the top left of the web gui?

Also, can you please run the following two commands to completely clean out the fog web directory and then immediately re-run the rc-14 installer please - and then try again?
rm -rf /var/www/fog
rm -rf /var/www/html/fog
Then re-run installer.

[FlareImp]

The cloud says:
Tue Oct 18, 2016 15:25 pm
Running Version 1.3.0-RC-14
SVN Revision: 5974

I will give those commands a try in the next hour and let you know the outcome.

[FlareImp]

I ran the two commands and then ran the installer. Afterwards I rebooted the server and then tried to import the hosts again with the same result.

Total Rows 0
Successful Hosts 0
Failed Hosts 0
Errors

[Wayne Workman]

@Tom-Elliott The import was working in RC-11.

I have confirmed that the import file that @FlareImp supplied me imported successfully in this commit:

https://github.com/FOGProject/fogproject/commit/d6cff6cfc2272cbde7764217292715129fc8c2a6

And that the issue became present in this commit:

https://github.com/FOGProject/fogproject/commit/3c916866f0f8ddc93c7f54edcf2eb48675606a90

And the issue remained present in RC-12, RC-13, RC-14, and the present working-RC-15 branch.

His CSV file is just two columns of data that are not quoted at all, just separated by a comma. First column is a MAC address, the second column is hostname.

I’ve replicated the format with my computers here at home for you to test with, here it is:
0_1476832244270_host_export.csv

[Tom Elliott]

Added better checking and allowing csv’s to contain equal to field count or less than from the csv.

[Wayne Workman]

@Tom-Elliott I just tried working-RC-15 version 51, its not importing the file I made, nor the file that @FlareImp gave me.

[Tom Elliott]

Sorry had flipped check. I meant to check if the comma fields was greater than what was expected, but was checking that the comma fields was less than or equal to.

This is fixed for sure now.

[Wayne Workman]

Confirmed fixed in rc-15.

@FlareImp you can either wait for RC-15 to be released, or you can message me for instructions on getting rc-15 before release - which may or may not be ideal at the moment, but I can confirm that this particular problem is resolved.