Difference between revisions of "Service/git"

From Sugar Labs
Jump to navigation Jump to search
Line 25: Line 25:
  
 
=== Change project owner ===
 
=== Change project owner ===
select * from users where login='sdz';
+
select * from users where login='sdz';
select id from projects where slug='soas';
+
select id from projects where slug='soas';
update projects set user_id=117 where slug='soas';
+
update projects set user_id=117 where slug='soas';
  
 
=== Add committer ===
 
=== Add committer ===

Revision as of 16:13, 7 September 2009

Hostnames

Hardware

  • XEN VM

Location

Hosted by the Open Source Lab

Admins

  • OSL Support <support AT osuosl.org> (ask here for anything that requires root access)
  • Lance Albertson <lance AT osuosl.org>, Ramereth on #osuosl Freenode
  • Bernie Innocenti, _bernie on #sugar Freenode
  • Luke Faraone, lfaraone on #sugar Freenode

Notes

Web interface

http://admin.osuosl.org/phpmyadmin

Get a MySQL prompt

type "db" at the prompt, than give the db password from ~gitorious/config/database.yml

Change project owner

select * from users where login='sdz';
select id from projects where slug='soas';
update projects set user_id=117 where slug='soas';

Add committer

insert into committerships set

       user_id=299,
       repository_id=275,
       kind=2,
       created_at='2009-08-03 08:12:19',
       created_at='2009-08-03 08:12:19';

WARNING

To zap a user account, make sure you also remove its related records from all tables (committers, projects, repositories, events...)