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

[Wolfe Farms]

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

[kobra]

check what the max exec time is for php

admin > tools > version/server info

[Wolfe Farms]

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

[Wolfe Farms]

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]']

[kobra]

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

[Wolfe Farms]

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?

[kobra]

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

[Courage9]

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

[Courage9]

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
)

[DrByte]

If you don't add ?paypal=1 to the curltester URL, then it won't test PayPal for you.

Use: /extras/curltester.php?paypal=1

Explained here: http://www.zen-cart.com/showthread.p...-Testing-Tools


A (28) Connect timed out message is ALWAYS a hosting problem, if you've properly got the CURL Proxy disabled. Especially if it "suddenly" breaks. Your hosting company will need to fix it.