Michaela241

Hi,
Do you have a set-up tutorial or docu. I can’t seem to figure out who to make it work.
Thank you.

Hostgator answered:
HI Michaela,

We have been looking further into this with the test script and our research shows that the CA Path is not necessary when the CA file is present:

/etc/pki/tls/certs/ca-bundle.crt

According to https://www.php.net/manual/en/context.ssl.php:

capath? string: If? cafile? is not specified or if the certificate is not found there, the directory pointed to by? capath? is searched for a suitable certificate.? capath? must be a correctly hashed certificate directory.

Furthermore, that can also be specified in the settigns such that it won’t say CA path none:

curl_setopt($curl, CURLOPT_CAPATH, ‘/etc/pki/tls/certs/’);

Here’s the log output when we ran it that way:

* About to connect() to https://www.google.com port 443 (#0)
* Trying 74.125.198.104…
* connected
* Connected to https://www.google.com (74.125.198.104) port 443 (#0)
* successfully set certificate verify locations:
* CAfile: /etc/pki/tls/certs/ca-bundle.crt
CApath: /etc/pki/tls/certs/
* SSL connection using ECDHE-RSA-AES128-GCM-SHA256
* Server certificate:

OK, Thank you. Let’s see what Hostgator has to say.

OK, done. This is the error log:
Last Error: exception ‘Google_IOException’ with message ‘HTTP Error: (0) Problem with the SSL CA cert (path? access rights?)’ in /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/io/Google_CurlIO.php:123
Stack trace:
#0 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/auth/Google_OAuth2.php(103): Google_CurlIO->makeRequest(Object(Google_HttpRequest))
#1 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google_Client.php(127): Google_OAuth2->authenticate(Array, ‘4/3yQuH16X0IvT9…’)
#2 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/admin/ga_dash_settings.php(572): Google_Client->authenticate(‘4/3yQuH16X0IvT9…’)
#3 [internal function]: GADASH_Settings::general_settings(”)
#4 /home3/golfhsp/public_html/wp-includes/plugin.php(429): call_user_func_array(Array, Array)
#5 /home3/golfhsp/public_html/wp-admin/admin.php(217): do_action(‘toplevel_page_g…’)
#6 {main}

What’s next?

OK, I will let you know the outcome ??

I am a fast learner ??
try, I can get help/ someone else to do it for me if I can’t figure it out.

Could you please tell me how and where to update the script. I am still kind of new to all of this. TA

There is an issue somewhere else. Can you find it?
Thank you in advance. Michaela

Dear Alin,
Just got a reply from the website host. Please see below:
Hi Michaela,
I have gone ahead and updated our test script so that it does the security checks and it still completes without error:

https://golf-hotspots.com/test.php

<?php
$curl = curl_init(‘https://www.google.com&#8217; . ($method == ‘GET’ && $params ? ‘?’ . $params : ”));

curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 1);
$response = curl_exec($curl);

print curl_error($curl);

phpinfo();

OK, will do ??

Alin,
After installing the update this morning still no success. ??
Please see below the reply from Hostgator, the host of the website and further down todays error logg:

Ticket: BJH-27630832
Hello

Thank you for contacting HostGator.

Unfortunately, the issue looks to be in the plugin itself. I say this because I created a test.php file on your account:
https://golf-hotspots.com/test.php

This file uses:

<?php
$curl = curl_init('https://www.google.com' . ($method == 'GET' && $params ? '?' . $params : ''));

curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0);
$response = curl_exec($curl);

print curl_error($curl);

phpinfo();
?>

Using curl to connect to https://www.google.com works without issue, as you can see in the above page that loads the Google search page. I would recommend contacting the developer of the plugin, and let them know that curl_ssl works, as shown in the above link, and request their assistance.

Please feel free to contact us if you have any other questions or concerns.

___________________________________________________________________
Error:
Last Error: exception ‘Google_IOException’ with message ‘HTTP Error: (0) Problem with the SSL CA cert (path? access rights?)’ in /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/io/Google_CurlIO.php:123
Stack trace:
#0 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/auth/Google_OAuth2.php(103): Google_CurlIO->makeRequest(Object(Google_HttpRequest))
#1 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google_Client.php(127): Google_OAuth2->authenticate(Array, ‘4/3yQuH16X0IvT9…’)
#2 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/admin/ga_dash_settings.php(572): Google_Client->authenticate(‘4/3yQuH16X0IvT9…’)
#3 [internal function]: GADASH_Settings::general_settings(”)
#4 /home3/golfhsp/public_html/wp-includes/plugin.php(429): call_user_func_array(Array, Array)
#5 /home3/golfhsp/public_html/wp-admin/admin.php(217): do_action(‘toplevel_page_g…’)
#6 {main}

Thank you very much. I will follow-up with the hosting provider.

Last Error: exception ‘Google_IOException’ with message ‘HTTP Error: (0) Problem with the SSL CA cert (path? access rights?)’ in /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/io/Google_CurlIO.php:123
Stack trace:
#0 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/auth/Google_OAuth2.php(103): Google_CurlIO->makeRequest(Object(Google_HttpRequest))
#1 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/tools/src/Google_Client.php(127): Google_OAuth2->authenticate(Array, ‘4/0QA9IgemBtprP…’)
#2 /home3/golfhsp/public_html/wp-content/plugins/google-analytics-dashboard-for-wp/admin/ga_dash_settings.php(546): Google_Client->authenticate(‘4/0QA9IgemBtprP…’)
#3 [internal function]: GADASH_Settings::general_settings(”)
#4 /home3/golfhsp/public_html/wp-includes/plugin.php(429): call_user_func_array(Array, Array)
#5 /home3/golfhsp/public_html/wp-admin/admin.php(217): do_action(‘toplevel_page_g…’)
#6 {main}

OK, done

Google Analytics Dashboard for WP, version4.2.14 by Alin Marcu