Associating multiple SSH keys to single SSH keys

[kshuta]

This might defeat the purpose of being passwordless, but what do you think about the possibility of associating multiple SSH keys to a single account / SSH key? I find myself wanting to access snips from different machines, but I'm not sure if there's a way to do that at the moment.

[robherley]

should be totally possible! a new command like ssh-import-id where you can add a new key for your current user

the database is already setup such that a user:keys is 1:N:

snips.sh/internal/db/schema.hcl

Lines 23 to 53 in 8e52e02

	table "public_keys" {
	schema = schema.main
	column "id" {
	type = text
	}
	column "created_at" {
	type = datetime
	}
	column "updated_at" {
	type = datetime
	}
	column "fingerprint" {
	type = text
	}
	column "type" {
	type = text
	}
	column "user_id" {
	type = text
	}
	primary_key {
	columns = [column.id]
	}
	index "idx_public_keys_created_at" {
	columns = [column.created_at]
	}
	index "idx_pubkey_fingerprint" {
	unique = true
	columns = [column.fingerprint]
	}
	}

(might need a new index if we need to fine all keys for a user ID though)

e.g. something like taking a list of keys from stdin and adding them to your current user id

curl https://github.com/robherley.keys | ssh :[email protected]

(need to think of a nice pattern for having more "commands")

we'll need some more tui to add/remove keys too

[mokrinsky]

I just bumped into similar issue while rotating my ssh keys.
Input:
I use gpg-agent and all of my ssh keys are provided with gpg. I rotated my auth gpg key, hence ssh key changed. When I tried logging in into snips, I've seen that all of my snippets are gone.
Also, I use snips in kubernetes with self-written helm chart so I cannot dynamically update my keys using ssh-copy-id or smth.

Solution I used:
Snips uses sqlite as a database backend. So I opened database and what I've seen is:

sqlite> .headers ON
sqlite> select * from users;
id|created_at|updated_at
1|2023-07-18 03:39:14.784065001+00:00|2023-07-18 03:39:14.784065177+00:00
2|2024-08-24 14:39:30.56052203+00:00|2024-08-24 14:39:30.560522224+00:00
sqlite> select * from public_keys;;
id|created_at|updated_at|fingerprint|type|user_id
1|2023-07-18 03:39:15.077009676+00:00|2023-07-18 03:39:15.077029709+00:00|SHA256:fingerprint|ssh-rsa|1
2|2024-08-24 14:39:30.590117152+00:00|2024-08-24 14:39:30.590117293+00:00|SHA256:fingerprint|ssh-ed25519|2

Hence, every ssh key is associated with different user. Let's change it...

sqlite> update public_keys set user_id='1' where id='2';
sqlite> select * from public_keys;
id|created_at|updated_at|fingerprint|type|user_id
1|2023-07-18 03:39:15.077009676+00:00|2023-07-18 03:39:15.077029709+00:00|SHA256:fingerprint|ssh-rsa|1
2|2024-08-24 14:39:30.590117152+00:00|2024-08-24 14:39:30.590117293+00:00|SHA256:fingerprint|ssh-ed25519|1

What I've got is - different ssh keys are attached to the same user. Worked like a charm, now I can login using any of the keys and I get all of my snippets.

[ImDevinC]

Any update on this feature? I have multiple devices, each with their own SSH keys, and would like to be able to see all my snips uploaded from all my different devices.

[kshuta]

Sorry I haven't had the time to implement this feature, and am not sure if I will in the near future.

…

On Thu, Jan 16, 2025 at 8:39 PM Devin Collins ***@***.***> wrote: Any update on this feature? I have multiple devices, each with their own SSH keys, and would like to be able to see all my snips uploaded from all my different devices. — Reply to this email directly, view it on GitHub <#164 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AK56Y5Z3JQMDIFQKXYI63ML2LCCPTAVCNFSM6AAAAABEGMHZZOVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCOBWGIZTSMQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>