Mysql after do-release-upgrade



  • 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)
    

  • Developer

    @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).



  • @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) ?


  • Developer

    @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


Log in to reply
 

348
Online

6.4k
Users

13.8k
Topics

130.3k
Posts