Re: Paypal and "going root"

From: Dave Page <dpage(at)postgresql(dot)org>
To: Kenneth Downs <ken(at)secdat(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Paypal and "going root"
Date: 2007-05-17 14:32:33
Message-ID: 464C6781.4060006@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kenneth Downs wrote:
> The last one left that I have is the sticky issue of a paypal IPN
> transaction coming in. I believe it applies generally to financial
> transactions. The user is sent by our application to the Paypal site.
> When they pay, paypal sends a POST with various information that we
> need. The user does not see this, it is behind the scenes. The POST
> request must run as an anonymous user because I have no state
> whatsoever. But the request must also commit financial data. This
> creates a vulnerability, at least in theory. There are fields contained
> in the transaction meant to allow confirmation and prevent fraud, but I
> just don't like that idea of running anonymously and committing
> financial data.
>
> In this case it seems creating a stored procedure will not automatically
> help, as then we just execute the SP anonymously, and it strikes me as
> no different.
>
> Has anybody pondered this and come up with anything?
>

In response to the incoming IPN you can create a connection back to the
paypal server to validate it. Iirc, you basically just send the entire
request back again and it returns 'VERIFIED'.

Only then do you act upon the IPN data (remember to double check all the
prices etc, to catch any instance in which a user might have faked the
handover from your site to Paypal).

Regards, Dave.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-05-17 14:35:25 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Previous Message Andrus 2007-05-17 14:28:01 FULL JOIN is only supported with merge-joinable join conditions