Upload Image From HDD 500GB to SSD 120GB

[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.