Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication) #560

MyNameIsRatchet · 2024-02-21T07:34:53Z

I'm running mariadb in docker with "latest"-tag. A nextcloud-container accesses the db via docker internal network.
Everything worked fine, but after I pull the latest (dae04d35ddd4ca837c1d330962eab9b5577325d1751e1877203b3fafe67b5daa) mariadb-image, Nextcloud can't connect anymore and mariadb throws the following:
Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'IP' (This connection closed normally without authentication)
When I start the container with the previous image I used before, everything works fine.

Anyone else?

The text was updated successfully, but these errors were encountered:

PhilippHandle · 2024-02-21T08:10:58Z

Yeah and if i want to connect an application to it, i get the error SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers the update killed all my applications.

WAdama · 2024-02-21T08:40:20Z

Can second that:
Message from MariaDB: 2024-02-21 8:03:53 259 [Warning] Aborted connection 259 to db: 'unconnected' user: 'unauthenticated' host: '172.23.0.3' (This connection closed normally without authentication)

Message from Nextcloud: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers in /var/www/html/lib/private/DB/Connection.php:139

Going back to last image solved the problem for the moment.

P.S. Bookstack container seems to have the same problem...

thomase1234 · 2024-02-21T10:07:36Z

I rolled back to 11.2 because none of my applications could connect to the mariadb.

WAdama · 2024-02-21T10:26:10Z

Found out, not all of my containers using MariaDB have this problem:
Bookstack > don't work
Firefox Sync RS > works
Nextcloud > don't work
Paperless-ngx > works

cvicentiu · 2024-02-21T10:26:28Z

We're looking into this right now.

If anyone can provide an easy to reproduce test case, it would help out in diagnosing this.

Relevant info:

The user authentication configuration the server had. (Which authentication plugins)
SHOW CREATE USER (and remove any password hashes from there for privacy)
The client version that was used to connect to the server. Language and version of the connector if it's an application connector.

PhilippHandle · 2024-02-21T10:36:24Z

Here are my configurations, all from a local installation so passwords are dummy
export of show create user:

+---------------------------------------------------------------------------------------------------+
| CREATE USER for root@localhost                                                                    |
+---------------------------------------------------------------------------------------------------+
| CREATE USER `root`@`localhost` IDENTIFIED BY PASSWORD 'HASH' |
+---------------------------------------------------------------------------------------------------+
1 row in set (0.002 sec)

docker settings

it's an php (8.3.2) application connection with doctrine 3.0.0

kimbtech · 2024-02-21T11:08:49Z

I would like to add that the issue does not affect:

Roundcube Mail (Docker-Image roundcube/roundcubemail:latest-apache)
GiTea (Docker-Image gitea/gitea:1)

LinuxJedi · 2024-02-21T11:30:18Z

I believe this is the cause: https://jira.mariadb.org/browse/MDEV-32975

LinuxJedi · 2024-02-21T11:52:25Z

I'm not a Docker expert, so I'm trying to figure a workaround now, but basically the file /etc/mysql/mariadb.conf.d/50-server.cnf has an issue that needs fixing. The line character-set-collations = utf8mb4=uca1400_ai_ci should be changed to:

character-set-collations = utf8mb4_general_ci

I'll see if I can investigate how to do this now, but if anyone has more Docker knowledge than me, please feel free to post it here.

martadinata666 · 2024-02-21T12:11:45Z

assuming if this only charset issue, docker wise can override command part with the charset.

 db:
    image: mariadb:lts
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin 
    environment:
      #- MARIADB_AUTO_UPGRADE=1
      - MARIADB_ROOT_PASSWORD=mariadbnc
      - TZ=Asia/Jakarta
      - MARIADB_DATABASE=nextcloud
      - MARIADB_USER=nextcloud
      - MARIADB_PASSWORD=nextcloud
    volumes:
      - ./db:/var/lib/mysql
    restart: unless-stopped

