PXI Image menu on new installation

[george1421]

@waveydavey ok I guess if you want to do it that way. I personally wouldn’t do it that way, but what the heck. No guts no glory.

[waveydavey]

@george1421 To be honest, if I could see the export, I would use it. However, needs must when the devil drives, and all that. I cant see any other way available.

[george1421]

@waveydavey I started writting this on the last post but decided to give you just enough rope to…

I guess I was not clear on my suggestion. I’ll go to level 2 since you seem to be familiar with db tables.

1. On the new fog server, go into the images web ui page and export your current image definitions into a csv file. This will give you the expected layout on an import.
2. On your old fog server go in and do a table dump of the images table into a file. If you know the commands you should be able to do a direct export of the images table into a csv file on the fog server. Bring that export to a windows computer.
3. Now with the web ui csv export (to show the csv column format) merge the exported db table with the exported web ui file.
4. Once you have the csv merged, remove the original images you had in the web ui export.
5. On the 1.5.5 FOG server, then import that csv file.

[george1421]

@george1421 To add a bit more information. You could use this query to export the images table into a csv file.

SELECT * FROM images INTO OUTFILE '/tmp/images.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n';

[waveydavey]

@george1421 Giving me rope could be dangerous

Ok, manually entering data with little knowledge did not work - Pxe image menu did not magically contain an extra entry, so I must have missed something.

I will try following your suggestions in some detail, and see what works.

I would like to say that I am very grateful for your generosity in helping me with this - it is very kind of you.

[waveydavey]

@george1421 Yes thanks, I am fine with mysql commands, been doing it for far too many years!

Just as an aside - do you know anything about the imageSize column ?

[george1421]

@waveydavey The imagesize column is for information only. That is(was) populated when an image was uploaded to the fog server. I seem to recall there is now a fog agent that will (on interval) update that field with current values. But again its not used for any operational function inside fog, its only for display.

[waveydavey]

@george1421 Having spoken to a colleague yesterday evening we have come to the (not unsurprising) conclusion that life is too short to do battle with 20 old images that are very unlikely to be used much.
Four images of our most used builds should probably address 95% of our needs, so we will just grab those 4 machines, image them on to the new fog server, and commence from there. It’s really not worth losing sleep and brain cells to take the obscure images any further.

I now need to decide whether to drop the database and reinstall fog, or just delete all test images, and start with an empty set of images.

[waveydavey]

@george1421 Any idea how to mark this post/topic solved ?

[george1421]

@waveydavey Topic Tools->Marked Solved

I took care of that for you.