Question Info about deleting some PSA package

[masaro]

Hello people,

i am currently having a dependency deadlock that i am trying to resolve with aptitute, and in order to do that it is suggesting a removal of several plesk specific packages

sudo aptitude remove mysql-server-8.0

The following packages will be REMOVED: 
  galera-4{u} mariadb-common{u} mecab-ipadic{u} mecab-ipadic-utf8{u}
  mecab-utils{u} mysql-server-8.0
The following partially installed packages will be configured:
  mariadb-server{b}
0 packages upgraded, 0 newly installed, 6 to remove and 7 not upgraded.
Need to get 0 B of archives. After unpacking 124 MB will be freed.
The following packages have unmet dependencies:
 dbconfig-mysql : Depends: default-mysql-client but it is not going to be installed or
                           virtual-mysql-client which is a virtual package, provided by:
                           - mariadb-client-10.4 (1:10.4.13+maria~focal), but it is not going to be installed
                           - mariadb-client-10.4 (1:10.4.14+maria~focal), but it is not going to be installed
                           - mysql-client-8.0 (8.0.21-0ubuntu0.20.04.4), but it is not going to be installed
                           - mariadb-client-10.3 (1:10.3.22-1ubuntu1), but it is not going to be installed
                           - mysql-client-8.0 (8.0.19-0ubuntu5), but it is not going to be installed

 mariadb-server : Depends: mariadb-server-10.4 (>= 1:10.4.14+maria~focal) but it is not going to be installed
The following actions will resolve these dependencies:


      Remove the following packages:                                             
1)      libpam-plesk [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]         
2)      mariadb-server [1:10.4.14+maria~focal (<NULL>, now)]                     
3)      plesk-backup-utilities [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]
4)      plesk-completion [18.0-v.ubuntu.20.04+p18.0.30.0+t200904.1146 (now)]     
5)      plesk-config-troubleshooter [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (
6)      plesk-core [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]           
7)      plesk-core-utilities [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)] 
8)      plesk-dovecot [2.3.10.1-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]     
9)      plesk-dovecot-imap-driver [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (no
10)     plesk-dovecot-pigeonhole [0.5.10-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (n
11)     plesk-git-http [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.0942 (now)]       
12)     plesk-kav-configurator [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]
13)     plesk-l10n [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]           
14)     plesk-mail-pc-driver [18.0-v.ubuntu.20.04+p18.0.30.0+t200911.1552 (now)] 
15)     plesk-modsecurity-configurator [18.0-v.ubuntu.20.04+p18.0.31.0+t200915.152
16)     plesk-mysql-server [18.0-v.ubuntu.18.04+p18.0.20.0+t191009.1747 (now)]   
17)     plesk-repair-kit [18.0-v.ubuntu.20.04+p18.0.30.0+t200910.1355 (now)]     
18)     plesk-resctrl [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]         
19)     plesk-roundcube [1.4.8-v.ubuntu.18.04+p18.0.30.0+t200826.1456 (now)]     
20)     plesk-service-node-utilities [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312
21)     plesk-web-hosting [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1545 (now)]     
22)     plesk-web-socket [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]     
23)     pp17.8.11-bootstrapper [17.8.11-ubuntu18.04.build1708191024.16 (now)]     
24)     pp18.0.20-bootstrapper [18.0-v.ubuntu.18.04+p18.0.20.2+t191101.1317 (now)]
25)     pp18.0.21-bootstrapper [18.0-v.ubuntu.18.04+p18.0.21.5+t191219.2005 (now)]
26)     pp18.0.23-bootstrapper [18.0-v.ubuntu.18.04+p18.0.23.4+t200206.1432 (now)]
27)     pp18.0.24-bootstrapper [18.0-v.ubuntu.18.04+p18.0.24.0+t200207.1734 (now)]
28)     pp18.0.25-bootstrapper [18.0-v.ubuntu.18.04+p18.0.25.2+t200325.1928 (now)]
29)     pp18.0.26-bootstrapper [18.0-v.ubuntu.18.04+p18.0.26.0+t200410.1427 (now)]
30)     pp18.0.27-bootstrapper [18.0-v.ubuntu.18.04+p18.0.27.1+t200522.1215 (now)]
31)     pp18.0.29-bootstrapper [18.0-v.ubuntu.18.04+p18.0.29.3+t200825.2156 (now)]
32)     pp18.0.30-bootstrapper [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]
33)     psa [18.0.30-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]               
34)     psa-firewall [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]         
35)     psa-horde [5.2.23-v.ubuntu.20.04+p18.0.30.0+t200826.1545 (now)]           
36)     psa-imp [6.2.24.1-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]           
37)     psa-ingo [3.2.16-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]           
38)     psa-kronolith [4.2.29-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]       
39)     psa-libxml-proxy [2.9.7-v.ubuntu.20.04+p18.0.29.0+t200703.1727 (now)]     
40)     psa-locale-base-en-us [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]
41)     psa-logrotate [3.8.2-v.ubuntu.20.04+p18.0.29.0+t200703.1727 (now)]       
42)     psa-mail-driver-common [18.0-v.ubuntu.20.04+p18.0.30.1+t200918.1312 (now)]
43)     psa-mnemo [4.2.14-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]           
44)     psa-passwd [5.0.7-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]           
45)     psa-php-configurator [1.8.0-v.ubuntu.20.04+p18.0.30.0+t200826.1545 (now)]
46)     psa-phpmyadmin [5.0.2-v.ubuntu.18.04+p18.0.30.0+t200828.1138 (now)]       
47)     psa-proftpd [1.3.6c-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]         
48)     psa-spamassassin [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]     
49)     psa-turba [4.2.25-v.ubuntu.20.04+p18.0.30.0+t200826.1456 (now)]           
50)     psa-updates [18.0-v.ubuntu.20.04+p18.0.29.0+t200703.1727 (now)]           
51)     psa-vhost [18.0-v.ubuntu.20.04+p18.0.30.0+t200826.1545 (now)]             
52)     psa-watchdog [18.0-v.ubuntu.18.04+p18.0.30.1+t200918.1312 (now)]         

      Install the following packages:                                             
