IPN TESTING - Confirmation/Validation response: FAILED

[jazznuts699]

Server OS: Windows NT ENEXSQL 5.2 build 3790
HTTP Server: Microsoft-IIS/6.0
Database: MySQL 5.0.37-community-nt
PHP Version: 5.2.8 (Zend: 2.2.0)
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
mods: VAT mod 1.5.1, Admin pw mod, Orders mod (not super orders), Image Handler 2

I am all of a sudden receiving IPN errors via paypal. Just the other week paypal payments were fine and transactions were being created.

I have read the below posts and here are some findings

http://www.zen-cart.com/forum/showthread.php?t=119431
http://www.zen-cart.com/forum/showthread.php?t=128248
http://www.zen-cart.com/forum/showthread.php?t=90695
http://www.zen-cart.com/forum/showthread.php?t=73123
http://www.zen-cart.com/wiki/index.php/PayPal

i'm pretty sure it has something to do with fsocket -- but it's enabled and has been for the past few months.

1. https://www.mysite.com/ipn_main_handler.php --> Nothing to process. Please return to home page.
as expected. debug code confirms.
2. all paypal payment module settings correct
3. all paypal.com settings correct (redirect, Ipn auto redirect, etc)
4. curl proxy disabled in admin\my store
5. ssl certificate added to list of certificates on paypal site. not a self-signed certificate
6. allow_url_fopen ON
7. when running https://www.mysite.com/extras/ipncheck.php:

IPNCHECK.PHP - Version 1.0

IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443


Warning: fsockopen() [function.fsockopen]: unable to connect to ssl://www.paypal.com:443 (Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?) in <removed>\catalog\extras\ipncheck.php on line 81
IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (24) Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?

Trying again without SSL ...

IPN TESTING - Confirmation/Validation response: FAILED

Script finished.

8. to check if function fsockopen exists i run a simple check which returns: Function exists

<?php
If(function_exists("fsockopen")){
        echo 'Function Exists';
}
Else{
        echo 'function does not exist';
}
?>

9. Below is my debug code (several files) for a transactions that paypal accepts but does not issue a new order for. As mentioned in post http://www.zen-cart.com/forum/showthread.php?t=119431 paypal is using the previous order number for a new order.

File1