LinuxJedi · 2024-02-21T12:13:10Z

That looks like it should work, I'm going to set up a test environment here shortly.

PhilippHandle · 2024-02-21T12:14:38Z

assuming if this only charset issue, docker wise can override command part with the charset.

 db:
    image: mariadb:lts
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin 
    environment:
      #- MARIADB_AUTO_UPGRADE=1
      - MARIADB_ROOT_PASSWORD=mariadbnc
      - TZ=Asia/Jakarta
      - MARIADB_DATABASE=nextcloud
      - MARIADB_USER=nextcloud
      - MARIADB_PASSWORD=nextcloud
    volumes:
      - ./db:/var/lib/mysql
    restart: unless-stopped

it works for me!

an3l · 2024-02-21T12:16:56Z

Yes without changes of collations for mariadb:latest :

$ docker exec -it mariadb-1 mariadb -uroot -psecret -e "select @@version; select @@character_set_collations;"
+---------------------------------------+
| @@version                             |
+---------------------------------------+
| 11.3.2-MariaDB-1:11.3.2+maria~ubu2204 |
+---------------------------------------+
+-------------------------------+
| @@character_set_collations    |
+-------------------------------+
| utf8mb4=utf8mb4_uca1400_ai_ci |
+-------------------------------+

I have tested suggested changes for character-set-collations on the latest image, variable is reset, but doesn't work change.

  mariadb-new-collation:
    <<: *common-attributes # aliases
    container_name: mariadb-cont
    command: --character-set-collations=utf8mb4_general_ci

$ docker exec -it mariadb-cont  -uroot -psecret -e "select @@version; set character_set_collations=utf8mb4_general_ci; select @@character_set_collations"
+---------------------------------------+
| @@version                             |
+---------------------------------------+
| 11.3.2-MariaDB-1:11.3.2+maria~ubu2204 |
+---------------------------------------+
ERROR 1231 (42000) at line 1: Variable 'character_set_collations' can't be set to the value of 'utf8mb4_general_ci'

$ docker exec -it mariadb-cont -uroot -psecret -e "select @@version; select @@character_set_collations;"
+---------------------------------------+
| @@version                             |
+---------------------------------------+
| 11.3.2-MariaDB-1:11.3.2+maria~ubu2204 |
+---------------------------------------+
+----------------------------+
| @@character_set_collations |
+----------------------------+
|                            |
+----------------------------+

Same happens for other collation ERROR 1231 (42000) at line 1: Variable 'character_set_collations' can't be set to the value of 'utf8mb4_uca1400_ai_ci'
Same happens on startup - tested with docker compose

mariadb-cont      | 2024-02-21 12:01:38+00:00 [Note] [Entrypoint]: Initializing database files
mariadb-cont      | 2024-02-21 12:01:38 0 [ERROR] Variable 'character_set_collations' can't be set to the value of 'utf8mb4_uca1400_ai_ci'

cvicentiu · 2024-02-21T12:18:02Z

assuming if this only charset issue, docker wise can override command part with the charset.

 db:
    image: mariadb:lts
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin 
    environment:
      #- MARIADB_AUTO_UPGRADE=1
      - MARIADB_ROOT_PASSWORD=mariadbnc
      - TZ=Asia/Jakarta
      - MARIADB_DATABASE=nextcloud
      - MARIADB_USER=nextcloud
      - MARIADB_PASSWORD=nextcloud
    volumes:
      - ./db:/var/lib/mysql
    restart: unless-stopped

it works for me!

Just to be clear: Are you running the :lts MariaDB or the :latest?

PhilippHandle · 2024-02-21T12:19:06Z

the latest version -> 11.3.2

WAdama · 2024-02-21T12:38:01Z

Hi All,
can second this, too...
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin did the trick in my case also.

Both, Netxcloud and Bookstack are running now with 11.3.2. And the other ones, which were not affected, are still running...

