sqlitebrowser / dbhub.io

A "Cloud" for SQLite databases. Collaborative development for your data. 😊
https://dbhub.io
GNU Affero General Public License v3.0
363 stars 39 forks source link

Let's discuss the client certificates #296

Open MKleusberg opened 5 months ago

MKleusberg commented 5 months ago

The way we're doing client certificates has quite some flaws at the moment. The major ones are:

Points 1 and 2 make them seem pretty insecure and problematic. Point 3 makes it harder to implement them properly because we'd have to have code in DB4S, in dio, and in Javascript for the web UI - besides basically building a full-fledged CA. And then users are still confused about certificates because they usually don't deal with them.

I definitely don't want to say client certificates for authentication are bad. But considering everything honestly wondering it it's maybe not better to implement 0Auth in dio and DB4S or just use API keys. What do you think?

justinclift commented 5 months ago

Hmmm, we could do that. Client certificates seemed like the right approach when we first started working on this, but they have turned out to be a fair pain in the butt. :wink:

For moving to a new approach, what do you reckon our requirements are? We'll probably also need some kind of transition plan too. Maybe supporting both methods for a while or something. :smile: