UVOS Test Report v. 1.4.1 for EMI-1-RC0

Component: UNICORE VO System (UVOS)

Savannah task: https://savannah.cern.ch/task/?18731

ETICS Configuration Names: emi-unicore-uvos-clc_B_TRUNK, emi-unicore-uvos-server_B_TRUNK, emi-unicore-uvos-webapp_B_TRUNK, emi-unicore-uvos-webauth_B_TRUNK

VCS Tag: NONE (trunk)

EMI Major Release: EMI 1

Platform: SL5/x86_64

Author(s): Krzysztof Benedyczak

Date: 04.04.2011

Summary

  1. Deployment test:
    1. Clean Installation - PASS
    2. Upgrade Installation - NA
  2. Static Code Analysis - Not done
  3. Unit Test coverage - PASS
  4. System tests:
    1. Basic Functionality tests - PASS
    2. Regression tests - PASS
    3. Performance/Scalability tests - PASS
    4. Standard Compliance/Conformance tests - NA

Automatic pre-packaging tests

Full build log including output of all unit tests and all automated functional and regression tests is available here:

Common library: http://unicore-dev.zam.kfa-juelich.de/bamboo/download/UVOS-COMMONTRUNK/build_logs/UVOS-COMMONTRUNK-19.log

Server: http://unicore-dev.zam.kfa-juelich.de/bamboo/download/UVOS-UVOSSERVERTRUNK/build_logs/UVOS-UVOSSERVERTRUNK-38.log

Client: http://unicore-dev.zam.kfa-juelich.de/bamboo/download/UVOS-UVOSCLIENT/build_logs/UVOS-UVOSCLIENT-39.log

Code coverage and unit tests

Common library: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-COMMONTRUNK-19/artifact/cobertura/index.html

Server: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSSERVERTRUNK-38/artifact/Cobertura-report/index.html

Client: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSCLIENT-39/artifact/Cobertura-report/index.html

Regression tests

Common library: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-COMMONTRUNK-19/artifact/Tests-reports/regressionTestReport.html

Server: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSSERVERTRUNK-38/artifact/Tests-reports/regressionTestReport.html

Notes: Bug 3020090 was fixed. There no regression test as fix was a change in architecture: now security context is not handled manually by implementation but it is stored as thread-local data.

Client: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSCLIENT-39/artifact/Tests-reports/regressionTestReport.html

Functional tests

Common library: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-COMMONTRUNK-19/artifact/Tests-reports/functionalTestReport.html

Server: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSSERVERTRUNK-38/artifact/Tests-reports/functionalTestReport.html

Client: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSCLIENT-39/artifact/Tests-reports/functionalTestReport.html

Standard Compliance/Conformance tests

Nothing yet according to the test plan.

Performance and Scalability tests

Performance test
$ mvn test -Dtest=PerformanceTest
...
Starting performance metering...


IDENTITY CREATION performed 500 in 0.742s, 673.0 ops/s
GROUP CREATION performed 1000 in 1.281s, 780.0 ops/s
NESTED GROUP CREATION performed 100 in 0.73s, 136.0 ops/s
ADD TO GROUP performed 1000 in 0.336s, 2976.0 ops/s
ADD GLOBAL ATTR performed 100 in 0.054s, 1851.0 ops/s
ADD GROUP ATTR performed 100 in 0.036s, 2777.0 ops/s
ADD ID@GROUP ATTR performed 100 in 0.054s, 1851.0 ops/s
UPDATE GLOBAL ATTR performed 100 in 0.07s, 1428.0 ops/s
UPDATE GROUP ATTR performed 100 in 0.05s, 2000.0 ops/s
UPDATE ID@GROUP ATTR performed 100 in 0.081s, 1234.0 ops/s
GET ALL IDENTITIES performed 100 in 0.38s, 263.0 ops/s
GET ALL IDENTITY'S IMPLIED GROUPS performed 100 in 0.123s, 813.0 ops/s
GET ALL IDENTITY'S DIRECT GROUPS performed 100 in 0.086s, 1162.0 ops/s
GET ALL IDENTITY'S ATTRIBUTES (true, true, true) performed 100 in 0.123s, 813.0 ops/s
GET ALL IDENTITY'S ATTRIBUTES (true, true, false) performed 100 in 0.094s, 1063.0 ops/s
GET ALL IDENTITY'S ATTRIBUTES (true, false, false) performed 100 in 0.058s, 1724.0 ops/s
GET IDENTITY'S GLOBAL ATTRIBUTES performed 100 in 0.052s, 1923.0 ops/s
GET IDENTITY'S ATTRIBUTES@GROUP (true, true, true) performed 100 in 0.09s, 1111.0 ops/s
GET GROUP CONTENTS performed 100 in 0.03s, 3333.0 ops/s
REMOVE FROM GROUP performed 10 in 0.024s, 416.0 ops/s
NESTED GROUP REMOVAL performed 11 in 0.192s, 57.0 ops/s
IDENTITIY REMOVAL performed 501 in 0.396s, 1265.0 ops/s
PERFORMANCE TEST PASSED
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.549 sec