Oct 14 2009 21:14 -- Keys for submission: Array
(
    [charset] => iso-8859-2
    [lc] => US
    [page_style] => Primary
    [custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
    [business] => <removed: private data>
    [return] => https://<removed: private data>/index.php?main_page=checkout_process&amp;referer=paypal
    [cancel_return] => https://<removed: private data>/index.php?main_page=checkout_payment
    [shopping_url] => https://<removed: private data>/index.php?main_page=shopping_cart
    [notify_url] => https://<removed: private data>/ipn_main_handler.php
    [redirect_cmd] => _xclick
    [rm] => 2
    [bn] => zencart
    [mrb] => <removed: private data>
    [pal] => <removed: private data>
    [first_name] => <removed: private data>
    [last_name] => <removed: private data>
    [address1] => <removed: private data>
    [city] => <removed: private data>
    [state] => <removed: private data>
    [zip] => <removed: private data>
    [country] => <removed: private data>
    [email] => <removed: private data>
    [H_PhoneNumber] => <removed: private data>
    [night_phone_a] => <removed: private data>
    [night_phone_b] => <removed: private data>
    [night_phone_c] => <removed: private data>
    [day_phone_a] => <removed: private data>
    [day_phone_b] => <removed: private data>
    [day_phone_c] => <removed: private data>
    [no_shipping] => 1
    [upload] => 1
    [currency_code] => EUR
    [cmd] => _ext-enter
    [item_name] => <removed: private data>
    [item_number] => Store Receipt
    [amount] => 0.01
    [shipping] => 0.00
    [tax] => 0.00
    [tax_cart] => 0.00
)

File2

Oct 14 2009 21:15 -- IPN INFO - POST VARS to be sent back for validation: 
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 101
Connection: close

Array
(
    [cmd] => _notify-sync
    [tx] => <removed: private data>
    [at] => <removed: private data>
)


Oct 14 2009 21:15 -- IPN INFO - Confirmation/Validation response 


0


Oct 14 2009 21:16 -- IPN WARNING :: PDT Transaction was not marked as SUCCESS. Keep this report for potential use in fraud investigations.
IPN Info = 
0

File3

Oct 14 2009 21:15 -- PDT Returned Data Array
(
)


Oct 14 2009 21:16 -- PDT WARNING :: Order not marked as "Completed".  Check for Pending reasons or wait for IPN to complete.
[payment_status] => 
[pending_reason] => 

Oct 14 2009 21:16 -- PDT WARNING :: Transaction already exists. Perhaps IPN already added it.  PDT processing ended.

File4

Oct 14 2009 21:15 -- IPN PROCESSING INITIATED. 
*** Originating IP: 66.211.170.66  notify.paypal.com

Oct 14 2009 21:15 -- IPN INFO - POST VARS received (sorted):
Array
(
    [business] => <removed: private data>
    [charset] => windows-1250
    [custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
    [first_name] => <removed: private data>
    [handling_amount] => 0.00
    [item_name] => <removed: private data>
    [item_number] => Store Receipt
    [last_name] => <removed: private data>
    [mc_currency] => EUR
    [mc_fee] => 0.01
    [mc_gross] => 0.01
    [notify_version] => 2.8
    [payer_email] => <removed: private data>
    [payer_id] => <removed: private data>
    [payer_status] => unverified
    [payment_date] => 12:15:37 Oct 14, 2009 PDT
    [payment_fee] => 
    [payment_gross] => 
    [payment_status] => Completed
    [payment_type] => instant
    [protection_eligibility] => Ineligible
    [quantity] => 1
    [receipt_id] => <removed: private data>
    [receiver_email] => <removed: private data>
    [receiver_id] => <removed: private data>
    [residence_country] => US
    [shipping] => 0.00
    [tax] => 0.00
    [transaction_subject] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
    [txn_id] => <removed: private data>
    [txn_type] => web_accept
    [verify_sign] => <removed: private data>
)


Oct 14 2009 21:16 -- IPN INFO - POST VARS to be sent back for validation: 
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 857
Connection: close

Array
(
    [mc_gross] => 0.01
    [protection_eligibility] => Ineligible
    [payer_id] => <removed: private data>
    [tax] => 0.00
    [payment_date] => 12:15:37 Oct 14, 2009 PDT
    [payment_status] => Completed
    [charset] => windows-1250
    [first_name] => <removed: private data>
    [mc_fee] => 0.01
    [notify_version] => 2.8
    [custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
    [payer_status] => unverified
    [business] => <removed: private data>
    [quantity] => 1
    [verify_sign] => <removed: private data>
    [payer_email] => <removed: private data>
    [txn_id] => <removed: private data>
    [payment_type] => instant
    [last_name] => <removed: private data>
    [receiver_email] => <removed: private data>
    [payment_fee] => 
    [receiver_id] => <removed: private data>
    [txn_type] => web_accept
    [item_name] => <removed: private data>
    [mc_currency] => EUR
    [item_number] => Store Receipt
    [residence_country] => US
    [receipt_id] => <removed: private data>
    [handling_amount] => 0.00
    [transaction_subject] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
    [payment_gross] => 
    [shipping] => 0.00
    [cmd] => _notify-validate
)


Oct 14 2009 21:16 -- IPN INFO - Confirmation/Validation response 


0


Oct 14 2009 21:16 -- Breakpoint: 1 - Collected data from PayPal notification

anything i failed to check?

[jazznuts699]

quick update, i found that php.ini had the below extenstions disabled:

php_openssl.dll
php_sockets.dll

once i enabled them i received the following output from https://www.mysite.com/extras/ipncheck.php:

IPNCHECK.PHP - Version 1.0

IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443

IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY


Script finished.

However the debug logs for a new test order show the same results as above.

[jazznuts699]

i spent all day trying to figure this out before posting and now i find a post that says Paypal is the problem..... what a bloody waste of time. Nice to see Paypal post a message on the main site that there is a problem with IPN

http://developer.paypal-portal.com/t...5CDC4B9A2#A470


http://www.zen-cart.com/forum/showth...847#post793847