Difference between revisions of "Imperial DIRAC FTS3"

From GridPP Wiki
Jump to: navigation, search
(Configuration)
(Installation)
 
Line 4: Line 4:
 
(The actual working command is:
 
(The actual working command is:
 
<pre>ALTER TABLE Operations ADD INDEX rmsOpID (rmsOpID);</pre>
 
<pre>ALTER TABLE Operations ADD INDEX rmsOpID (rmsOpID);</pre>
Though table is empty after install.)
+
Though table is empty after install. Run this command after the setup below is finished and everything has been restarted (*))
  
 
<pre>
 
<pre>
Line 26: Line 26:
 
Loading configuration template /home/hep/dbauer/check_dirac/2018_Aug_10_1308_gridpp_EL7/DIRAC/DataManagementSystem/ConfigTemplate.cfg
 
Loading configuration template /home/hep/dbauer/check_dirac/2018_Aug_10_1308_gridpp_EL7/DIRAC/DataManagementSystem/ConfigTemplate.cfg
 
Adding to CS agent DataManagement/FTS3Agent
 
Adding to CS agent DataManagement/FTS3Agent
 +
</pre>
 +
 +
(*)
 +
<pre>
 +
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
 
</pre>
 
</pre>
  

Latest revision as of 10:46, 17 August 2018

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