upgrade to bookworm broke phpmyadmin

Rick Macdonald

unread,

Aug 21, 2023, 10:10:06 PM8/21/23

to

I've been running phpmyadmin for years. It survived the upgrade to bullseye about a month ago but now the upgrade to bookworm broke it.

I don't see any similar bug reports. I do see similar error messages around the web from over the years, but I don't expect to have to do a manual re-install or repair. I removed it and installed again, but the result is the same. My mariadb is accessible from other apps and the "mysql" command line program, so it's up and running. "Composer" as mentioned in the error message isn't something that I have installed.

PHP 8.2.7 is the default version of php.

PHP 7.2.5+ is required.

Currently installed version is: ' . PHP_VERSION . '
'); } // phpcs:disable PSR1.Files.SideEffects define('PHPMYADMIN', true); // phpcs:enable require_once ROOT_PATH . 'libraries/constants.php'; /** * Activate autoloader */ if (! @is_readable(AUTOLOAD_FILE)) { die( '
File ' . AUTOLOAD_FILE . ' missing or not readable.
' . '
Most likely you did not run Composer to ' . '' . 'install library files.
' ); } require AUTOLOAD_FILE; global $route, $containerBuilder, $request; Common::run(); $dispatcher = Routing::getDispatcher(); Routing::callControllerForRoute($request, $route, $dispatcher, $containerBuilder);

I tried reconfigure, but I didn't select the option to "reinstall the database":

# dpkg-reconfigure phpmyadmin
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
dbconfig-common: flushing administrative password
apache2_invoke phpmyadmin: already enabled

Any ideas?

Rick

Michael Kjörling

unread,

Aug 22, 2023, 5:10:08 AM8/22/23

to

On 21 Aug 2023 20:00 -0600, from rick...@shaw.ca (Rick Macdonald):

>> # dpkg-reconfigure phpmyadmin
>> Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
>> dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
>> dbconfig-common: flushing administrative password
>> apache2_invoke phpmyadmin: already enabled

$ dpkg -l php php8.2 phpmyadmin

Which exact version of each respective package is installed?

Also

$ aptitude why php8.2

_IF_ the version of phpmyadmin which Bookworm ships doesn't work with
the version of PHP which Bookworm ships, that's at a minimum a
packaging bug. But that would be an awfully obvious one that a lot
more people should already have run into in that case, so I'm
reluctant to assume that that's the problem. I'm more inclined to
believe that maybe you're somehow running a non-Bookworm version of
phpmyadmin which for whatever reason doesn't work with PHP 8, or for
some reason your installation of phpmyadmin is being run through a
different version of PHP. Buster and Bullseye were both PHP 7.x; which
could help explain why it worked there but not after you upgraded to
Bookworm.

--
Michael Kjörling 🔗 https://michael.kjorling.se
“Remember when, on the Internet, nobody cared that you were a dog?”

Rick Macdonald

unread,

Aug 23, 2023, 1:00:06 PM8/23/23

to

On 8/22/23 03:08, Michael Kjörling wrote:

On 21 Aug 2023 20:00 -0600, from rick...@shaw.ca (Rick Macdonald):

# dpkg-reconfigure phpmyadmin
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
dbconfig-common: flushing administrative password
apache2_invoke phpmyadmin: already enabled

$ dpkg -l php php8.2 phpmyadmin

Which exact version of each respective package is installed?

# dpkg -l php php8.2 phpmyadmin
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version         Architecture Description
+++-==============-===============-============-===========================================================
ii php            2:8.2+93        all          server-side, HTML-embedded scripting language (default)
ii php8.2         8.2.7-1~deb12u1 all          server-side, HTML-embedded scripting language (metapackage)
ii phpmyadmin     4:5.2.1+dfsg-1 all          MySQL web administration tool

Also

$ aptitude why php8.2

# aptitude why php8.2
i   roundcube      Depends roundcube-core (= 1.6.1+dfsg-1)
i A roundcube-core Depends php
i A php            Depends php8.2

I don't use roundcube any more. Would it help to uninstall it? Although, at the moment I have only php5.6 and php8.2 installed. I'm guessing the bookworm upgrade removed php7.x.

_IF_ the version of phpmyadmin which Bookworm ships doesn't work with
the version of PHP which Bookworm ships, that's at a minimum a
packaging bug. But that would be an awfully obvious one that a lot
more people should already have run into in that case, so I'm
reluctant to assume that that's the problem. I'm more inclined to
believe that maybe you're somehow running a non-Bookworm version of
phpmyadmin which for whatever reason doesn't work with PHP 8, or for
some reason your installation of phpmyadmin is being run through a
different version of PHP. Buster and Bullseye were both PHP 7.x; which
could help explain why it worked there but not after you upgraded to
Bookworm.

