Fog failed to update due to mysql-client package

[Nono]

On a ubuntu server, I fail to update FOG from 1.5.10.1798 to 1.5.10.1870 :

before the update:

$ dpkg -l | grep mysql-client
ii  mysql-client                           8.0.46-0ubuntu0.22.04.2                          all          MySQL database client (metapackage depending on the latest version)
ii  mysql-client-8.0                       8.0.46-0ubuntu0.22.04.2                          amd64        MySQL database client binaries
ii  mysql-client-core-8.0                  8.0.46-0ubuntu0.22.04.2                          amd64        MySQL database core client binaries

then:

$ sudo ./installfog.sh
[...]
 * Checking package: liblzma-dev...............................OK
 * Checking package: m4........................................OK
 * Checking package: mariadb-server............................OK
 * Checking package: mysql-client..............................Failed!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!! The installer was not able to run all the way to the end as   !!
!! something has caused it to fail. The following few lines are  !!
!! from the error log file which might help us figure out what's !!
!! wrong. Please add this information when reporting an error.   !!
!! As well you might want to take a look at the full error log   !!
!! in /tmp/fogproject-1.5.10.1870/bin/error_logs/fog_error_1.5.10.1870.log !!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ii  libc6:amd64    2.35-0ubuntu3.13 amd64        GNU C Library: Shared libraries
ii  liblzma-dev:amd64 5.2.5-2ubuntu1 amd64        XZ-format compression library - development files
ii  m4             1.4.18-5ubuntu2 amd64        macro processing language
ii  mariadb-server 1:10.6.23-0ubuntu0.22.04.1 all          MariaDB database server (metapackage depending on the latest version)
dpkg-query: no packages found matching mysql-client

and if I check the packages:

$ dpkg -l | grep mysql-client

It’s not there anymore.

[Nono]

Okay, I found the culprit.
I still had listed on the /opt/fog/.fogsettings

mysql-client mysql-server

on the packages list, instead of

mariadb-client mariadb-server

This came from a migration from another server.

[Tom Elliott]

@Nono Edit your /opt/fog/.fogsettings file and replace entries of ‘mysql-client’ with ‘mariadb-client’

I suspect they’ve updated the repo to solely exist for mariadb-client, but you had it before that package switch/change occurred so your fogsettings file is just expecting mysql-client always.

I might also recommend removing the existing mysql-client package just to ensure clean flow, though of course get a backup before any such actions.