Project

General

Profile

Actions

Bug #91797

closed

Typo3 Azure MySQL

Added by ondro no-lastname-given almost 4 years ago. Updated about 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 #1

Updated by ondro no-lastname-given almost 4 years ago

Hello, any news abut this?

Thank you so much

Actions #2

Updated by Benni Mack over 2 years ago

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

Updated by Riccardo De Contardi about 2 years ago

  • Status changed from New to Needs Feedback

Does this issue still happens on recent TYPO3 versions like 10 or 11 ?

Actions #4

Updated by Benni Mack about 2 years ago

  • Status changed from Needs Feedback to Closed

Hey ondro,

sorry for the late reply but only a few people run TYPO3 on Azure with MySQL. I'm actually one of them now... unfortunately.

I learned a lot about TYPO3 on Azure in the past 6 months, and mysqlnd_azure is one of them.

I have TYPO3 v9 with PHP 7.4 and mysqlnd_azure in the latest version, and there is no problem, it just works as expected and documented. I firmly believe that you would need to ensure to run the latest mysqlnd_azure package, and TYPO3 v9+ (to use Doctrine DBAL 2.10+). So the answer is: Update to TYPO3 v9 or higher.

Note for all the rest: If somebody wants to sponsor me, I'm happy to write about all my findings in blog post but this would take a few of my work days...

Actions

Also available in: Atom PDF