CouchDB and the Heartbleed SSL/TLS Vulnerability
You may or may not have heard about the Heartbleed SSL/TLS vulnerability yet. Without much exaggeration, this is a big one.
What does this mean for CouchDB?
1. If you are using CouchDB with the built-in SSL support, you are at the whim of Erlang/OTP’s handling of SSL. Lucky for you, while they do use OpenSSL for the heavy lifting, they do the TLS/SSL handshake logic in Erlang (Source). That means you are not affected by this issue.
2. If you are using CouchDB behind a third-party proxy server you are at the whim of the SSL library it uses. For the big three Apache, nginx and HAProxy it’s all OpenSSL. So if they are using OpenSSL 1.0.1-1.0.1f with heartbeat support (RFC6520) enabled (the default), you need to take action. As far as I can tell now:
- 0. Check if you are vulnerable
- 1. Stop your service.
- 2. Upgrade to OpenSSL 1.0.1g or recompile OpenSSL without heartbeat support.
- 3. Request new cert from your SSL cert vendor.
- 4. Revoke your old cert.
- 5. Invalidate all existing sessions by changing the CouchDB couchdb_httpd_auth/secret configuration value to a new UUID.
- 6. Restart your service.
- 7. Invalidate all your user’s passwords and/or OAuth tokens.
- 8. Notify your users that any of their data and passwords are potentially compromised.
The Little Things(1): Do Not Delete
CouchDB takes data storage extremely seriously. This usually means we work hard to make sure that the CouchDB storage modules are as robust as we can make them. Sometimes though, we go all the way to the HTTP API to secure against accidental data loss, saving users from their mistakes, rather than dealing with hard drives and kernel caches that usually stand in the way of safe data storage.
To delete a document in CouchDB, you issue the following HTTP request:
DELETE /database/docid?rev=12345 HTTP/1.1
A common way to program this looks like this:
http.request('DELETE', db + '/' + docId + '?rev=' + docRev);
So far so innocent. Sometimes though, users came to us and complained that their whole database was deleted by that code.
Turns out the above code creates a request that deletes the whole database, if the docId variable isn’t set correctly. The request then looks like:
DELETE /database/?rev=12345 HTTP/1.1
It looks like an honest mistake, once you check the CouchDB log file, but good old CouchDB would just go ahead and delete the database, ignoring the
We thought this is a good opportunity to help users not accidentally losing their data. So since late 2009 (yes, this is an oldie, but it came up in a recent discussion and we thought it is worth writing about :), CouchDB will not delete a database, if it sees that a
?rev= parameter is present and it looks like that this is just a malformed request, as database deletions have no business requiring a
One can make an easy argument that the code sample is fairly shoddy and we’d agree. But we are not here to argue how our users use our database beyond complying with the API and recommended use-cases. And if we can help them keep their data, that’s a win in our book
Continuing down this thought, we thought we could do one better. You know that to delete a document, you must pass the current rev value, like you see above. This is to ensure that we don’t delete the document accidentally without knowing that someone else may have added an update to it that we don’t actually want to delete. It’s CouchDB’s standard multi version currency control (MVCC) mechanism at work.
Databases don’t have revisions like documents, and deleting a database is a simple
HTTP DELETE /database away. Databases, however, do have a sequence id, it’s the ID you get from the changes feed, it’s an number that starts at 0 when the database is created and increments by 1 each time a document is added, updated or deleted. Each state of the database has a single sequence ID associated with it.
Similar to a rev, we could require the latest sequence ID to delete a database, as in:
And deny database deletes that don’t carry the latest
seq_id. We think this is a decent idea, but unfortunately, this would break backwards compatibility with older versions of CouchDB and it would break a good amount of code in the field, so we are hesitant to add this feature. In addition, sequence IDs change a little when BigCouch finally gets merged, so we’d have to look at this again then.
In the meantime, we have the protection against simple coding errors and we are happy that our users keep their hard earned data more often now.