News for hackers. Stuff that matters.
Re:Security Vulnerabilities in Heroku by jiggy2011 on Wednesday January 09, 2013 @01:11PM (#5032496)
"If the POST was made with ID removed from both the URL and body, the password of a random account would be reset and the account automatically logged in to:"

That seems like a very strange bug to occur.

Re:Security Vulnerabilities in Heroku by scriby on Wednesday January 09, 2013 @01:29PM (#5032602)
This kind of bug can happen when you have code like this in SQL:

SELECT @id = id FROM table --Oops, forgot where clause. This selects a "random" row

DELETE FROM table_2 WHERE id = @id

Re:Security Vulnerabilities in Heroku by tmaher on Wednesday January 09, 2013 @03:32PM (#5033317)
It was actually slightly more dumb than that.

Like most sites, after you register your account, we generate a nonce and email it to the provided address. You click the link with the nonce, we prompt you to set your password, and your account is ready. Our bug was that for already-verified users, the nonce column in the database is empty (it's a nonce, you see, so we only use it once...). This was the root cause for both bugs Mr. Sclafani describes.

Re:Security Vulnerabilities in Heroku by bgentry on Wednesday January 09, 2013 @03:44PM (#5033390)
The ActiveRecord query that caused this was along the lines of:

    User.find_by_email_and_token(params[:email], params[:token])
If the token is nil, it basically turns into a `find_by_email`.

I'll also add that while we had tests that were intended to avoid this bad behavior, these tests were unfortunately broken and were instead verifying the incorrect behavior.

Re:Security Vulnerabilities in Heroku by wulczer on Wednesday January 09, 2013 @04:09PM (#5033526)
It's interesting how differently Django handles password resets - no nonce is generated.

Instead, the user is emailed a token that's just her user ID, HMAC-signed with the last login date and a secret site key.

You can't generate valid reset links without knowing the secret key and you can't tamper with the one you got because it's HMAC-signed. By adding the last login date to the HMAC you make sure the link can be used only once. After a user resets her password, the last login date is updated to now so the link is no longer valid due to broken HMAC.

I like this solution because it doesn't rely on storing any state anywhere between requesting the reset and completing it.

Re:Security Vulnerabilities in Heroku by mikey_p on Wednesday January 09, 2013 @06:14PM (#5034171)
This is pretty much exactly what Drupal does as well, with the exception of using the user's password hash instead of the ID as input before hashing and it also stores the timestamp of the reset request as part of the URL (and the token) to allow for expiring password resets.
Re:Security Vulnerabilities in Heroku by zapu on Wednesday January 09, 2013 @03:44PM (#5033385)
Thank you for being open about that issue. All the reading about vulnerabilities definitely made me more aware when writing critical parts of my applications.
Re:Security Vulnerabilities in Heroku by jiggy2011 on Wednesday January 09, 2013 @01:34PM (#5032640)
Presumably though the where clause would be there if you are taking the user id from the request vars in order for the code to work at all?
Re:Security Vulnerabilities in Heroku by jstanley on Wednesday January 09, 2013 @01:45PM (#5032689)
If you build the query at runtime based on whichever arguments are available, it is quite easy for missing arguments to slip through to the inner query generator and end up with a blank where clause.
Re:Security Vulnerabilities in Heroku by jiggy2011 on Wednesday January 09, 2013 @01:49PM (#5032718)
a blank where clause throws an error (in mySQL at least) as it should do. Or will the query generator respond to missing arguments by removing the where clause altogether? In which case that's some pretty nasty behaviour.
Re:Security Vulnerabilities in Heroku by scriby on Wednesday January 09, 2013 @03:59PM (#5033482)
Depends on the flavor of SQL. But also, might not be a totally missing where clause, but just an incomplete one.