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:

    
     
    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
    
    

    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:

    mysql -u root [ -p'MYSQLPASSWORD IF SET' #ONLY ENTER THIS IF YOU SET A PASSWORD ] fog
    delete from hosts WHERE hostID='0';
    

    Then re-register the host.


Log in to reply
 

496
Online

38926
Users

10692
Topics

101460
Posts

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