Consider the following notes of what i found simply poking around. Hope to
export all this and import into another platform. Any tips appreciated.
Gitorious consists of more than just a webserver, database, git repository
as can be seen by running the command: ` /usr/bin/gitorious_status `
root@gitorious:~ # /usr/bin/gitorious_status
GITORIOUS HEALTH CHECKS:
----------------------------------------------------------
* Unicorn [UP]
* Resque [UP]
* Nginx [UP]
* Git-daemons [UP]
* Sphinx [UP]
* Memcached [UP]
* SSH-daemon [UP]
* Mysqld [UP]
gitorious repositories may be "bare" because the
[core]
repositoryformatversion = 0
filemode = true
bare = true
/var/www/gitorious/repositories/sip-asterisk/sip-asterisk.git
ls /var/www/gitorious/repositories/
sip-asterisk
vm-storage-config
somerepo
gitoriousconfig
dumb-switch-configuration-files
for P in $(pgrep mysql); do ps ${P}; done;
1976
2078
PID TTY STAT TIME COMMAND
1976 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
PID TTY STAT TIME COMMAND
2078 ? Sl 0:14 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
# echo mysql -u root
# mysql> show databases;
# mysql> use gitorious_production;
# mysql> show tables;
# mysql> select * from comments;
# Recommend to use show databases; from within mysql>
# List of gitorious mysql template table files as found on the file system:
ls /var/lib/mysql/gitorious_production/
archived_events.frm
cloners.frm
comments.frm
committerships.frm
content_memberships.frm
db.opt
emails.frm
events.frm
favorites.frm
feed_items.frm
groups.frm
issues_comments.frm
issues_issue_labels.frm
issues_issues.frm
issues_issue_users.frm
issues_labels.frm
issues_milestones.frm
issues_queries.frm
ldap_groups.frm
memberships.frm
merge_requests.frm
merge_request_statuses.frm
merge_request_versions.frm
messages.frm
messages_users.frm
open_id_authentication_associations.frm
open_id_authentication_nonces.frm
project_proposals.frm
projects.frm
repositories.frm
roles.frm
schema_migrations.frm
services.frm
sessions.frm
sites.frm
ssh_keys.frm
taggings.frm
tags.frm
users.frm
root@gitorious:~ /usr/bin/gitorious_status
GITORIOUS HEALTH CHECKS:
----------------------------------------------------------
* Unicorn [UP]
* Resque [UP]
* Nginx [UP]
* Git-daemons [UP]
* Sphinx [UP]
* Memcached [UP]
* SSH-daemon [UP]
* Mysqld [UP]
root@gitorious:# which gitorious_status
/usr/bin/gitorious_status
root@gitorious:~ # whereis gitorious_status: /usr/bin/gitorious_status
WHEREIS(1) WHEREIS(1)
whereis - locate the binary, source, and manual page files for a com-
mand
root@gitorious:~# df -h
Filesystem Size Used Avail Use% Mounted on
rootfs 12G 5.1G 6.1G 46% /
devtmpfs 919M 168K 919M 1% /dev
tmpfs 933M 0 933M 0% /dev/shm
/dev/xvda1 12G 5.1G 6.1G 46% /
cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid