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

Component: UNICORE VO System (UVOS)

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

ETICS Configuration Names: emi-unicore-uvos-server_R_1_4_1_rc1,
emi-unicore-uvos-clc_R_1_4_1_0,
emi-unicore-uvos-webapp_R_1_5_0_p1,
emi-unicore-uvos-webauth_R_1_5_0_p1

VCS Tag: https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-common/tags/uvos-common-1.4.1,
https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-server/tags/rel-1.4.1-rc1,
https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-client/tags/uvos-client-1.4.1,
https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-webapp/tags/uvos-webapp-1.5.0-p1,
https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-webauthn/tags/uvos-webauthn-1.5.0-p1

EMI Major Release: EMI 1

Platform: SL5/x86_64

Author(s): Krzysztof Benedyczak

Date: 17.03.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-20.log

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

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

Code coverage and unit tests

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

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

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

Regression tests

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

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

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

Functional tests

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

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

Client: http://unicore-dev.zam.kfa-juelich.de/bamboo/browse/UVOS-UVOSCLIENT-47/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: full

Shortened report:

--- [INFO] Deployment test: ./testcases.d/uvos
--- [INFO] Started at: Thu Mar 17 20:29: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
unicore-uvos-server-1.4.1-rc1.noarch
Loaded plugins: kernel-module
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-server.noarch 0:1.4.1-rc1 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-rc1         installed        33 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-server                                      1/1 
warning: /etc/unicore/uvos-server/uvosServer.conf saved as /etc/unicore/uvos-server/uvosServer.conf.rpmsave

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

Complete!
--- [INFO] Uninstalling the package unicore-uvos-clc and cleaning all its files
unicore-uvos-clc-1.4.1-0.noarch
Loaded plugins: kernel-module
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-clc.noarch 0:1.4.1-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-clc        noarch        1.4.1-0           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-0                                             

