Why SSL Error Message?

[Mike Enos]

Hi,

On my local Windows 10 XAMPP system, I often getting this SSL message error

The script runs fine on my web server, but not locally    

See screenshot at  https://www.screencast.com/t/t4Vdahnc4GF

Any ideas what I'm doing wrong?

Thanks!!

( ! ) Fatal error: Uncaught exception 'RuntimeException' with message ' in C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Exception\RequestException.php on line 52
( ! ) RuntimeException: Error creating resource: [message] fopen(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 [message] fopen(): Failed to enable crypto [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 [message] fopen(https://adwords.google.com/api/adwords/reportdownload/v201708): failed to open stream: operation failed [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 in C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php on line 252
Call Stack
#	Time	Memory	Function	Location
1	0.4105	211680	{main}( )	...\cron_Update_mastercampaign.php:0
2	3.1033	826992	Google\AdsApi\Examples\AdWords\v201708\Reporting\RunAWQLQuery( )	...\cron_Update_mastercampaign.php:90
3	3.1033	827064	Google\AdsApi\Examples\AdWords\v201708\Reporting\DownloadCriteriaReportWithAwql::main( )	...\ProcessAWQLStatement.php:127
4	3.2134	1617584	Google\AdsApi\Examples\AdWords\v201708\Reporting\DownloadCriteriaReportWithAwql::runExample( )	...\ProcessAWQLStatement.php:115
5	3.3934	2779568	Google\AdsApi\AdWords\Reporting\v201708\ReportDownloader->downloadReportWithAwql( )	...\ProcessAWQLStatement.php:90
6	4.0843	3066528	Google\AdsApi\AdWords\Reporting\v201708\ReportDownloader->makeReportRequest( )	...\ReportDownloader.php:127
7	4.0844	3067120	GuzzleHttp\Client->request( )	...\ReportDownloader.php:146
8	4.0844	3067616	GuzzleHttp\Client->requestAsync( )	...\Client.php:131
9	4.0853	3073736	GuzzleHttp\Client->transfer( )	...\Client.php:125
10	4.0871	3080656	GuzzleHttp\HandlerStack->__invoke( )	...\Client.php:277
11	4.0872	3082016	Google\AdsApi\Common\GuzzleLogMessageHandler::Google\AdsApi\Common\{closure}( )	...\HandlerStack.php:67
12	4.0872	3082032	GuzzleHttp\Middleware::GuzzleHttp\{closure}( )	...\GuzzleLogMessageHandler.php:41
13	4.0873	3082032	GuzzleHttp\RedirectMiddleware->__invoke( )	...\Middleware.php:59
14	4.0873	3083144	GuzzleHttp\Middleware::GuzzleHttp\{closure}( )	...\RedirectMiddleware.php:70
15	4.0873	3083144	GuzzleHttp\PrepareBodyMiddleware->__invoke( )	...\Middleware.php:30
16	4.0884	3089104	GuzzleHttp\Handler\Proxy::GuzzleHttp\Handler\{closure}( )	...\PrepareBodyMiddleware.php:66
17	4.0884	3089240	GuzzleHttp\Handler\StreamHandler->__invoke( )	...\Proxy.php:52
18	4.0885	3089424	GuzzleHttp\Handler\StreamHandler->createStream( )	...\StreamHandler.php:52
19	4.0891	3097456	GuzzleHttp\Handler\StreamHandler->createResource( )	...\StreamHandler.php:336
( ! ) GuzzleHttp\Exception\RequestException: Error creating resource: [message] fopen(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 [message] fopen(): Failed to enable crypto [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 [message] fopen(https://adwords.google.com/api/adwords/reportdownload/v201708): failed to open stream: operation failed [file] C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Handler\StreamHandler.php [line] 324 in C:\DataH\xampp\htdocs\vendor\guzzlehttp\guzzle\src\Exception\RequestException.php on line 52
Call Stack
#	Time	Memory	Function	Location
1	0.4105	211680	{main}( )	...\cron_Update_mastercampaign.php:0
2	3.1033	826992	Google\AdsApi\Examples\AdWords\v201708\Reporting\RunAWQLQuery( )	...\cron_Update_mastercampaign.php:90
3	3.1033	827064	Google\AdsApi\Examples\AdWords\v201708\Reporting\DownloadCriteriaReportWithAwql::main( )	...\ProcessAWQLStatement.php:127
4	3.2134	1617584	Google\AdsApi\Examples\AdWords\v201708\Reporting\DownloadCriteriaReportWithAwql::runExample( )	...\ProcessAWQLStatement.php:115
5	3.3934	2779568	Google\AdsApi\AdWords\Reporting\v201708\ReportDownloader->downloadReportWithAwql( )	...\ProcessAWQLStatement.php:90
6	4.0843	3066528	Google\AdsApi\AdWords\Reporting\v201708\ReportDownloader->makeReportRequest( )	...\ReportDownloader.php:127
7	4.0844	3067120	GuzzleHttp\Client->request( )	...\ReportDownloader.php:146
8	4.7725	3197032	GuzzleHttp\Promise\Promise->wait( )	...\Client.php:131
9	4.7812	3210240	GuzzleHttp\Promise\RejectedPromise->wait( )	...\Promise.php:65

[Sreelakshmi Sasidharan (AdWords API Team)]

Hi Mike, 

It looks like an issue with your SSL certificates. Could you please create an issue on the PHP issues tracker? The library owner is better equipped to address this question.

Thanks,
Sreelakshmi, AdWords API Team

[Mike Enos]

I found the solution at:

https://ourcodeworld.com/articles/read/196/xampp-wampp-php-ssl-certificate-error-unable-to-get-local-issuer-certificate

I had updated PHP. It seems that php 5.6X  has a verify ssl cert. Just a few changes to my php.ini and everything is great.

Live is Good!

[Mayank Upadhyay]

Thanks MIKE ,I was looking for the solution since last two days.

Glad I found this discussion.