Hangs before image upload (not during)



  • 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


  • Senior Developer

    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.


Log in to reply
 

412
Online

39.3k
Users

11.0k
Topics

104.6k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.