MySqlCheck.php

Go to the documentation of this file.

<?php

namespace TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform;

/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */

use TYPO3\CMS\Core\Database\Connection;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Database\Query\QueryBuilder;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Install\Status;
use TYPO3\CMS\Install\SystemEnvironment\CheckInterface;

class MySqlCheck implements CheckInterface
{
    protected $minimumMySQLVersion = '5.5.0';

    protected $incompatibleSqlModes = [
        'NO_BACKSLASH_ESCAPES'
    ];

    public function getStatus(): array
    {
        $statusArray = [];
        $defaultConnection = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getConnectionByName(ConnectionPool::DEFAULT_CONNECTION_NAME);
        if (strpos($defaultConnection->getServerVersion(), 'MySQL') !== 0) {
            return $statusArray;
        }
        $statusArray[] = $this->checkMysqlVersion($defaultConnection);
        $statusArray[] = $this->checkInvalidSqlModes($defaultConnection);
        $statusArray[] = $this->checkMysqlDatabaseUtf8Status($defaultConnection);
        return $statusArray;
    }

    protected function checkInvalidSqlModes($connection)
    {
        $detectedIncompatibleSqlModes = $this->getIncompatibleSqlModes($connection);
        if (!empty($detectedIncompatibleSqlModes)) {
            $status = new Status\ErrorStatus();
            $status->setTitle('Incompatible SQL modes found!');
            $status->setMessage(
                'Incompatible SQL modes have been detected:' .
                ' ' . implode(', ', $detectedIncompatibleSqlModes) . '.' .
                ' The listed modes are not compatible with TYPO3 CMS.' .
                ' You have to change that setting in your MySQL environment' .
                ' or in $GLOBALS[\'TYPO3_CONF_VARS\'][\'SYS\'][\'setDBinit\']'
            );
        } else {
            $status = new Status\OkStatus();
            $status->setTitle('No incompatible SQL modes found.');
        }

        return $status;
    }

    protected function checkMysqlVersion($connection)
    {
        preg_match('/MySQL ((\d+\.)*(\d+\.)*\d+)/', $connection->getServerVersion(), $match);
        $currentMysqlVersion = $match[1];
        if (version_compare($currentMysqlVersion, $this->minimumMySQLVersion, '<')) {
            $status = new Status\ErrorStatus();
            $status->setTitle('MySQL version too low');
            $status->setMessage(
                'Your MySQL version ' . $currentMysqlVersion . ' is too old. TYPO3 CMS does not run' .
                ' with this version. Update to at least MySQL ' . $this->minimumMySQLVersion
            );
        } else {
            $status = new Status\OkStatus();
            $status->setTitle('MySQL version is fine');
        }

        return $status;
    }

    protected function checkMysqlDatabaseUtf8Status(Connection $connection)
    {
        $queryBuilder = $connection->createQueryBuilder();
        $defaultDatabaseCharset = (string)$queryBuilder->select('DEFAULT_CHARACTER_SET_NAME')
            ->from('information_schema.SCHEMATA')
            ->where(
                $queryBuilder->expr()->eq(
                    'SCHEMA_NAME',
                    $queryBuilder->createNamedParameter($connection->getDatabase(), \PDO::PARAM_STR)
                )
            )
            ->setMaxResults(1)
            ->execute()
            ->fetchColumn();
        // also allow utf8mb4
        if (strpos($defaultDatabaseCharset, 'utf8') !== 0) {
            $status = new Status\ErrorStatus();
            $status->setTitle('MySQL database character set check failed');
            $status->setMessage(
                'Checking database character set failed, got key "'
                . $defaultDatabaseCharset . '" instead of "utf8" or "utf8mb4"'
            );
        } else {
            $status = new Status\OkStatus();
            $status->setTitle('Your database uses utf-8. All good.');
        }
        return $status;
    }

    protected function getIncompatibleSqlModes($connection)
    {
        $sqlModes = explode(',', $connection->executeQuery('SELECT @@SESSION.sql_mode;')
            ->fetch(0)['@@SESSION.sql_mode']);
        return array_intersect($this->incompatibleSqlModes, $sqlModes);
    }
}