Hi, I have the well-known problem of the pending order after payment with paypal: Add a product to cart, then confirm the order selecting paypal, complete a transaction successfully (the money has been transfered, as I can see on sandbox account), but the order is PENDING and no email is sent
I have already tried this:
1)"the subfolder fix" - no success
2) checked that in /logs/paypal.log there's "message: plgVmConfirmedOrder order number xxxx". (ok)
3) checked that in "#_virtuemart_payment_plg_paypal" under "paypal response raw" there are only "zeros" (ok)
4) disabled SEF (no success)
5) tried to use the extension PayPal Checkout Express
6) tried on THREE different webspaces (same provider) with the same result
7) fresh install of joomla+vm on a fourth webspace (same result)
I don't know what to do anymore. please help me!!
I'm using J!2.5.14 + VM 2.0.22c
Do you have all available logs that could help us to help you?
sure!
2013-09-04 13:20:39
message: plgVmConfirmedOrder order number: 7160011
2013-09-04 16:48:46
message: plgVmConfirmedOrder order number: 17e8012
2013-09-04 16:49:17
message: plgVmConfirmedOrder order number: 2d51013
2013-09-04 17:04:52
message: plgVmConfirmedOrder order number: 0711016
2013-09-04 17:16:29
message: plgVmConfirmedOrder order number: 2a5e017
2013-09-04 19:19:08
message: plgVmConfirmedOrder order number: 60fa08
2013-09-04 20:06:12
message: plgVmConfirmedOrder order number: 47bd09
2013-09-04 20:06:40
message: paypal_data 9.27 47bd09 Ineligible L67V76KACQQPC 0.00 13:06:38 Sep 04, 2013 PDT Completed windows-1252 0.67 3.7 90e9e5c8b84becd4bb0cde022cd80331 verified mysandboxseller@mydomain.it 1 Axto1SMPKSr2e88JBjtEiuXYUiidAioaqPobrlhw8dJm25ZZvbYdvIxM mysandboxbuyer@gmail.com 1MT19078G15914423 instant esposito test_seller@mydomain.it 8Q7KQ4MG5CQHY web_accept Order Number: 47bd09 EUR IT 1 0.00 90e9e5c8b84becd4bb0cde022cd80331 0.00 c5ec54bc4aaef
2013-09-04 20:06:40
message: checkPaypalIps: 173.0.82.126 server is:173.0.82.126
2013-09-04 20:06:40
message: checkPaypalIps: OK
2013-09-04 20:06:40
message: _processIPN Fputs: POST /cgi-bin/webscr HTTP/1.1
User-Agent: PHP/5.3.10
Referer: mysite.com/index.phpoption=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
Server: Apache
Host: www.sandbox.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 873
Connection: close
cmd=_notify-validate&mc_gross=9.27&invoice=47bd09&protection_eligibility=Ineligible&payer_id=L67V76KACQQPC&tax=0.00&payment_date=13%3A06%3A38+Sep+04%2C+2013+PDT&payment_status=Completed&charset=windows-1252&first_name=ciro&mc_fee=0.67¬ify_version=3.7&custom=90e9e5c8b84becd4bb0cde022cd80331&payer_status=verified&business=test_seller%40&quantity=1&verify_sign=Axto1SMPKSr2e88JBjtEiuXYUiidAioaqPobrlhw8dJm25ZZvbYdvIxM&payer_email=andreaprove92%40gmail.com&txn_id=1MT19078G15914423&payment_type=instant&last_name=qqq&receiver_email=mysandboxseller%40mydomain.it&payment_fee=&receiver_id=8Q7KQ4MG5CQHY&txn_type=web_accept&item_name=Order+Number%3A+47bd09&mc_currency=EUR&item_number=&residence_country=IT&test_ipn=1&handling_amount=0.00&transaction_subject=90e9e5c8b84becd4bb0cde022cd80331&payment_gross=&shipping=0.00&ipn_track_id=c5ec54bc4aaef
2013-09-04 20:06:40
message: _processIPN FROM IPN VALIDATION:HTTP/1.0 500 Server closed connection without sending any data back
Date: Wed, 04 Sep 2013 20:06:40 GMT
Server: Apache
Content-Type: text/plain
500 Server closed connection without sending any data back
2013-09-04 20:06:40
message: _processIPN NO ANSWER FROM PAYPAL
2013-09-04 20:06:40
message: _processIPN valid_ipn:
2013-09-04 20:06:40
message: paypal_data _processIPN FALSE
the errors should be for transactions made with PayPal Checkout Express.
The fact is that no email is sent. because I dont care about the name of the status if the email is sent to the vendor and the buyer. I've already set up the email parameters in virtuemart (infact with the "standard" payment method the mail is sent) and also the joomla email configuration looks to be fine (I can register a new joomla user)
Thank you for the answer :)
Is this a live or test shop
Are you using sandbox ?
sandbox. in paypal dev account I can see that the transaction went fine. maybe that error for the ipn is what makes the order remaining pending?
IPN works
So this is likely to be your configuration settings for the sandbox account and/or VM
in VM I have:
Sandbox: on
email sandbox: emailofseller
Let buyers override their PayPal addresses?: on
Prompt buyers for a shipping address: do not prompt...
For Paypal Sandbox I created a dev-account, the in section "Sandbox" created an account for test_seller and an account for test_buyer. the emails are obviously different and in Seller's profile I activated IPN with url = mysite.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
Seems to be alright...
I checked the log file again and again and I found something strange.
In the IPN validation (that brings me to an error) there's "Referer: mysite.com/index.phpoption=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component"
I'm not a php programmer, so I dont know if I'm saying something obvious or totally incorrect, but I think that between /index.php and option= should be a "?". This can be a problem?? In ipn settings on sandbox.paypal.com I'm sure there is that "?"
Thank you
This is the IPN url:-
http://site.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
Tested in my site sandbox and working well.
This is my configuration:
-added two accounts in sandbox. 1 business, 1 personal.
-automatic redirect from paypal to my page
-activated "Payment Data Transfers" in sandbox vendor profile
-set in paypal sandbox vendor profile the IPN url
-in vm set vendor email as receiver_email (and checked "Sandbox")
I continue to have pending order.
Is this config the same as yours? Have you got "confirmed" status order after a sandbox transaction?
Sorry, but I can't really figure out! it seems so easy, but doesnt work for me.. :'(
Another (the last) question: could be my webspace provider that blocks something?
make sure that you can make ssl connections on port 443
Have you checked the log files?
Quote from: andre-83 on September 04, 2013, 23:33:25 PM
sure!
2013-09-04 13:20:39
message: plgVmConfirmedOrder order number: 7160011
2013-09-04 16:48:46
message: plgVmConfirmedOrder order number: 17e8012
2013-09-04 16:49:17
message: plgVmConfirmedOrder order number: 2d51013
2013-09-04 17:04:52
message: plgVmConfirmedOrder order number: 0711016
2013-09-04 17:16:29
message: plgVmConfirmedOrder order number: 2a5e017
2013-09-04 19:19:08
message: plgVmConfirmedOrder order number: 60fa08
2013-09-04 20:06:12
message: plgVmConfirmedOrder order number: 47bd09
2013-09-04 20:06:40
message: paypal_data 9.27 47bd09 Ineligible L67V76KACQQPC 0.00 13:06:38 Sep 04, 2013 PDT Completed windows-1252 0.67 3.7 90e9e5c8b84becd4bb0cde022cd80331 verified mysandboxseller@mydomain.it 1 Axto1SMPKSr2e88JBjtEiuXYUiidAioaqPobrlhw8dJm25ZZvbYdvIxM mysandboxbuyer@gmail.com 1MT19078G15914423 instant esposito test_seller@mydomain.it 8Q7KQ4MG5CQHY web_accept Order Number: 47bd09 EUR IT 1 0.00 90e9e5c8b84becd4bb0cde022cd80331 0.00 c5ec54bc4aaef
2013-09-04 20:06:40
message: checkPaypalIps: 173.0.82.126 server is:173.0.82.126
2013-09-04 20:06:40
message: checkPaypalIps: OK
2013-09-04 20:06:40
message: _processIPN Fputs: POST /cgi-bin/webscr HTTP/1.1
User-Agent: PHP/5.3.10
Referer: mysite.com/index.phpoption=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
Server: Apache
Host: www.sandbox.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 873
Connection: close
cmd=_notify-validate&mc_gross=9.27&invoice=47bd09&protection_eligibility=Ineligible&payer_id=L67V76KACQQPC&tax=0.00&payment_date=13%3A06%3A38+Sep+04%2C+2013+PDT&payment_status=Completed&charset=windows-1252&first_name=ciro&mc_fee=0.67¬ify_version=3.7&custom=90e9e5c8b84becd4bb0cde022cd80331&payer_status=verified&business=test_seller%40&quantity=1&verify_sign=Axto1SMPKSr2e88JBjtEiuXYUiidAioaqPobrlhw8dJm25ZZvbYdvIxM&payer_email=andreaprove92%40gmail.com&txn_id=1MT19078G15914423&payment_type=instant&last_name=qqq&receiver_email=mysandboxseller%40mydomain.it&payment_fee=&receiver_id=8Q7KQ4MG5CQHY&txn_type=web_accept&item_name=Order+Number%3A+47bd09&mc_currency=EUR&item_number=&residence_country=IT&test_ipn=1&handling_amount=0.00&transaction_subject=90e9e5c8b84becd4bb0cde022cd80331&payment_gross=&shipping=0.00&ipn_track_id=c5ec54bc4aaef
2013-09-04 20:06:40
message: _processIPN FROM IPN VALIDATION:HTTP/1.0 500 Server closed connection without sending any data back
Date: Wed, 04 Sep 2013 20:06:40 GMT
Server: Apache
Content-Type: text/plain
500 Server closed connection without sending any data back
2013-09-04 20:06:40
message: _processIPN NO ANSWER FROM PAYPAL
2013-09-04 20:06:40
message: _processIPN valid_ipn:
2013-09-04 20:06:40
message: paypal_data _processIPN FALSE
the errors should be for transactions made with PayPal Checkout Express.
Just to avoid any confusion those are actually PayPal Standard logs. Express does not use IPN . It communicates directly with the PayPal server and IPN settings are not needed.
So to avoid further confusion and help anyone trying to answer your request for support
Can you calrify Point 5 from your first post
Are you using the paypal standard plugin or are you using express plugin
Sorry, my mistake. I have tried to use PayPal checkout express, but with no success. So I came back to VM PayPal plugin. Now I'm trying to use VM PayPal plugin.
For the SSL, is this necessary to use? Because it's not free and before buying it I would like to be sure that it is the problem
Thanks for the clarification
From what I can see in the log that SSC3 posted for you
IPN is connecting
But
We see this in the log
processIPN FROM IPN VALIDATION:HTTP/1.0 500 Server closed connection without sending any data back
I would expect it to be
message: _processIPN FROM IPN VALIDATION:HTTP/1.1 200 OK
Have you made sure you have updated the AIO part of the VM update
sure. The first installation I made was 2.0.22a, downloaded as vm + aio from vm's site. Then I updated through live update both vm and aio. However now I'll try to install a "fresh v2.0.22c + aio" over my "updated v2.0.22c + aio". I'll let you know asap
EDIT: VM & aio installed. made a transaction. This is its log:
2013-09-06 12:26:46
message: plgVmConfirmedOrder order number: 09d2032
2013-09-06 12:27:20
message: paypal_data 3.03 09d2032 Ineligible C4XV3QQR5M6TG 0.00 05:27:17 Sep 06, 2013 PDT Completed windows-1252 ciro 0.45 3.7 5sdkmd6f4tkd5q5jbppqnac0o5 verified test.seller.92@gmail.com 1 AiPC9BjkCyDFQXbSkoZcgqH3hpacAfx-YW1edY16.kvlI7F2QeQvTOJD test.buyer.92@gmail.com 8NJ72992TT775810B instant esposito test.seller.92@gmail.com 3XVGLQ8T4W3HC web_accept Order Number: 09d2032 EUR IT 1 0.00 5sdkmd6f4tkd5q5jbppqnac0o5 0.00 99e98c647f334
2013-09-06 12:27:20
message: checkPaypalIps: 173.0.82.126 server is:173.0.82.126
2013-09-06 12:27:20
message: checkPaypalIps: OK
2013-09-06 12:27:20
message: _processIPN Fputs: POST /cgi-bin/webscr HTTP/1.1
User-Agent: PHP/5.2.17
Referer: imecprofessional.altervista.org/index.phpoption=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
Server: Apache
Host: www.sandbox.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 849
Connection: close
cmd=_notify-validate&mc_gross=3.03&invoice=09d2032&protection_eligibility=Ineligible&payer_id=C4XV3QQR5M6TG&tax=0.00&payment_date=05%3A27%3A17+Sep+06%2C+2013+PDT&payment_status=Completed&charset=windows-1252&first_name=ciro&mc_fee=0.45¬ify_version=3.7&custom=5sdkmd6f4tkd5q5jbppqnac0o5&payer_status=verified&business=test.seller.92%40gmail.com&quantity=1&verify_sign=AiPC9BjkCyDFQXbSkoZcgqH3hpacAfx-YW1edY16.kvlI7F2QeQvTOJD&payer_email=test.buyer.92%40gmail.com&txn_id=8NJ72992TT775810B&payment_type=instant&last_name=esposito&receiver_email=test.seller.92%40gmail.com&payment_fee=&receiver_id=3XVGLQ8T4W3HC&txn_type=web_accept&item_name=Order+Number%3A+09d2032&mc_currency=EUR&item_number=&residence_country=IT&test_ipn=1&handling_amount=0.00&transaction_subject=5sdkmd6f4tkd5q5jbppqnac0o5&payment_gross=&shipping=0.00&ipn_track_id=99e98c647f334
2013-09-06 12:27:20
message: _processIPN FROM IPN VALIDATION:HTTP/1.0 500 Server closed connection without sending any data back
Date: Fri, 06 Sep 2013 12:27:17 GMT
Server: Apache
Content-Type: text/plain
Server closed connection without sending any data back at /usr/lib/perl5/site_perl/5.8.8/Net/HTTP/Methods.pm line 345.
2013-09-06 12:27:20
message: _processIPN NO ANSWER FROM PAYPAL
2013-09-06 12:27:20
message: _processIPN valid_ipn:
2013-09-06 12:27:20
message: paypal_data _processIPN FALSE
problem still not solved.. if somebody can understand why this error appears, please help me! :'(
Hello
QuoteServer closed connection without sending any data back at /usr/lib/perl5/site_perl/5.8.8/Net/HTTP/Methods.pm line 345.
Interesting.
Can you contact me via PM, so i can check on your site why
sent. If there's some other detail you need tell me
Hello
I do not know why you have this problem.
I have google your error message. I found this post that migth help you http://www.webhostingtalk.com/showthread.php?t=1172517
same issue here with 2.0.22c on a live webshop which work flawless for years.
I get these emails for each time it goes wrong.
QuotePayPal IPN Transaction on your site: Possible fraud
Error code 506. Possible fraud. Error with REMOTE IP ADDRESS = 172.17.1.2.
The remote address of the script posting to this notify script does not match a valid PayPal ip address
These are the valid IP Addresses: 2.19.178.234,173.0.81.1,173.0.81.33,216.113.188.202,216.113.188.203,216.113.188.204,66.211.170.66The Order ID received was: 3cf904474
So I think the paypal ip adresses in the paypal plugin need updating again. I had this issue in VM years ago and adding Paypals new server ip's solved the problem then.
here is the fix (at least for this new ip, maybe there are more)
Vm Payment plugin Paypal 2.0.6 (included in AIO 22.0.2c)
file:
plugins/vmpayment/paypal.php
line: 790
$paypal_iplist3 = array('216.113.188.202', '216.113.188.203', '216.113.188.204', '66.211.170.66');
change to
$paypal_iplist3 = array('216.113.188.202', '216.113.188.203', '216.113.188.204', '66.211.170.66', '172.17.1.2');
Dear all
I have also been unable to solve a similar IPN and 'payment pending' problem. I have upgraded to VM 2.0.22c on Joomla 2.5.14, including the AIO update.
As far as I can tell following the advice posted in a number of different threads, and from looking at the log files, there are no obvious error messages.
Everything was working as originally set up until a previous upgrade to VM 2.0.21. I have no idea if this is a cause, but it's the only major change that I have made.
I recently checked on the client's Paypal account and saw that IPN and PDT were not enabled, although they were previously and IPN was working fine. I have now set these up and provided the notification URL as advised. The Paypal IPN history settings are not showing an HTTP response and when I access this URL I get a blank page.
I am not a developer, so rely on using components, modules and plug-ins as instructed. Although I can read and amend code if necessary.
I appreciate the volume of advice that there is about this issue, but so far none of the recommendations have solved my problem, so I am reluctantly adding to the discussion.
Any advice gratefully received.
Thanks.
Jake
Live site for this is http://cuisenaire.co.uk/index.php/shop
Hello Carsten
This can´t be right. My guess is that the correct IP address doesn´t get through and doesn´t get visible for Virtuemart. I see this with people that have made PayPal payments via mobile 3G and 4G networks.
Here is a list of trusted PayPal ip addresses. Please correct me if I am wrong:
https://cms.paypal.com/ca/cgi-bin/?cmd=_render-content&content_ID=developer/howto_api_golivechecklist
(https://cms.paypal.com/ca/cgi-bin/?cmd=_render-content&content_ID=developer/howto_api_golivechecklist)
Quote
URL IP Address(es)
www.paypal.com 64.4.241.16
64.4.241.32 to 64.4.241.39
216.113.188.32 to 216.113.188.35
216.113.188.64 to 216.113.188.67
api.paypal.com 216.113.188.39
216.113.188.71
66.211.168.91
66.211.168.123
api-aa.paypal.com 216.113.188.52
216.113.188.84
66.211.168.92
66.211.168.124
api-3t.paypal.com 216.113.188.10
66.211.168.126
api-aa-3t.paypal.com 216.113.188.11
66.211.168.125
notify.paypal.com 216.113.188.202
216.113.188.203
216.113.188.204
66.211.170.66
developer.paypal.com 66.135.197.163
sandbox.paypal.com 216.113.169.205
www.sandbox.paypal.com 66.135.197.160
api.sandbox.paypal.com 66.135.197.162
api-aa.sandbox.paypal.com 66.135.197.141
ipn.sandbox.paypal.com 66.135.197.164
regards
Jörgen @ Kreativ Fotografi
@Jörgen
that seems like a correct list, however VM tells me a different url, so possible fraud. It tells me this once for each of the orders, same ip. While the payments were properly made in Paypal. Each of these was consistently followed by an angry email from a client who wanted to download the extension they paid for.
There has recently been maintenance work at Paypal. So maybe they didn't update their list yet. I dunno.
I am angtiously awaiting the next purchase, see how that goes.
Hello
QuoteError code 506. Possible fraud. Error with REMOTE IP ADDRESS = 172.17.1.2.
Quotehttps://cms.paypal.com/ca/cgi-bin/?cmd=_render-content&content_ID=developer/howto_api_golivechecklist
Yes this is the correct list of the Paypal IP address.
It is not the first time, that somebody gets during some time that email, and then the problem disappear.
I understand that this can be very annoying.
Ofc, we can find work around like having a white IP list, or checking the IP address as an option, but i don't think it is correct.
I did a search on that ip, but it does not seem to be registered.
I am thinking about making a ticket about this issue at Paypal tomorrow.
Hello
i searched, and found this
http://www.speedguide.net/ip/172.17.1.2
@alatak
thanks. what does that mean? That paypals callback IPN is redirected by the (hacked?) server my site runs on?
Hello
I don't really know. Somebody spoofing the IP address ...
@alatak
I think not, as each order is paid for and only one IPN notification is received. Anyway, with the above alteration my shop is working again. But that might not have been the same issue as others on htis thread. Sorry about that. I thought this was the same thing.
Could all this have anything to do with the change in http support? Could it be the IPN bounces at the host as the http is no longer supported by VM, the host returns the IPN back with a different http, as a workaround to get it going, VM sees a different ip and won't accept it. Could this be what is happening? Just a thought.
Hello
QuoteCould all this have anything to do with the change in http support?
No , not at all. Some people got the exact problem with the previous version.
QuoteHere is a list of trusted PayPal ip addresses. Please correct me if I am wrong:
https://cms.paypal.com/ca/cgi-bin/?cmd=_render-content&content_ID=developer/howto_api_golivechecklist
Quote
URL IP Address(es)
www.paypal.com 64.4.241.16
64.4.241.32 to 64.4.241.39
216.113.188.32 to 216.113.188.35
216.113.188.64 to 216.113.188.67
api.paypal.com 216.113.188.39
216.113.188.71
66.211.168.91
66.211.168.123
api-aa.paypal.com 216.113.188.52
216.113.188.84
66.211.168.92
66.211.168.124
api-3t.paypal.com 216.113.188.10
66.211.168.126
api-aa-3t.paypal.com 216.113.188.11
66.211.168.125
notify.paypal.com 216.113.188.202
216.113.188.203
216.113.188.204
66.211.170.66
developer.paypal.com 66.135.197.163
sandbox.paypal.com 216.113.169.205
www.sandbox.paypal.com 66.135.197.160
api.sandbox.paypal.com 66.135.197.162
api-aa.sandbox.paypal.com 66.135.197.141
ipn.sandbox.paypal.com 66.135.197.164
This is the list of the valid Paypal IP address.
And the one you mentioned is not on that list.
I am sure that in a week or so, This IP will disappear.
Dear all
In relation to my earlier post, connected to this subject, I have received the following from Paypal
Please check your server that handles PayPal Instant Payment Notifications
(IPN). Instant Payment Notifications sent to the following URL(s) are
failing:
http://www.cuisenaire.co.uk/index.php/shop/pluginresponse/pluginnotification?tmpl=component
http://cuisenaire.co.uk/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
http://cuisenaire.co.uk/index.php/shop/view/pluginresponse/task/pluginnotification/tmpl/component
At this stage, I am pretty sure that maintaining VM up to date should have fixed any problems, but I'm completely at a loss on this.
Thanks in advance.
Jake
VM 2.0.22c
J - 2.5.14
Apache server
Linux host
PHP 5.3.27
www.cuisenaire.co.uk
or cuisenaire.co.uk
As an update
I have solved this problem by recreating the Payment option in the back end of the store.
So far so good.
Jake
This issue will not go away in a week or so.
I have a first documented issue in AUG 7 2012.
QuoteError code 506. Possible fraud. Error with REMOTE IP ADDRESS = 173.0.81.1.
This is not caused by something that PayPal will fix, I think it is a routing issue and that the server request for IP address gives a wrong IP adress. None of my payments have been spoofed or otherwise faulty.
My guess is that this is coming from 3G or 4G based home networks. I have had other issues with ISP providers supplying their services on thoose networks.
But I would be more than happy if anyone could come up with a solution for this.
regards
Jörgen @ Kreativ Fotografi
Quote from: Jörgen on September 12, 2013, 12:03:33 PM
But I would be more than happy if anyone could come up with a solution for this.
You can use the fix I posted earlyer, just replace the new ip adress with 173.0.81.1. Mine works fine now. I'm pretty sure its some routing issue.
Hi all,
I've just upgraded to VM 2.0.22c and I'm testing with PayPal Sandbox. When I put through transactions they are remaining as Pending.
I'm not quite sure where to start in figuring out why - can anyone point me in the right direction? What do you need to know?
I really need to have this upgrade sorted by the Oct 7th paypal changes.
Many thanks
Claire
Nearby thread
Quote from: avirammr on September 16, 2013, 02:09:59 AM
i tested it on live site and it works perfect.. it fix my problem also with the confirmed and pending problem..
Tested and works fine for me also
Orders are confirming for me now - for some reason the IPN was queued.