Importing SSH keys

[Rafal Habrat]

Hi,

I'm looking to import SSH keys into Stash (directly into the database) from a different system and ran into a problem. I'm trying to figure out how I should populate the KEY_MD5 column in the database - specifically when I tried to get the hashed value of a key that I added through the UI with md5sum as below, I was unable to produce the same value that Stash had generated itself.

echo 'ssh-rsa ... <email>' | md5sum

I alos tried using MySQL's MD5 function and that did not work either

select MD5('ssh-rsa ... <email>');

Any advice would be appreciated...

[seb · Accepted solution]

Hi Rafal,

Why are you inserting SSH keys directly into our database? If you would like to automate/script some processes, you should always be using our REST apis.

Have a look the following question for how to add SSH keys to Stash via REST:

https://answers.atlassian.com/questions/93488/is-there-a-way-to-upload-an-ssh-key-to-stash-via-command-line

[Rafal Habrat]

Thanks Seb - that helps...

[Michael Heemskerk]

Hi,

The safest way of importing SSH keys into Stash is to use the REST endpoint:

POST http://<your-baseurl-here>/rest/ssh/1.0/keys?user=<username>

with body:

{ "text":"<your-public-key-content-here>", "label":"<your-label-here; not used by Stash for auth>"}

Things to watch out for:

• You'll need Admin permissions to upload keys for other users.
• Make sure you POST with Content-Type set to "application/json".

Cheers,

Michael