Hangs before image upload (not during)

Alasdair Hatfield

Hello,

I am suffering a similar but different problem to the previous thread. Here, I don’t get as far as starting the upload.
As it is probably a different problem, I started a new thread.

System is:
openSuSe 13.1
FOG 1.1.1
MariaDB 5.5.33

I am trying to do a registration and image upload from the client.

What works (or at least appears to) -
registration of a host via the web interface
registration of a host from the host itself

in both cases I can see a host entry in the web interface list of all hosts.

What doesn’t work -
upload of image using web interface

I get a red error that I should associate an image and haven’t yet cracked how to do this but that is for another tread
registration and upload of an image from the client - this is where I am busy at the moment

I get to answer the questions about host name and image etc. When I answer ‘y’ to the question if I want to upload an image, it then seems to hang, just echoing line feeds.
I am tracking the DB accesses and this repeatedly gets requested to the database:

[CODE]

140709 14:24:44 131 Connect root@localhost as anonymous on
131 Init DB fog
131 Query SELECT vValue FROM schemaVersion LIMIT 1
131 Query SELECT * FROM plugins WHERE pName = ‘capone’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘capone’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘example’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘example’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM globalSettings WHERE settingKey = ‘FOG_PLUGINSYS_ENABLED’ ORDER BY settingKey ASC
131 Query SELECT * FROM modules ORDER BY name ASC
131 Query SELECT * FROM hosts WHERE hostMAC = ‘48:5b:39:7f:32:4a’ ORDER BY hostName ASC
131 Query SELECT * FROM hostMAC WHERE hmMAC = ‘48:5b:39:7f:32:4a’ ORDER BY hmID ASC
131 Query SELECT * FROM modules WHERE id=‘4’
131 Query SELECT * FROM modules WHERE id=‘7’
131 Query SELECT * FROM modules WHERE id=‘1’
131 Query SELECT * FROM modules WHERE id=‘3’
131 Query SELECT * FROM modules WHERE id=‘5’
131 Query SELECT * FROM modules WHERE id=‘8’
131 Query SELECT * FROM modules WHERE id=‘9’
131 Query SELECT * FROM modules WHERE id=‘10’
131 Query SELECT * FROM modules WHERE id=‘6’
131 Query SELECT * FROM modules WHERE id=‘11’
131 Query SELECT * FROM modules WHERE id=‘2’
131 Query SELECT * FROM modules WHERE id=‘12’
131 Query INSERT INTO hosts (hostName, hostDesc, hostCreateDate, hostCreateBy, hostMAC) VALUES (‘qwe’, ‘Created by FOG Reg on July 9, 2014, 12:24 pm’, ‘2014-07-09 12:24:44’, ‘FOGREG’, ‘48:5b:39:7f:32:4a’) ON DUPLICATE KEY UPDATE hostID = ‘’, hostName = ‘qwe’, hostDesc = ‘Created by FOG Reg on July 9, 2014, 12:24 pm’, hostIP = ‘’, hostImage = ‘’, hostBuilding = ‘’, hostLastDeploy = ‘’, hostMAC = ‘48:5b:39:7f:32:4a’, hostUseAD = ‘’, hostADDomain = ‘’, hostADOU = ‘’, hostADUser = ‘’, hostADPass = ‘’, hostPrinterLevel = ‘’, hostKernel = ‘’, hostKernelArgs = ‘’, hostDevice = ‘’, hostID = LAST_INSERT_ID(hostID)
131 Query SELECT * FROM moduleStatusByHost WHERE msHostID = ‘0’ ORDER BY msID ASC
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘4’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘4’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘7’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘7’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘1’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘1’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘3’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘3’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘5’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘5’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘8’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘8’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘9’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘9’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘10’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘10’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘6’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘6’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘11’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘11’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘2’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘2’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘12’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘12’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO groupMembers (``) VALUES (‘’) ON DUPLICATE KEY UPDATE gmID = ‘’, gmHostID = ‘0’, gmGroupID = ‘’, gmID = LAST_INSERT_ID(gmID)
131 Query SELECT * FROM plugins WHERE pName = ‘location’ ORDER BY pName ASC
131 Quit
[/CODE]

This pops up each time the host adds a line feed.
My guess is that the database is throwing errors for some reason but I can’t see where.
The database access could be a red herring and the problem might be somewhere else.

Database configuration is that STRICT is off as this being on threw other problems during the installation.

Any ideas or suggestions as to where I should look are appreciated.

Alasdair

Tom Elliott

When you register the system, the “Do you want to image the system now?” is not referring to uploading an image. It’s referring to “Downloading” the image to the client.

Also, update to 1.1.2 as there was a bug with 1.1.1 where registering the host and assigning the image id did not work properly.

You’ll likely need to delete the hosts as they most likely got created with hostID=‘0’ which is in valid.

From terminal you can do this:
[code]mysql -u root [ -p’MYSQLPASSWORD IF SET’ #ONLY ENTER THIS IF YOU SET A PASSWORD ] fog
delete from hosts WHERE hostID=‘0’;[/code]

Then re-register the host.

Hangs before image upload (not during)

202

12.1k

17.3k

155.3k