SHOzturk-PV · 2024-02-21T12:54:30Z

First of all thank you @LinuxJedi for hitting the nail on the head.

Many of us are here because our nextcloud setups went down and putting the collation into the docker command serves as a workaround for now. Nonetheless I would advise having a glance at the nextcloud documentations for docker compose examples and database config.

The example already gives the following line:
command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW
And the typical use case collation seems to be "utf8mb4_general_ci"
So the following line would probably serve nextcloud users the best:
command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci

stanthewizzard · 2024-02-21T13:13:04Z

command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci

IT works for me

martadinata666 · 2024-02-21T13:16:00Z

So far I can tell, if the database created by latest 11.3.2, then it can't be read/connect mostly "PHP module" I assume. If the database created before latest then force mariadb to use old charset. *cmiiw

Check on dbtest
Database created from :latest no command override

docker exec -it db-test-db-1 mariadb -uroot -ppassword -e "SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;"
+--------------------+---------+-----------------------+
| database           | charset | collation             |
+--------------------+---------+-----------------------+
| information_schema | utf8mb3 | utf8mb3_general_ci    |
| performance_schema | utf8mb3 | utf8mb3_general_ci    |
| mysql              | utf8mb4 | utf8mb4_uca1400_ai_ci |
| dbtest             | utf8mb4 | utf8mb4_uca1400_ai_ci |
| sys                | utf8mb3 | utf8mb3_general_ci    |
+--------------------+---------+-----------------------+

Database created from :latest override command

docker exec -it db-test-db-1 mariadb -uroot -ppassword -e "SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;"
+--------------------+---------+--------------------+
| database           | charset | collation          |
+--------------------+---------+--------------------+
| information_schema | utf8mb3 | utf8mb3_general_ci |
| performance_schema | utf8mb3 | utf8mb3_general_ci |
| mysql              | utf8mb4 | utf8mb4_general_ci |
| dbtest             | utf8mb4 | utf8mb4_general_ci |
| sys                | utf8mb3 | utf8mb3_general_ci |
+--------------------+---------+--------------------+

Database from old version to latest no override

docker exec -it db-test-db-1 mariadb -uroot -ppassword -e "SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;"
+--------------------+---------+--------------------+
| database           | charset | collation          |
+--------------------+---------+--------------------+
| information_schema | utf8mb3 | utf8mb3_general_ci |
| performance_schema | utf8mb3 | utf8mb3_general_ci |
| mysql              | utf8mb4 | utf8mb4_general_ci |
| dbtest             | utf8mb4 | utf8mb4_general_ci |
| sys                | utf8mb3 | utf8mb3_general_ci |
+--------------------+---------+--------------------+

Stay same

docker exec -it db-test-db-1 mariadb -uroot -ppassword -e "SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;"
+--------------------+---------+--------------------+
| database           | charset | collation          |
+--------------------+---------+--------------------+
| information_schema | utf8mb3 | utf8mb3_general_ci |
| performance_schema | utf8mb3 | utf8mb3_general_ci |
| mysql              | utf8mb4 | utf8mb4_general_ci |
| dbtest             | utf8mb4 | utf8mb4_general_ci |
| sys                | utf8mb3 | utf8mb3_general_ci |
+--------------------+---------+--------------------+

SHOzturk-PV · 2024-02-21T13:50:47Z

50-server.cnf commit

It seems the dev wanted to modernize utf8mb4_general_ci to utf8mb4_uca1400_ai_cias as default ~~but made both an executive decision and typo~~ for php reasons.

Ref MariaDB/mariadb-docker#560

LinuxJedi · 2024-02-21T14:22:06Z

50-server.cnf commit

It seems the dev wanted to modernize utf8mb4_general_ci to utf8mb4_uca1400_ai_cias as default but made both an executive decision and typo.

