• Resolved juicymediadanieloateslee

    (@juicymediadanieloateslee)


    We are using MySQL with TLS and the plugin is unable to connect to the database.

    Please see below:

    [Thu May 23 14:00:09.084013 2024] [php:error] [pid 3490668] [client 147.243.250.138:59306] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while –require_secure_transport=ON. in /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connectors/Connector.php:53 Stack trace: #0 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connectors/Connector.php(53): PDO->__construct() #1 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connectors/Connector.php(34): IAWPSCOPED\\Illuminate\\Database\\Connectors\\Connector->createPdoConnection() #2 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connectors/MySqlConnector.php(22): IAWPSCOPED\\Illuminate\\Database\\Connectors\\Connector->createConnection() #3 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connectors/ConnectionFactory.php(157): IAWPSCOPED\\Illuminate\\Database\\Connectors\\MySqlConnector->connect() #4 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(884): IAWPSCOPED\\Illuminate\\Database\\Connectors\\ConnectionFactory->IAWPSCOPED\\Illuminate\\Database\\Connectors\\{closure}() #5 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(913): IAWPSCOPED\\Illuminate\\Database\\Connection->getPdo() #6 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(374): IAWPSCOPED\\Illuminate\\Database\\Connection->getReadPdo() #7 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(319): IAWPSCOPED\\Illuminate\\Database\\Connection->getPdoForSelect() #8 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(587): IAWPSCOPED\\Illuminate\\Database\\Connection->IAWPSCOPED\\Illuminate\\Database\\{closure}() #9 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\\Illuminate\\Database\\Connection->runQueryCallback() #10 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(312): IAWPSCOPED\\Illuminate\\Database\\Connection->run() #11 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\\Illuminate\\Database\\Connection->select() #12 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\\Illuminate\\Database\\Query\\Builder->exists() #13 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/IAWP/Database.php(39): IAWPSCOPED\\Illuminate\\Database\\Query\\Builder->doesntExist() #14 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/iawp-bootstrap.php(270): IAWP\\Database::is_missing_all_tables() #15 /var/www/htdocs/wordpress/public/wp-includes/class-wp-hook.php(324): IAWPSCOPED\\{closure}() #16 /var/www/htdocs/wordpress/public/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #17 /var/www/htdocs/wordpress/public/wp-includes/plugin.php(517): WP_Hook->do_action() #18 /var/www/htdocs/wordpress/public/wp-admin/includes/plugin.php(705): do_action() #19 /var/www/htdocs/wordpress/public/wp-admin/plugins.php(60): activate_plugin() #20 {main} Next IAWPSCOPED\\Illuminate\\Database\\QueryException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while –require_secure_transport=ON. (SQL: select exists(select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = wpdb and TABLE_NAME LIKE wp_independent_analytics_%) as exists) in /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php:589 Stack trace: #0 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\\Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(312): IAWPSCOPED\\Illuminate\\Database\\Connection->run() #2 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\\Illuminate\\Database\\Connection->select() #3 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\\Illuminate\\Database\\Query\\Builder->exists() #4 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/IAWP/Database.php(39): IAWPSCOPED\\Illuminate\\Database\\Query\\Builder->doesntExist() #5 /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/iawp-bootstrap.php(270): IAWP\\Database::is_missing_all_tables() #6 /var/www/htdocs/wordpress/public/wp-includes/class-wp-hook.php(324): IAWPSCOPED\\{closure}() #7 /var/www/htdocs/wordpress/public/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #8 /var/www/htdocs/wordpress/public/wp-includes/plugin.php(517): WP_Hook->do_action() #9 /var/www/htdocs/wordpress/public/wp-admin/includes/plugin.php(705): do_action() #10 /var/www/htdocs/wordpress/public/wp-admin/plugins.php(60): activate_plugin() #11 {main} thrown in /var/www/htdocs/wordpress/public/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php on line 589, referer: https://www.example.com/wp-admin/plugins.php?plugin=independent-analytics-pro%2Fiawp.php

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Ben Sibley

    (@bensibley)

    Hi there,

    Thanks for bringing this to our attention. We weren’t aware of this incompatibility.

    We’re looking into this now and should have a solution ready in the next update.

    Plugin Author Ben Sibley

    (@bensibley)

    @juicymediadanieloateslee could you let me know if you have a value set for MYSQL_CLIENT_FLAGS?

    Thread Starter juicymediadanieloateslee

    (@juicymediadanieloateslee)

    I have used the following in the wp-config.php

    define(‘MYSQL_CLIENT_FLAGS’, MYSQLI_CLIENT_SSL);

    Plugin Author Ben Sibley

    (@bensibley)

    Thank you! We will have this fixed soon.

    Hi @bensibley

    I have the same problem, do you know when it will be updated?

    Thanks you.

    Plugin Author Ben Sibley

    (@bensibley)

    Yes, sorry we lost track of this. Here’s an advance copy of the patch: download from here. Could you give it a try and confirm if it fixes the issue for you?

    Thanks!

    Thanks you! But for me dont work, the same problem with 2.5.2

    Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php:53 Stack trace: #0 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php(53): PDO->__construct() #1 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/Connector.php(34): IAWPSCOPED\Illuminate\Database\Connectors\Connector->createPdoConnection() #2 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/MySqlConnector.php(22): IAWPSCOPED\Illuminate\Database\Connectors\Connector->createConnection() #3 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connectors/ConnectionFactory.php(157): IAWPSCOPED\Illuminate\Database\Connectors\MySqlConnector->connect() #4 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(884): IAWPSCOPED\Illuminate\Database\Connectors\ConnectionFactory->IAWPSCOPED\Illuminate\Database\Connectors\{closure}() #5 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(913): IAWPSCOPED\Illuminate\Database\Connection->getPdo() #6 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(374): IAWPSCOPED\Illuminate\Database\Connection->getReadPdo() #7 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(319): IAWPSCOPED\Illuminate\Database\Connection->getPdoForSelect() #8 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(587): IAWPSCOPED\Illuminate\Database\Connection->IAWPSCOPED\Illuminate\Database\{closure}() #9 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback() #10 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(323): IAWPSCOPED\Illuminate\Database\Connection->run() #11 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\Illuminate\Database\Connection->select() #12 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\Illuminate\Database\Query\Builder->exists() #13 /var/www/html/public/wp-content/plugins/independent-analytics/IAWP/Database.php(39): IAWPSCOPED\Illuminate\Database\Query\Builder->doesntExist() #14 /var/www/html/public/wp-content/plugins/independent-analytics/iawp-bootstrap.php(292): IAWP\Database::is_missing_all_tables() #15 /var/www/html/public/wp-includes/class-wp-hook.php(307): IAWPSCOPED\{closure}() #16 /var/www/html/public/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #17 /var/www/html/public/wp-includes/plugin.php(476): WP_Hook->do_action() #18 /var/www/html/public/wp-admin/plugins.php(194): do_action() #19 {main} Next IAWPSCOPED\Illuminate\Database\QueryException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. (SQL: select exists(select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = HaKz1YRC4yuRquNF and TABLE_NAME LIKE wp_4_independent_analytics_%) as exists) in /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php:589 Stack trace: #0 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(323): IAWPSCOPED\Illuminate\Database\Connection->run() #2 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2250): IAWPSCOPED\Illuminate\Database\Connection->select() #3 /var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Query/Builder.php(2267): IAWPSCOPED\Illuminate\Database\Query\Builder->exists() #4 /var/www/html/public/wp-content/plugins/independent-analytics/IAWP/Database.php(39): IAWPSCOPED\Illuminate\Database\Query\Builder->doesntExist() #5 /var/www/html/public/wp-content/plugins/independent-analytics/iawp-bootstrap.php(292): IAWP\Database::is_missing_all_tables() #6 /var/www/html/public/wp-includes/class-wp-hook.php(307): IAWPSCOPED\{closure}() #7 /var/www/html/public/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #8 /var/www/html/public/wp-includes/plugin.php(476): WP_Hook->do_action() #9 /var/www/html/public/wp-admin/plugins.php(194): do_action() #10 {main} thrown in?/var/www/html/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php?on line?589

    Plugin Author Ben Sibley

    (@bensibley)

    Thanks for letting me know.

    We’re having trouble recreating the same error with version 2.5.2. Could you let me know what host you’re using? We’d like to try to replicate the same environment for testing.

    Sorry, but is domain internt, only access with VPN.

    How I can send more info?

    Thanks you!

    Plugin Author Ben Sibley

    (@bensibley)

    Got it. Could you reach out to us at [email protected] to discuss this further? We may have to ask about some site details that aren’t appropriate to share in the public forums.

    Thank you!

Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.