Upgrade to 1.5.9 failure

[ariederer26]

I have had a working fog system running on Ubuntu 16.04 for quite some time. I began to upgrade to 1.5.9
It fails at setting up the MySQL user and database. It asks for the database root user password. I can’t remember what this would be. This was setup so long ago.
Anyway the installer fails at this point because it can’t connect to the database.
I am also unable to get back to using my 1.5.6 that was previously working.
What am I missing here?

[Sebastian Roth]

@ariederer26 Probably best to reset the database root password first to be able to go ahead and more important, take a full backup of the database!

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password (skip the parts/commands on mariadb)

Some people report that the directory containing the socket file might be missing after initially stopping mysqld. In that case you would see a connection error when trying to access the DB. Run sudo mkdir -p /var/run/mysqld just before the command sudo mysql_safe ... from the tutorial to work around this.

In case you still get a connection error, check out this topic: https://stackoverflow.com/a/41987711

Now before you go ahead I highly recommend you backup the database and possibly all your image files as well!!

As well I might suggest you use these backups to setup a complete new FOG server instead of updating it. Why? Because Ubuntu 16.04 is many years old and EOL! Setting up a new FOG server on a fresh clean install and recovering the backup will be much quicker than trying to update FOG on such an old system.

[ariederer26]

@sebastian-roth Thank you for the quick reply. My intentions are to move this to new hardware. I will also install a newer version of Ubuntu. I’m trying to backup the DB. Not exactly sure how to do this. Along with the image files. I would think I could just transfer the images from the existing hard drive to the new server.