I too thought that it was a typo too, but it is in fact correct (see https://mariadb.com/kb/en/server-system-variables/#character_set_collations). The problem stems from compatibility with the PHP MySQL connector and that default change for our Debian packages (which affects Docker images too).

We already have a patch to fix the compatibility, but it hasn't been merged yet. This patch is now blocker level priority for us. I suspect something will be done on the Docker image as well in the mean time.

agarov · 2024-02-21T15:16:10Z

I encountered the same problem when using this new image with wordpress docker image.

I can connect using the mysql client from one container to the other, but wordpress can't.

Rollbacking to the previous version resolved the problem.

Unfortunately the last latest release broken PHP and nodejs because of a protocol issue. The configuration item character-set-collations added in the default 11.3/11.4 image generated this. Closes: MariaDB/mariadb-docker#560

jcrossbdn · 2024-02-22T03:52:39Z

Can confirm that all my containers running php scripts that connect to mariadb databases using mysqli also have this issue resulting in error "Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'IP' (This connection closed normally without authentication)". Connecting from the command line from inside the container using "mysql -h x -u y -p" did work properly as well as externally using dBeaver.

Adding "command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin" to the docker-compose file on each container has "corrected" the issue.

grooverdan · 2024-02-22T05:04:47Z

Docker hub contains new image as of ~15 mins ago. No work arounds should be required.

hosseinitabar · 2024-02-22T08:51:54Z

Man, we had mardiadb docker from 34 hours ago and we never even realized that this madness went on. Today I wanted to create a database and encountered this error. Kudos to people who solved it that fast. I got the newest version, from 15 minutes ago. I'm just so happy.

LinuxJedi · 2024-02-22T08:54:45Z

We apologise again for the inconvenience, I'm working an internal post-mortem right now (may make public too if there is interest) so that we can learn from it and prevent anything like this happening again for PHP / Docker users.

ckuethe · 2024-02-22T10:18:42Z

I'm working an internal post-mortem right now (may make public too if there is interest) so that we can learn from it ...

I think it's fair to say there would be interest. We're all interested in building more robust systems, right?

stanthewizzard · 2024-02-22T11:19:11Z

I keep the commabd even with the new version :)
thanks for post mortem

LinuxJedi · 2024-02-22T12:33:02Z

I think it's fair to say there would be interest. We're all interested in building more robust systems, right?

Had clearance to do that. I'll write it up in a more publicly consumable form in the next couple of days.

mattdale77 · 2024-02-22T15:02:47Z

I just deployed the latest and still received the same error. I've switched back to lts and it's fine but I believed that this issue was resolved already?

danieljweinberg · 2024-02-22T15:35:40Z

I just deployed the latest and still received the same error. I've switched back to lts and it's fine but I believed that this issue was resolved already?

I had the same problem in docker-compose, "latest" simply reused the most recent image, docker did not think the image had changed. I had to delete all mariadb images and pull latest again, then it worked. @mattdale77

mattdale77 · 2024-02-22T15:39:29Z

I just deployed the latest and still received the same error. I've switched back to lts and it's fine but I believed that this issue was resolved already?

I had the same problem in docker-compose, "latest" simply reused the most recent image, docker did not think the image had changed. I had to delete all mariadb images and pull latest again, then it worked. @mattdale77

Thanks. I've got a few so I'll need to track them all down. Thanks for the tip

LinuxJedi · 2024-02-22T17:30:11Z

For those who requested it, post-mortem here: https://mariadb.org/post-mortem-php-and-mariadb-docker-issue/

Unfortunately the last latest release broken PHP and nodejs because of a protocol issue. The configuration item character-set-collations added in the default 11.3/11.4 image generated this. Closes: MariaDB/mariadb-docker#560

…ions" This reverts commit d7a950d.

This reverts commit d7a950d.

This reverts commit 1e14bca. but only for 11.3/11.4 which haven't been updated.

…et-collations"" This reverts commit e067772.

…ations"" This reverts commit e067772.

Nefcanto · 2024-06-05T06:25:16Z

