@ihcrcdan We eventually got it resolved. We had to remove 3 columns from the mysql.user table. Once that was done, I was able to update the password and the installer was able to complete. Just took us a while to find that information.
Best posts made by IHCRCDan
Latest posts made by IHCRCDan
RE: MYSQL Problem during Upgrade
Performed the update you suggested and it did help, but I got a different error at the same point now.
mysqladmin: unable to change password; error: 'Column count of mysql.user is wrong. expected 46, found 48. The table is probably corrupted."
MYSQL Problem during Upgrade
I am trying to upgrade to the latest stable version of FOG. I have downloaded the tarball and am running the installer. When it gets to setting the root password for MYSQL, it is failing with the message
The installer was not able to run all the way to the end as something has caused it to fail. The following few lines are from the error log file which might help us figure out what’s wrong. Please add this information when reporting an error. As well you might want to take a look at the full error log in /root/fogproject-1.5.9/bin/error_logs/fog_error_1.5.9.log.
msqladmin: [Warning] Using a password on the command line interface can be insecure. Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety. mysqladmin: Unable to change password; error: " ‘Cannot load from mysql.user. The table is probably corrupted’
mysql: [Warning] Using a password on the command line interface can be insucre.
Error 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
RE: Attempting to check in failed : No Open Slots, There are 0 Before Me
@Sebastian-Roth you are correct. We do only have one server. You are pointing in the correct direction, as we had a maximum number of 10 clients selected and we had a number of tasks “stuck” in the storage activity group, even though they are no long in the task list. We have like 4 queued and 10 active. I was able to change the limit to 20 and now it is working fine. What I can’t figure out is how to remove the stuck queued and active tasks that are no longer valid.
Attempting to check in failed : No Open Slots, There are 0 Before Me
OS: Ubuntu 18.04
Starting in the middle of last week, when we try to capture an image or deploy an image, the process starts okay, but right after the status message:
We begin getting the following two errors in sequence:
Attempting to check in…Failed
No open slots, There are 0 before me. (In line for XX). The count begins at 0 or null, and then about every 10 seconds the count goes up by 5.
The clients and the server have been rebooted multiple times. The OS on the server and the version of FOG needed to both be updated, which have both been completed. I have found a couple of posts on this issue (https://forums.fogproject.org/topic/10169/storage-node-no-open-slots-there-are-0-before-me/3 and one that told me to make sure the WEB ROOT was set to /fog/), and neither one has been successful in resolving the issue.
We did not make any changes to the system or our network when this started to occur.
Any help would be appreciated.