Problem with Paypal connection - Error (28) connect() timed out!

I'm having an issue with my Paypal Express Checkout that I hope someone can give some insight as to where to resolve the issue. I am currently getting a (28) connect() timed out! error when a customer is trying to check out. Everything has been working for the last year and a half and then this issue started yesterday. No changes were made on the Zen-Cart configuration or on the Paypal side of things, so I'm at a loss as to where to look. My site is hosted on GoDaddy and I opened a support ticket yesterday, but so far their support responses have been pretty useless. Here is the error message that is captured in the log file for reference:

2011-03-25 07:11:51

(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 45
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP
[4] => X-VPS-VIT-Integration-Version: 1.3.8a
)

Request Parameters: {SetExpressCheckout}
Array
(
[LOCALECODE] => US
[PAYMENTACTION] => Sale
[ADDROVERRIDE] => 1
[SHIPTONAME] => [Removed]
[SHIPTOSTREET] => [Removed]
[SHIPTOCITY] => [Removed]
[SHIPTOZIP] => [Removed]
[SHIPTOSTATE] => [Removed]
[SHIPTOCOUNTRYCODE] => US
[EMAIL] => [Removed]
[PHONENUM] => [Removed]
[AMT] => [Removed]
[RETURNURL] => [Removed]
[CANCELURL] => [Removed]
[PAGESTYLE] => Primary
[METHOD] => SetExpressCheckout
[CURRENCYCODE] => USD
[USER] => [Removed]
[PWD] => ****************
[VERSION] => 3.2
[SIGNATURE] => ****************************************************53.r
)

Response:
Array
(
[] =>
[CURL_ERRORS] => (28) connect() timed out!
)

(28) connect() timed out!
Array
(
[url] => https://api-3t.paypal.com/nvp
[content_type] =>
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0
[namelookup_time] => 0.006837
[connect_time] => 0
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0
[redirect_time] => 0
)

SetExpressCheckout, Elapsed: 60005ms -- Failed
(28) connect() timed out!
Array
(
[url] => https://api-3t.paypal.com/nvp
[content_type] =>
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0
[namelookup_time] => 0.006837
[connect_time] => 0
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0
[redirect_time] => 0
)

I appreciate any assistance you gave provide.

Thanks,

James

check what the max exec time is for php

admin > tools > version/server info

Hi Kobra,

Here is the setting:

max_execution_time
Local Value = 60
Master Value = 30

Let me know if you need any other information.

Thanks for the help.

James

Here's another error that comes up on the site when trying to get to Paypal that may help identify the issue:

2006 MySQL server has gone away
in:
[select customers_email_format from zen_customers where customers_email_address= '[REMOVED]']
2006 MySQL server has gone away
in:
[select count(*) as total from zen_sessions where sesskey = '[REMOVED]']

Basically, I do not advocate using GD as a host for any "serious" business. They make a bevy of issues for anyone that does attempt to use them

Just search this forum for their name

you can test 'curl" by using this tester that is in the /extras folder - - just insert your domain/cart path

http://yourdomain.xxx/extras/curltester.php

Hi Kobra,

I ran the curltest.php from my site with the following results:

CURL Test Page
This page is intended for testing CURL behaviour. You should be accessing this page via CURLTESTER.PHP running on YOUR server.

You submitted the following fields and data:

Array
(
[field1] => This is a test
[statuskey] => ready
)

Data validation
Good
Other Info
Your server IP address is: [REMOVED].
user-agent: unknown.

Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] => text/html
[http_code] => 200
[header_size] => 275
[request_size] => 174
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.58755
[namelookup_time] => 0.00961
[connect_time] => 0.296544
[pretransfer_time] => 0.296613
[size_upload] => 0
[size_download] => 2144
[speed_download] => 3649
[speed_upload] => 0
[download_content_length] => 2144
[upload_content_length] => 0
[starttransfer_time] => 0.587433
[redirect_time] => 0
)

Does this mean that the CURL communication is getting through?

It does not appear to be successfully uploading

This is what I get for comparison

