Bug #91797

Typo3 Azure MySQL

Added by ondro no-lastname-given over 1 year ago. Updated over 1 year ago.

Status:
New
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

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

Actions
#1

Updated by ondro no-lastname-given over 1 year ago

Hello, any news abut this?

Thank you so much

#2

Updated by Benni Mack 3 days ago

  • Related to Feature #17108: Support secure database connections (e.g. MySQL over SSL) added

Also available in: Atom PDF