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

Component: UNICORE VO System (UVOS)

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

ETICS Configuration Names: emi-unicore-uvos-server_R_1_4_1_2,
emi-unicore-uvos-clc_R_1_4_1_1,
emi-unicore-uvos-webapp_R_1_5_0_2,
emi-unicore-uvos-webauth_R_1_5_0_2

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-rc2,
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-p2,
https://unicore.svn.sourceforge.net/svnroot/unicore/uvos/uvos-webauthn/tags/uvos-webauthn-1.5.0-p2

EMI Major Release: EMI 1

Platform: SL5/x86_64

Author(s): Krzysztof Benedyczak

Date: 26.03.2011

Summary

  1. Deployment test:
    1. Clean Installation - FAILED
    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-53.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-53/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-53/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-53/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

Note: Deployment test failed due to bug introduced when fixing pid file names of RC1. The problem is already fixed, will be available in RC3.

Full report link: full

Shortened report:

--- [INFO] Deployment test: ./testcases.d/uvos
--- [INFO] Started at: Sat Mar 26 19:29:55 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-2.noarch
Loaded plugins: kernel-module
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package unicore-uvos-server.noarch 0:1.4.1-2 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-2 set to be erased
---> Package unicore-uvos-webauth.noarch 0:1.5.0-2 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-2          installed        33 M
Removing for dependencies:
 unicore-uvos-webapp        noarch       1.5.0-2          installed       4.4 M
 unicore-uvos-webauth       noarch       1.5.0-2          installed       839 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-2                                          

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

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

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/rc2.repo
--- [INFO] 
--- [INFO] Fetching yum Repository definition
--2011-03-26 19:29:58--  https://twiki.cern.ch/twiki/pub/EMI/EMI-1/rc2.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% 1.72M=0s

2011-03-26 19:29:58 (1.72 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-2 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-2        EMI-1-RC2         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-2                                          

Complete!
unicore-uvos-server-1.4.1-2.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-1 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-1           EMI-1-RC2         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-1                                             

Complete!
unicore-uvos-clc-1.4.1-1.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
keystorePasswd=SET-ME
keystoreType=JKS
keystoreAlias=SET-ME' -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
--- [INFO] Updating /etc/unicore/uvos-clc/uvosClient.conf: property truststore = /etc/unicore/uvos-server/certs/dummyServerTruststore.jks
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: A UVOS instance may be already running with process id 14856
If this is not the case, delete the file /var/run/unicore/uvos-server.pid and re-run this script
                                                           [FAILED]
--- [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: No LAST_PID file. It seems that server is not running.

--- [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-2 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-2          EMI-1-RC2       834 k

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

Total download size: 834 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-2                                         

Complete!
unicore-uvos-webauth-1.5.0-2.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-2 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-2        EMI-1-RC2        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-2                                          

Complete!
unicore-uvos-webapp-1.5.0-2.noarch
--- [INFO] Starting the service unicore-uvos-server
Starting UVOS: A UVOS instance may be already running with process id 14856
If this is not the case, delete the file /var/run/unicore/uvos-server.pid and re-run this script
                                                           [FAILED]
--- [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-26 19:30:31--  https://localhost:2443/uvos-webapp-1.5.0-p2/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... 404 Not Found
2011-03-26 19:30:31 ERROR 404: Not Found.

--- [ERROR] VO applications module not working properly: can't access registration page
--- [ERROR] Outcome: FAILED

Upgrade deployment report

N/A - this is the first EMI Linux-packaged release.
Topic attachments
I Attachment History Action SizeSorted ascending Date Who Comment
Unknown file formatext full r1 manage 50.0 K 2011-03-26 - 21:50 UnknownUser Full deployment log for UVOS 1.4.1, RC2
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: r5 - 2011-03-26 - 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