Fog Upgrade (Backing up database.. Failed!)

[Raymond Bell]

I am getting (Backing up database… Failed!) during the upgrade process.
I was able to backup the database with Web Interface before i started the upgrade process.
Now i have now web interface at all

(Backing up database....................................................... Failed!)

[Sebastian Roth]

@Raymond-Bell Which version of FOG did you use before and which version are you updating to? As well, which Linux OS and version do you use?

[Raymond Bell]

@sebastian-roth Not going to lie i think 1.5.7 maybe if that sounds right.
and using xubuntu

[Sebastian Roth]

@Raymond-Bell Again, which version you want to update to and which version of Xubuntu?

Please also post the last 10 lines of the installer error log here.

[Raymond Bell]

@sebastian-roth Upgrade to = At revision 6078.
xubuntu version is 16.04.6 LTS
I am running version 1.5.7
I restored the Server from backup to get interface back up
Trying to upgrade to 1.5.9

[Sebastian Roth]

@Raymond-Bell The step “Backing up database” only works when Apache, PHP-FPM and MySQL are up and running fine. Not sure what caused the problem without actually looking at the full installer error log.

You can try running the installer without stopping at errors: ./installfog.sh -X

See if you can make it finish like that. Though 16.04 is really kind of old and I can’t promise you the installer will be still able to handle this.

[Raymond Bell]

@sebastian-roth Ok so i went another route this time and upgrade storage nodes with no issues but the Server i am getting this error now
I have used BLANK password and i have tried password
I am able to login to mysql with password as the password and backup DB

 * Stopping FOGImageSize.service Service.......................OK
 * Setting up and starting MySQL...............................OK
 * Setting up MySQL user and database..........................
   To improve the overall security the installer will create an
   unpriviledged database user account for FOG's database access.
   Please provide the database *root* user password. Be asured
   that this password will only be used while the FOG installer
   is running and won't be stored anywhere:

   Unable to connect to the database using the given password!
   Try again:
   Failed! Terminating installer now.
root@Fog-Server-15:/home/fog/Downloads/fog_1.5.9/bin# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.7.33-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[Raymond Bell]

@sebastian-roth UPDATE
I ran 1.4.4 installer
then ran 1.5.5 installer
then ran 1.5.9 installer
and everything worked fine this time it asked me to set a password for MySql this time