Scalability test
$ mvn test -Dtest=StressTest
...
Concurrent part
Thread TGetAllIds did 71680 ops.
Thread TIsMember did 1166 ops.
Thread TGetAttributes did 127 ops.
Thread TGetAllEquivs did 6502 ops.
Thread TGetGroupCont did 2678 ops.
Thread TGetAllGroups did 3079 ops.
Thread TGroupMess did 57 ops.
Thread TMembersMess did 64 ops.
Thread TEquivMess did 12 ops.
Thread TIdsSimpleMess did 52 ops.
Thread TAttrsMess did 36 ops.
Thread TGroup2Mess did 42 ops.
Thread TIdsMess did 5 ops.
Used memory: 23585976
Change: 7376264
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 48.226 sec

Clean installation deployment report

Full report link: uvos-1.4.1-EMI1-rc0-full.txt

Shortened report:

--- [INFO] Deployment test: ./testcases.d/uvos
--- [INFO] Started at: Fri Mar  4 00:05:30 CET 2011
--- [INFO] Platform: Scientific Linux SL release 5.5 x86_64
--- [INFO] Uninstalling the package unicore-uvos-server and cleaning all its files
--- [INFO] Uninstalling the package unicore-uvos-server and cleaning all its files
unicore-uvos-server-1.4.1-SNAPSHOT.noarch
Loaded plugins: kernel-module
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-server.noarch 0:1.4.1-SNAPSHOT set to be erased
--> Processing Dependency: unicore-uvos-server >= 1.4.0 for package: unicore-uvos-webapp
--> Processing Dependency: unicore-uvos-server >= 1.4.0 for package: unicore-uvos-webauth
--> Running transaction check
---> Package unicore-uvos-webapp.noarch 0:1.5.0-0 set to be erased
---> Package unicore-uvos-webauth.noarch 0:1.5.0-0 set to be erased
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                   Arch        Version             Repository      Size
================================================================================
Removing:
 unicore-uvos-server       noarch      1.4.1-SNAPSHOT      installed       33 M
Removing for dependencies:
 unicore-uvos-webapp       noarch      1.5.0-0             installed      4.4 M
 unicore-uvos-webauth      noarch      1.5.0-0             installed      837 k

Transaction Summary
================================================================================
Install      0 Package(s)         
Update       0 Package(s)         
Remove       3 Package(s)         

Is this ok [y/N]: Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing        : unicore-uvos-webauth                                     1/3 
  Erasing        : unicore-uvos-server                                      2/3 
warning: /etc/unicore/uvos-server/uvosServer.conf saved as /etc/unicore/uvos-server/uvosServer.conf.rpmsave
  Erasing        : unicore-uvos-webapp                                      3/3 

Removed:
  unicore-uvos-server.noarch 0:1.4.1-SNAPSHOT                                   

Dependency Removed:
  unicore-uvos-webapp.noarch 0:1.5.0-0   unicore-uvos-webauth.noarch 0:1.5.0-0  

Complete!
--- [INFO] Uninstalling the package unicore-uvos-clc and cleaning all its files
--- [INFO] Uninstalling the package unicore-uvos-clc and cleaning all its files
unicore-uvos-clc-1.4.1-SNAPSHOT.noarch
Loaded plugins: kernel-module
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-clc.noarch 0:1.4.1-SNAPSHOT set to be erased
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                Arch         Version              Repository       Size
================================================================================
Removing:
 unicore-uvos-clc       noarch       1.4.1-SNAPSHOT       installed        16 M

Transaction Summary
================================================================================
Install      0 Package(s)         
Update       0 Package(s)         
Remove       1 Package(s)         

