Bug #91797
closedTypo3 Azure MySQL
0%
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?
Updated by ondro no-lastname-given over 4 years ago
Hello, any news abut this?
Thank you so much
Updated by Benni Mack almost 3 years ago
- Related to Feature #17108: Support secure database connections (e.g. MySQL over SSL) added
Updated by Riccardo De Contardi over 2 years ago
- Status changed from New to Needs Feedback
Does this issue still happens on recent TYPO3 versions like 10 or 11 ?
Updated by Benni Mack over 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...