The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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=299,
       repository_id=275,
       kind=2,
       created_at='2009-08-03 08:12:19',
       created_at='2009-08-03 08:12:19';

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

Service/git

Contents