Is this ok [y/N]: Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing        : unicore-uvos-clc                                         1/1 
warning: /etc/unicore/uvos-clc/uvosClient.conf saved as /etc/unicore/uvos-clc/uvosClient.conf.rpmsave

Removed:
  unicore-uvos-clc.noarch 0:1.4.1-SNAPSHOT                                      

Complete!
--- [INFO] Uninstalling the package unicore-uvos-webapp and cleaning all its files
--- [INFO] Uninstalling the package unicore-uvos-webapp and cleaning all its files
package unicore-uvos-webapp is not installed
--- [INFO] Uninstalling the package unicore-uvos-webauth and cleaning all its files
--- [INFO] Uninstalling the package unicore-uvos-webauth and cleaning all its files
package unicore-uvos-webauth is not installed
--- [INFO] Setting up the repository
--- [INFO] Setting up the repository
--- [INFO] 
--- [INFO] 
--- [INFO] YUM_REPOSITORY=https://twiki.cern.ch/twiki/pub/EMI/EMI-1/rc0.repo
--- [INFO] YUM_REPOSITORY=https://twiki.cern.ch/twiki/pub/EMI/EMI-1/rc0.repo
--- [INFO] 
--- [INFO] 
--- [INFO] Fetching yum Repository definition
--- [INFO] Fetching yum Repository definition
--- [INFO] Installing from binary package
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-server
--- [INFO]   Component: uvos-server
--- [INFO]   Package:   unicore-uvos-server
--- [INFO]   Package:   unicore-uvos-server
--- [INFO] 
--- [INFO] 
Loaded plugins: kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-server.noarch 0:1.4.1-SNAPSHOT set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                  Arch        Version              Repository      Size
================================================================================
Installing:
 unicore-uvos-server      noarch      1.4.1-SNAPSHOT       EMI-1-RC0       26 M

Transaction Summary
================================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 26 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : unicore-uvos-server                                      1/1 

Installed:
  unicore-uvos-server.noarch 0:1.4.1-SNAPSHOT                                   

Complete!
unicore-uvos-server-1.4.1-SNAPSHOT.noarch
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-clc
--- [INFO]   Package:   unicore-uvos-clc
--- [INFO] 
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-clc
--- [INFO]   Package:   unicore-uvos-clc
--- [INFO] 
Loaded plugins: kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-clc.noarch 0:1.4.1-SNAPSHOT set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                Arch         Version              Repository       Size
================================================================================
Installing:
 unicore-uvos-clc       noarch       1.4.1-SNAPSHOT       EMI-1-RC0        14 M

Transaction Summary
================================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 14 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : unicore-uvos-clc                                         1/1 

Installed:
  unicore-uvos-clc.noarch 0:1.4.1-SNAPSHOT                                      

