14 Oct 2009, 7:36 PM
New Zenner
- Join Date:
- Jul 2009
- Posts:
- 72
- Plugin Contributions:
- 0
IPN TESTING - Confirmation/Validation response: FAILED
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.
- https://www.mysite.com/ipn_main_handler.php --> Nothing to process. Please return to home page.
as expected. debug code confirms. - all paypal payment module settings correct
- all paypal.com settings correct (redirect, Ipn auto redirect, etc)
- curl proxy disabled in admin\my store
- ssl certificate added to list of certificates on paypal site. not a self-signed certificate
- allow_url_fopen ON
- 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.
- 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';
}
?>
- 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&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? :frusty: