Jump to content

Service/git: Difference between revisions

From Sugar Labs
No edit summary
Line 1: Line 1:
= Hardware =
* XEN VM
= Location =
Hosted by the [http://www.osuosl.org/ Open Source Lab]
= Admins =
* OSL Support <support AT osuosl.org>
* Lance Albertson <lance AT osuosl.org>, Ramereth on #osuosl Freenode
* Gary C Martin <gary AT garycmartin.com>, basic` on #osuosl Freenode
* [[User:Bernie|Bernie Innocenti]], _bernie on #sugar Freenode
* [[User:LFaraone|Luke Faraone]], lfaraone on #sugar Freenode
= Notes =
== Gitorious DB hacking ==
== Gitorious DB hacking ==



Revision as of 15:59, 7 September 2009

Hardware

  • XEN VM

Location

Hosted by the Open Source Lab

Admins

  • OSL Support <support AT osuosl.org>
  • Lance Albertson <lance AT osuosl.org>, Ramereth on #osuosl Freenode
  • Gary C Martin <gary AT garycmartin.com>, basic` on #osuosl Freenode

Notes

Gitorious DB hacking

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...)