Upload Image From HDD 500GB to SSD 120GB

[george1421]

@Gilberto-Ferraz said in Upload Image From HDD 500GB to SSD 120GB:

@Sebastian-Roth Hello, thanks for the help!
I am afraid to upgrade to version 1.5.7 I am afraid of losing access to the images and inventoried hosts.

Do I get all this after the upgrade?

Unless you do something really bad, upgrading will only extend the sql database schema and not replace any of its contents. So upgrading will not loose any data or images on your fog server. The upgrade process does not touch anything in your /images directory either. While anything is possible historically we have not seen any such loss. If you are at all concerned make sure you have a backup or snapshot of the FOG server so you can restore it.

[Gilberto Ferraz]

@george1421 hello!
I upgraded to fog 1.5.7 on my ubuntu 18.08.3 LTS.

Now I have problems with Maria DB “Database connection unavailable”

could you help me?

[george1421]

@Gilberto-Ferraz Well, that isn’t what I wanted to hear. We had another thread just a few days ago where the mssql server went away.

Lets start with

sudo systemctl restart mariadb

If no luck then lets see whats the status is

sudo systemctl status maridb

[Gilberto Ferraz]

@george1421 said in Upload Image From HDD 500GB to SSD 120GB:

sudo systemctl status maridb

bart2018@bart2018fog:~$ sudo systemctl restart mariadb
Failed to restart mariadb.service: Unit mariadb.service not found.
bart2018@bart2018fog:~$ sudo systemctl status maridb
Unit maridb.service could not be found.
bart2018@bart2018fog:~$

is that mariadb is no longer on my server

[george1421]

@Gilberto-Ferraz I’m not a ubuntu admin but what does sudo apt-get install mariadb give you?

@Developers would the fog 1.5.7 log list if the database was uninstalled for any reason?

[Gilberto Ferraz]

@george1421 I can’t even install it I’m using OS ubuntu 18.08.3 LTS.

[george1421]

@Gilberto-Ferraz then try sudo apt-get install mysql

I do find it very strange that the database service would be installed by the fog installer. Something unexpected must be going on with ubuntu.

[Gilberto Ferraz]

@george1421 It is very strange I do not know what happened also does not let install mysql. I try to install version 1.5.7 again?

[Tom Elliott]

@george1421 What OS is this being installed from?

I’m fairly sure 18.04 and newer have mariadb available.

[Tom Elliott]

On Ubuntu 18.04 it’s mariadb-server I think

[Gilberto Ferraz]

@Tom-Elliott I thought so too, but the update turned out not to work well I try to install fog 1.5.7 again ??

[george1421]

@Gilberto-Ferraz So if you follow Tom’s lead does sudo apt-get install mariadb-server work better.

Secondly, I feel I need to apologies since the upgrade should have worked no problem. I have no idea that ubuntu would break.

[Gilberto Ferraz]

@george1421 said in [Upload Image From HDD 500GB to SSD 120GB]

when i try to reinstall fog 1.5.7 again give me this error when installing mariadb-client and mariadb-server package.

[george1421]

@Gilberto-Ferraz so again, if you run sudo apt-get install mariadb-server (now that we know the package name) what does apt-get tell you?

[Sebastian Roth]

@Gilberto-Ferraz Too bad I have been away for a couple of hours and did not know the Linux OS you have. If I’d known I would have warned you.

There is a known issue when upgrading to 1.5.7 on Ubuntu!! If you say yes when the installer asks if it should re-install Apache/PHP it will also try to force a migration from mysql to mariadb and fails.

Here are the steps to manually roll back to MySQL that will still have all your FOG information:

sudo -i
mv /var/lib/mysql /var/lib/mysql-mariadb
apt-get remove mariadb-client mariadb-server
cp -a /var/lib/mysql-5.7 /var/lib/mysql
apt-get install mysql-client mysql-server
systemctl start mysql

For more detailed infos read:
https://forums.fogproject.org/topic/13492/fog-1-5-7-update-database-issue
https://forums.fogproject.org/topic/13703/missing-data-after-fog-1-5-7-upgrade
https://forums.fogproject.org/topic/13447/lost-database

[Gilberto Ferraz]

@Sebastian-Roth

Thanks a lot for the help. I’m already weekend. But then I test your solution. I’m glad to hear that the problem was not mine but ubuntu 18.04 You will try to recover the system and install new centos.

[Sebastian Roth]

@Gilberto-Ferraz said in Upload Image From HDD 500GB to SSD 120GB:

will try to recover the system and install new centos.

First make sure you get this all back to running on Ubuntu. Don’t try to move to CentOS in a rush. There are more things that can go wrong when moving to a new Linux OS.