DatabaseCheck.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Install\SystemEnvironment;

/*
 * 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\Utility\GeneralUtility;
use TYPO3\CMS\Install\Status;

class DatabaseCheck
{
    protected $incompatibleSqlModes = array(
        'STRICT_ALL_TABLES',
        'STRICT_TRANS_TABLES',
        'NO_BACKSLASH_ESCAPES'
    );

    public function getStatus()
    {
        $statusArray = array();
        if ($this->isDbalEnabled() || !$this->getDatabaseConnection()) {
            return $statusArray;
        }
        $statusArray[] = $this->checkMysqlVersion();
        $statusArray[] = $this->checkInvalidSqlModes();
        return $statusArray;
    }

    protected function checkInvalidSqlModes()
    {
        $detectedIncompatibleSqlModes = $this->getIncompatibleSqlModes();
        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()
    {
        $minimumMysqlVersion = '5.5.0';
        $currentMysqlVersion = '';
        $resource = $this->getDatabaseConnection()->sql_query('SHOW VARIABLES LIKE \'version\';');
        if ($resource !== false) {
            $result = $this->getDatabaseConnection()->sql_fetch_row($resource);
            if (isset($result[1])) {
                $currentMysqlVersion = $result[1];
            }
        }
        if (version_compare($currentMysqlVersion, $minimumMysqlVersion) < 0) {
            $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 ' . $minimumMysqlVersion
            );
        } else {
            $status = new Status\OkStatus();
            $status->setTitle('MySQL version is fine');
        }

        return $status;
    }

    protected function getIncompatibleSqlModes()
    {
        $sqlModes = array();
        $resource = $this->getDatabaseConnection()->sql_query('SELECT @@SESSION.sql_mode;');
        if ($resource !== false) {
            $result = $this->getDatabaseConnection()->sql_fetch_row($resource);
            if (isset($result[0])) {
                $sqlModes = explode(',', $result[0]);
            }
        }
        return array_intersect($this->incompatibleSqlModes, $sqlModes);
    }

    protected function getDatabaseConnection()
    {
        static $database;
        if (!is_object($database)) {
            $database = GeneralUtility::makeInstance(\TYPO3\CMS\Core\Database\DatabaseConnection::class);
            $database->setDatabaseUsername($GLOBALS['TYPO3_CONF_VARS']['DB']['username']);
            $database->setDatabasePassword($GLOBALS['TYPO3_CONF_VARS']['DB']['password']);
            $database->setDatabaseHost($GLOBALS['TYPO3_CONF_VARS']['DB']['host']);
            $database->setDatabasePort($GLOBALS['TYPO3_CONF_VARS']['DB']['port']);
            $database->setDatabaseSocket($GLOBALS['TYPO3_CONF_VARS']['DB']['socket']);
            $database->setDatabaseName($GLOBALS['TYPO3_CONF_VARS']['DB']['database']);
            $database->initialize();
            $database->connectDB();
        }
        return $database;
    }

    protected function isDbalEnabled()
    {
        return \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::isLoaded('dbal');
    }
}