Page History

...

    mkdir /root/.ssh
    mkdir /home/rmtbckup

3.Create ssh key

Wiki Markup        ssh-keygen \ -t rsa \ -b 1024     \1024
    [press return until you are back to command line - do not use encrypted private keys, as this will cause the cron job to fail\]

4.Copy ssh key to eurydice.mit.edu

    scp /root/.ssh/id_rsa.pub \
    rmtbckup@eurydice.mit.edu:/home/rmtbckup/.ssh/`hostname`-id_rsa.pubunmigrated-wiki-markup

5.Login to eurydice as rmtbckup  \as rmtbckup  [note, this should be done from another thalia system, as Ubuntu does not currently have working Kerberos configurations\]

6.Add public key to authorized key lists and deleted from eurydice

     1.On Eurydice:

Wiki Markup         cd          cd /home/rmtbckup/.ssh          cat \[remote hostname\
         cat [remote hostname]-id_rsa.pub >> authorized_keys          rm \[remote hostname\
         rm [remote hostname]-id_rsa.pub

     2.On remote server:

         cd /root/.ssh
         cat id_rsa.pub >> authorized_keys

...

        Alternatively, you could backup the filestore with the tar command:

Wiki Markup    tar \    tar -czf /home/rmtbckup/`hostname`-file-`date \ +%F-%H-%M`.tgz /home/\[alf_home\]/alf_data/\*

5.Login to Eurydice as rmtbckup and check that the files are there.

...

    rm -rf  $ALF_HOME/alf_data

5.Untar the file backup:

Wiki Markup    tar \    tar -xjvf /home/rmtbckup/`hostname`-file-\[date of backup\].bz2 $ALF_HOME/alf_data

6.Login to the MySQL server, and dump the database.  The database name is available in the alfresco/extensions directory in the custom-db-connections.properties file.

Wiki Markup    mysql     drop database \    mysql
    drop database [db.name\];     revoke all
    revoke all privileges, grant option from \ [db.username\]@*;     drop user \
    drop user [db.username\]@*;

7.Source the sql backup, and grant privledges to the Alfresco user.  See custom-db-connections.properites.

Wiki Markup    source     source /home/rmtbckup/\[hostname\]-db-\[db.name\]-\[date of backup\].sql;     grant all on \
    grant all on [db.name\].\* to \ [db.username\]@'localhost' identified by \ [db.password\] with     grant option;     grant all on \with
    grant option;
    grant all on [db.name\].\* to \ [db.username\]@'localhost.localdomain' identified by \ [db.password\] with grant option;     grant all on \
    grant all on [db.name\].\* to \ [db.username\]@\[IP of Alfresco server\] identified by \ [db.password\] with grant option;     grant all on \
    grant all on [db.name\].\* to \ [db.username\]@\[hostname of Alfresco server\] identified by \ [db.password\] with grant option;

8.Login to Alfresco server and restart Alfresco.

...