Launchpad itself

Please reassign all Ubuntu mirrors owned by ~salgado to ~ubuntu-mirror-admins

Asked by Guilherme Salgado

When we first registered the Ubuntu mirrors in Launchpad I wrote a script which parsed a wiki page and inserted them all into the database, with myself as the owner. But that's not true as I don't have any control over the actual mirrors, and occasionally people come to me asking that I reassign the mirrors to them. It'd be better if the mirrors were owned by ~ubuntu-mirror-admins as that's the team for the Ubuntu IS members that look after mirrors.

There are currently 110 mirrors where I'm the owner, so this should probably be done via DB surgery. I'm happy to provide the SQL for that when it's approved.

Question information

Language:
English Edit question
Status:
Answered
For:
Launchpad itself Edit question
Assignee:
[LEGACY] Canonical WebOps Edit question
Last query:
Last reply:
Revision history for this message
Curtis Hovey (sinzui) said : 		#1

If you can provide the sql in a pastebin, I can review it and ask a admin to test it and deploy it today.

Revision history for this message
Guilherme Salgado (salgado) said : 		#2

update distributionmirror set owner = (select id from person where name = 'ubuntu-mirror-admins') where owner = (select id from person where name = 'salgado');

Revision history for this message
Guilherme Salgado (salgado) said : 		#3

Oops, I pasted it here before I saw your comment. But there's nothing confidential there, so it's fine to leave it here.

Revision history for this message
Michael Barnett (mbarnett) said : 		#4

I double checked the sql and it looked good. All 110 mirrors have been updated per above.

-Michael

Can you help with this problem?

Provide an answer of your own, or ask Guilherme Salgado for more information if necessary.

To post a message you must log in.