Skip to content

Fix: Error: Failed to get current SQL modes. Reason: ERROR 2026 (HY000) - Bump mariadb to 11.8.3#228

Merged
lucatume merged 1 commit into2.1.3from
bugfix/mariadb-error-2026-hy000
Nov 26, 2025
Merged

Fix: Error: Failed to get current SQL modes. Reason: ERROR 2026 (HY000) - Bump mariadb to 11.8.3#228
lucatume merged 1 commit into2.1.3from
bugfix/mariadb-error-2026-hy000

Conversation

@defunctl
Copy link
Copy Markdown
Contributor

@defunctl defunctl commented Nov 25, 2025

Main Changes

Some of the more recent PHP containers have an upgraded mariadb client (11.8.3) that does not respect the TLS version or certs of older versions of MariaDB. This causes issues with slic wp db commands.

Combine that with some WP CLI bugs:

  1. Mariadb less then 10.5 command detection wp-cli/wp-cli#6097
  2. Detect MariaDB vs MySQL wp-cli/wp-cli#6072

The simplest thing I think is to update mariadb.

Full Error Message:

Error: Failed to get current SQL modes. Reason: ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

How To Reproduce:

slic php-version set 8.2 -y

This should show: mariadb:10.7.8:

docker ps
slic wp db reset --yes

…SQL modes. Reason: ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
@defunctl defunctl requested review from borkweb and lucatume November 25, 2025 23:13
@defunctl defunctl self-assigned this Nov 25, 2025
@defunctl defunctl added the bug Contains a bug that needs resolution. label Nov 25, 2025
@lucatume lucatume changed the base branch from main to 2.1.3 November 26, 2025 07:42
@lucatume
Copy link
Copy Markdown
Contributor

To make sure this would not break things in existing code, I've tested this fix on lower PHP versions:

  • 7.4 (forcing it to not use the default MySQL 5.5 image with SLIC_DB_IMAGE=mariadb:11.8.3 slic up)
  • 8.0
  • 8.1
    I had no issues in any container. approving and merging.

@lucatume lucatume merged commit e724577 into 2.1.3 Nov 26, 2025
@lucatume lucatume deleted the bugfix/mariadb-error-2026-hy000 branch November 26, 2025 10:51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

bug Contains a bug that needs resolution.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants