run Gratipay 237

[gratipay-bot]

← Payday 236

---

Docs

http://inside.gratipay.com/howto/run-payday

Checklist

• Review accounts
  • New givers - One violations still opened - https://github.com/gratipay/violations/issues/32
  • 1.0 Payout applications
• Trigger backup
• Run payday script
• Commit payday logs
• Run masspay
  • DB query to update broken paypal fees
  • Generate paypal inputs
  • Verify there is no fee mismatch
  • Submit masspay on paypal
  • Post back masspay
• Commit masspay logs
• Review decline rate
• Shuffle escrow

Rotation

Month	Pilot	Copilot
December	@whit537 ✈️	@clone1018
January	@rohitpaulk	@whit537
February	@clone1018	@rohitpaulk
March	@whit537	@clone1018
April	@rohitpaulk	@whit537
May	@clone1018	@rohitpaulk
June	@whit537	@clone1018
July	@rohitpaulk	@whit537
August	@clone1018	@rohitpaulk
September	@whit537	@clone1018
October	@rohitpaulk	@whit537
November	@clone1018	@rohitpaulk

[chadwhitacre]

On my radar for this afternoon.

[chadwhitacre]

12 new accounts! Thanks largely to https://www.loomio.org/d/E67u1Aen/proposal/oURxeqbF, I think ...

[chadwhitacre]

12 accounts reviewed. No 1.0 payouts.

[chadwhitacre]

Backup started …

[chadwhitacre]

Backup verified.

[chadwhitacre]

Script started.

[chadwhitacre]

Crash:

pid-6532 thread-140735226864384 (MainThread) Traceback (most recent call last):
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/gratipay/cli.py", line 24, in payday
pid-6532 thread-140735226864384 (MainThread)     Payday.start().run()
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/gratipay/billing/payday.py", line 111, in run
pid-6532 thread-140735226864384 (MainThread)     self.payin()
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/gratipay/billing/payday.py", line 132, in payin
pid-6532 thread-140735226864384 (MainThread)     holds = self.create_card_holds(cursor)
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/gratipay/billing/payday.py", line 194, in create_card_holds
pid-6532 thread-140735226864384 (MainThread)     holds = self.fetch_card_holds(participant_ids)
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/gratipay/billing/payday.py", line 166, in fetch_card_holds
pid-6532 thread-140735226864384 (MainThread)     braintree.TransactionSearch.status == 'authorized'
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/env/lib/python2.7/site-packages/braintree/transaction.py", line 317, in search
pid-6532 thread-140735226864384 (MainThread)     return Configuration.gateway().transaction.search(*query)
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/env/lib/python2.7/site-packages/braintree/transaction_gateway.py", line 74, in search
pid-6532 thread-140735226864384 (MainThread)     response = self.config.http().post("/transactions/advanced_search_ids", {"search": self.__criteria(query)})
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/env/lib/python2.7/site-packages/braintree/util/http.py", line 49, in post
pid-6532 thread-140735226864384 (MainThread)     return self.__http_do("POST", path, params)
pid-6532 thread-140735226864384 (MainThread)   File "/Users/whit537/personal/gratipay/gratipay.com/env/lib/python2.7/site-packages/braintree/util/http.py", line 71, in __http_do
pid-6532 thread-140735226864384 (MainThread)     raise e
pid-6532 thread-140735226864384 (MainThread) SSLError: [SSL: TLSV1_ALERT_PROTOCOL_VERSION] tlsv1 alert protocol version (_ssl.c:590)

[chadwhitacre]

I saw this the other day when poking at https://github.com/gratipay/gratipay.com/issues/4233—I assumed it was because I was running locally on http://localhost:8537 ... but maybe not?

[chadwhitacre]

https://github.com/kennethreitz/requests/issues/1847 suggests that Braintree has turned off TLSv1 support, but we're still trying it anyway and failing as a result.

[chadwhitacre]

https://www.braintreepayments.com/blog/updating-your-production-environment-to-support-tlsv1-2/

[chadwhitacre]

