Changes between Version 71 and Version 72 of SandBoxPac

Timestamp:

07/09/09 14:35:37 (16 years ago)

Author:

pacitu

Comment:

--

SandBoxPac

@@ -62 +62 @@
 
 
----------------------------------
 
- * Кафе машината -  София, Сервиз "БЪЛГАРИЯ СЕРВИЗ" : 
-   * ул. "Вежен" 25, тел.: 963-22-49; 
-   * жк "Люлин-10" бл. 149-партер, тел.: 925-08-70, 925-13-22 
+ ==  Backup Structure and Restoring a Backup ==
+ === Backup Structure ===
+ The backup script is executed every Sunday at 3 Am. And two CD's
+ * Backup catalog structure 
+  * apache - the /etc/apache2/sites-enabled/ contents - this is the file with the apache configuration for the trac environment.
+  * build  - the /home/build/ contents - these are all the files needed to restore the hudson server, except the downloaded trunk of the repository.
+  * postgres - in here we keep the dump from the postgres database.
+  * s2s - the /home/s2s/ contents - these are all the files needed to restore the s2s server.
+  * scs - the /home/scs/ contents - these are all the files needed to restore the scs servers.
+  * site-packages - the /usr/lib/python2.5/site-packages/ contents - here is the trac installation and some of the plug-ins we're using, also every change to the trac's look and feel are stored here.
+ * Script
+{{{
+#!sh
+#!/bin/bash
+dirname="/root/backup/`date +%Y-%m-%d`"
 
----------------------------------
+mkdir $dirname
+mkdir $dirname/scs
+mkdir $dirname/build
+mkdir $dirname/build/.hudson
+mkdir $dirname/s2s
+mkdir $dirname/apache
+mkdir $dirname/postgres
 
- * Sophie2 Server set-up
-   * Trac 
-   * SVN 
-   * Postgres + migrating the WBS
-   * Nexus
-   * Buld Server 
-   * Hudson
-   * Testlink
-
- * SCS_REPO_MAINTENANCE, SCS_ISSUE_TRACKER_MAINTENANCE, SCS_BACKUP
-
- * New Server installation and set-up
-   * software RAID
-   * users + quotas
-   * vnc4server instances for all users
-   * Eclipse, Java 6, Maven
-
- * Dzver port forwarding.
-
- * Sophie2 web site with Dian.
+## Trac, testlink, svn and python site packages
+cp -R /home/scs/svn/ $dirname/scs
+cp -R /home/scs/trac/ $dirname/scs
+cp -R /home/scs/testlink/ $dirname/scs
+cp -R /home/scs/nexus/ $dirname/scs
+cp -R /usr/lib/python2.5/site-packages/ $dirname
 
 
+## Apache virtual host
+cp /etc/apache2/sites-available/trac $dirname/apache/
 
+## PstgreSQL database
+pg_dumpall -U scs -c -d > $dirname/postgres/pgdump
 
+## Build server
+copy() {
+   for file in `ls "$1$2"`
+   do
+      if [ $file = 'Sophie' ]
+      then
+         file="Sophie 2.0"
+      fi
+      if [ `echo "$1$2$file" | grep /sophie2/ | wc -l` -eq 0 ]
+      then
+         if [ -d "$1$2$file" ]
+         then
+            mkdir "$dirname/build/$2$file"
+            copy "$1" "$2$file/"
+         else
+            cp "$1$2$file" "$dirname/build/$2$file"
+         fi
+      else
+      mkdir "$1$2$file"
+      fi
+   done
+}
 
-{{{
-#!C
-   [WebMethod]
-    public List<City> SearchStates(string userName, string password, string name)
-    {
-        IWorkspace workspace = Connect(userName, password);
+copy /home/build   /.hudson/
 
-        List<City> resCities = new List<City>();
-        IFeatureClass statesClass = (workspace as IFeatureWorkspace).OpenFeatureClass("States");
-        IFeatureClass capitalsClass = (workspace as IFeatureWorkspace).OpenFeatureClass("Capitals");
-        int nameIndex = capitalsClass.FindField("CITY_NAME");
+## S2S server
+cp -R /home/s2s/sophie2server $dirname/s2s
 
-        IQueryFilter sfs = new QueryFilterClass();
-        sfs.WhereClause = "STATE_ABBR = '" + name + "'";
-        IFeatureCursor resCursor = statesClass.Search(sfs, true);
+tar -pczf "$dirname".tar.gz $dirname
+rm -Rf $dirname
 
-        IFeature state = resCursor.NextFeature();
-        while (state != null)
-        {
-            
-            ISpatialFilter sfc = new SpatialFilterClass();
-            IGeometry buffer = state.Shape;
-            sfc.Geometry = buffer;
-            sfc.SpatialRel = esriSpatialRelEnum.esriSpatialRelEnvelopeIntersects;
+#mkisofs -r -o  "$dirname".iso "$dirname".tar.gz
+#wodim  "$dirname".iso
+}}}
 
-            IFeatureCursor resCursorCy = capitalsClass.Search(sfc, true);
-            IFeature capital = resCursorCy.NextFeature();
+ After copying all the needed data for the back up the catalog is compressed to tar.gz so when we create the .iso there are no conflicts with long file names and the data can be stored to one DVD. 
 
-            while (capital != null)
-            {
-                resCities.Add(new City(capital.get_Value(nameIndex) as string, 0, 0));
-                capital = resCursorCy.NextFeature();
-            }
+=== Restoring a Backup ===
+ Restoring the scs, s2s and apache are as simple as copying the contents of the back-up to the corresponding catalogs in the Server. The build restore is a bit more tricky  because you have to checkout the repository in the $HUDSON_HOME/".hudson/jobs/Sophie\ 2.0/sophie2/trunk" before the server can run properly. ( you also copy the contents of the catalog into the $HUDSON_HOME) The postgres database can be restored with the  "pg_restore -c -f $FILE" command executed as root. Finally the trac environment can be restored on the Sophie2 server in the same manner, but if we have to move the servers to another machine, then only the files for the trac look and feel should be copied all the other things should be installed properly. 
 
-            Marshal.ReleaseComObject(resCursorCy);
-            state = resCursor.NextFeature();
-        }
-
-        Marshal.ReleaseComObject(resCursor);
-        return resCities;
-    }
-}}}