Complete!
unicore-uvos-clc-1.4.1-SNAPSHOT.noarch
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystore = /etc/unicore/uvos-server/certs/dummyServer.jks
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystoreAlias = mykey
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keyPasswd = _COMMENT
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystore = /etc/unicore/uvos-server/certs/dummyServer.jks
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystoreAlias = mykey
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keyPasswd = _COMMENT
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystore = /etc/unicore/uvos-server/certs/dummyServer.jks
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystoreAlias = mykey
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keyPasswd = _COMMENT
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.https.truststoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystore = /etc/unicore/uvos-server/certs/dummyServer.jks
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystoreType = JKS
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keystoreAlias = mykey
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property keyPasswd = _COMMENT
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststorePasswd = the!server
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststoreType = JKS
Checking content of DB
CREATE TABLE UVOS_FLAG_(        VAL CHAR(128)   ) 
Clearing DB
DROP TABLE UVOS_FLAG_ 
DROP TABLE NOTIFICATIONS 
DROP TABLE APPLICATIONS 
DROP TABLE APPLICATION_FORMS 
DROP TABLE AUTHZ_ATTRIBUTE 
DROP TABLE AUTHZ_SPECIAL 
DROP TABLE GROUP_ENTITIES 
DROP TABLE GROUP_SUBGROUPS 
DROP TABLE GROUP_ATTRIBUTES 
DROP TABLE ENTITY_ATTRIBUTES 
DROP TABLE GROUPS 
DROP TABLE IDENTITIES 
DROP TABLE ENTITIES 
DROP TABLE IDENTITY_TYPES 
DROP TABLE ATTRIBUTE_TYPES 
Initialazing DB
CREATE TABLE IDENTITY_TYPES(    ID INTEGER IDENTITY NOT NULL,   VAL VARCHAR(1024)       ) 
CREATE TABLE ATTRIBUTE_TYPES(   ID INTEGER IDENTITY NOT NULL,   NAME VARCHAR(1024) NOT NULL,    SHORT_DESC VARCHAR(256),     DESCRIPTION VARCHAR(10240),      CONSTRAINT attrtype_name_unique UNIQUE(NAME)    ) 
CREATE TABLE ENTITIES(  ID INTEGER IDENTITY NOT NULL,   PERSISTENT_ID VARCHAR(256) NOT NULL,    NAME VARCHAR(255),      CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   REMOVED_ID INTEGER DEFAULT -1 NOT NULL,      CONSTRAINT entities_removed_unique UNIQUE (NAME, REMOVED_ID),    CONSTRAINT persistent_id_unique UNIQUE (PERSISTENT_ID)  ) 
CREATE TABLE IDENTITIES(        ID INTEGER IDENTITY NOT NULL,   VAL VARCHAR(30000) NOT NULL,    CMP VARCHAR(1024) NOT NULL,  TYPEID INTEGER,  ENTITY_ID INTEGER NOT NULL,     AUTHN_DATA VARCHAR(10240),      CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   REMOVED_ID INTEGER DEFAULT -1 NOT NULL,         INACTIVE INTEGER DEFAULT 0 NOT NULL, CONSTRAINT identities_fk_typeid FOREIGN KEY (TYPEID) REFERENCES IDENTITY_TYPES(ID),      CONSTRAINT identities_fk_entityid FOREIGN KEY (ENTITY_ID) REFERENCES ENTITIES(ID),    CONSTRAINT identities_removed_unique UNIQUE(CMP, TYPEID, REMOVED_ID)    ) 
CREATE TABLE GROUPS(    ID INTEGER IDENTITY NOT NULL,   NAME VARCHAR(255),      PARENT_ID INTEGER,      CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   REMOVED_ID INTEGER DEFAULT -1 NOT NULL,         CONSTRAINT groups_removed_unique UNIQUE (PARENT_ID, NAME, REMOVED_ID),        CONSTRAINT groups_fk_parentid FOREIGN KEY (PARENT_ID) REFERENCES GROUPS(ID) ON DELETE CASCADE         ) 
CREATE TABLE GROUP_ATTRIBUTES(  ID INTEGER IDENTITY NOT NULL,   VAL VARCHAR(102400),    ATTRTYPE_ID INTEGER NOT NULL,   GROUP_ID INTEGER,     INACTIVE INTEGER DEFAULT 0 NOT NULL,    CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,       REMOVAL_TS TIMESTAMP,         CONSTRAINT groupattr_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID),   CONSTRAINT groupattr_fk_attrtypeid FOREIGN KEY (ATTRTYPE_ID) REFERENCES ATTRIBUTE_TYPES(ID)   ) 
CREATE TABLE ENTITY_ATTRIBUTES(         ID INTEGER IDENTITY NOT NULL,   ATTRTYPE_ID INTEGER NOT NULL,   VAL VARCHAR(102400), ENTITY_ID INTEGER,       GROUP_ID INTEGER,       INACTIVE INTEGER DEFAULT 0 NOT NULL,    CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   CONSTRAINT entityattributes_fk_entityid FOREIGN KEY (ENTITY_ID) REFERENCES ENTITIES(ID),              CONSTRAINT entityattributes_fk_attrtypeid FOREIGN KEY (ATTRTYPE_ID) REFERENCES ATTRIBUTE_TYPES(ID),  CONSTRAINT entityattributes_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID)              ) 
CREATE TABLE GROUP_ENTITIES(    ID INTEGER IDENTITY NOT NULL,   ENTITY_ID INTEGER,      GROUP_ID INTEGER,       CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   REMOVED_ID INTEGER DEFAULT -1 NOT NULL,         CONSTRAINT group_entities_removed_unique UNIQUE (ENTITY_ID, GROUP_ID, REMOVED_ID),    CONSTRAINT group_entities_fk_entityid FOREIGN KEY (ENTITY_ID) REFERENCES ENTITIES(ID),        CONSTRAINT group_entities_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID)                     ) 
CREATE TABLE GROUP_SUBGROUPS(   CHILD_ID INTEGER,       GROUP_ID INTEGER,       CREATION_TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,     REMOVAL_TS TIMESTAMP,   PRIMARY KEY (CHILD_ID, GROUP_ID),       CONSTRAINT groupsubgroups_fk_childid FOREIGN KEY (CHILD_ID) REFERENCES GROUPS(ID),    CONSTRAINT groupsubgroups_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID)     ) 
CREATE TABLE AUTHZ_ATTRIBUTE(   ATTR_TYPE_ID INTEGER NOT NULL,  ATTR_VALUE VARCHAR(102400),     GROUP_ID INTEGER,       PERMISSION INTEGER NOT NULL,  CONSTRAINT authzattr_unique UNIQUE (ATTR_TYPE_ID, ATTR_VALUE, GROUP_ID),        CONSTRAINT authzattr_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID),         CONSTRAINT authzattr_fk_attrtypeid FOREIGN KEY (ATTR_TYPE_ID) REFERENCES ATTRIBUTE_TYPES(ID)          ) 
CREATE TABLE AUTHZ_SPECIAL(     SPECIAL CHAR(1) NOT NULL,       GROUP_ID INTEGER,       PERMISSION INTEGER NOT NULL,    CONSTRAINT authzspecial_unique UNIQUE (GROUP_ID, SPECIAL),    CONSTRAINT authzspecial_fk_groupid FOREIGN KEY (GROUP_ID) REFERENCES GROUPS(ID)       ) 
CREATE TABLE APPLICATION_FORMS(         ID INTEGER IDENTITY NOT NULL,   FRIENDLY_NAME VARCHAR(256),     DESCRIPTION VARCHAR(10240),   AGREEMENT VARCHAR(102400),      BASE_GROUP_ID INTEGER,  CONSTRAINTS VARCHAR(102400),    CONSTRAINT applicationforms_fk_basegroupid FOREIGN KEY (BASE_GROUP_ID) REFERENCES GROUPS(ID)  ) 
CREATE TABLE APPLICATIONS(      ID INTEGER IDENTITY NOT NULL,   FORM_ID INTEGER,        ID_VAL VARCHAR(30000) NOT NULL,      ID_TYPEID INTEGER,       ID_AUTHN_DATA VARCHAR(10240),   IS_CSR INTEGER,         EMAIL_ADDRESS VARCHAR(256),     REQUESTS VARCHAR(102400),     STATUS VARCHAR(16),     ADMIN_NOTES VARCHAR(10240),     EQUIVALENT_ID INTEGER,  CONSTRAINT applications_fk_idtypeid FOREIGN KEY (ID_TYPEID) REFERENCES IDENTITY_TYPES(ID),    CONSTRAINT applications_fk_formid FOREIGN KEY (FORM_ID) REFERENCES APPLICATION_FORMS(ID) ON DELETE CASCADE,   CONSTRAINT applications_fk_equivalentid FOREIGN KEY (EQUIVALENT_ID) REFERENCES IDENTITIES(ID) ON DELETE CASCADE       ) 
CREATE TABLE NOTIFICATIONS(     ID INTEGER IDENTITY NOT NULL,   GROUP_FILTER VARCHAR(1024),     RECIPIENTS VARCHAR(1024) NOT NULL,    OPERATION VARCHAR(32) ) 
CREATE TABLE UVOS_FLAG_(        VAL CHAR(128)   ) 
INSERT INTO UVOS_FLAG_ (VAL) VALUES ('1_2_0') 
Putting initial data into DB
INSERT INTO IDENTITY_TYPES (VAL) VALUES         ('urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress') 
INSERT INTO IDENTITY_TYPES (VAL) VALUES         ('urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName') 
INSERT INTO IDENTITY_TYPES (VAL) VALUES         ('urn:unicore:idType:X509Certificate') 
INSERT INTO ATTRIBUTE_TYPES (NAME, SHORT_DESC, DESCRIPTION) VALUES      ('urn:authz:intervo:vo', 'VO service internal authorization', 'Assigning special values of this attribute changes VO service or VO group (depending on the attribute scope) access permissions if the default authZ policy is used. Valid values are: read, fullRead, identityCtl and write') 
INSERT INTO AUTHZ_ATTRIBUTE (ATTR_TYPE_ID, ATTR_VALUE, PERMISSION)      SELECT ID, 'read', 1 FROM ATTRIBUTE_TYPES WHERE      NAME = 'urn:authz:intervo:vo' 
INSERT INTO AUTHZ_ATTRIBUTE (ATTR_TYPE_ID, ATTR_VALUE, PERMISSION)      SELECT ID, 'fullRead', 3 FROM ATTRIBUTE_TYPES WHERE  NAME = 'urn:authz:intervo:vo' 
INSERT INTO AUTHZ_ATTRIBUTE (ATTR_TYPE_ID, ATTR_VALUE, PERMISSION)      SELECT ID, 'identityCtl', 7 FROM ATTRIBUTE_TYPES WHERE                NAME = 'urn:authz:intervo:vo' 
INSERT INTO AUTHZ_ATTRIBUTE (ATTR_TYPE_ID, ATTR_VALUE, PERMISSION)      SELECT ID, 'write', 15 FROM ATTRIBUTE_TYPES WHERE    NAME = 'urn:authz:intervo:vo' 
INSERT INTO AUTHZ_SPECIAL (SPECIAL, PERMISSION) VALUES  ('M', 1) 
INSERT INTO AUTHZ_SPECIAL (SPECIAL, PERMISSION) VALUES  ('O', 7) 
INSERT INTO ENTITIES (NAME, PERSISTENT_ID) VALUES       ('VOADMIN', '1234') 
INSERT INTO IDENTITIES (VAL, CMP, TYPEID, ENTITY_ID)    SELECT 'voadmin@localhost', 'voadmin@localhost', IDENTITY_TYPES.ID, ENTITIES.ID FROM IDENTITY_TYPES, ENTITIES WHERE           VAL = 'urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress' AND NAME = 'VOADMIN' 
INSERT INTO ENTITY_ATTRIBUTES (ATTRTYPE_ID, ENTITY_ID, VAL)     SELECT ATTRIBUTE_TYPES.ID, ENTITIES.ID, 'write' FROM ATTRIBUTE_TYPES, ENTITIES WHERE           ATTRIBUTE_TYPES.NAME = 'urn:authz:intervo:vo' AND ENTITIES.NAME = 'VOADMIN' 
RECREATING ALL PERSISTENT ENTITY IDs.
ALL PERSISTENT ENTITY IDs WERE UPDATED.
--- [INFO] Starting the service unicore-uvos-server
--- [INFO] Starting the service unicore-uvos-server
Starting UVOS:                                             [  OK  ]
--- [INFO] 
--- [INFO] 
--- [INFO] uvos-server active for user unicore ...
--- [INFO] uvos-server active for user unicore ...
--- [INFO] Waiting for service to start...
--- [INFO] Waiting for service to start...
--- [INFO] Checking if log file uvos is present for component uvos-server
--- [INFO] Checking if log file uvos is present for component uvos-server
--- [INFO] 
--- [INFO] Log file present on the system.
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] No problems in the log file were found.
--- [INFO] 
--- [INFO] Log file present on the system.
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] No problems in the log file were found.
Available identity types are:
  urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress
  urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName
  urn:unicore:idType:X509Certificate
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] No problems in the log file were found.
--- [INFO] No problems in the log file were found.
Stopping UVOS: Waiting for server to stop...
Server stopped.

