Service/git

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

• Bernie Innocenti, _bernie on #sugar Freenode
• Luke Faraone, lfaraone on #sugar 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...)