phpmyadmin: dipende: php-phpmyadmin-sql-parser (<5 ~~) ma 5.4.0-1 deve essere installato

Question

Dopo l'aggiornamento dist della mia Debian, dalla 10.5 alla 10.6 ho questo piccolo problema

Non riesco ad aggiornare questo pacchetto

The following packages have been kept back:
  php-phpmyadmin-sql-parser

Ho pensato di installare ma Debian mi ha chiesto di rimuovere phpmyadmin. e non è una buona idea credo

The following packages will be REMOVED:
  phpmyadmin
The following packages will be upgraded:
  php-phpmyadmin-sql-parser

Poi ho pensato di installare sia phpmyadmin che php-phpmyadmin-sql-parser ma ho un altro stallo

apt install phpmyadmin php-phpmyadmin-sql-parser

Reading package lists... Done
Building dependency tree
Reading state information... Done
phpmyadmin is already the newest version (4:4.9.5+dfsg1-2).
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 phpmyadmin : Depends: php-phpmyadmin-sql-parser (< 5~~) but 5.4.0-1 is to be installed
E: Unable to correct problems, you have held broken packages.

Provai

 dpkg --get-selections | grep hold

Ma non mi dà risultati. Uscita zero

Quindi ho provato a usare aptitude, ma aptitude mi ha chiesto di rimuovere phpmyadmin

# aptitude install php-phpmyadmin-sql-parser
The following packages will be upgraded:
  php-phpmyadmin-sql-parser
1 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 78.4 kB of archives. After unpacking 12.3 kB will be used.
The following packages have unmet dependencies:
 phpmyadmin : Depends: php-phpmyadmin-sql-parser (< 5~~) but 5.4.0-1 is to be installed
The following actions will resolve these dependencies:

     Remove the following packages:
1)     phpmyadmin [4:4.9.5+dfsg1-2 (now, unstable)]



Accept this solution? [Y/n/q/?]

Quindi ho rimosso phpmyadmin e php-phpmyadmin-sql-parser, quindi ho provato a reinstallare solo phpmyadmin

# apt install phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 phpmyadmin : Depends: php-phpmyadmin-sql-parser (< 5~~) but 5.4.0-1 is to be installed
              Recommends: php-bz2
              Recommends: php-tcpdf but it is not going to be installed

Quindi ho finito per non essere in grado di installare phpmyadmin

Il mio elenco delle fonti

deb http://mirrors.linode.com/debian buster main
deb-src http://mirrors.linode.com/debian buster main

deb http://mirrors.linode.com/debian-security buster/updates main
deb-src http://mirrors.linode.com/debian-security buster/updates main

deb http://mirrors.linode.com/debian buster-updates main
deb-src http://mirrors.linode.com/debian buster-updates main

E questo è il contenuto di tutti i file .list aggiuntivi in ​​sources.list.d

deb http://ftp.debian.org/debian unstable main contrib

deb https://packages.sury.org/php/ buster main

deb https://dl.yarnpkg.com/debian/ stable main

Cosa posso fare per sbloccare questa situazione?

Soluzioni e soluzioni suggerite

Non posso rimuovere

deb http://ftp.debian.org/debian unstable main contrib

perché la rimozione di questo renderà phpmyadmin non disponibile, nessun candidato da installare

-

Answer 1

Stai phpmyadminriscontrando problemi perché hai il repository instabile configurato e non è installabile lì al momento. phpmyadminnon è disponibile in Debian 10, ma è disponibile e installabile da backport, senza rischiare di aggiornare (parti del) sistema a unstable.

Per correggere la configurazione:

1. rimuovere unstable dall'elenco dei repository

2. aggiungi backport:

   echo deb http://deb.debian.org/debian buster-backports main | sudo tee /etc/apt/sources.list.d/buster-backports.list
   sudo apt update
   

3. installa il backport phpmyadmin:

   sudo apt install -t buster-backports phpmyadmin
   

Probabilmente incontrerai problemi causati da pacchetti che hai finito per installare da unstable; dovrai eseguire il downgrade di quelli manualmente, eseguendo lo stesso apt installcomando di cui sopra, sostituendolo phpmyadmincon i pacchetti che devi eseguire il downgrade (o aggiungendoli al phpmyadmin apt installcomando).