cURL connection errors - PayPal IPN fails - on new IIS7 server

Hi all,

I've transferred my site from IIS6 to a new IIS 7 server and the PayPal IPN promptly failed. It still takes the money, but the orders don't have any products so I don't know what has been ordered.

So today I decided to try installing a fresh Zen Cart just to see if it would give me any useful error messages... and it has:

CURL problems detected: 28 => Operation timed out after 4 seconds with 0 bytes received more info...
CURL requires SSL support. Please notify webmaster or hosting company. 28 => Operation timed out after 4 seconds with 0 bytes received more info...

and then the same two errors again.

Another test, the extras/curltest.php page results in a timeout.

Then I read this thread and added ?paypal=1 to the test.

That resulted in this:

Array
(
[url] => "https://api-3t.paypal.com/nvp"
[content_type] => text/plain; charset=utf-8
[http_code] => 200
[header_size] => 215
[request_size] => 166
[filetime] => -1
[ssl_verify_result] => 19
[redirect_count] => 0
[total_time] => 2.028
[namelookup_time] => 0.041
[connect_time] => 0.078
[pretransfer_time] => 1.926
[size_upload] => 0
[size_download] => 146
[speed_download] => 71
[speed_upload] => 0
[download_content_length] => 146
[upload_content_length] => 0
[starttransfer_time] => 2.027
[redirect_time] => 0
)

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

In that other thread DrByte says that this error is from paypal and is what one would want to see.

So, if that is the case then how do I stop these cURL errors on the installer? The rest of the thread gives no further clues.

Any advice is much appreciated.
Rob

Is this your server or a hosted server?

The PayPal IPN in v1.3.x doesn't use CURL for anything, so that's a red herring.

You need to make sure your new server can receive communication from PayPal, as well as initiate it: http://www.zen-cart.com/wiki/index.php/PayPal

As to CURL in the zc_install process, it uses the same code as curltest.php does, but without the ?paypal=1 on it.

DrByte,

Just to confirm:

If I'm only using PayPal IPN for payments then can I safely dismiss the CURL errors as causing the orders to show no products after returning from Paypal?

And related:

I'm still unsure if all of this means CURL is working or not.

I read somewhere that the next ZC will require CURL. As well, I want to use the "AustPost Improved" contribution and I am of the impression that CURL is required for that.

Therefore I sort of need to know if it is working or if not then I need to find out why and fix it.

Thanks for any further advice on this. I'll go and run back through the Paypal connections page now as well.

Rob

kobra:

Is this your server or a hosted server?

Hi Kobra,

Yes, the server is mine, as in - it's a brand new fully dedicated server at Server Intellect. It's running 64 bit Server 2008 and I've installed MySQL and PHP on it to run my ZC store.

The old IIS6 server was a VPS on Server 2003 which I have full remote desktop control over as well. That account expires in a week and I'm fast running out of options.

I really need to find someone who is running Zen Cart with Paypal IPN successfully on IIS7... and then perhaps compare the configuration.

Here's the PHPinfo in case anyone can spot anything obvious: http://wonderwebs.net/phpinfo.php

Regards,
Rob

Is this Dedi soley for your Zen Cart or do you have other win specific apps that require Win2003?

If no other apps you might consider converting it to a Linux base as Zen Cart excells in that environment.

Your phpinfo states cURL support enabled

kobra:

Is this Dedi soley for your Zen Cart or do you have other win specific apps that require Win2003?

If no other apps you might consider converting it to a Linux base as Zen Cart excells in that environment.

Your phpinfo states cURL support enabled

Hi kobra,
Yes, I primarily host Dotnetnuke systems and require the MS gear. Both Server 2003 and 2008 are fully capable of running Zen Cart however and the problem lies somewhere in a configuration option.

I'm at least in the correct forum for it :)

Regards,
Rob

Using http://wonderwebs.net/zencart/extras/curltest.php, it seems your CURL support works fine to talk to paypal and authorize.net and linkpoint, but it doesn't seem to be able to reach the zen-cart.com server to get a response from a plain curl test, such as curltest.php uses without any parameters.
I suspect your CURL functionality is probably fine. I have no idea why your server can't talk to the Zen Cart server ... unless the IP address you're on has been blocked due to excessive spam at some point. Nevertheless, CURL support appears to be active. I can't vouch for the austpost mod, as I've never used it.

robax:

... the PayPal IPN promptly failed. It still takes the money,
If it's taking the money but your store is never adding the order to its database, that means that the IPN communication from PayPal's server to your server is failing.

As is mentioned in the wiki article I posted earlier, there are all kinds of reasons for that to fail. Turn on the debug log-to-file, and post a link to a zipped copy of the logs you collect when doing a test transaction.

Was there a PHP version difference between the old and new servers? What were the versions? How about MySQL versions?

robax:

...but the orders don't have any products so I don't know what has been ordered.If you're referring to the PayPal email receipt, that's normal. The IPN-initiated transactions don't currently include line-item details ... by design.

DrByte:

Using http://wonderwebs.net/zencart/extras/curltest.php, it seems your CURL support works fine to talk to paypal and authorize.net and linkpoint, but it doesn't seem to be able to reach the zen-cart.com server to get a response from a plain curl test, such as curltest.php uses without any parameters.
I suspect your CURL functionality is probably fine. I have no idea why your server can't talk to the Zen Cart server ... unless the IP address you're on has been blocked due to excessive spam at some point.

Thanks again very much for the replies.

I'm going to put a ticket in with Server Intellect in a moment and point them to the thread.

If the ip was blocked, would I be able to access the Zen cart site at all from the server? I have tried opening http://www.zen-cart.com/testcurl.php directlly in a browser and it loads a green page as follows:

CURL Test Page
This page is intended for testing CURL behaviour. You should be accessing this page via CURLTEST.PHP running on YOUR server.
You submitted the following fields and data:
PROBLEM: No POST data received.
Data validation
failed to receive expected statuskey
Other Info
Your server IP address is: 75.126.107.229.
Your system identifies itself as: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; .NET CLR 3.5.30729)

If that page is accessible from the server's web browser, then does that mean it should also work via curltest.php running off the same server/ip?

Or is the curltest.php using a special port that I could check for. I've read that it wants 80 or 443 and as far as I can tell they are both open both ways.

Rob

robax:

If the ip was blocked, would I be able to access the Zen cart site at all from the server?
No, you couldn't.

robax:

If that page is accessible from the server's web browser, then does that mean it should also work via curltest.php running off the same server/ip?Yes, it should.

robax:

Or is the curltest.php using a special port that I could check for. I've read that it wants 80 or 443 and as far as I can tell they are both open both ways.
It's using port 80 for non-SSL and 443 for SSL, which are normal web traffic.

28 => Operation timed out after 4 seconds with 0 bytes received
Your hosting company is going to have to sort out whatever is causing the timeout problems.

DrByte:

Your hosting company is going to have to sort out whatever is causing the timeout problems.

Hi DrByte,

The host checked and found no connectivity problems at thei end, but he did say that a trace to the ZC site was being slow and that I should increase the timeout for the test.

So I edited the file and set it to 60 seconds and sure enough, it now gives a valid result... generally after about 18 seconds.

I've fired another ticket off to determine why it would take so long from my new server in Dallas when my old server in LA does it in a couple hundred ms.

I'll post what I find out.

The good news is that I can now begin to troubleshoot the PayPal issue without these other worries :smile:

The AustPost contribution also works now thanks to some help in anoth thread. That was not due to CURL but a possible bug and a wrong address.

Regards,
Rob

Hopefully you can help diagnose the response below:

Array
(
[url] => "http://www.zen-cart.com/testcurl.php"
[content_type] => text/html
[http_code] => 200
[header_size] => 139
[request_size] => 174
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
** [total_time] => 18.302**
[namelookup_time] => 0.278
[connect_time] => 0.29
[pretransfer_time] => 0.29
[size_upload] => 0
[size_download] => 2142
[speed_download] => 117
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 18.302
[redirect_time] => 0
)

The problem being the 18 second total load time. I'm not sure if this would be something in the Zen cart configuration or in IIS7. Doesn't appear to be network related; all pings/tracerts come back with minimal latency.

Are there any key spots in the IIS7/Curl configuration I should check that would cause slow communication with the Zen server?

Thanks

The server at zen-cart.com is much like any other webserver.
There's no known reason for why IIS7 would connect to it any differently than any other server would.

Thanks for the replies DrByte,

My host has thus far been unable to determine why the connection specifically to zen-cart.com has a delay in it. I've checked repeatedly with Firebug and Yslow and have also drawn a blank. Individual page items either load in less than 400ms or have a fixed delay of 15-18 seconds. Originally I thought this to be affecting only the curltest.php, but then I realised it was the entire zen-cart.com website.

Even so, that may not affect the Paypal issues and so I've been busy troubleshooting that and have posted a new thread with full details and logs here:

http://www.zen-cart.com/forum/showthread.php?p=645687

Thank you for any advice on that thread as well.
Kind regards,
Rob

My host has resolved the slow zen-cart.com page loads. It was because the Zen Cart site for some reason is reverse resoving the requestor and because the default ip of my server did not have an active domain name assigned to it, the zen-cart server would time page components out. All very odd, but with a valid domain on my server ip, things are snappy again!

However - this hasn't had any affect on the remaining issue - whereby I have no products in Paypal IPN orders, or I get two orders if I enable PDT. I've detailed this with debug logs here and am desparate for some assistance with it:
http://www.zen-cart.com/forum/showthread.php?p=645687
:frusty: