Service/git: Difference between revisions
Appearance
< Service
| Line 21: | Line 21: | ||
=== Get a MySQL prompt === | === Get a MySQL prompt === | ||
type "db" at the prompt, | type "db" at the prompt, then give the db password | ||
from ~gitorious/config/database.yml | from ~gitorious/config/database.yml | ||
Revision as of 16:15, 7 September 2009
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
Notes
Web interface
http://admin.osuosl.org/phpmyadmin
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';
WARNING
To zap a user account, make sure you also remove its related records from all tables (committers, projects, repositories, events...)