--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-webauth
--- [INFO]   Package:   unicore-uvos-webauth
--- [INFO] 
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-webauth
--- [INFO]   Package:   unicore-uvos-webauth
--- [INFO] 
Loaded plugins: kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-webauth.noarch 0:1.5.0-0 set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                    Arch         Version          Repository       Size
================================================================================
Installing:
 unicore-uvos-webauth       noarch       1.5.0-0          EMI-1-RC0       833 k

Transaction Summary
================================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 833 k
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : unicore-uvos-webauth                                     1/1 

Installed:
  unicore-uvos-webauth.noarch 0:1.5.0-0                                         

Complete!
unicore-uvos-webauth-1.5.0-0.noarch
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-webapp
--- [INFO]   Package:   unicore-uvos-webapp
--- [INFO] 
--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-webapp
--- [INFO]   Package:   unicore-uvos-webapp
--- [INFO] 
Loaded plugins: kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-webapp.noarch 0:1.5.0-0 set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin

Dependencies Resolved

================================================================================
 Package                    Arch          Version        Repository        Size
================================================================================
Installing:
 unicore-uvos-webapp        noarch        1.5.0-0        EMI-1-RC0        4.4 M

Transaction Summary
================================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 4.4 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : unicore-uvos-webapp                                      1/1 

