1. Install latest LCG MONBOX (using YAIM)
  2. Create /etc/apt/sources.list.d/sft.list file with the following line:
    rpm http://grid-deployment.web.cern.ch/grid-deployment/gis/sft2 apt sft
  3. Install SFT server using the following commands
    apt-get update
    apt-get install perl-DBD-MySQL=2.1021.1-3lcg MySQL-python= mod_ssl lcg-sft-server
  4. Create archiver databases:
    $ mysql -p
    type your and then the following commands under MySQL shell:
    create database latestProducer;
    create database dbProducer;
    grant all privileges on latestProducer.* to 'rgma'@'localhost' identified by 'test';
    grant all privileges on latestProducer.* to 'rgma'@'%' identified by 'test';
    grant all privileges on dbProducer.* to 'rgma'@'localhost' identified by 'test';
    grant all privileges on dbProducer.* to 'rgma'@'%' identified by 'test';
    [MASTER only]
    grant replication slave on *.* to 'repl'@'%.your.domain' identified by 'rep_password';
    [end of MASTER only]
    flush privileges;
  5. Create SFT tables (only if running in other grid than LCG):
    cd /opt/lcg/sft/web/
    . tablesV0_4.sh
  6. Configure archiver: edit /opt/lcg/etc/lcg-archiver.conf and change the relevant lines as following:
    tables = TestData_v0_2 TestDef_v0_2:LATEST TestEnv_v0_2 GocSite_v0_4:LATEST GocNode_v0_4:LATEST
    db_user = rgma
    db_passwd = test
    db_latest = jdbc:mysql://localhost/latestProducer
    db_hist= jdbc:mysql://localhost/dbProducer
    • On the MASTER:
      1. Create a snapshot of the MySQL data directory:
        cd /var/lib
        tar cf /tmp/mysql-snapshot.tar mysql
      2. Copy the snapshot to safe place or any SLAVE machine and after finishing MASTER configuration follow instructions for SLAVE on the slave machine.
      3. Enable binary logging in mysql DB by editing /etc/my.cnf and making sure the following lines are present (create the file if it does not exist):
      4. Restart the mysql daemon:
        service mysql restart
      5. (re)start archiver:
        service lcg-archiver restart
      6. Enable passwordless (key based) ssh authentication for root from any SLAVE machines.
      7. Create /etc/rsyncd.conf file with the following contents:
          path = /opt/lcg/sft/web/info
          comment = SFT2 logs directory
    • On the SLAVE
      1. Stop the mysql daemon:
        service mysql stop
      2. Unpack MASTER database snapshot:
        cd /var/lib
        tar xf  <dir_with_snapshot>/mysql-snapshot.tar
      3. Set server ID for MySQL. Note: server ID must be different from Master's ID (1) and all other SLAVE IDs. Edit /etc/my.cnf and make sure the following lines are there:
      4. Start the mysql daemon:
        service mysql start
      5. Configure slave function in MySQL:
        mysql -p
        <root password>
        in MySQL shell:
        change master to master_host='MASTER-hostname', master_user='repl', master_password='rep_password', 
             master_log_file='mysql-bin.001', master_log_pos=0;
        start slave;
      6. Set up a passwordless ssh authentication from SLAVE to MASTER.
      7. Add the following line to /opt/lcg/sft/web/sft.conf file:
      8. Setup a cron job that synchronises info directory with MASTER
        crontab -e
        */5 * * * * /opt/lcg/sft/web/syncInfo.sh > /opt/lcg/var/log/lcg-syncInfo.log 2>&1

-- Main.jnovak - 17 Aug 2005
Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2005-08-18 - unknown
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback