mysql -u root fog
Thank you very much, I was able to go in and clear the images table from the mysql DB.
I am just going to come out and say it, I goofed up. But, I am trying to figure out how I can resolve the problem I created.
I have a fresh Fog 1.3.5 server that I wanted to upload an image file to create all the images for my hosts.
I already uploaded all my hosts with their MAC addresses without issue, I wanted to do the same with the images and link them, that way I don’t have to create and link an image file manually 1 at a time for the 100+ hosts I have.
So first, I exported the images to CSV to get the “format” of the template. Then I filled in the blanks.
However, this is where I goofed up, I deleted the settings and left them blank. Settings that identified the storage group, OS, Partition, Image Type, etc. I know, I am kicking myself for it. Please don’t scrutinize me, I already see my BIG error.
It did successfully import the images, however, when I go to view the images on the web GUI, they are not listed, if I try to create a new image manually using the same image name, it fails because that name already exists.
If I FTP into Fog and view the images directory, they do not show there either.
I really don’t want to have to wipe and reload Fog. So, is there a way to clear the images I goofed up importing? Is there another directory other than images they could be? Cache? Config? Anything? Or do I need to start over?
Any help is appreciated.