Installed:
  unicore-uvos-webapp.noarch 0:1.5.0-0                                          

Complete!
unicore-uvos-webapp-1.5.0-0.noarch
--- [INFO] Starting the service unicore-uvos-server
--- [INFO] Starting the service unicore-uvos-server
Starting UVOS:                                             [  OK  ]
--- [INFO] 
--- [INFO] uvos-server active for user unicore ...
--- [INFO] Waiting for service to start...
--- [INFO] 
--- [INFO] uvos-server active for user unicore ...
--- [INFO] Waiting for service to start...
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] No problems in the log file were found.
--- [INFO] Checking if log file uvos of uvos-server contains any problematic phrases
--- [INFO] No problems in the log file were found.
Stopping UVOS: Waiting for server to stop...
Server stopped.
--- [INFO] Checking if documentation is present for uvos-server
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-clc
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-webapp
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-webauth
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Outcome: PASSED

--- [INFO] Checking if documentation is present for uvos-server
total 1168
drwxr-xr-x  2 root root   4096 Mar  4 00:05 .
drwxr-xr-x 10 root root   4096 Mar  4 00:06 ..
-rw-r--r--  1 root root   5581 Feb 27 16:49 Changes.txt
-rw-r--r--  1 root root   1491 Feb 27 16:49 LICENSE.ICM
-rw-r--r--  1 root root   3125 Feb 27 16:49 UPGRADE.txt
-rw-r--r--  1 root root  71202 Feb 27 16:49 UVOSAdministration.odt
-rw-r--r--  1 root root 347827 Feb 27 16:49 UVOSAdministration.pdf
-rw-r--r--  1 root root 183368 Feb 27 16:49 UVOSOverview.odt
-rw-r--r--  1 root root 547108 Feb 27 16:49 UVOSOverview.pdf
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-clc
total 56
drwxr-xr-x  3 root root  4096 Mar  4 00:05 .
drwxr-xr-x 10 root root  4096 Mar  4 00:06 ..
-rw-r--r--  1 root root  2160 Feb 27 16:40 Changes.txt
-rw-r--r--  1 root root  2961 Feb 27 16:40 ClientConfiguration.txt
-rw-r--r--  1 root root 25663 Feb 27 16:40 CommandsReference.txt
drwxr-xr-x  2 root root  4096 Mar  4 00:05 examples
-rw-r--r--  1 root root  1492 Feb 27 16:40 LICENSE.ICM
-rw-r--r--  1 root root  2833 Feb 27 16:40 README
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-webapp
total 28
drwxr-xr-x  2 root root 4096 Mar  4 00:06 .
drwxr-xr-x 10 root root 4096 Mar  4 00:06 ..
-rw-r--r--  1 root root  750 Feb 27 16:30 Changes.txt
-rw-r--r--  1 root root 1491 Feb 27 16:30 LICENSE.ICM
-rw-r--r--  1 root root 1497 Feb 27 16:30 README
-rw-r--r--  1 root root 6068 Feb 27 16:30 referenceApplicationForm.xml
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Checking if documentation is present for uvos-webauth
total 32
drwxr-xr-x  2 root root 4096 Mar  4 00:06 .
drwxr-xr-x 10 root root 4096 Mar  4 00:06 ..
-rw-r--r--  1 root root  391 Feb 27 16:39 Changes.txt
-rw-r--r--  1 root root 1615 Feb 27 16:39 DEVELOPER
-rw-r--r--  1 root root 1491 Feb 27 16:39 LICENSE.ICM
-rw-r--r--  1 root root 2080 Feb 27 16:39 README
-rw-r--r--  1 root root 4993 Feb 27 16:39 TestLoginServlet.java
--- [INFO] 
--- [INFO] Documentation present on the system.
--- [INFO] Outcome: PASSED

Upgrade deployment report

N/A - this is the first EMI Linux-packaged release.
Topic attachments
I Attachment History Action Size Date Who Comment
Texttxt uvos-1.4.1-EMI1-rc0-full.txt r1 manage 64.1 K 2011-03-04 - 11:50 UnknownUser Full deployment test report for RC0
Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2011-03-04 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    EMI All webs login

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