Hostname Change on 700+ Workstations

[anthony.delarosa]

@Wayne-Workman thank you! I think the easiest is the host export and import! i will test with that and see how it goes. Thank you everyone!

[anthony.delarosa]

Update:

I tried exporting and importing and upon importing i get Total Rows, Hosts with a 0

Am I doing something wrong? file is the same

[anthony.delarosa]

so used a different version of Excel and now I get this error:

Not sure what tit means by Row #0: 'cause the Excel file starts at Row 1

[Tom Elliott]

@anthony.delarosa Did you remove all the hosts first?

[anthony.delarosa]

@Tom-Elliott hey Tom, remove them? sorry I wasn’t aware of this, I need to go in there and delete all the hosts and then import it again? All I did was export, modify and import the hosts and I keep getting this Row#0 error

[Tom Elliott]

Right.

You’re exporting to chagne the names.

Then you remove all the hosts are you changing. Reimport.

Essentially what you’re importing is failing because it already exists.

[anthony.delarosa]

@Tom-Elliott ah ok, so i export, make the changes to the 10x (example) hosts, remove all the other ones and re-import that file with 10x hosts? k let me try

[Tom Elliott]

@anthony.delarosa Only remove the hosts you need to change from FOG.

[anthony.delarosa]

@Tom-Elliott hey Tom, thanks for that! it worked but after the import the PC (test PC) won’t change it’s hostname automatically. I mean FOG shows the new given name: van-wsz440-147 but the computer Windows 8.1 still has the old name vanprodz440-147 and it’s not rebooting automatically.

FOG log file shows:

---

--------------------------------Authentication--------------------------------

2017-04-20 2:30 PM Client-Info Version: 0.11.9
2017-04-20 2:30 PM Client-Info OS: Windows
2017-04-20 2:30 PM Middleware::Authentication Waiting for authentication timeout to pass
2017-04-20 2:32 PM Middleware::Communication Download: http://192.168.170.128/fog/management/other/ssl/srvpublic.crt
2017-04-20 2:32 PM Data::RSA FOG Server CA cert found
2017-04-20 2:32 PM Middleware::Authentication Cert OK
2017-04-20 2:32 PM Middleware::Communication POST URL: http://192.168.170.128/fog/management/index.php?sub=requestClientInfo&authorize&newService
2017-04-20 2:32 PM Middleware::Response Invalid security token

[anthony.delarosa]

this is what the Hostname Changer shows:

---

--------------------------------HostnameChanger-------------------------------

2017-04-20 2:41 PM Client-Info Client Version: 0.11.9
2017-04-20 2:41 PM Client-Info Client OS: Windows
2017-04-20 2:41 PM Client-Info Server Version: 1.3.4
2017-04-20 2:41 PM Middleware::Response ERROR: Unable to get subsection
2017-04-20 2:41 PM Middleware::Response ERROR: Object reference not set to an instance of an object.

[Tom Elliott]

@anthony.delarosa said in Hostname Change on 700+ Workstations:

2017-04-20 2:32 PM Middleware::Response Invalid security token

2017-04-20 2:32 PM Middleware::Response Invalid security token

Please go to the hosts you reimported to edit, and click the “Reset encryption data” button for them.

[anthony.delarosa]

@Tom-Elliott that’s why you’re the creator and i’m just some guy breaking stuff lol ^_^ thanks Tom! with this I’ll be able to complete it by assigning them to a group

[anthony.delarosa]

@Tom-Elliott by the way, any snap-in that would detect what OU the computer is in and be able to put it back into that same OU after import? it’s a lot to ask but why not lol

[Tom Elliott]

@anthony.delarosa I’m sure it could be done, but I don’t think anyone has set one up yet.

That said, you can use the FOG Client to join a host to a domain, including the OU.

[george1421]

@anthony.delarosa said in Hostname Change on 700+ Workstations:

@Tom-Elliott by the way, any snap-in that would detect what OU the computer is in and be able to put it back into that same OU after import?

We will have to ask @Joe-Schmitt for confirmation, but a system rename shouldn’t remove the host from AD to rename it. It should just rename it and leave it where the system was in AD/OU. I can understand (re)connecting the target computer to AD may change its OU.

You could also do this with a VBScript or powershell script to rename the system. I’ve done this before with vbscript.

[Joe Schmitt]

@george1421 the problem is likely that he is deleting hosts and then importing them (I’m not sure if a CSV export stores this information). This is why I advised directly modifying the SQL database.

[george1421]

@Joe-Schmitt I agree that modifying the database directly is probably the best solution. But my question was around the mechanics of the fog client. The host rename function doesn’t touch/deal with AD does it? Its only a host rename??

[Wayne Workman]

I can assist with a script to do this - if we think it’s valuable. But I don’t think it’s really valuable to the community - what is wanted here is an edge case.

@Joe-Schmitt I know. I just gave the way that anyone could do without scripting.

[george1421]

@george1421 Here is a rough outline of what needs to be done on the database side. Understand you do this at your own risk. I’m only suggesting one way to go about it.

This concept uses a temporary table to hold both the old name and new names. Then we will export the hostid and existing host name to this temp table. This will build the structure of what we need. The mysqldump command will export the temp table with all of the data into a text file. You will have to tweak this file to insert the new names into the dump file. Next we will import that dump file back into mysql and then finally run an update command to replace the existing host name with the updated host name.

mysql -u root

USE fog;

CREATE TABLE hostname_fixup (
    hostID int,
    hostName varchar(16),
    newhostName varchar(16)
);

INSERT INTO hostname_fixup (hostID,hostName)
  SELECT hostID,hostName FROM hosts;

EXIT;

Export the fixup table
mysqldump -u root fog hostname_fixup > hname_fixup.sql

fixup the new host names in the dump file

remove any windows nonsense with dos2unix command

Import the database back into the fog server
mysql -u root fog < hname_fixup.sql

Login to mysql
mysql -u root

USE fog;

UPDATE hosts
       JOIN hostname_fixup
       ON hosts.hostID = hostname_fixup.hostID
SET    hosts.hostName = hostname_fixup.newhostName;

DROP TABLE hostname_fixup;

[george1421]

@george1421 Now to the sql dump file.

This is the business end of the dump file.

LOCK TABLES `hostname_fixup` WRITE;
/*!40000 ALTER TABLE `hostname_fixup` DISABLE KEYS */;
INSERT INTO `hostname_fixup` VALUES (1,'b8ca3ace1d1a',NULL),(4,'joebob',NULL),(3,'0800275f0038',NULL),(5,'tomcat',NULL);
/*!40000 ALTER TABLE `hostname_fixup` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

The key in this the data line.

INSERT INTO `hostname_fixup` VALUES (1,'b8ca3ace1d1a',NULL),(4,'joebob',NULL),(3,'0800275f0038',NULL),(5,'tomcat',NULL);

the VALUES is the data from the table we exported.

How I would go about this is to use notepad++ to clean up the data a bit and then import into excel. Match up the new and old names. Then export back to a text file and finally regroup into this data structure. You can change the format a bit to support the export from excel.

LOCK TABLES `hostname_fixup` WRITE;
/*!40000 ALTER TABLE `hostname_fixup` DISABLE KEYS */;
INSERT INTO `hostname_fixup` VALUES 
(1,'b8ca3ace1d1a',NULL),
(4,'joebob',NULL),
(3,'0800275f0038',NULL),
(5,'tomcat',NULL);
/*!40000 ALTER TABLE `hostname_fixup` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;