Service/git

From Sugar Labs
Jump to navigation Jump to search

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