Project

General

Profile

Actions

Bug #98518

closed

Wrong version detection of database

Added by Stefan Froemken about 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2022-10-04
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
12
PHP Version:
8.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Hello,

I just try to install TYPO3 12.0, but install wizard fails because of:

MariaDB version too low
Your MariaDB version 5.5.5 is too old. TYPO3 CMS does not run with this version. Update to at least MariaDB 10.3.0

My .ddev/config.yaml:

mariadb_version: "10.3" 

Server Version copied from PhpMyAdmin:

Server-Version: 10.3.32-MariaDB-1:10.3.32+maria~focal-log - mariadb.org binary distribution

I have started a xdebug session in TYPO3\CMS\Install\SystemEnvironment\DatabaseCheck\Platform\MySql.php. In method checkMySQLOrMariaDBVersion the Server string is:

MySQL 5.5.5-10.3.32-MariaDB-1:10.3.32+maria~focal-log

Seems the preg_match "/MySQL ((\d+\.)*(\d+\.)*\d+)/" has to be updated.

Stefan


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #93261: Wrong detection of MariaDB/MySQL version on Debian 9ClosedStefan Bürk2021-01-11

Actions
Actions #1

Updated by Georg Ringer about 2 years ago

  • Status changed from New to Accepted
  • Priority changed from Should have to Must have
Actions #2

Updated by Benni Mack about 2 years ago

  • Target version changed from 12.0 to 12.1
Actions #3

Updated by Gerrit Code Review about 2 years ago

  • Status changed from Accepted to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #4

Updated by Stefan Bürk about 2 years ago

Stefan Frömken, can you test and verify if it works with the patch ? (composer patch etc) ?

Normaly having the 5.5.5- prefix in the version string means that a not-fully mariadb compat client version is used. Compat client libraries normall removes the fake prefix, which mariadb has to ship to avoid MySQL/MariaDB replication issues. At least from my research. Mainly it seems to occour on
windows servers.

However .. will check ddev the next days if I find a spare machine to install it. And eventually report it to ddev that thay may have to update the client library etc.

However, to be on the safe side I changed the regexp which should no properly deal with it.

Actions #5

Updated by Gerrit Code Review about 2 years ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #6

Updated by Stefan Froemken about 2 years ago

Thank you Stefan,

I have tested your patch and it works.

I found the problem in MariaDB source code:
https://github.com/MariaDB/server/blob/826f9d4f7e99973cafe7654697d7c50b8b64b76b/include/mysql_com.h#L41

Further the PHP community was also not amused about it:
https://bugs.php.net/bug.php?id=78179
See answer of "[2019-07-21 17:43 UTC] "
Quote: "...but the truth is that since 10.0 their versioning scheme is incompatible with MySQL's"

Actions #7

Updated by Gerrit Code Review about 2 years ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #8

Updated by Gerrit Code Review about 2 years ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #9

Updated by Gerrit Code Review about 2 years ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #10

Updated by Gerrit Code Review about 2 years ago

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #11

Updated by Gerrit Code Review about 2 years ago

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #12

Updated by Gerrit Code Review about 2 years ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75991

Actions #13

Updated by Stefan Bürk about 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #14

Updated by Stefan Bürk about 2 years ago

  • Related to Bug #93261: Wrong detection of MariaDB/MySQL version on Debian 9 added
Actions #15

Updated by Benni Mack almost 2 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF