2 ms·
> After examining a variety of different possible solutions, we came to the conclusion that the least-worst option was to patch OpenSSH to lookup keys in a MySQ
by tzs 3y ago
> After examining a variety of different possible solutions, we came to the conclusion that the least-worst option was to patch OpenSSH to lookup keys in a MySQL database, indexed on the key fingerprint.
Why MySQL rather than sqlite?
They were trying to speed up access to ~/.ssh/authorized_keys. That's the kind of situation mysql is designed to shine in. I would have expected that patching OpenSSH to check for ~/.ssh/authorized_keys.db would be less work than patching it to use MySQL.
- klysm 3y agoI’d imagine there are many machines involved and maintaining one database is typically easier than maintaining many. I’d also imagine MySQL was already in operation, so there wasn’t any startup cost to storing data there. They already had a database of users _somewhere_