Mysql after do-release-upgrade

[jmeyer]

Hello,

it seems that mysql have been remove after a do-release-upgrade between Ubuntu 16.04.6 LTS and Ubuntu 18.04.3 LTS.

On GUI, I have : Database connection unavailable

With SSH, I have :

root@fogserver:~/fogproject/bin# mysql -u root
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

During FOG reinstall :

* Installing package: mariadb-client..........................Failed! (Will try later)
* Installing package: mariadb-server..........................Failed! (Will try later)

[Sebastian Roth]

@jmeyer said:

it seems that mysql have been remove after a do-release-upgrade between Ubuntu 16.04.6 LTS and Ubuntu 18.04.3 LTS.

While it might seem like it’s lost I don’t think it’s entirely gone. Even Ubuntu wouldn’t just delete all your database files.

Probably this will help: https://forums.fogproject.org/topic/13492/fog-1-5-7-update-database-issue

Run ls -al /var/lib/mysql* and post output here.

During FOG reinstall :

• Installing package: mariadb-client

You have read the important notice here: https://forums.fogproject.org/topic/13488/fog-1-5-7-officially-released

[jmeyer]

@Sebastian-Roth As I was running a VM, i have restore snapshot and restart the process.
First, i updated last GIT version then do the OS upgrade.
SQL hasn’t been touch this way and everything works fine.

Could FOG install tried to install mariadb over mysql since I was under version 18.04 or is there a check of running SQL server type (if it’s mysql or mariadb) ?

[Sebastian Roth]

@jmeyer There is no real check. At the moment we install mariadb on fresh installs but stick to mysql on upgrades (which is set in /opt/fog/.fogsettings) because Ubuntu does not properly migrate your database from mysql to mariadb yet (while Debian has long ago).