CURL Error 28

[astm0652]

Hi Guys,

PHP Version: 5.4.45
Zen Cart Version: 1.5.1
Database: MySQL 5.5
Server OS: Linux
HTTP Server: Apache/2.4.43
Godaddy VPS
Site URL:adulttoyssupermart.com


My site was working fine for over a 1 year, and for the past week my credit card transaction through PayPal express is not appearing in my Zen Cart admin but appearing in PayPal. I took a look at the debug file and i see this error message CURL Error 28. Can someone look at the attached debug file and let me know how to fix this. It will be well appreciated!

[astm0652]

Any help with this thread?

More info:

curltester.php


Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] =>
[http_code] => 301
[header_size] => 373
[request_size] => 212
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.163397
[namelookup_time] => 0.053317
[connect_time] => 0.105027
[pretransfer_time] => 0.105128
[size_upload] => 37
[size_download] => 0
[speed_download] => 0
[speed_upload] => 226
[download_content_length] => -1
[upload_content_length] => 37
[starttransfer_time] => 0.163328
[redirect_time] => 0
[certinfo] => Array
(
)

[primary_ip] => 172.67.134.32
[primary_port] => 80
[local_ip] => 198.12.152.24
[local_port] => 34892
[redirect_url] => https://www.zen-cart.com/testcurl.php
)



curltester.php?paypal=1



4 OpenSSL was built without SSLv3 support
Array
(
[url] => "https://api-3t.paypal.com/nvp"
[content_type] =>
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 1
[redirect_count] => 0
[total_time] => 0.059446
[namelookup_time] => 0.001015
[connect_time] => 0.059314
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => -1
[upload_content_length] => -1
[starttransfer_time] => 0
[redirect_time] => 0
[certinfo] => Array
(
)

[primary_ip] => 173.0.88.69
[primary_port] => 443
[local_ip] => 198.12.152.24
[local_port] => 59854
[redirect_url] =>
)



EOF





curltester.php?ssl=1



4 OpenSSL was built without SSLv3 support
Array
(
[url] => "https://www.zen-cart.com/testcurl.php"
[content_type] =>
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 1
[redirect_count] => 0
[total_time] => 0.105916
[namelookup_time] => 0.054076
[connect_time] => 0.10578
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => -1
[upload_content_length] => -1
[starttransfer_time] => 0
[redirect_time] => 0
[certinfo] => Array
(
)

[primary_ip] => 104.28.7.98
[primary_port] => 443
[local_ip] => 198.12.152.24
[local_port] => 48686
[redirect_url] =>
)

[DrByte]

You're going to find it increasingly difficult to support your old PHP 5.4 server as time goes along. PHP 5.4 has been obsolete for a couple years already. Out-of-the-box it has no awareness of the modern TLS methods for talking to servers (maybe GoDaddy has patched it somehow, I dunno?)

The "OpenSSL wasn't compiled with SSLv3" errors are simply a reflection that the curltester you're using is trying to use a completely outdated type of SSL/TLS connection. You might try grabbing the latest from https://github.com/zencart/zencart/tree/v157/extras and try again.

CURL error 28 means "operation timed out" ... meaning, in theory, "we tried to connect to PayPal to make a transaction, but the connection didn't complete in the allowed timeframe" ... where the timeframe is typically 6-10 seconds ... which is a LONG time just to connect.

"why" it's timing out is indeed the thing you need to chase down.
It could be your server.
It could be your PHP version.
It could be firewalls.
It could be PayPal is rejecting your incoming transaction requests because they're coming from a format they no longer support. That wouldn't surprise me given you're using ZC v1.5.1 which was released in 2012.
While, yes, I'll absolutely advocate that you should be upgrading, I realize that's not a helpful statement when you just want transactions to work again. It would indeed be helpful to know exactly "why" in order to be certain that upgrading is the key step or not. Upgrading should still be done, but I agree it'd be helpful to get payments working first if possible and then spend time on an upgrade while transactions are still happening.

[astm0652]

Thank you for replying. I got my work cut out for me lol, i'll keep you posted.

Thank You Again!

[astm0652]

New curltester.php


Connection uses TLS 1.3

Testing communications to various destinations. This is a simple diagnostic to determine whether your server can connect to common destinations.
For advanced "details" mode, add ?details=on to the URL.

(Another resource you may find useful for testing your server's overall customer-facing SSL configuration: https://www.ssllabs.com/ssltest/index.html )

Connecting to Zen Cart Version Server (http) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Version Server (https) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Support Server (https) ...
GOOD: CURL Connection successful.

Connecting to USPS (port 80)...
GOOD: CURL Connection successful.

Connecting to USPS Test/Staging/Sandbox Server (port 80)...
GOOD: CURL Connection successful.

Connecting to UPS (port 80)...
GOOD: CURL Connection successful.

GOOD: Socket established

Connecting to UPSXML (onlinetools.ups.com) ...
GOOD: CURL Connection successful.

Connecting to UPSXML (sandbox) ...
GOOD: CURL Connection successful.

Connecting to FedEx (port 80)...
GOOD: Socket established

Connecting to Canada Post SellOnline HTTP/S ...
GOOD: CURL Connection successful.

Connecting to Canada Post REST API (SSL) ...
GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443)...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443) Sandbox ...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Sandbox ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Pilot/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to PayPal TLSTest Server ...
Error 6: Could not resolve host: tlstest.paypal.com

Connecting to Cardinal Commerce 3D-Secure Server ...
GOOD: CURL Connection successful.

Connecting to Square Payments Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Production Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Developer/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to First Data GGe4 server (SSL)...
GOOD: CURL Connection successful.

Connecting to Elavon Server...
GOOD: CURL Connection successful.

