entrypoint MySQL connection try and SSL

[jfcoz]

MySQL SSL connection

When using WORDPRESS_CONFIG_EXTRA ( #142 ) to force MySQL SSL connection (because the server require this) via :

define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL);

The MySQL connection try in entrypoint will not use this setting and slow down the startup by 30 seconds :

wordpress/php7.4/apache/docker-entrypoint.sh

Lines 266 to 277 in b112774

	$maxTries = 10;
	do {
	$mysql = new mysqli($host, $user, $pass, '', $port, $socket);
	if ($mysql->connect_error) {
	fwrite($stderr, "\n" . 'MySQL Connection Error: (' . $mysql->connect_errno . ') ' . $mysql->connect_error . "\n");
	--$maxTries;
	if ($maxTries <= 0) {
	exit(1);
	}
	sleep(3);
	}
	} while ($mysql->connect_error);

During this time the container will loop on this kind of errors :

MySQL Connection Error: (9002) SSL connection is required. Please specify SSL options and retry.

[wglambert]

Related to #264 and https://github.com/docker-library/wordpress/issues/299#issuecomment-412201734

I think we should consider updating our documentation to make it clear that if you need SSL for your MySQL connection, you should not set the environment variables we provide and should instead modify wp-config.php

[jfcoz]

Do you think the connection test could include the wp-config to use strictly the same settings ?

[tianon]

We wanted to do so, and tried, but because wp-config.php isn't strictly a configuration file and ends with require_once ABSPATH . 'wp-settings.php';, it ends up not being something we can include directly. 😞

[tianon]

This is fixed by #557, and should be available for testing under the beta tags on Docker Hub soon!