53)     mysql-client-8.0 [8.0.21-0ubuntu0.20.04.4 (focal-security, focal-updates)]
54)     mysql-client-core-8.0 [8.0.21-0ubuntu0.20.04.4 (focal-security, focal-upda

I would like a suggestion because i was wondering if doing that and running plesk installer right after would recover all deleted packages, and of course avoid data loss (websites and db).

Thanks

 

[IgorG]

I would like a suggestion because i was wondering if doing that and running plesk installer right after would recover all deleted packages, and of course avoid data loss (websites and db).

In fact, it is a bad idea to delete MySQL server on a live and running Plesk server. Moreover, MySQL 8 is not supported by Plesk yet.
Do I understand correctly that you only have one MySQL server on your Plesk server and you want to remove it? Do you want to downgrade MySQL to a supported version?
This is not a trivial task and requires delicate manual work. Therefore, I would advise you to contact Plesk Support Team.

 

[masaro]

I would like to fix the issue either having Mysql (even a prior version like 5.7) or Mariadb, it doesn't matter too much. The problem is that at the moment i can't do anything because every time i try to reinstall or remove/install any of them (or any package in general) i keep ending in a dependance issue i don't know how to fix

sudo apt-get upgrade


Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
dbconfig-mysql : Depends: default-mysql-client or
virtual-mysql-client
mariadb-server : Depends: mariadb-server-10.4 (>= 1:10.4.14+maria~focal) but it is not installed
mysql-server-8.0 : Depends: mysql-client-8.0 (>= 8.0.21-0ubuntu0.20.04.4) but it is not installed
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).

apt --fix-broken install

Preconfiguring packages ...
dpkg: mysql-server-8.0: dependency problems, but removing anyway as you requested:
 plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:
  Package mariadb-server is not configured yet.
  Package virtual-mysql-server is not installed.
  Package mysql-server-8.0 which provides virtual-mysql-server is to be removed.
  Package mysql-server-5.7 which provides virtual-mysql-server is not installed.
  Package mariadb-server-10.3 which provides virtual-mysql-server is not installed
.
 plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:
  Package mariadb-server is not configured yet.
  Package virtual-mysql-server is not installed.
  Package mysql-server-8.0 which provides virtual-mysql-server is to be removed.
  Package mysql-server-5.7 which provides virtual-mysql-server is not installed.
  Package mariadb-server-10.3 which provides virtual-mysql-server is not installed
.
 plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:
  Package mariadb-server is not configured yet.
  Package virtual-mysql-server is not installed.
  Package mysql-server-8.0 which provides virtual-mysql-server is to be removed.
  Package mysql-server-5.7 which provides virtual-mysql-server is not installed.
  Package mariadb-server-10.3 which provides virtual-mysql-server is not installed
.
 plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:
  Package mariadb-server is not configured yet.
  Package virtual-mysql-server is not installed.
  Package mysql-server-8.0 which provides virtual-mysql-server is to be removed.
  Package mysql-server-5.7 which provides virtual-mysql-server is not installed.
  Package mariadb-server-10.3 which provides virtual-mysql-server is not installed
.


dpkg: error processing package mysql-server-8.0 (--remove):
 package is in a very bad inconsistent state; you should
 reinstall it before attempting a removal
dpkg: too many errors, stopping
Errors were encountered while processing:
 mysql-server-8.0
Processing was halted because there were too many errors.
E: Sub-process /usr/bin/dpkg returned an error code (1)

sudo apt-get --reinstall install mysql-server-8.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
dbconfig-mysql : Depends: default-mysql-client or
virtual-mysql-client
mariadb-server : Depends: mariadb-server-10.4 (>= 1:10.4.14+maria~focal) but it is not going to be installed
mysql-server-8.0 : Depends: mysql-client-8.0 (>= 8.0.21-0ubuntu0.20.04.4) but it is not going to be installed
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).