Doesn’t work while –require_secure_transport=ON

Resolved deash
(@deash)

1 year, 4 months ago

We run WordPress on Azure App Service with a Azure Database for MySQL flexible server. When I install the plugin, I only get the following error message and a constant login loop – no connection is possible:

“Connections using insecure transport are prohibited while –require_secure_transport=ON”

The MySQL Database requires a secure connection and it is also a company policy to only use secure connections.

For testing I disabled “require_secure_transport” on the flexible MySQL server and then access to the database is working.

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author Pexle Chris
(@pexlechris)

1 year, 4 months ago

Hello and thank you for your report!

It seems that this is a problem of official Adminer software (and then the forked AdminerEVO Software)…

Because this plugin is only an integration of Adminer to WordPress, I cannot offer support for official Adminer software…

So you need to open a ticket in AdminerEVO (because Adminer before fork seem to be abandoned) in the GitHub repo of AdminerEVO: https://github.com/adminerevo/adminerevo/issues

Thank you for using WP Adminer, and I am here to help you If I can with the integration based features!

Thread Starter deash
(@deash)

1 year, 4 months ago

Hello, thanks for your help – I got a reply on github: WordPress on Azure App Service – Connections using insecure transport are prohibited while –require_secure_transport=ON · Issue #232 · adminerevo/adminerevo

Is this something you could include in your plugin? I mean that the needed plugins from AdminerEVO are included and that it is possible to activate/deactivate SSL via a config page? That would be great!
Plugin Author Pexle Chris
(@pexlechris)

1 year, 4 months ago
Hello,

this is not a change that I will do in my plugin globally, but you can do it at your end!

So, in order to do the integration with my plugin, you need to add a must-use plugin in your WP site with these contents:
```
if (!function_exists('adminer_object')) {

	function adminer_object()
	{

		include_once PEXLECHRIS_ADMINER_DIR . '/inc/class-pexlechris-adminer.php';

		class My_Custom_Adminer_Class extends Pexlechris_Adminer
		{
			function connectSsl()
			{
				return [
					'key'	=> 'filename', // you maybe change or delete this row
					'cert'	=> 'filename',  // you maybe change or delete this row
					'ca'	=> '/var/www/html/DigiCertGlobalRootCA.crt.pem', // Certificate can be downloaded here: https://dl.cacerts.digicert.com/DigiCertGlobalRootCA.crt.pem
				];
			}
		}

		return new My_Custom_Adminer_Class();

	}

}
```
Finally, learn what is a must-use plugin and how to install it in this article (method 3) here: https://www.pexlechris.dev/how-to-add-php-hooks-in-your-wordpress-site/
Thread Starter deash
(@deash)

1 year, 4 months ago

Hello, thanks for your help! I will do it on my end.

Plugin Author Pexle Chris
(@pexlechris)

1 year, 4 months ago

Great! If you like WP Adminer and its support, you can review it here: https://ww.wp.xz.cn/support/plugin/pexlechris-adminer/reviews/#new-post

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Doesn’t work while –require_secure_transport=ON’ is closed to new replies.