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

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

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

[Wolfe Farms]

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

[kobra]

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

[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)

[Wolfe Farms]

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_LONGMESSAG E0=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