• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Hostname already exists

Scheduled Pinned Locked Moved Solved
FOG Problems
1
2
691
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A
    Avaryan
    last edited by Aug 8, 2017, 1:00 PM

    Server
    • FOG Version: 1.4.2
    • OS: Ubuntu 14.04
    Description

    I am replacing a computer lab. I need to give the new desktops the names that the old ones had.

    I’ve done a search and an export, but the hosts aren’t listed.

    1 Reply Last reply Reply Quote 0
    • A
      Avaryan
      last edited by Aug 8, 2017, 1:05 PM

      Nvm. Fixed. Ran the following from the troubleshooting page.
      https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

      DELETE FROM `hosts` WHERE `hostID` = '0';
      DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
      DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
      DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
      DELETE from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0';
      DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC` WHERE `hmPrimary` = '1');
      DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`);
      DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
      DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
      DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);
      DELETE FROM `tasks` WHERE `taskStateID` IN ("1","2","3");
      DELETE FROM `snapinTasks` WHERE `stState` in ("1","2","3");
      
      1 Reply Last reply Reply Quote 1
      • 1 / 1
      1 / 1
      • First post
        1/2
        Last post

      212

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project