Project

General

Profile

Actions

Bug #91797

closed

Typo3 Azure MySQL

Added by ondro no-lastname-given over 4 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2020-07-13
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Hello,

We are connecting to Azure MySQL database using redirection https://docs.microsoft.com/en-us/azure/mysql/howto-redirection to be able to improve performance.
DB connection is configured as follow:

 'DB' => [
        'Connections' => [
            'Default' => [
                'charset' => 'utf8',
                'dbname' => getenv('DB_NAME'),
                'driver' => 'mysqli',
                'host' => getenv('DB_HOST'),
                'password' => getenv('DB_PASSWORD'),
                'user' => getenv('DB_USER'),
                'driverOptions' => [
                    'flags' => MYSQLI_CLIENT_SSL,
                ],
            ],
        ],
    ],

BE works fine but FE reports:
mysqlnd_azure.enableRedirect is on, but SSL option is not set in connection string. Redirection is only possible with SSL.

I've investigated \Doctrine\DBAL\Driver\Mysqli\MysqliConnection::__construct and for BE is all right. All parameters are set in constructor. But or the FE dbname, host and driverOptions are not set. Why so?


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Feature #17108: Support secure database connections (e.g. MySQL over SSL)Closed2007-03-10

Actions
Actions

Also available in: Atom PDF