FOG 1.5.0 RC2 Cannot Delete Image From Storage Node/Group
-
Sebastian,
Tracking message sequence in this website isn’t straight forward. I didn’t see this message before I posted my last with all the screenshots, nor did I see it before I attempted to add test items to my system and see if I could at least manage new items (Host, Storage Node, Storage Group and Location).
Adding these items seems to have completely messed up my installation of FOG. Please see my message to Tom for details.
Thanks,
Jim -
@Jim-Graczyk said:
add test items to my system and see if I could at least manage new items (Host, Storage Node, Storage Group and Location).
Adding these items seems to have completely messed up my installation of FOG. Please see my message to Tom for details.
What do you mean by messed up? The screenshots you posted look as if you are not able to remove a storage group assoc from an image (as we already know). What else do you think is messed up? Things can be cleaned up in most cases I think.
Did you check in the mysql db using the query I posted?
-
My next test was to add new objects to the existing FOG configuration to see if I could get the results others are getting with object created in this version of FOG.
I did the following:
- Created a new location
- Created a new storage group
- Created a new Host (fake MAC)
- Created a new storage node (non-existant IP address). I think I put the new storage node in the new storage groups, but not sure due to problem described next.
When I hit add on the storage node, I got the storage node added, I got the message Storage Node Added, but then the web UI failed to respond from that point on. The server was fine and not showing a lot of load, but the UI just sat there (for several minutes). I rebooted the server and was able to logon to FOG. the dashboard came up - minus the storage node graphic - and then failed to respond.
I have disconnected the server from the network, rebooted it and attempted to connect to the fog website via localhost, but I get no response. FOG wed UI may not be bound to the local host IP.
I’m at a loss. It’s Sunday and I’m off tomorrow, but have people who need FOG up and working tomorrow morning.
My only choice may be to restore my FOG server 1.4.2 - as it was configured and working before I attempted to upgrade to 1.4.4 and ended up with 1.5.0 RC2 via my system backups and leave it there for now. If I don’t hear from anyone on this, I’ll assume I need to uninstall FOG from my storage nodes and reinstall 1.4.2.
Jim
-
Can you take the location plugin out of question for the moment?
-
Doing so now. And FYI - I had uninstalled the Locations Plugin and reinstalled it this morning - before I ran into problems. I was AFK some and will be again in 45 mins. I hope Sebastian was able to record what he and I did today over WebEx. I don’t know that I can provide sufficient detail to assist you. I haven’t seen any posts from him since we concluded the WebEx.
One thing I did want to tell :
I have a FOG and 2 Storage Node Servers. I have 3 Locations defined and 3 storage groups with one FOG server in each site and storage group. If I shut down one of my Storage Nodes or Make a new storage node, when I click on the storage icon in the UI, the UI goes unresponsive for about 5 mintues. Start the node back up and it the Storage icon response time is about 10 seconds.
Once I have locations plugin uninstalled, I’ll attempt to disassociate an image from a storage node and report back.
Jim
-
@Tom-Elliott Location Plugin is uninstalled but still cannot disassociate an image from a storage group.
Jim
-
@Jim-Graczyk Can you get a backup of your sql and send it to me via email (hit me in chat to send me email please)?
I would like to take a look at the actual DB, and see what/why things are going funky here. I suspect some sort of strangeness left in the DB. That or the DB user isn’t allowed to modify that portion of the database? I’m just speculating. Hopefully the config file would tell me more.
-
@Tom-Elliott I remoted in with Jim the other day. Though we could not fix this issue I might add some information here.
The
imageGroupAssoclooked alright (didn’t check all the others). Using the web UI we were able to add a storage group assoc to an image (one that only had two so far). But we were not able to remove this assoc or any other in his setup using the web UI. As Jim reported removing the location plugin didn’t fix it either. As well I tested with location plugin but still can’t replicate the issue. Hopefully you can find something in the DB dump!Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)
Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG
-
@Sebastian-Roth If I were a guessing guy, the user used to “manage” fog at the DB level is allowed to “create/update” but not allowed to DELETE. (just a guess, and the db dump probably wouldn’t be able to tell me this or not.
-
Sebastian, I know we delete records when we were looking at the install here over the weekend. Would any of the deletes we did apply to what Tom’s talking about?
Jim
-
@Jim-Graczyk As far as I remember we only did SQL queries but did not try to delete… should have. Please contact me in chat so we can try…
-
Definitely not a mysql ACL/permission issue as we were able to delete entries from that table by hand. Tom got a dump now and seems to have found what is causing this. He’s working on a fix.
-
Fix is now in the
workingbranch. I accidentally pushed into thedev-branchas well, so you could just do a pull from dev-branch and reinstall and revel in the success. (Hopefully). -
@Tom-Elliott Update Worked! Location plugin was installed when the update was made. Was able to disassociate several images from several storage groups.
We can consider this resolved.
Thanks.
Jim -
@tom-elliott I’ve got the same exact problem happening as @Jim-Graczyk and I’ll try to be more descriptive.
I have an image stored on a storage group “3r” but when I select the image and view its Storage Group two groups are listed “2r” and “3r” with a radio button check mark beside 3r, which I take to mean primary although there is no header text for that column so it’s not clear what that check is for. The available options include check boxes beside Storage Group name and beside each listed node, in this case 2r and 3r, and an Update primary group “Update” button and a Remove selected groups “Remove” button.
I’ve confirmed that the image does exist in both images folders on both nodes 2r and 3r but I only want it to occupy 3r, the image’s primary storage group. When I directly remove the image by deleting it from the 2r images folder it gets copied back, thereby suggesting an accurately reflected status on the Image Management/Storage Group page. When I select the checkbox beside 2r and click the Remove button an Image Update Success “Image Updated” popup appears but 2r never disappears from the list even after refreshing or navigating away and back again and the image still gets copied back to 2r if deleted directly.
Each node is set as a Master Node with its own Storage Group; node2r:group2r and node3r:group3r
I actually have this occurring with several images but not all, most images are fine being listed in only one storage group and existing in the one images folder. It appears something is gummed up with the database records that the GUI cannot correct.
Additionally, but a separate problem is, I have images in the database listed in 2r that are really in 3r and vise versa and I wish I could just change the reference via the GUI.
-
@mjaskowski Would you care to share a copy of your database with me so I can figure out what the issue is? Don’t post it here, PM me.