Connecting to Elavon Sandbox Server...
GOOD: CURL Connection successful.

Testing completed. See results above.



curltester.php?paypal=1


Connection uses TLS 1.3

Testing communications to various destinations. This is a simple diagnostic to determine whether your server can connect to common destinations.
For advanced "details" mode, add ?details=on to the URL.

(Another resource you may find useful for testing your server's overall customer-facing SSL configuration: https://www.ssllabs.com/ssltest/index.html )

Connecting to Zen Cart Version Server (http) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Version Server (https) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Support Server (https) ...
GOOD: CURL Connection successful.

Connecting to USPS (port 80)...
GOOD: CURL Connection successful.

Connecting to USPS Test/Staging/Sandbox Server (port 80)...
GOOD: CURL Connection successful.

Connecting to UPS (port 80)...
GOOD: CURL Connection successful.

GOOD: Socket established

Connecting to UPSXML (onlinetools.ups.com) ...
GOOD: CURL Connection successful.

Connecting to UPSXML (sandbox) ...
GOOD: CURL Connection successful.

Connecting to FedEx (port 80)...
GOOD: Socket established

Connecting to Canada Post SellOnline HTTP/S ...
GOOD: CURL Connection successful.

Connecting to Canada Post REST API (SSL) ...
GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443)...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443) Sandbox ...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Sandbox ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Pilot/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to PayPal TLSTest Server ...
Error 6: Could not resolve host: tlstest.paypal.com

Connecting to Cardinal Commerce 3D-Secure Server ...
GOOD: CURL Connection successful.

Connecting to Square Payments Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Production Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Developer/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to First Data GGe4 server (SSL)...
GOOD: CURL Connection successful.

Connecting to Elavon Server...
GOOD: CURL Connection successful.

Connecting to Elavon Sandbox Server...
GOOD: CURL Connection successful.

Testing completed. See results above.



curltester.php?ssl=1



Connection uses TLS 1.3

Testing communications to various destinations. This is a simple diagnostic to determine whether your server can connect to common destinations.
For advanced "details" mode, add ?details=on to the URL.

(Another resource you may find useful for testing your server's overall customer-facing SSL configuration: https://www.ssllabs.com/ssltest/index.html )

Connecting to Zen Cart Version Server (http) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Version Server (https) ...
GOOD: CURL Connection successful.

Connecting to Zen Cart Support Server (https) ...
GOOD: CURL Connection successful.

Connecting to USPS (port 80)...
GOOD: CURL Connection successful.

Connecting to USPS Test/Staging/Sandbox Server (port 80)...
GOOD: CURL Connection successful.

Connecting to UPS (port 80)...
GOOD: CURL Connection successful.

GOOD: Socket established

Connecting to UPSXML (onlinetools.ups.com) ...
GOOD: CURL Connection successful.

Connecting to UPSXML (sandbox) ...
GOOD: CURL Connection successful.

Connecting to FedEx (port 80)...
GOOD: Socket established

Connecting to Canada Post SellOnline HTTP/S ...
GOOD: CURL Connection successful.

Connecting to Canada Post REST API (SSL) ...
GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443)...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal IPN (port 443) Sandbox ...
GOOD: Socket established

GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Express/Pro Sandbox ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Server ...
GOOD: CURL Connection successful.

Connecting to PayPal Payflowpro Pilot/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to PayPal TLSTest Server ...
Error 6: Could not resolve host: tlstest.paypal.com

Connecting to Cardinal Commerce 3D-Secure Server ...
GOOD: CURL Connection successful.

Connecting to Square Payments Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Production Server ...
GOOD: CURL Connection successful.

Connecting to AuthorizeNet Developer/Sandbox Server ...
GOOD: CURL Connection successful.

Connecting to First Data GGe4 server (SSL)...
GOOD: CURL Connection successful.

Connecting to Elavon Server...
GOOD: CURL Connection successful.

Connecting to Elavon Sandbox Server...
GOOD: CURL Connection successful.

Testing completed. See results above.

[DrByte]

for the past week my credit card transaction through PayPal express is not appearing in my Zen Cart admin but appearing in PayPal.

Please clarify. Are you saying "purchases work correctly, but in my Zen Cart Admin I can see the orders but I can no longer inspect details of Express Checkout payments"?

[astm0652]

Orders that are paid by credit card are not showing in new orders in admin, but PayPal has the order information and not me.

[DrByte]

Orders that are paid by credit card are not showing in new orders in admin, but PayPal has the order information and not me.

That's symptomatic of whatever PHP errors are occurring when submitting the transaction. If PayPal has the details (ie: the payment) but your store does not then it means a PHP fatal error happened after/during the transaction response and the store wasn't able to finish saving the order or sending the emails.

Normally Zen Cart will log fatal PHP errors in the /logs/ directory.
If those logs are indicating CURL problems, you'll probably need to work with your hosting company to sort that out.

[astm0652]

I'm going to check the error the logs. Does this help to solving the problem?

ACK=Failure&L_ERRORCODE0=81002&L_SHORTMESSAGE0=Unspecified%20Method&L_LONGMESSAG E0=Method%20Specified%20is%20not%20Supported&L_SEVERITYCODE0=Error


Thank You DrByte

[DrByte]

I'm going to check the error the logs. Does this help to solving the problem?

ACK=Failure&L_ERRORCODE0=81002&L_SHORTMESSAGE0=Unspecified%20Method&L_LONGMESSAG E0=Method%20Specified%20is%20not%20Supported&L_SEVERITYCODE0=Error

Not really.

81002 is a very generic PayPal error that suggests the request being transmitted is malformed and doesn't make sense to them.
But that would be completely different from a CURL error 28 which means connection timed out, because if it's timed out then it's not getting a response.