You submitted the following fields and data:

Array
(
    [field1] => This is a test
    [statuskey] => ready
)

Data validation
Good
Other Info
Your server IP address is: xx.xx.xx.xx.
Your system identifies itself as: Zen Cart(tm) - CURL TEST

Array
(
    [url] => "http://www.zen-cart.com/testcurl.php"
    [content_type] => text/html
    [http_code] => 200
    [header_size] => 275
    [request_size] => 212
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.123369
    [namelookup_time] => 0.002418
    [connect_time] => 0.036928
    [pretransfer_time] => 0.036937
    [size_upload] => 37
    [size_download] => 2181
    [speed_download] => 17678
    [speed_upload] => 299
    [download_content_length] => 2181
    [upload_content_length] => 0
    [starttransfer_time] => 0.123281
    [redirect_time] => 0

kobra:

It does not appear to be successfully uploading

Kobra,

So would this be an issue with GD blocking the CURL from sending data up to an external site, such as PayPal? I'm just trying to get to the source of the problem so I can deal with it. GD technical support so far has not been technical or supportive of the issue. I'm hoping that the more information I can throw at them, the better my chances are of getting it resolved.

Thanks for the help thus far. It's really appreciated.

James

One who knows what that test is requesting intimately will have to happen by

As far as GD support - - always kick it up higher right off

Try running it as: curltester.php?paypal=1 to test connecting specifically to PayPal, and post the results.

Granted, that's not going to do anything more than give you something to show the slow folks at GD that there's really something wrong. I wouldn't be surprised that it tells you the same thing you're already seeing in your logs: an error code of "28 connect timed out", which is all GD should need.

Also, I note that your post said you were using "curltest.php", which tells me you're using an old version of Zen Cart with some publicly-known security vulnerabilities. It would be wise to be upgrading ASAP.

Also, do you have "CURL Proxy Status" turned off under Admin->Configuration->My Store? If not, it NEEDS to be off. It was only ever added because GD used to configure their servers in a very bizarre non-standard way for talking to external services. Now they've removed that need. Their overall server config is still bunk, but at least the proxy is no longer needed (as of about 2 years ago)

DrByte:

Try running it as: curltester.php?paypal=1 to test connecting specifically to PayPal, and post the results.

Granted, that's not going to do anything more than give you something to show the slow folks at GD that there's really something wrong. I wouldn't be surprised that it tells you the same thing you're already seeing in your logs: an error code of "28 connect timed out", which is all GD should need.

Also, I note that your post said you were using "curltest.php", which tells me you're using an old version of Zen Cart with some publicly-known security vulnerabilities. It would be wise to be upgrading ASAP.

Also, do you have "CURL Proxy Status" turned off under Admin->Configuration->My Store? If not, it NEEDS to be off. It was only ever added because GD used to configure their servers in a very bizarre non-standard way for talking to external services. Now they've removed that need. Their overall server config is still bunk, but at least the proxy is no longer needed (as of about 2 years ago)

Hi DrByte,

Thanks for the input. I did still have the CURL proxy on set to True, so I've set that to False. I'm still using ZenCart 1.3.8a, so I will have to look in to what it will take to upgrade to the newest version. I ran the curltest.php?paypal=1 and here are the results:

Array
(
[url] => "https://api-3t.paypal.com/nvp"
[content_type] => text/plain; charset=utf-8
[http_code] => 200
[header_size] => 153
[request_size] => 166
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.118733
[namelookup_time] => 0.00685
[connect_time] => 0.014275
[pretransfer_time] => 0.045533
[size_upload] => 0
[size_download] => 146
[speed_download] => 1229
[speed_upload] => 0
[download_content_length] => 146
[upload_content_length] => 0
[starttransfer_time] => 0.118649
[redirect_time] => 0
)

ACK=Failure&L_ERRORCODE0=81002&L_SHORTMESSAGE0=Unspecified%20Method&L_LONGMESSAGE0=Method%20Specified%20is%20not%20Supported&L_SEVERITYCODE0=ErrorEOF

I hope this sheds some light on the issue. Let me know if there is anything else I can do on my end besides waiting for GD to respond.

Thanks again,

James

ACK=Failure&L_ERRORCODE0=81002&L_SHORTMESSAGE0=Unspecified%20Method&L_LONGMESSAG E0=Method%20Specified%20is%20not%20Supported&L_SEVERITYCODE0=ErrorEOFOkay, so that response actually comes from PayPal's server, so the script is able to talk to PayPal's server fine.

I suspect your incorrect proxy status setting was what was causing the problem. Time to do a test transaction of your own.

DrByte,

You hit the nail on the head. After setting the Curl Proxy to False, it allowed the checkout to pass to Paypal. This hadn't been an issue until yesterday, so perhaps GD just shut down the proxy server that was handling those calls.

I'm going to spend some time this weekend upgrading the Zen-Cart to the current version. I just need to make sure that the customization that have been made are not wiped out when I do it. I have a test site that I will practice on first to see what issue arise. I'll be reading through the forum to see what I should look out for before I get started.

Thank you for the help. It is really appreciated.

James

Upgrade guidance is posted here:
https://www.zen-cart.com/tutorials/index.php?article=98
https://www.zen-cart.com/tutorials/index.php?article=108

I am getting the same error now, however when I go to /extras/curltester.php?paypal=1 I am getting a 404 error

Our Apache was recently upgraded and I bet our hosting company left the curl off of it, because other scripts are having issues too. I will verify this.

I'm running 1.3.9h. All has been good until a few days ago when I got a notice for the same Error Code... I'm hosted by POWWEB.
My Curl Proxy is, and has always been set to False. I've made no updates or upgrades recently.
I ran curltester.php and this was the result:

You submitted the following fields and data:
Array
(
[field1] => This is a test
[statuskey] => ready
)
Data validation
Good
Other Info
Your server IP address is: xx.xxx.xx.xxx.
Your system identifies itself as: Zen Cart(tm) - CURL TEST
Copyright © 2003 - 2013 Zen Ventures, LLC - Powered by Zen Cart™
Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] => text/html
[http_code] => 200
[header_size] => 179
[request_size] => 212
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.148173
[namelookup_time] => 0.032615
[connect_time] => 0.089501
[pretransfer_time] => 0.089519
[size_upload] => 37
[size_download] => 2182
[speed_download] => 14726
[speed_upload] => 249
[download_content_length] => 2182
[upload_content_length] => 0
[starttransfer_time] => 0.148015
[redirect_time] => 0
)

