nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot add SSH key to Stash

Svante Gustafsson Björkegren

Hi all,

Some time ago I added my public key to Stash (I created a project/repo and was able to pull/push stuff)

But I'm not longer able to push to Stash. And when I look at the ssh-keys settings in Stash it says:

No SSH keys have been added

But when I try to set my ssh key again I get this error message:

This SSH key is already used to access a repository or project

Any clues what is wrong? It looks like the account got duplicated or messed up. I have verified that there are no duplicate accounts.

Where is the actual key stored? In the database or in the home-directory?

Thnx in advance!

// Svante

Accepted answers

Svante Gustafsson Björkegren

Problem solved!

I found the keys in the database and saw that the user had added his personal public key to both a project and a repo. This made it impossible to add the key to the personal profile.

After the key was removed from the Project and Repo it worked fine again :-)

Cheers,

// Svante

All comments

Svante Gustafsson Björkegren

Problem solved!

I found the keys in the database and saw that the user had added his personal public key to both a project and a repo. This made it impossible to add the key to the personal profile.

After the key was removed from the Project and Repo it worked fine again :-)

Cheers,

// Svante

Bruno Lavit

Hi Svante,

I have the same problem, but I'm not able to find the relevant Stash table which host the SSH keys.

Can you send me the table name please? smile

Thanks,

Bruno

Mira Hedl

What is *name* of the table?

Svante Gustafsson Björkegren

Hey, The SSH keys are stored in the table: AO_FB71B4_SSH_PUBLIC_KEY (per Stash 3.4) The following query will give you any keys including the name "my-key": {code} select * from "AO_FB71B4_SSH_PUBLIC_KEY" key where key."KEY_TEXT" like '%my-key%' {code} Hope that helped! Cheers, // Svante

Bruno Lavit

Thanks a lot

Patrick Viet

Hi,

Here is how to find the actual repositories once you got the user id from AO_FB71B4_SSH_PUBLIC_KEY :

select * from repository inner join sta_repo_permission on repo_id = repository.id where user_id=<the ID>

Patrick Viet

Hi,

Here is how to find the actual repositories once you got the user id from AO_FB71B4_SSH_PUBLIC_KEY :

select * from repository inner join sta_repo_permission on repo_id = repository.id where user_id=<the ID>

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

bitbucket

bitbucket-server

bitbucket-administration

ssh-key