Conversation
supportWe 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.
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!
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!
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/
Hello, thanks for your help! I will do it on my end.
Great! If you like WP Adminer and its support, you can review it here: https://wordpress.org/support/plugin/pexlechris-adminer/reviews/#new-post
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!
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!
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/
Hello, thanks for your help! I will do it on my end.
Great! If you like WP Adminer and its support, you can review it here: https://wordpress.org/support/plugin/pexlechris-adminer/reviews/#new-post