Complete!
--- [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
package unicore-uvos-webauth is not installed
--- [INFO] Setting up the repository
--- [INFO] 
--- [INFO] YUM_REPOSITORY=https://twiki.cern.ch/twiki/pub/EMI/EMI-1/rc1.repo
--- [INFO] 
--- [INFO] Fetching yum Repository definition
--2011-03-17 20:29:33--  https://twiki.cern.ch/twiki/pub/EMI/EMI-1/rc1.repo
Resolving twiki.cern.ch... 137.138.6.73
Connecting to twiki.cern.ch|137.138.6.73|:443... connected.
WARNING: cannot verify twiki.cern.ch's certificate, issued by `/C=US/O=VeriSign, Inc./OU=VeriSign Trust Network/OU=Terms of use at https://www.verisign.com/rpa (c)10/CN=VeriSign Class 3 Secure Server CA - G3':
  Unable to locally verify the issuer's authority.
HTTP request sent, awaiting response... 200 OK
Length: 144 [application/octet-stream]
Saving to: `/etc/yum.repos.d/unicore-uvos.repo'

     0K                                                       100% 4.04M=0s

2011-03-17 20:29:34 (4.04 MB/s) - `/etc/yum.repos.d/unicore-uvos.repo' saved [144/144]

--- [INFO] Installing from binary package
--- [INFO]   Component: uvos-server
--- [INFO]   Package:   unicore-uvos-server
--- [INFO] 
Loaded plugins: kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-server.noarch 0:1.4.1-rc1 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-rc1         EMI-1-RC1        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-rc1                                        

Complete!
unicore-uvos-server-1.4.1-rc1.noarch
--- [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-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-clc        noarch        1.4.1-0           EMI-1-RC1         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-0                                             

Complete!
unicore-uvos-clc-1.4.1-0.noarch
--- [INFO] Updating /etc/unicore/uvos-server/uvosServer.conf: property uvos.server.keystore = /etc/unicore/uvos-server/certs/dummyServer.jks
uvos.server.keystorePasswd=SET_KEYSTORE_PASSWORD
uvos.server.keystoreType=JKS
uvos.server.keystoreAlias=SET_SERVER_KEY_ALIAS' -a -z '' ']'
--- [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
uvos.server.https.truststorePasswd=SET_TRUSTSTORE_PASSWORD
uvos.server.https.truststoreType=JKS' -a -z '' ']'
--- [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
keystore=SET-ME
keystorePasswd=SET-ME
keystoreType=JKS
keystoreAlias=SET-ME
# keyPasswd defaults to keystorePassword' -a -z '' ']'
--- [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
#keyPasswd=' -a -z true ']'
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
truststore=SET-ME
truststorePasswd=SET-ME
truststoreType=JKS' -a -z '' ']'
--- [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 
Error executing: DROP TABLE NOTIFICATIONS 
java.sql.SQLException: Table not found: NOTIFICATIONS in statement [DROP TABLE NOTIFICATIONS ]
Error executing: DROP TABLE APPLICATIONS 
java.sql.SQLException: Table not found: APPLICATIONS in statement [DROP TABLE APPLICATIONS ]
Error executing: DROP TABLE APPLICATION_FORMS 
java.sql.SQLException: Table not found: APPLICATION_FORMS in statement [DROP TABLE APPLICATION_FORMS ]
Error executing: DROP TABLE AUTHZ_ATTRIBUTE 
java.sql.SQLException: Table not found: AUTHZ_ATTRIBUTE in statement [DROP TABLE AUTHZ_ATTRIBUTE ]
Error executing: DROP TABLE AUTHZ_SPECIAL 
java.sql.SQLException: Table not found: AUTHZ_SPECIAL in statement [DROP TABLE AUTHZ_SPECIAL ]
Error executing: DROP TABLE GROUP_ENTITIES 
java.sql.SQLException: Table not found: GROUP_ENTITIES in statement [DROP TABLE GROUP_ENTITIES ]
Error executing: DROP TABLE GROUP_SUBGROUPS 
java.sql.SQLException: Table not found: GROUP_SUBGROUPS in statement [DROP TABLE GROUP_SUBGROUPS ]
Error executing: DROP TABLE GROUP_ATTRIBUTES 
java.sql.SQLException: Table not found: GROUP_ATTRIBUTES in statement [DROP TABLE GROUP_ATTRIBUTES ]
Error executing: DROP TABLE ENTITY_ATTRIBUTES 
java.sql.SQLException: Table not found: ENTITY_ATTRIBUTES in statement [DROP TABLE ENTITY_ATTRIBUTES ]
Error executing: DROP TABLE GROUPS 
java.sql.SQLException: Table not found: GROUPS in statement [DROP TABLE GROUPS ]
Error executing: DROP TABLE IDENTITIES 
java.sql.SQLException: Table not found: IDENTITIES in statement [DROP TABLE IDENTITIES ]
Error executing: DROP TABLE ENTITIES 
java.sql.SQLException: Table not found: ENTITIES in statement [DROP TABLE ENTITIES ]
Error executing: DROP TABLE IDENTITY_TYPES 
java.sql.SQLException: Table not found: IDENTITY_TYPES in statement [DROP TABLE IDENTITY_TYPES ]
Error executing: DROP TABLE ATTRIBUTE_TYPES 
java.sql.SQLException: Table not found: ATTRIBUTE_TYPES in statement [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
Starting UVOS:                                             [  OK  ]
--- [INFO] uvos-server active for user unicore ...
--- [INFO] Waiting for service to start...
--- [INFO] Checking if log file uvos is present for component uvos-server
--- [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.
  urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress
  urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName
  urn:unicore:idType:X509Certificate'
  urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress
  urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName
  urn:unicore:idType:X509Certificate'
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
  urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress
  urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName
  urn:unicore:idType:X509Certificate'
  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] 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] 
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-RC1       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] 
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-RC1        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
Starting UVOS:                                             [  OK  ]
--- [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.
--2011-03-17 20:30:10--  https://localhost:2443/uvos-webapp-1.5.0/VOapplications.do
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:2443... connected.
WARNING: cannot verify localhost's certificate, issued by `/C=PL/ST=Example State/L=Example City/O=Example Organisation/OU=Example Unit/CN=Example UVOS Server':
  Self-signed certificate encountered.
WARNING: certificate common name `Example UVOS Server' doesn't match requested host name `localhost'.
HTTP request sent, awaiting response... 302 Found
Location: https://localhost:2443/uvos-webapp-1.5.0/VOapplications.do;jsessionid=1o2p9efb0r6l411awsp98mp2nv?execution=e1s1 [following]
--2011-03-17 20:30:11--  https://localhost:2443/uvos-webapp-1.5.0/VOapplications.do;jsessionid=1o2p9efb0r6l411awsp98mp2nv?execution=e1s1
Reusing existing connection to localhost:2443.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: `/tmp/output-webapp.html'

     0K .                                                       257M=0s

2011-03-17 20:30:11 (257 MB/s) - `/tmp/output-webapp.html' saved [1346]

--2011-03-17 20:30:11--  https://localhost:2443/uvos-webauth-1.5.0/VOauthentication.do
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:2443... connected.
WARNING: cannot verify localhost's certificate, issued by `/C=PL/ST=Example State/L=Example City/O=Example Organisation/OU=Example Unit/CN=Example UVOS Server':
  Self-signed certificate encountered.
WARNING: certificate common name `Example UVOS Server' doesn't match requested host name `localhost'.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: `/tmp/output-webauth.html'

     0K ..                                                      444M=0s

2011-03-17 20:30:11 (444 MB/s) - `/tmp/output-webauth.html' saved [2326]

Stopping UVOS: Waiting for server to stop...
Server stopped.

--- [INFO] Checking if documentation is present for uvos-server
total 1168
drwxr-xr-x 2 root root   4096 Mar 17 20:29 .
drwxr-xr-x 9 root root   4096 Mar 17 20:30 ..
-rw-r--r-- 1 root root   5581 Mar 15 02:01 Changes.txt
-rw-r--r-- 1 root root   1491 Mar 15 02:01 LICENSE.ICM
-rw-r--r-- 1 root root   3125 Mar 15 02:01 UPGRADE.txt
-rw-r--r-- 1 root root  71202 Mar 15 02:01 UVOSAdministration.odt
-rw-r--r-- 1 root root 347827 Mar 15 02:01 UVOSAdministration.pdf
-rw-r--r-- 1 root root 183368 Mar 15 02:01 UVOSOverview.odt
-rw-r--r-- 1 root root 547108 Mar 15 02:01 UVOSOverview.pdf
--- [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 17 20:29 .
drwxr-xr-x 9 root root  4096 Mar 17 20:30 ..
-rw-r--r-- 1 root root  2465 Mar 15 01:48 Changes.txt
-rw-r--r-- 1 root root  2961 Mar 15 01:48 ClientConfiguration.txt
-rw-r--r-- 1 root root 25663 Mar 15 01:48 CommandsReference.txt
drwxr-xr-x 2 root root  4096 Mar 17 20:29 examples
-rw-r--r-- 1 root root  1492 Mar 15 01:48 LICENSE.ICM
-rw-r--r-- 1 root root  2833 Mar 15 01:48 README
--- [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 17 20:30 .
drwxr-xr-x 9 root root 4096 Mar 17 20:30 ..
-rw-r--r-- 1 root root  750 Mar  1 01:35 Changes.txt
-rw-r--r-- 1 root root 1491 Mar  1 01:35 LICENSE.ICM
-rw-r--r-- 1 root root 1497 Mar  1 01:35 README
-rw-r--r-- 1 root root 6068 Mar  1 01:35 referenceApplicationForm.xml
--- [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 17 20:30 .
drwxr-xr-x 9 root root 4096 Mar 17 20:30 ..
-rw-r--r-- 1 root root  391 Mar  1 01:44 Changes.txt
-rw-r--r-- 1 root root 1615 Mar  1 01:44 DEVELOPER
-rw-r--r-- 1 root root 1491 Mar  1 01:44 LICENSE.ICM
-rw-r--r-- 1 root root 2080 Mar  1 01:44 README
-rw-r--r-- 1 root root 4993 Mar  1 01:44 TestLoginServlet.java
--- [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
Unknown file formatext full r1 manage 67.0 K 2011-03-17 - 22:20 UnknownUser Full deployment test report for RC1
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: r4 - 2011-03-17 - 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