Support

November 6, 2013 at 3:07 pm

Another few bits of information:

We have correctly set up the Paypal account settings to accept IPN payments as well as look at the transactions page for our site, which you can see here:

http://events.rrc.ca/PaypalIPNSettings.gif

What happens when I just finished paying for an event is that we get re-directed to this page:

https://events.rrc.ca/?page_id=5&r_id=5%2d527abaff4ac73&type=paypal

(this is our thank-you page) But if you go to that link, you will see that the transaction is still showing up as incomplete.

November 7, 2013 at 2:10 pm

Heck yes, logging! Here is one error result in the log:

[11/06/2013 3:56 PM] – Errors from IPN Validation:

Using BUILT-IN PHP curl methods
key = mc_gross
value = 0.05
key = protection_eligibility
value = Eligible
key = address_status
value = confirmed
key = item_number1
value =
key = payer_id
value = WGV4RVNB3TXTA
key = tax
value = 0.00
key = address_street
value = 12 Orum Drive
key = payment_date
value = 13:56:39 Nov 06, 2013 PST
key = payment_status
value = Completed
key = charset
value = windows-1252
key = address_zip
value = R3W1S9
key = mc_shipping
value = 0.00
key = mc_handling
value = 0.00
key = first_name
value = Lisa
key = mc_fee
value = 0.05
key = address_country_code
value = CA
key = address_name
value = Lisa Arsenault
key = notify_version
value = 3.7
key = custom
value =
key = payer_status
value = verified
key = business
value = rrcfinancial@rrc.mb.ca
key = address_country
value = Canada
key = num_cart_items
value = 1
key = mc_handling1
value = 0.00
key = address_city
value = Winnipeg
key = verify_sign
value = A21kmBLyRcQpDSjYvmswlm3ckjahADiYo2hMU1K2ny-OK4R7F8rRS9QK
key = payer_email
value = mike@xosoftware.com
key = mc_shipping1
value = 0.00
key = tax1
value = 0.00
key = txn_id
value = 0PV564033D712054V
key = payment_type
value = instant
key = last_name
value = Arsenault
key = address_state
value = Manitoba
key = item_name1
value = Student for RRC Directions 2014 – 212-13001-00. Attendee: Mike Arsenault
key = receiver_email
value = rrcfinancial@rrc.mb.ca
key = payment_fee
value =
key = quantity1
value = 1
key = receiver_id
value = SQ8QYC29VKFLG
key = txn_type
value = cart
key = mc_gross_1
value = 0.05
key = mc_currency
value = CAD
key = residence_country
value = CA
key = transaction_subject
value =
key = payment_gross
value =
key = ipn_track_id
value = f076dc4253aaa
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=0.05&protection_eligibility=Eligible&address_status=confirmed&item_number1=&payer_id=WGV4RVNB3TXTA&tax=0.00&address_street=12+Orum+Drive&payment_date=13%3A56%3A39+Nov+06%2C+2013+PST&payment_status=Completed&charset=windows-1252&address_zip=R3W1S9&mc_shipping=0.00&mc_handling=0.00&first_name=Lisa&mc_fee=0.05&address_country_code=CA&address_name=Lisa+Arsenault&notify_version=3.7&custom=&payer_status=verified&business=rrcfinancial%40rrc.mb.ca&address_country=Canada&num_cart_items=1&mc_handling1=0.00&address_city=Winnipeg&verify_sign=A21kmBLyRcQpDSjYvmswlm3ckjahADiYo2hMU1K2ny-OK4R7F8rRS9QK&payer_email=mike%40xosoftware.com&mc_shipping1=0.00&tax1=0.00&txn_id=0PV564033D712054V&payment_type=instant&last_name=Arsenault&address_state=Manitoba&item_name1=Student+for+RRC+Directions+2014+-+212-13001-00.+Attendee%3A+Mike+Arsenault&receiver_email=rrcfinancial%40rrc.mb.ca&payment_fee=&quantity1=1&receiver_id=SQ8QYC29VKFLG&txn_type=cart&mc_gross_1=0.05&mc_currency=CAD&residence_country=CA&transaction_subject=&payment_gross=&ipn_track_id=f076dc4253aaa&cmd=_notify-validate
Success Setting Fain On Error
Success Setting return transfer
Success Setting Timeout
Success Setting verbose mode
Errors resulting from the execution of curl transfer: SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed[11/06/2013 3:56 PM] – FAIL: IPN Validation Failed . /cgi-bin/webscr : http://www.paypal.com
IPN POST Vars from gateway:
mc_gross=0.05, protection_eligibility=Eligible, address_status=confirmed, item_number1=, payer_id=WGV4RVNB3TXTA, tax=0.00, address_street=12 Orum Drive, payment_date=13:56:39 Nov 06, 2013 PST, payment_status=Completed, charset=windows-1252, address_zip=R3W1S9, mc_shipping=0.00, mc_handling=0.00, first_name=Lisa, mc_fee=0.05, address_country_code=CA, address_name=Lisa Arsenault, notify_version=3.7, custom=, payer_status=verified, business=rrcfinancial@rrc.mb.ca, address_country=Canada, num_cart_items=1, mc_handling1=0.00, address_city=Winnipeg, verify_sign=A21kmBLyRcQpDSjYvmswlm3ckjahADiYo2hMU1K2ny-OK4R7F8rRS9QK, payer_email=mike@xosoftware.com, mc_shipping1=0.00, tax1=0.00, txn_id=0PV564033D712054V, payment_type=instant, last_name=Arsenault, address_state=Manitoba, item_name1=Student for RRC Directions 2014 – 212-13001-00. Attendee: Mike Arsenault, receiver_email=rrcfinancial@rrc.mb.ca, payment_fee=, quantity1=1, receiver_id=SQ8QYC29VKFLG, txn_type=cart, mc_gross_1=0.05, mc_currency=CAD, residence_country=CA, transaction_subject=, payment_gross=, ipn_track_id=f076dc4253aaa,
IPN Response from gateway Server:

The part that seems the moist relevant are these lines:

Errors resulting from the execution of curl transfer: SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed[11/06/2013 6:11 PM] – FAIL: IPN Validation Failed . /cgi-bin/webscr : http://www.paypal.com

Is this a problem with OUR certificate on events.rrc.ca? If so, do you guys notice or see what could be happening?

November 7, 2013 at 2:58 pm

I don’t actually have a [cURL] block in my php.ini file… the security certificate is installed and working, and I substituted the theme you recommended earlier in the thread for the one I was using previously on the transaction page:

https://events.rrc.ca/transactions/

When you go to that page, the certificate is loading properly. Our site is hosted internally, and runs on IIS. Where would I find the CA information (the path/file location) that I need to plug into the php.ini file? Does the .pem file extension work in Windows? Once I have all of the info, do I just add this block into my php.ini file and restart the server?

[cURL]

curl.cainfo = ‘\path\to\my\cafile’

Thanks!