I'm not sure how to read this data?? But I do know my site is still down...please HELP..

Courage9:

I'm running 1.3.9h.... I ran curltester.php

[url] => "http://www.zen-cart.com/testcurl.php"

testcurl.php is not the file included with 1.3.9h
It is located here /extras/curltester.php

OK...I'll find the correct one and run it.

I couldn't find my original file "extras". I believe I deleted that file on the server years ago. I found my zen zip files for the 1.3.9h and extracted the extras folder and added it to my server. I then ran the curltester.php from the server location and this was what came back:

CURL Test Page
This page is intended for testing CURL behaviour. You should be accessing this page via CURLTESTER.PHP running on YOUR server.

You submitted the following fields and data:
Array
(
[field1] => This is a test
[statuskey] => ready
)
Data validation
Good
Other Info
Your server IP address is: xx.xxx.xxx.35.
Your system identifies itself as: Zen Cart(tm) - CURL TEST
Copyright © 2003 - 2013 Zen Ventures, LLC - Powered by Zen Cart™
Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] => text/html
[http_code] => 200
[header_size] => 179
[request_size] => 212
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.127616
[namelookup_time] => 0.014915
[connect_time] => 0.0705
[pretransfer_time] => 0.070516
[size_upload] => 37
[size_download] => 2182
[speed_download] => 17098
[speed_upload] => 289
[download_content_length] => 2182
[upload_content_length] => 0
[starttransfer_time] => 0.127475
[redirect_time] => 0
)