Package phpmyadmin

buster-backports (web): MySQL web administration tool
4:5.0.4+dfsg2-2~bpo10+1: all
bullseye (oldstable) (web): MySQL web administration tool
4:5.0.4+dfsg2-2+deb11u1: all
bullseye-backports (web): MySQL web administration tool
4:5.2.1+dfsg-1~bpo11+1: all
bookworm (stable) (web): MySQL web administration tool
4:5.2.1+dfsg-1: all
trixie (testing) (web): MySQL web administration tool
4:5.2.1+dfsg-1: all
sid (unstable) (web): MySQL web administration tool
4:5.2.1+dfsg-1: all

Rick

Michael Kjörling

unread,

Aug 23, 2023, 1:10:06 PM8/23/23

to

On 23 Aug 2023 10:52 -0600, from rick...@shaw.ca (Rick Macdonald):

> # dpkg -l php php8.2 phpmyadmin
> Desired=Unknown/Install/Remove/Purge/Hold
> |
> Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
> |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
> ||/ Name           Version         Architecture Description
> +++-==============-===============-============-===========================================================
> ii php            2:8.2+93        all          server-side, HTML-embedded scripting language (default)
> ii php8.2         8.2.7-1~deb12u1 all          server-side, HTML-embedded scripting language (metapackage)
> ii phpmyadmin     4:5.2.1+dfsg-1 all          MySQL web administration tool

Looks reasonable to me, showing php and phpmyadmin at the current
Bookworm versions.

> # aptitude why php8.2
> i roundcube Depends roundcube-core (= 1.6.1+dfsg-1)
> i A roundcube-core Depends php
> i A php Depends php8.2

Also looks reasonable. "php8.2" is being pulled in by "php" which, as
you also showed above, are both at the current Bookworm versions.

> I don't use roundcube any more. Would it help to uninstall it? Although, at
> the moment I have only php5.6 and php8.2 installed. I'm guessing the
> bookworm upgrade removed php7.x.

I imagine that uninstalling roundcube won't do anything either way.
However, if it was me, unless there was some compelling reason to keep
it I'd consider uninstalling php5.6 and seeing if that helps.

Can't really help you further at this point because I've never
installed phpmyadmin myself; sorry.

Rick Macdonald

unread,

Aug 23, 2023, 6:10:07 PM8/23/23

to

On 8/23/23 11:03, Michael Kjörling wrote:

I don't use roundcube any more. Would it help to uninstall it? Although, at
the moment I have only php5.6 and php8.2 installed. I'm guessing the
bookworm upgrade removed php7.x.

I imagine that uninstalling roundcube won't do anything either way.
However, if it was me, unless there was some compelling reason to keep
it I'd consider uninstalling php5.6 and seeing if that helps.

Can't really help you further at this point because I've never
installed phpmyadmin myself; sorry.

I removed or purged roundecube, squirrelmail, phpmyadmin and every php5* package, then reinstall phpmyadmin. No change.

Silly me though, I see I didn't actually describe the failure when I try to connect to localhost/phpmyadmin. The browser just opens and shows the text of the file /usr/share/phpmyadmin/index.php. Is this a clue?

<?php

declare(strict_types=1);

use PhpMyAdmin\Common;
use PhpMyAdmin\Routing;

if (! defined('ROOT_PATH')) {
    // phpcs:disable PSR1.Files.SideEffects
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
    // phpcs:enable
}

if (PHP_VERSION_ID < 70205) {
    die('<p>PHP 7.2.5+ is required.</p><p>Currently installed version is: ' . PHP_VERSION . '</p>');
}

// phpcs:disable PSR1.Files.SideEffects
define('PHPMYADMIN', true);
// phpcs:enable

require_once ROOT_PATH . 'libraries/constants.php';

/**
 * Activate autoloader
 */
if (! @is_readable(AUTOLOAD_FILE)) {
    die(
        '<p>File <samp>' . AUTOLOAD_FILE . '</samp> missing or not readable.</p>'
        . '<p>Most likely you did not run Composer to '
        . '<a href="https://docs.phpmyadmin.net/en/latest/setup.html#installing-from-git">'
        . 'install library files</a>.</p>'
    );
}

require AUTOLOAD_FILE;

global $route, $containerBuilder, $request;

Common::run();

$dispatcher = Routing::getDispatcher();
Routing::callControllerForRoute($request, $route, $dispatcher, $containerBuilder);

Rick