Unable to connect to MariaDB 11.3

[mvorisek]

Description

Docker GH service:

    services:
      mysql:
        image: mysql:8
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=5 -e MYSQL_ROOT_PASSWORD=atk4_pass_root -e MYSQL_USER=atk4_test_user -e MYSQL_PASSWORD=atk4_pass -e MYSQL_DATABASE=atk4_test
      mariadb:
        image: mariadb:11.2.3
        options: --health-cmd="mariadb-admin ping" --health-interval=10s --health-timeout=5s --health-retries=5 -e MYSQL_ROOT_PASSWORD=atk4_pass_root -e MYSQL_USER=atk4_test_user -e MYSQL_PASSWORD=atk4_pass -e MYSQL_DATABASE=atk4_test

php -r '(new PDO("mysql:host=mysql", "root", "atk4_pass_root"))->exec("ALTER USER '"'"'atk4_test_user'"'"'@'"'"'%'"'"' WITH MAX_USER_CONNECTIONS 5");'

passes, but with MariaDB:

php -r '(new PDO("mysql:host=mariadb", "root", "atk4_pass_root"))->exec("ALTER USER '"'"'atk4_test_user'"'"'@'"'"'%'"'"' WITH MAX_USER_CONNECTIONS 5");

it fails with the following error:

PDOException: SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers in Command line code:1
Stack trace:
#0 Command line code(1): PDO->__construct('mysql:host=mari...', 'root', 'atk4_pass_root')
#1 {main}
  thrown in Command line code on line 1

With MariaDB 11.2, the PHP is working perfectly.

I am not sure if this is MariaDB or PHP error, but I would expect at least a better error message.

full repro: #13452 (comment)

PHP Version

any

Operating System

any

[SakiTakamachi]

At least, it does not reproduce with the master php built on my ubuntu.
Did you use the php distributed with Alpine? Or did you build it yourself on Alpine?

[mvorisek]

Official PHP base image and mysqli and pdo_mysql installed using https://github.com/mlocati/docker-php-extension-installer.

[SakiTakamachi]

Can you provide repro code without dependencies?
At least, I was not able to reproduce it using the code you provided.

[AirBair]

Run into the same issue and found more context/examples here : MariaDB/mariadb-docker#560

[SakiTakamachi]

@AirBair
Thank you! The URL you provided means that this problem is on the MariaDB side. (I was initially worried that mysqlnd might be showing spurious errors)

This is not a PHP issue, so I Close it. Thank you!

[mvorisek]

Here is a full repro: https://github.com/atk4/data/blob/576cc2d2df48ac88ad45c5c3b5b4f8758fab0981/.github/workflows/test-unit.yml:

name: Unit

on:
  push:

jobs:
  unit-test:
    name: Unit
    runs-on: ubuntu-latest
    container:
      image: php:8.3
    services:
      mysql:
        image: mysql:8
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=5 -e MYSQL_ROOT_PASSWORD=atk4_pass_root -e MYSQL_USER=atk4_test_user -e MYSQL_PASSWORD=atk4_pass -e MYSQL_DATABASE=atk4_test
      mariadb:
        image: mariadb
        options: --health-cmd="mariadb-admin ping" --health-interval=10s --health-timeout=5s --health-retries=5 -e MYSQL_ROOT_PASSWORD=atk4_pass_root -e MYSQL_USER=atk4_test_user -e MYSQL_PASSWORD=atk4_pass -e MYSQL_DATABASE=atk4_test
    steps:
      - name: Show PHP version
        run: |
          php --version

      - name: Install pdo_mysql
        run: |
          curl -sSLf -o /usr/local/bin/install-php-extensions https://github.com/mlocati/docker-php-extension-installer/releases/latest/download/install-php-extensions
          chmod +x /usr/local/bin/install-php-extensions
          install-php-extensions pdo_mysql

      - name: Init MySQL
        run: |
          php -r '(new PDO("mysql:host=mysql", "root", "atk4_pass_root"))->exec("ALTER USER '"'"'atk4_test_user'"'"'@'"'"'%'"'"' WITH MAX_USER_CONNECTIONS 5");'
      - name: Init MariaDB
        run: |
          php -r '(new PDO("mysql:host=mariadb", "root", "atk4_pass_root"))->exec("ALTER USER '"'"'atk4_test_user'"'"'@'"'"'%'"'"' WITH MAX_USER_CONNECTIONS 5");'

I am not sure if the issue should be closed, as any other cli client can connect to MariaDB, so maybe the php mysqli native driver needs some tweaks even if this breakage was introduced from MariaDB server side.

[LinuxJedi]

Hi, I'm from the MariaDB Foundation.

This could actually be seen as a bug in mysqlnd because it is using behaviour that went away in MySQL 4.1, 20 years ago.

For reference:

php-src/ext/mysqlnd/mysqlnd_commands.c

Line 619 in 642e111

mnd_sprintf(&msg, 0, "Server sent charset (%d) unknown to the client. Please, report to the developers", greet_packet.charset_no);

The server sends 0 in the server default collation byte of the initial handshake packet for collations that are above 1..255 range.

But actually the connector is mainly interested in the character set, not the collation.

In MySQL-4.0 the client received the collation ID in the initial handshake packet from the server and set its own localization specific variables accordingly, to make things like strcasemp() work like on the server side.

Since MySQL-4.1 (which was released in ~2003) it works the other way around: the client sends its desired character set to the server. This collation ID in the handshake packet does not mean anything useful. It was preserved only for 4.0 client compatibility.

We are planning on working around this on the server side by downgrading the collation ID for legacy behaviour (https://jira.mariadb.org/browse/MDEV-32975). But the real fix should also be done in the PHP connector - it should not read this collation ID at all.

[nielsdos]

Thanks for the clarification. This would indeed need a proper fix at PHP's side then.