Re:Show HN: Collections, a fast multiple-account Google Docs...
by tonyx on Friday July 13, 2012 @05:53PM
(#4242168)
Hi thomas-st, thanks a lot for bring this up. we just fixed the issue and changed credentials on the server as well. All transmission also happen securely through HTTPS and contents are only stored on Google's server, not ours.
[ Parent
| on HN ]
Re:Show HN: Collections, a fast multiple-account Google Docs...
by xb95 on Friday July 13, 2012 @06:04PM
(#4242223)
Actually, your Postgres credentials still work. I am currently able to connect to the database and I can still view people in the role I grabbed.
I'm not sure how to validate that this is still timely, though... oh, I created a table:
public | hacker_news_1342216769 | table | ruwdncbzdkulsh
With the current timestamp. So, if you changed anything, it hasn't actually taken effect in the part that matters -- the exposed database.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by tonyx on Friday July 13, 2012 @06:14PM
(#4242263)
thanks xb95, it took a minute to take effect, but issue is now fixed.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by xb95 on Friday July 13, 2012 @06:19PM
(#4242284)
As of right now, 3:16 PM PDT, I can still connect to (one of) your Postgres databases.
# psql --host=ec2-23-21-85-231.compute-1.amazonaws.com --port=5432 -U ruwdncbzdkulsh dc6jnvg2ce8qim
Password for user ruwdncbzdkulsh:
psql (9.1.4)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
dc6jnvg2ce8qim=> SELECT NOW();
now
-------------------------------
2012-07-13 22:17:51.821052+00
(1 row)
Re:Show HN: Collections, a fast multiple-account Google Docs...
by jordanlee on Friday July 13, 2012 @06:40PM
(#4242376)
Hi Xb95, we first removed the heroku add-on and thought that it would automatically destroy the database, but that turned out not to be the case. So what we did to fix the issue was purge all of the tables from the database. Now the credentials still work, but they reach an empty database without any content. We're working on revoking the access token for all affected users right now. Thanks for helping us through this.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by xb95 on Friday July 13, 2012 @06:44PM
(#4242390)
I have confirmed that there is no longer any data in the database I can connect to. Thank you for taking care of this.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by mehulkar on Friday July 13, 2012 @07:11PM
(#4242466)
/xb95 rides off into the sunset.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by thomas-st on Friday July 13, 2012 @05:56PM
(#4242186)
You should also notify any users who already signed up and stored their access token in the database.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by jordanlee on Friday July 13, 2012 @10:55PM
(#4242948)
Hi Thomas, just following up on this. After fixing the security issue, we revoked access for all of the potentially affected user accounts and emailed users individually to apprise them of the situation and the steps we took to address it.
Re:Show HN: Collections, a fast multiple-account Google Docs...
by anemitz on Friday July 13, 2012 @05:55PM
(#4242179)
Since you store the Google auth_token couldn't anyone with access to the database also gain access to sessions?
Re:Show HN: Collections, a fast multiple-account Google Docs...
by tonyx on Friday July 13, 2012 @06:06PM
(#4242235)
We've turned off debug mode and reset our database credentials. We are looking through the database server access log right now and going to make sure that 1) all connections were made from our own servers and 2) users in the timeframe affected will be notified of the issue and guided to resolve it as soon as possible