Please have a look at the relevant instructions on testing your setup. If you are not communicating over TLSv1.2, you’ll need to upgrade your production operating systems, encryption libraries, runtime environments, and/or SDKs to communicate to Braintree over TLSv1.2. We will stop accepting connections made via TLSv1.0 and TLSv1.1 when the update to require TLS 1.2 goes into effect.

We’ll be updating the Braintree sandbox environment on December 13, 2016.

However:

Braintree will be upgrading its services to require TLSv1.2 for all HTTPS connections starting January 31, 2017.

Harumph. :-/

[chadwhitacre]

https://github.com/paypal/TLS-update#python

[chadwhitacre]

[gratipay] $ python -c "import urllib2; print(urllib2.urlopen('https://tlstest.paypal.com/').read())"
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/usr/local/lib/python2.7/urllib2.py", line 154, in urlopen
    return opener.open(url, data, timeout)
  File "/usr/local/lib/python2.7/urllib2.py", line 431, in open
    response = self._open(req, data)
  File "/usr/local/lib/python2.7/urllib2.py", line 449, in _open
    '_open', req)
  File "/usr/local/lib/python2.7/urllib2.py", line 409, in _call_chain
    result = func(*args)
  File "/usr/local/lib/python2.7/urllib2.py", line 1240, in https_open
    context=self._context)
  File "/usr/local/lib/python2.7/urllib2.py", line 1197, in do_open
    raise URLError(err)
urllib2.URLError: <urlopen error [Errno 54] Connection reset by peer>
[gratipay] $

[chadwhitacre]

That's locally. Looks like we're in the clear on Heroku. 👍

[gratipay] $ heroku run bash
Running bash on ⬢ gratipay... up, run.1167 (Hobby)
~ $ python -c "import urllib2; print(urllib2.urlopen('https://tlstest.paypal.com/').read())"
PayPal_Connection_OK
~ $

[chadwhitacre]

Okay! So I need to install OpenSSL 1.0.1c or higher locally, or run payday somewhere else. Hmm ...

[chadwhitacre]

😁

[gratipay] $ openssl version
OpenSSL 0.9.8zg 14 July 2015

[chadwhitacre]

H*ck yeah, Homebrew! 👍

$ python -c "import urllib2; print(urllib2.urlopen('https://tlstest.paypal.com/').read())"
PayPal_Connection_OK
$

[chadwhitacre]

/me rebuilds env ...

[chadwhitacre]

Harumph. :-/

I ran without for_real_please, so I was hitting the sandbox after all. 😬

[gratipay] $ less ../logs/payday/
Display all 246 possibilities? (y or n)
[gratipay] $ less ../logs/payday/test-237.log

[chadwhitacre]

Okay! Here we go ...

[chadwhitacre]

Script started.

[chadwhitacre]

Script ran for a minute (0:01:20.827975).

[chadwhitacre]

gratipay::MAROON=> update exchange_routes set fee_cap = 20.00 where fee_cap is null and network = 'paypal';
UPDATE 17
gratipay::MAROON=>

[chadwhitacre]

MassPay out by 49¢.

[chadwhitacre]

Got it!

[chadwhitacre]

Escrow Shuffle

	$
MassPay	1,740.39
5x	8,701.95
Balance	8,953.01
Added	0.00

[chadwhitacre]

[chadwhitacre]

2 / 49 = 4.1% failed at Braintree
10 / 72 = 13.9% failed at PayPal

[chadwhitacre]

Logs in https://github.com/gratipay/logs/commit/ebcf87f9a54bea17d17cc97a1223c8829bd8c55b.

[chadwhitacre]

Eff. I think I forgot to post masspay back again. 😞

[clone1018]

Don't forget this step!

[chadwhitacre]

😭

[mattbk]

Is that why I got extra monies this week?

[chadwhitacre]

Dammit. 😭 😭

[chadwhitacre]

Sorry, everyone. :-(

Evaluating ...

[chadwhitacre]

Picking up at #951 (comment) ...

[chadwhitacre]

POSTed MassPay back to Gratipay for 72 users.