Imported images on new server not showing

[Wayne Workman]

This is a common question, and a common misconception is that simply copying the image files makes them show in the web interface, this isn’t the case.

Image definitions are metadata about the actual image files. This data is stored in the database. The image definitions are what the web interface displays, regardless of what’s on the disk.

What version of FOG is your old server? If it’s 1.2.0 or older, you’re going to need to manually re-create the image definitions. Manually doing it just involves making sure you type the image paths correctly, as they are case sensitive, and selecting the same options as the images had on the old server. If your old server is 1.3.0 Trunk, you can just export the image definitions via the web interface and import into the new server the same way.

[FallingWax]

@Wayne-Workman The old server is trunk 1.3.0 -RC-14 (moving everything to new hardware). I ran export images on the old machine and imported them to the new, but I am still not seeing the images in the GUI on the new machine.

[Wayne Workman]

@FallingWax Oh. Well that’s a problem. If there’s nothing sensitive about your image definitions, you can upload here for us to take a look at the file.

[FallingWax]

@Wayne-Workman [0_1476905657234_image_export.csv](Uploading 100%)

[FallingWax]

@Wayne-Workman I am not sure if that upload worked. Pop up said not enough privileges to perform this action

[Wayne Workman]

@FallingWax I messaged you, top right, the talk bubble.

[FallingWax]

@Wayne-Workman looks like the csv format does not match up to the columns in mysql. If i try to add the .csv in manually its only taking the first row but all of the data is off. I think if i manipulate the csv I can get the images to come through correctly. Can you verify my findings? If so, any chance you know the command to copy the table to csv with headers? I tried SELECT * FROM images ‘OUTPUT FILE \images\test.csv’ but that gave me no result. said 1 row affect but no file was generated and I am sure it wouldn’t have the headers.

[Wayne Workman]

@FallingWax If you’re just wanting to know the field names you can do describe images;

[Tom Elliott]

@FallingWax you say you exported images from an older version, but what is that older version of fog?

[FallingWax]

@Tom-Elliott the old server is on 1.3.0-RC-14 as well. I had just updated prior to moving. Figured it was best to move to move to the same version.

[FallingWax]

@Wayne-Workman I ended up editing the CSV and manually importing it to SQL. I am not sure how the export/import is working but the exported file is missing a number of columns. imageID, imageProtect, imageMagnetUri, imageFormat
Once i added those I was able to import and everything is in the GUI now.

[Tom Elliott]

@FallingWax If it’s missing that many fields, I would like this is what’s causing the issue, though if you exported from 14 and imported into 14, I imagine you are seeing:

imageName,imageDesc,,,,,,,,, or similar.

Like people already said, the image ID is not exported, so that is fine. Data missing (but wrapped by blank comma’s) is fine.

[FallingWax]

@Tom-Elliot that explains why manually importing in to mysql I would need to fix the fields, but not why the initial import did not add to the table. It gave a good confirmation in the GUI after importing as well. I got everything in there now and it sees the images fine so I guess for now all is well. thanks

[Tom Elliott]

i think we need an example file to give you more information.

[FallingWax]

@Tom-Elliott I emailed it to Wayne yesterday.

[Wayne Workman]

@Tom-Elliott I just shared the file with you.