Keep hashed things tokens in the database

[ghost]

FEATURE REQUEST

Things tokens are stored in a plaintext format in the things db. Anyone with the read access to the database can see them. I think they should be stored in a hashed format.

From security perspective, I think that this is a must have feature

[ghost]

In order for this to happen, there are following things that need to be changed:

1. the API should return the token upon thing creation
2. the token should be hashed and stored in the db
3. auth should be updated so it compares hashes
4. there should be a way to reset the token in case it's lost of compromised

[anovakovic01]

Hashing is one way encryption function that cannot be easily reversed. This is in contradiction with current API which can return plain thing key anytime. IMO we have two options:

1. Change API and return plain key only when creating thing.
2. Keep current API and use some other kind of encryption function that can be reversed only on client side.

I would like to hear other opinions regarding this @mainflux/contributors.

[drasko]

Find appropriate solution with Vault (or similar) - it's a storage for keys and secrets.

[anovakovic01]

@drasko I like this idea of using Vault too.

[nmarcetic]

Needs more research and brainstorming, moving for 0.9

[drasko]

Apart from this - I think we should separate thing token from thingID, and really have an independant pair. This would allow then for users to provide us their Passwords (or tokens) for things.

I am saying this in light of the MQTT protocol, which indeed has an independent Username and Password - while in our case token contains thingID inside as well, as it uniquelly represents Thing.

[anovakovic01]

1. thing token is a separate piece of info (it has nothing to do with thing ID). Our token doesn't have thing ID info inside of it,
2. AFAIK user can already set thing token on his own.

[drasko]

OK, then I guess it is just for us to decide do we encrypt, or we let user give us his key.

I am more for the approach where we ecrypt, especially for the reasons that this way encryption key does not have to travel.

So I would say that this issue would then consider:

• How do we change an API to use one pre-defined (our) key for encryption in the DB
• How do we store this key (as this is a deployments issue, we can stop at reccomendations, we do not necesary have to do an implementation with Vault. Also - this key can be maybe stored in binary).

[lpegoraro]

I did something similar to this, do we want to encrypt or just hash? Would we need to retrieve that or just validate the hash?

[drasko]

At this moment, I think we should encrypt, as I would expect that someone forgot/lost token written in the device flash and wants to retrieve it.

If we just hash, then all we can do is reset, but this might be complicated for devices in the field - they would have to be re-flashed.

But I might be wrong, and hash with reset might be the correct procedure. The rationale for this might be that if device "forgot" its token - there is something already wrong with the device's flash or firmware...

@dborovcanin @nmarcetic what would be your opinions here?

[lpegoraro]

When you guys figure that out, let me know, I will have some time probably next week and I could work on this.

[drasko]

@lpegoraro great, it would be highly appreciated. We'll let you know very soon.