Revision as of 14:36, 19 April 2010

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
Sascha Silbe, silbe on #sugar Freenode

Notes

Web interface

http://admin.osuosl.org/phpmyadmin

Gitorious environments

We do not have root on git.sugarlabs.org. Put the following aliases in your ~/.bashrc to quickly switch to the Gitorious production, test and development environments:

alias gitorious='sudo su - gitorious'
alias gittest='sudo su - gittest'
alias gitdev='sudo su - gitdev'
alias db='mysql -h db1.osuosl.org -u sugarlabs_git -p  sugarlabs_git_dev'

Get a MySQL prompt

type "db" at the prompt, then 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=(select id from users where login='bernie'),
       repository_id=(SELECT id FROM repositories where
               project_id=(SELECT id FROM projects WHERE title='sugar') AND name='mainline'),
       kind=2, created_at=NOW(), updated_at=NOW();

Hijack account to reset password

update users set email='YOUREMAIL' where login='USER';

Then make Gitorious send you a password reset email.

update users set email='OLDEMAIL' where login='USER';

WARNING

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

@@ Line 43: / Line 43: @@
 === Add committer ===
-  insert into committerships set
+  INSERT INTO committerships SET
-         user_id=299,
+         user_id=(select id from users where login='bernie'),
-         repository_id=275,
+         repository_id=(SELECT id FROM repositories where
-         kind=2,
+                project_id=(SELECT id FROM projects WHERE title='sugar') AND name='mainline'),
-        created_at='2009-08-03 08:12:19',
+         kind=2, created_at=NOW(), updated_at=NOW();
-        created_at='2009-08-03 08:12:19';
 === Hijack account to reset password ===

Difference between revisions of "Service/git"