Guys, I read this thread, but I could not figure out if the new collation utf8mb4_uca1400_ai_ci is here to stay as the new default collation or if it will be reverted back to utf8mb4_general_ci? Can anyone please guide me regarding that?

Because if it's the new default, then we should create a migration script to update all of our databases on our production server.

Simbiat · 2024-06-23T13:19:57Z

I just recently started using Docker, and I am using MariaDB's 11.4.2-noble. I have

[client]
default-character-set=utf8mb4

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_uca1400_nopad_as_cs

and I am getting these errors every like 10 seconds:

2024-06-23 13:11:52 19351 [Warning] Aborted connection 19351 to db: 'unconnected' user: 'unauthenticated' host: '::1' (This connection closed normally without authentication)

But as far as I know I do not have anything on the same container that would connect over ::1. Connections from another container (frankenphp) work absolutely fine, too, no errors. Is this somehow related to this issue or is this something completely different?

grooverdan · 2024-06-23T22:30:43Z

@Simbiat,

The original cause of this one was fixed with 11.4.2.

The way I managed to generate that error was podman exec containername socat STDIO TCP6:[::1]:3306. It looks like a custom healthcheck or liveliness test performing tcp connection without authentication.

I also reproduced this with:

$ podman exec  cool_solomon rm /var/lib/mysql/.my-healthcheck.cnf
$ podman exec  cool_solomon healthcheck.sh --connect

If your .my-healthcheck.sh is also has all permissions like #573 that could also be a causing factor if and unauthenticated tcp checks.

Simbiat · 2024-06-24T04:31:59Z

My case is slightly different, than tat, but I'll post in that issue, since it's close to that.

adimoldovan mentioned this issue Feb 21, 2024

@wordpress/env: Getting error on version 9.3.0 when run start command WordPress/gutenberg#59232

Closed

cvicentiu added Workaround Available Bug that can be worked around with a fix. Check issue comments. bug labels Feb 21, 2024

t-hamano mentioned this issue Feb 21, 2024

env: Fix mariadb version to LTS WordPress/gutenberg#59237

Merged

Murazaki mentioned this issue Feb 21, 2024

Latest Mariadb image has authentication issues #563

Closed

CATCHPOLEBHC added a commit to bhccwebmaster/drupal-container that referenced this issue Feb 21, 2024

Pin to MariaDB 11.2

2a37249

Ref MariaDB/mariadb-docker#560

hoorna mentioned this issue Feb 21, 2024

Service cannot start, (SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client) alexjustesen/speedtest-tracker#1205

Closed

AirBair mentioned this issue Feb 21, 2024

Unable to connect to MariaDB 11.3 php/php-src#13452

Closed

grooverdan mentioned this issue Feb 22, 2024

MariaDB urgent reissue docker-library/official-images#16293

Merged

jtagcat mentioned this issue Feb 22, 2024

Wallabag mariadb: Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.29.0.33' (This connection closed normally without authentication) wallabag/docker#380

Closed

grooverdan closed this as completed Feb 22, 2024

grooverdan added a commit to grooverdan/mariadb-docker that referenced this issue Apr 11, 2024

Revert "Workaround issue MariaDB#560 by removing character-set-collat…

207786e

…ions" This reverts commit d7a950d.

grooverdan added a commit that referenced this issue Apr 15, 2024

Revert "Workaround issue #560 by removing character-set-collations"

58614cb

This reverts commit d7a950d.

megamattc mentioned this issue May 17, 2024

Wikibase interface - Can't add statements to an item wmde/wikibase-release-pipeline#670

Closed

grooverdan added a commit that referenced this issue May 17, 2024

Revert "Workaround issue #560 by removing character-set-collations"

1e14bca

This reverts commit d7a950d.

grooverdan added a commit that referenced this issue May 23, 2024

Reapply "Workaround issue #560 by removing character-set-collations"

e067772

