Difference between revisions of "ProjectInfrastructure"

From RackTables Wiki
Jump to navigation Jump to search
m
Line 6: Line 6:
 
=== racktables-users mail ===
 
=== racktables-users mail ===
 
FreeLists is a great free service without accompanying advertisements. The only drawback about it is that it is non-profit and can go down some day.
 
FreeLists is a great free service without accompanying advertisements. The only drawback about it is that it is non-profit and can go down some day.
−
=== Demo host ===
+
=== Bug tracker, wiki, demo host ===
−
Arnaud Launay is the administrator of a server, which currently runs RackTables demo. To get SSH access there, be a team member and find someone who already has access.
+
Arnaud Launay is the administrator of a server, which currently runs this wiki, Mantis and the RackTables demo. To get SSH access there, be a team member and find someone who already has access.
 
=== Statistics ===
 
=== Statistics ===
 
SF download stats work for the downloads. Google analytics works for the content of racktables.org and demo.racktables.org.
 
SF download stats work for the downloads. Google analytics works for the content of racktables.org and demo.racktables.org.
 
=== Everything else ===
 
=== Everything else ===
−
SourceForge. SVN, Mantis, Wiki, racktables.org HTTP vhost, downloads and shell service.
+
SourceForge. SVN, racktables.org HTTP vhost, downloads and shell service.
 
----
 
----
 
==Backup procedure==
 
==Backup procedure==
Line 18: Line 18:
 
===SourceForge data===
 
===SourceForge data===
 
# Project page, "Project admin", "Features", "XML export": save the file into backup directory as "racktables_export.xml".
 
# Project page, "Project admin", "Features", "XML export": save the file into backup directory as "racktables_export.xml".
−
# Project page, "Project admin", "Features", "Hosted apps": save 4 files (mantisbt, mediawiki)*(Database,Files) into backup directory.
 
 
# Backup stuff accessible from SF SSH only:
 
# Backup stuff accessible from SF SSH only:
 
<pre>ssh -t YOUR_SF_USERNAME,racktables@shell.sourceforge.net create
 
<pre>ssh -t YOUR_SF_USERNAME,racktables@shell.sourceforge.net create
Line 40: Line 39:
 
* racktables.org.tar.gz
 
* racktables.org.tar.gz
 
* racktables_export.xml
 
* racktables_export.xml
−
* racktables_mantisbt_files.tar.bz2
 
−
* racktables_mantisbt_mysqldump.sql.bz2
 
−
* racktables_mediawiki_files.tar.bz2
 
−
* racktables_mediawiki_mysqldump.sql.bz2
 
 
Wrap this stuff into a single archive file with a meaningful name and '''save it to a safe place''':
 
Wrap this stuff into a single archive file with a meaningful name and '''save it to a safe place''':
 
<pre>
 
<pre>
 
tar cf RackTables-project-backup-`date +%Y%m%d`.tar ./racktables*
 
tar cf RackTables-project-backup-`date +%Y%m%d`.tar ./racktables*
 
</pre>
 
</pre>
 +
 +
 +
===Bug tracker, wiki data===
 +
SSH into the host and create a new backup directory.
 +
mkdir ~/RackTables-apps-backup
 +
cd ~/RackTables-apps-backup
 +
 +
Copy the applications into the backup directory.  This is important because they contain uploaded files and configuration settings.
 +
cp -r ~/www/bugs .
 +
cp -r ~/www/wiki .
 +
 +
Export the database for each application.
 +
mysqldump -u <username> -p <dbname> > bugs.sql
 +
mysqldump -u <username> -p <dbname> > wiki.sql
 +
 +
Wrap it all up in a single archive file and '''save it to a safe place''':
 +
cd ~/
 +
tar czf RackTables-apps-backup-`date +%Y%m%d`.tar.gz ./RackTables-apps-backup

Revision as of 20:36, 8 July 2012

Mapping of assets

DNS

racktables.org domain is currently registered through GoDaddy, which also provides 2 free nameservers.

racktables.org mail

"racktables.org mail is handled by 10 mx.yandex.ru." Yandex Mail is a free email service, which allows for an own DNS domain. There is a single "devteam" mailbox configured in the domain, which is setup to forward all messages to every development team member.

racktables-users mail

FreeLists is a great free service without accompanying advertisements. The only drawback about it is that it is non-profit and can go down some day.

Bug tracker, wiki, demo host

Arnaud Launay is the administrator of a server, which currently runs this wiki, Mantis and the RackTables demo. To get SSH access there, be a team member and find someone who already has access.

Statistics

SF download stats work for the downloads. Google analytics works for the content of racktables.org and demo.racktables.org.

Everything else

SourceForge. SVN, racktables.org HTTP vhost, downloads and shell service.

Backup procedure

racktables-users

Send an empty email with subject "who racktables-users" to ecartis@freelists.org and you will get a list of all subscribers. Save it to the backup directory as "racktables-users.txt".

SourceForge data

  1. Project page, "Project admin", "Features", "XML export": save the file into backup directory as "racktables_export.xml".
  2. Backup stuff accessible from SF SSH only:
ssh -t YOUR_SF_USERNAME,racktables@shell.sourceforge.net create
adminrepo --checkout svn
svnadmin dump /svnroot/racktables | gzip > racktables-svn-dump.bin.gz
adminrepo --discard svn
tar czf racktables.org.tar.gz /home/project-web/racktables/htdocs/

sf-help | fgrep 'ssh -p'
# Note the hostname and the port and copy the files from SF shell to your directory:
scp -P 24006 YOUR_SF_USERNAME@shell4.sourceforge.net:~/racktables-svn-dump.bin.gz .
scp -P 24006 YOUR_SF_USERNAME@shell4.sourceforge.net:~/racktables.org.tar.gz .

# in SF shell again
rm racktables-svn-dump.bin.gz racktables.org.tar.gz
shutdown

Now the backup directory must have these files:

  • racktables-svn-dump.bin.gz
  • racktables-users.txt
  • racktables.org.tar.gz
  • racktables_export.xml

Wrap this stuff into a single archive file with a meaningful name and save it to a safe place: 

tar cf RackTables-project-backup-`date +%Y%m%d`.tar ./racktables*


Bug tracker, wiki data

SSH into the host and create a new backup directory. 

mkdir ~/RackTables-apps-backup
cd ~/RackTables-apps-backup

Copy the applications into the backup directory. This is important because they contain uploaded files and configuration settings. 

cp -r ~/www/bugs .
cp -r ~/www/wiki .

Export the database for each application. 

mysqldump -u <username> -p <dbname> > bugs.sql
mysqldump -u <username> -p <dbname> > wiki.sql

Wrap it all up in a single archive file and save it to a safe place: 

cd ~/
tar czf RackTables-apps-backup-`date +%Y%m%d`.tar.gz ./RackTables-apps-backup
Retrieved from "https://wiki.racktables.org/index.php?title=ProjectInfrastructure&oldid=352"