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
Failed!
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) -
@IHCRCDan Which Linux OS so you use? Probably you did a system upgrade moving to a new major version of the database and it did not so all the steps needed. Usually this kind of issue can be fixed using the command
mysql_upgrade -u root -p --forceand entering the DB root password. Restart the DB or your while server after this to make sure it loads the fixed tables. For more information search the web for the error “The table is probably corrupted” -
We are on Ubuntu 18.04. I will give the MYSQL command a go and see what happens.
-
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."
-
@ihcrcdan said in MYSQL Problem during Upgrade:
Performed the update you suggested and it did help, but I got a different error at the same point now.
Should have asked you to copy and paste the output you got from the mysql_upgrade command. This new error suggests the tables were not fully fixed. Please run the same mysql_upgrade command again (copy&paste the output here).
Did you restart the server as I asked to do?
-
@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.