This reverts commit 1e14bca. but only for 11.3/11.4 which haven't been updated.

grooverdan added a commit to grooverdan/mariadb-docker that referenced this issue May 23, 2024

Revert "Reapply "Workaround issue MariaDB#560 by removing character-s…

54986c8

…et-collations"" This reverts commit e067772.

grooverdan added a commit that referenced this issue May 30, 2024

Revert "Reapply "Workaround issue #560 by removing character-set-coll…

fc15778

…ations"" This reverts commit e067772.

grooverdan mentioned this issue May 31, 2024

Default collation changed between 11.4.1 and 11.4.2 (latest) #591

Closed

sastromo mentioned this issue Oct 31, 2024

Aborted connection # to db: 'unconnected' user: 'unauthenticated' host: 'x.x.x.x' (This connection closed normally without authentication) wallabag/docker#420

Open

physikerwelt mentioned this issue Dec 27, 2024

Update mariadb MaRDI4NFDI/portal-compose#604

Closed

4 tasks

Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication) #560

Aborted connection to db: 'unconnected' user: 'unauthenticated' host: 'xxx' (This connection closed normally without authentication) #560

Comments

MyNameIsRatchet commented Feb 21, 2024 • edited Loading

PhilippHandle commented Feb 21, 2024

WAdama commented Feb 21, 2024 • edited Loading

thomase1234 commented Feb 21, 2024

WAdama commented Feb 21, 2024

cvicentiu commented Feb 21, 2024 • edited Loading

PhilippHandle commented Feb 21, 2024 • edited Loading

kimbtech commented Feb 21, 2024

LinuxJedi commented Feb 21, 2024

LinuxJedi commented Feb 21, 2024 • edited Loading

martadinata666 commented Feb 21, 2024

LinuxJedi commented Feb 21, 2024

PhilippHandle commented Feb 21, 2024

an3l commented Feb 21, 2024 • edited Loading

cvicentiu commented Feb 21, 2024 • edited Loading

PhilippHandle commented Feb 21, 2024

WAdama commented Feb 21, 2024

SHOzturk-PV commented Feb 21, 2024 • edited Loading

stanthewizzard commented Feb 21, 2024

martadinata666 commented Feb 21, 2024 • edited Loading

SHOzturk-PV commented Feb 21, 2024 • edited Loading

LinuxJedi commented Feb 21, 2024

agarov commented Feb 21, 2024 • edited Loading

jcrossbdn commented Feb 22, 2024

grooverdan commented Feb 22, 2024 • edited Loading

hosseinitabar commented Feb 22, 2024

LinuxJedi commented Feb 22, 2024

ckuethe commented Feb 22, 2024

stanthewizzard commented Feb 22, 2024

LinuxJedi commented Feb 22, 2024

mattdale77 commented Feb 22, 2024

danieljweinberg commented Feb 22, 2024

mattdale77 commented Feb 22, 2024

LinuxJedi commented Feb 22, 2024

Nefcanto commented Jun 5, 2024

Simbiat commented Jun 23, 2024

grooverdan commented Jun 23, 2024

Simbiat commented Jun 24, 2024

MyNameIsRatchet commented Feb 21, 2024 •

edited

Loading

WAdama commented Feb 21, 2024 •

edited

Loading

cvicentiu commented Feb 21, 2024 •

edited

Loading

PhilippHandle commented Feb 21, 2024 •

edited

Loading

LinuxJedi commented Feb 21, 2024 •

edited

Loading

an3l commented Feb 21, 2024 •

edited

Loading

cvicentiu commented Feb 21, 2024 •

edited

Loading

SHOzturk-PV commented Feb 21, 2024 •

edited

Loading

martadinata666 commented Feb 21, 2024 •

edited

Loading

SHOzturk-PV commented Feb 21, 2024 •

edited

Loading

agarov commented Feb 21, 2024 •

edited

Loading

grooverdan commented Feb 22, 2024 •

edited

Loading