Imperial DIRAC FTS3

Installation

Install FTS3 database and add index as per [[1]] (The actual working command is:

ALTER TABLE Operations ADD INDEX rmsOpID (rmsOpID);

Though table is empty after install. Run this command after the setup below is finished and everything has been restarted (*))

lx02:EL7 > source bashrc
lx02:EL7 > dirac-proxy-init -g dirac_admin
lx02:EL7 > dirac-admin-sysadmin-cli -H dirac01.grid.hep.ph.ic.ac.uk
Pinging dirac01.grid.hep.ph.ic.ac.uk...
[dirac01.grid.hep.ph.ic.ac.uk]> install db FTS3DB
MySQL root password: 
Adding to CS DataManagement/FTS3DB
Database FTS3DB from DIRAC/DataManagementSystem installed successfully

Now the Agent and Service:

[dirac01.grid.hep.ph.ic.ac.uk]> install service DataManagement FTS3Manager
Loading configuration template /home/hep/dbauer/check_dirac/2018_Aug_10_1308_gridpp_EL7/DIRAC/DataManagementSystem/ConfigTemplate.cfg
Adding to CS service DataManagement/FTS3Manager
service DataManagement_FTS3Manager is installed, runit status: Run
[dirac01.grid.hep.ph.ic.ac.uk]> install agent DataManagement FTS3Agent
Loading configuration template /home/hep/dbauer/check_dirac/2018_Aug_10_1308_gridpp_EL7/DIRAC/DataManagementSystem/ConfigTemplate.cfg
Adding to CS agent DataManagement/FTS3Agent

(*)

mysql> show tables;
+------------------+
| Tables_in_FTS3DB |
+------------------+
| Files            |
| Jobs             |
| Operations       |
+------------------+
3 rows in set (0.00 sec)

mysql> ALTER TABLE Operations ADD INDEX rmsOpID (rmsOpID);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Configuration

Systems -> DataManagement -> Production -> Databases -> FTS3DB: change host to diracdb.dirac
Systems -> DataManagement -> Production -> Agents -> FTS3Agent: leave defaults
Systems -> DataManagement -> Production -> Services -> FTS3Manager: leave defaults

Systems -> RequestManagement -> Production -> Agents -> RequestExecutingAgent -> Operationhandlers -> ReplicateAndRegister
FTSMode = True
UseNewFTS3 = True
Create "RegisterReplica" section of not present (copy RemoveReplica and replace 'Location')
Operations -> Defaults -> DataManagement -> FTSPlacement (new):
FTSVersion = FTS3
Operations -> Defaults -> DataManagement -> FTSPlacement -> FTS3 (new):
ServerPolicy = Random
Resources -> FTSEndpoints -> FTS3:
IC-FTS3 = gttps://fts00.grid.hep.ph.ic.ac.uk:8446