Please reassign gpg key

Asked by Dimitri John Ledkov (ex-credativ) on 2011-04-15

I have split my personal & my work accounts on launchpad. Please move my work GPG key across from dmitrij.ledkov to the dle-credativ account.

adapted solution from another question:

update gpgkey set owner=person.id from person where fingerprint = 'E9AB0BDDA4C5F78CF44B9FCEF21BB3E375B9187F' and person.name='dle-credativ';

Question information

Language:
English Edit question
Status:
Answered
For:
Launchpad itself Edit question
Assignee:
No assignee Edit question
Last query:
2011-04-15
Last reply:
2012-06-06
Dimitri John Ledkov (xnox) said : #1

I agree =)

Steve McInerney (spm) said : #2

Hi Dmitrijs,
as a matter of policy we no longer run SQL updates directly against the production database.
So I can file an appropriate bug report, can you please explain what you've tried, and why you've chosen this particular solution?

I gather the goal is to move your gpg key from account A to account B.
You can't simply remove it from one and thus re-enable it on another?

Cheers!
- Steve

Max Bowsher (maxb) said : #3

Steve,

The UI does not permit removing GPG keys from persons, only flagging them as deactivated. (Which does not permit another person to register them.)

Whilst there may be some good reasons (e.g. audit trails) for this prohibition, it does mean there is no way for a real person realizing they need to divide their Launchpad identity to accomplish this, without LOSA SQL intervention.

I went through this process myself in https://answers.launchpad.net/launchpad/+question/72929

Tom Haddon (mthaddon) said : #4

Max,

I understand you may have gone through this process as well, we're just trying to push for a better solution than running manual SQL as that's something we're no longer happy to do as a matter of policy. If something is a valid request from a user, there should be a way of achieving it in the UI, or through a script that avoids running manual SQL.

Thanks, Tom

Max Bowsher (maxb) said : #5

Tom,

Sure, I just mentioned the previous question to provide additional background to answering Steve's question of why this couldn't be done by the affected user themselves. I understand that running arbitrary SQL is awkward to support.

Max.

Curtis Hovey (sinzui) said : #6

Launchpad needs a code change to support this.

Can you help with this problem?

Provide an answer of your own, or ask Dimitri John Ledkov (ex-credativ) for more information if necessary.

To post a message you must log in.