Google Analytics Dashboard for WP authentication not possible

Press the Show Log link from General Settings -> Debugging Data and post your Last Error here.

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}

Hi,

There is a CURL issue, a problem with the SSL CA cert setup (path or access rights), please ask your hosting provider to properly configure PHP CURL for HTTPS requests (this may also come handy: https://stackoverflow.com/questions/7179216/php-problem-with-the-ssl-ca-cert-path-access-rights )

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

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}

OMG, of course it works because they intentionally disable security checks, CURLOPT_SSL_VERIFYPEER with curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0) and curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0);;

We are working here with authorization codes and account access codes, setting that to 0 is insecure and can result in a man-in-middle attack!

Please send them my answer! Linux System Administrator II, huh?!

@esmi or any other mod: Removing the signature from the above mail would be nice, just to keep mail privacy intact ??

OK, will do ??

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();

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

If you have time, update the script to this:

<?php
$curl = curl_init('https://accounts.google.com');
curl_setopt($curl, CURLOPT_STDERR, $f = fopen('curl.log', "w+"));
curl_setopt($curl, CURLOPT_VERBOSE, TRUE);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 1);
$response = curl_exec($curl);

print curl_error($curl);

I’m curious to see if the certificate gets verified.

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

https://support.hostgator.com/articles/cpanel/how-to-createeditdelete-a-file-using-the-file-manager

But i don’t know if that’s a good ideea if you’re a beginner.

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