|
Margaret Andrews
|
February 5, 2013 at 12:44 am
Hello,
I’m a new user and have just discovered the log files while trying to track down why event registrations weren’t getting Payment Status updated to “Complete” in our attendee records. The people get registered OK and Paypal seems to accept the payment but apparently, we don’t get that last update of payment status.
The paypal.ipn_results.log file is displaying the following msgs:
—BEGIN LOG EXCERPT —
[12/20/2012 2:58 PM] - Errors from IPN Validation:
Using BUILT-IN PHP curl methods
key = mc_gross
value = 1.00
key = protection_eligibility
value = Eligible
(snip)
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=1.00&
Success Setting Fain On Error
Success Setting return transfer
Success Setting Timeout
Success Setting verbose mode
Errors resulting from the execution of curl transfer: error setting certificate verify locations:
CAfile: /usr/local/share/certs/ca-root-nss.crt
CApath: none
[12/20/2012 2:58 PM] - FAIL: IPN Validation Failed . /cgi-bin/webscr : www.paypal.com
IPN POST Vars from gateway:
mc_gross=1.00,
(snip)
IPN Response from gateway Server:
—– END OF LOG EXCERPT —-
Nothing follows that last line except for the beginning of the next log entry.
I found a thread here: https://eventespresso.com/forums/2012/03/paypal-payments-payments-incomplete/
where you say, “Verify that the CA certificate bundle on the site can be found. PayPal checks for this, and if it can’t find it, the IPN will fail. http://curl.haxx.se/docs/sslcerts.html”
Does this address my problem? If so, I don’t know how to do this. I’m just the website developer relying on Yahoo Small Business (our host provider) and WordPress. Is this something I can check myself or do I need to contact my host provider, in which case, what exactly do I ask him so he’ll know exactly what I’m talking about, when I have no idea what I’m talking about?
Thank you,
Margaret
|
|
Chris Reynolds
|
February 5, 2013 at 1:38 pm
If you’re using PayPal standard (not pro) then you don’t need an SSL certificate, so that wouldn’t apply. Usually IPN failures come from your transaction page not existing or not being publicly accessible to the internet. So you’ll want to make sure that it is not private, draft or deleted and if you have a maintenance mode plugin blocking access to your site, then IPNs will always fail until that’s deactivated.
|
|
Margaret Andrews
|
February 5, 2013 at 2:52 pm
Chris – Thank you for your response.
We do have Paypal Standard, so I guess the SSL certificate is not an issue.
I checked the transaction page after logging out of WordPress and the page seemed to display fine. (I assume the display message “ID not supplied” is expected since the page is not actually currently being called by Event Espresso with any data?) Here is the page in case I’m wrong if you want to double-check: http://boldlyme.org/blog/transactions
And we do not have a maintenance mode plug-in installed, let alone activated (unless Yahoo automatically installed one with a misleading name, like “Yahoo! Blog Statistics” or “Yahoo! Web Hosting Warning Messages”).
If the above is true, is there anything else I can check or provide to you that may help resolve this issue?
|
|
Dean
|
February 6, 2013 at 5:38 am
Hi Margaret,
I assume the display message “ID not supplied” is expected
Yes that is correct.
Have you set the IPN to be active in your PayPal account? Sorry if that sounds overly simple but its best to check. https://eventespresso.com/wiki/how-to-set-up-paypal-ipn/
|
|
Margaret Andrews
|
February 6, 2013 at 12:30 pm
Hi Dean,
I sure hope it’s something as simple as that. But when I go to Paypal Settings, there’s a red button at the top that says “Deactivate Paypal IPN?”, so I assume that means it’s activated.
|
|
Josh
|
February 6, 2013 at 3:13 pm
Hi Margaret,
This may be a file permissions issue. Here are the two lines from the error log:
CAfile: /usr/local/share/certs/ca-root-nss.crt
CApath: none
So it looks like the CAfile is there, but it may be that PHP can’t access it. You’ll likely need to contact the host and ask them if they can make it so the webserver has read access to that file.
Alternatively, you could try this solution:
http://stackoverflow.com/questions/521418/reading-ssl-page-with-curl-php/13564776#13564776
Please note that other users have reported one problem after another while being hosted on Yahoo hosting, so we’ve listed them on our requirements page as hosts that should be avoided:
https://eventespresso.com/requirements/
|
|
Margaret Andrews
|
February 11, 2013 at 9:45 pm
Hi Josh,
I spoke with the Yahoo Web Hosting Support team and they told me that they cannot change file permissions for Paypal to interact with it. Something about it being a shell file and the Yahoo Web Hosting environment can’t accommodate something like that.
I take this to mean that anyone using Yahoo Web Hosting cannot use Event Espresso if they want to do any payment processing (which was one of my main priorities).
Perhaps there should be a warning to Yahoo web hosting users before purchasing this plug-in.
I appreciate the help and time you all took to address this issue.
Do you happen to know the email address I should send a refund request to?
Thanks,
Margaret
|
|
Josh
|
February 12, 2013 at 12:08 pm
Hi Margaret,
We try to warn folks that Event Espresso does not work as expected with Yahoo hosting. It’s posted on our requirements page:
Please be aware that Event Espresso (as well as most other plugins) may not function properly when used on Godaddy, Yahoo, Crazy Domains (Australia), and most Windows/IIS based servers.
For sales inquiries, please contact the sales team via our contact form:
https://eventespresso.com/contact/
|
