Package: phpmyadmin
Version: 4:5.0.4+dfsg2-2
Severity: important
Tags: l10n
Dear Maintainer,
A rather important component of phpmyadmin is the ability to change and set
privileges on tables and columns.
This feature if brokon on a current default install of phpmyadmin when used
with a default install of MariaDB
on Debian 11/Testing.
Clicking on the "privileges" tab reders the following error:
#1267 - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and
(utf8mb4_unicode_ci,COERCIBLE) for operation '<>'
The database installation is completely default. No changes have been made to
default collations after the installation
of mariadb-server.
Reproduction involves installing, logging in, and clicking. Namely from a
vanilla Debian 11 (testing) environment...
- Install and configure your web server of choice with tls (lighttpd in my
case)
- Install mariadb-server and phpmyadmin with all required dependencies
- Work around the current phpmyadmin bugs with respect to php-cgi-cfm if using
lighttpd
(Bugs #979380 and #979421)
- Add a mariadb login user to use with phpmyadmin
- Log in to phpmyadmin, click on any database and then the "privileges" tab.
-- System Information:
Debian Release: bullseye/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 5.10.0-5-amd64 (SMP w/2 CPU threads)
Kernel taint flags: TAINT_CPU_OUT_OF_SPEC
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages phpmyadmin depends on:
ii dbconfig-common 2.0.19
ii dbconfig-mysql 2.0.19
ii debconf [debconf-2.0] 1.5.75
ii libjs-bootstrap4 4.5.2+dfsg1-6
ii libjs-codemirror 5.59.2+~cs0.23.109-1
ii libjs-jquery 3.5.1+dfsg+~3.5.5-7
ii libjs-jquery-mousewheel 1:3.1.13-2
ii libjs-jquery-timepicker 1.6.3-1
ii libjs-jquery-ui 1.12.1+dfsg-8
ii libjs-openlayers 2.13.1+ds2-8
ii libjs-sphinxdoc 3.4.3-2
ii php-cli 2:7.4+76
ii php-common 2:76
ii php-google-recaptcha 1.2.4-3
ii php-mariadb-mysql-kbs 1.2.12-1
ii php-mbstring 2:7.4+76
ii php-mysql 2:7.4+76
ii php-phpmyadmin-motranslator 5.2.0-1
ii php-phpmyadmin-shapefile 2.1-5
ii php-phpmyadmin-sql-parser 5.4.1-1
ii php-phpseclib 2.0.30-1
ii php-symfony-config 4.4.19+dfsg-1
ii php-symfony-dependency-injection 4.4.19+dfsg-1
ii php-symfony-expression-language 4.4.19+dfsg-1
ii php-symfony-yaml 4.4.19+dfsg-1
ii php-twig 2.14.3-1
ii php-twig-i18n-extension 3.0.0-2
ii php-xml 2:7.4+76
ii php7.4-cli [php-cli] 7.4.15-5+deb11u1
ii php7.4-json [php-json] 7.4.15-5+deb11u1
ii php7.4-mbstring [php-mbstring] 7.4.15-5+deb11u1
ii php7.4-xml [php-xml] 7.4.15-5+deb11u1
ii sensible-utils 0.0.14
ii ucf 3.0043
Versions of packages phpmyadmin recommends:
ii lighttpd [httpd] 1.4.59-1
ii php-bz2 2:7.4+76
ii php-curl 2:7.4+76
ii php-gd 2:7.4+76
ii php-tcpdf 6.3.5+dfsg1-1
ii php-zip 2:7.4+76
ii php7.4-bz2 [php-bz2] 7.4.15-5+deb11u1
ii php7.4-curl [php-curl] 7.4.15-5+deb11u1
ii php7.4-gd [php-gd] 7.4.15-5+deb11u1
ii php7.4-zip [php-zip] 7.4.15-5+deb11u1
Versions of packages phpmyadmin suggests:
ii mariadb-server-10.5 [virtual-mysql-server] 1:10.5.9-1
pn php-gd2 <none>
pn php-pragmarx-google2fa-qrcode <none>
pn php-recode <none>
pn php-samyoul-u2f-php-server <none>
ii php7.4-opcache [php-opcache] 7.4.15-5+deb11u1
pn www-browser <none>
-- Configuration Files:
/etc/phpmyadmin/lighttpd.conf changed:
alias.url += (
"/phpmyadmin" => "/usr/share/phpmyadmin",
)
$HTTP["url"] =~ "^/phpmyadmin/" {
$HTTP["remoteip"] !~ "^(127.0.0.1)$" {
url.redirect-code=404
url.redirect = ( ".*" => "http://va1der.ca"; )
#url.access-deny = ( "" )
}
}
-- debconf information:
phpmyadmin/remote/host: localhost
* phpmyadmin/reconfigure-webserver: lighttpd
phpmyadmin/db/dbname: phpmyadmin
* phpmyadmin/dbconfig-install: true
phpmyadmin/internal/reconfiguring: false
phpmyadmin/remove-error: abort
phpmyadmin/upgrade-backup: true
phpmyadmin/install-error: abort
phpmyadmin/upgrade-error: abort
phpmyadmin/missing-db-package-error: abort
phpmyadmin/remote/newhost:
phpmyadmin/dbconfig-upgrade: true
* phpmyadmin/mysql/admin-user: root
phpmyadmin/dbconfig-reinstall: false
phpmyadmin/mysql/authplugin: default
phpmyadmin/passwords-do-not-match:
phpmyadmin/mysql/method: Unix socket
phpmyadmin/internal/skip-preseed: false
phpmyadmin/db/app-user: phpmyadmin@localhost
phpmyadmin/dbconfig-remove: true
phpmyadmin/database-type: mysql
phpmyadmin/remote/port:
phpmyadmin/purge: false
