Certification Report for EMI Task #20915 (GridSite 1.7.19-1, x86, SL5)
Origins
Summary (EMI Test Report Structure)
- Deployment log:
- Clean Installation—PASS
- Upgrade Installation—PASS
- Static Code Analysis—N/A (The prevalent programming language is C)
- Unit Tests Execution—N/A
- System tests:
- Basic Functionality tests—PASS
- Regression tests—PASS
- Performance/Scalability tests—N/A
- Standard Compliance/Conformance tests—N/A
Remarks:
- GridSite does not employ YAIM for configuration. Giving a copy of YAIM log is not applicable.
Clean installation, Scientific 5 (x86_64)
Environment
Clean installation according to EMI guidelines (CA certificates, proxy certificate...).
OS Issue |
Scientific Linux SL release 5.7 (Boron) |
Platform |
x86_64 |
Host |
myriad11.zcu.cz |
Duration |
7 min |
Testbed uptime |
10:27:52 up 13 min, 1 user, load average: 1.85, 0.84, 0.36 |
Process
rpm -ivh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
yum install -y yum-priorities yum-protectbase
rpm -i http://emisoft.web.cern.ch/emisoft/dist/EMI/1/sl5/x86_64/base/emi-release-1.0.0-1.sl5.noarch.rpm
cd /etc/yum.repos.d/
wget http://etics-repository.cern.ch/repository/pm/registered/repomd/id/5208b166-0e0c-4b18-b517-d7d44314a8e7/sl5_x86_64_gcc412EPEL/etics-registered-build-by-id-protect.repo
echo priority=45 >> etics-registered-build-by-id-protect.repo
yum install -y gridsite-apache gridsite-commands gridsite-debuginfo gridsite-devel.x86_64 gridsite-gsexec gridsite-service-clients gridsite-services gridsite-shared
Full Output of the Installation
Retrieving http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
Preparing... ##################################################
epel-release ##################################################
Loaded plugins: downloadonly, kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package yum-priorities.noarch 0:1.1.16-16.el5 set to be updated
---> Package yum-protectbase.noarch 0:1.1.16-16.el5 set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
yum-priorities noarch 1.1.16-16.el5 sl-base 14 k
yum-protectbase noarch 1.1.16-16.el5 sl-base 13 k
Transaction Summary
================================================================================
Install 2 Package(s)
Upgrade 0 Package(s)
Total download size: 27 k
Downloading Packages:
--------------------------------------------------------------------------------
Total 211 kB/s | 27 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : yum-priorities 1/2
Installing : yum-protectbase 2/2
Installed:
yum-priorities.noarch 0:1.1.16-16.el5 yum-protectbase.noarch 0:1.1.16-16.el5
Complete!
Loaded plugins: downloadonly, kernel-module, priorities, protectbase
465 packages excluded due to repository priority protections
0 packages excluded due to repository protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package gridsite-apache.x86_64 0:1.7.19-1.el5 set to be updated
--> Processing Dependency: libidn.so.11()(64bit) for package: gridsite-apache
--> Processing Dependency: libcurl.so.3()(64bit) for package: gridsite-apache
---> Package gridsite-commands.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-debuginfo.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-devel.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-gsexec.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-service-clients.x86_64 0:1.7.19-1.el5 set to be updated
--> Processing Dependency: libgsoapssl.so.0()(64bit) for package: gridsite-service-clients
---> Package gridsite-services.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-shared.x86_64 0:1.7.19-1.el5 set to be updated
--> Running transaction check
---> Package curl.x86_64 0:7.15.5-9.el5_7.4 set to be updated
---> Package gsoap.x86_64 0:2.7.13-4.el5 set to be updated
---> Package libidn.x86_64 0:0.6.5-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:
gridsite-apache x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
69 k
gridsite-commands x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
28 k
gridsite-debuginfo x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
434 k
gridsite-devel x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
81 k
gridsite-gsexec x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
12 k
gridsite-service-clients x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
29 k
gridsite-services x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
23 k
gridsite-shared x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
131 k
Installing for dependencies:
curl x86_64 7.15.5-9.el5_7.4 sl-base 231 k
gsoap x86_64 2.7.13-4.el5 epel 444 k
libidn x86_64 0.6.5-1.1 sl-base 195 k
Transaction Summary
================================================================================
Install 11 Package(s)
Upgrade 0 Package(s)
Total download size: 1.6 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 13 kB/s | 1.6 MB 02:11
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : gridsite-shared 1/11
Installing : libidn 2/11
Installing : curl 3/11
Installing : gsoap 4/11
Installing : gridsite-commands 5/11
Installing : gridsite-service-clients 6/11
Installing : gridsite-services 7/11
Installing : gridsite-gsexec 8/11
warning: group apache does not exist - using root
Installing : gridsite-apache 9/11
Installing : gridsite-devel 10/11
Installing : gridsite-debuginfo 11/11
Installed:
gridsite-apache.x86_64 0:1.7.19-1.el5
gridsite-commands.x86_64 0:1.7.19-1.el5
gridsite-debuginfo.x86_64 0:1.7.19-1.el5
gridsite-devel.x86_64 0:1.7.19-1.el5
gridsite-gsexec.x86_64 0:1.7.19-1.el5
gridsite-service-clients.x86_64 0:1.7.19-1.el5
gridsite-services.x86_64 0:1.7.19-1.el5
gridsite-shared.x86_64 0:1.7.19-1.el5
Dependency Installed:
curl.x86_64 0:7.15.5-9.el5_7.4 gsoap.x86_64 0:2.7.13-4.el5
libidn.x86_64 0:0.6.5-1.1
Complete!
Tests
Certificate file: none
gLite user: glite
Terminal width: 80
Output format: -x
Package curl-7.15.5-9.el5_7.4.x86_64 already installed and latest version
Package wget-1.11.4-2.el5_4.1.x86_64 already installed and latest version
Package lsof-4.78-3.x86_64 already installed and latest version
Starting httpd -f /etc/httpd/gridsite-webserver.conf
CVS binary not present`/tmp/test-certs.2599/grid-security/certificates/5a762d74.0' -> `/etc/grid-security/certificates/5a762d74.0'
`/tmp/test-certs.2599/grid-security/certificates/5a762d74.namespaces' -> `/etc/grid-security/certificates/5a762d74.namespaces'
`/tmp/test-certs.2599/grid-security/certificates/5a762d74.r0' -> `/etc/grid-security/certificates/5a762d74.r0'
`/tmp/test-certs.2599/grid-security/certificates/5a762d74.signing_policy' -> `/etc/grid-security/certificates/5a762d74.signing_policy'
Installing experimental VOMS server
Package wget-1.11.4-2.el5_4.1.x86_64 already installed and latest version
`/tmp/test-certs.4143/grid-security/certificates/5a762d74.0' -> `/etc/grid-security/certificates/5a762d74.0'
`/tmp/test-certs.4143/grid-security/certificates/5a762d74.namespaces' -> `/etc/grid-security/certificates/5a762d74.namespaces'
`/tmp/test-certs.4143/grid-security/certificates/5a762d74.r0' -> `/etc/grid-security/certificates/5a762d74.r0'
`/tmp/test-certs.4143/grid-security/certificates/5a762d74.signing_policy' -> `/etc/grid-security/certificates/5a762d74.signing_policy'
Initializing MySQL database: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h myriad11.zcu.cz password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[60G[[0;32m OK [0;39m]
Starting MySQL: [60G[[0;32m OK [0;39m]
WARNING:
WARNING: *****************************************************************************
WARNING: Your siteinfo directory is world readable. This is generally a bad idea
WARNING: as configuration files may contain passwords and other sensitive information.
WARNING: *****************************************************************************
WARNING:
INFO: Using site configuration file: site-info-voms.def
INFO: Sourcing service specific configuration file: ./services/glite-voms
INFO:
###################################################################
. /'.-. ')
. yA,-"-,( ,m,:/ ) .oo. oo o ooo o. .oo
. / .-Y a a Y-. 8. .8' 8'8. 8 8b d'8
. / ~ ~ / 8' .8oo88. 8 8 8' 8
. (_/ '====' 8 .8' 8. 8 8 Y 8
. Y,-''-,Yy,-.,/ o8o o8o o88o o8o o8o o8o
. I_))_) I_))_)
current working directory: /root/yaim
site-info.def date: Mar 5 10:25 site-info-voms.def
yaim command: -c -s site-info-voms.def -n VOMS
log file: /opt/glite/yaim/bin/../log/yaimlog
Mon Mar 5 10:25:48 CET 2012 : /opt/glite/yaim/bin/yaim
Installed YAIM versions:
glite-yaim-bdii 4.3.8-1
glite-yaim-core 5.0.2-1
glite-yaim-voms 1.0-10
####################################################################
INFO: The default location of the grid-env.(c)sh files will be: /usr/libexec
INFO: Sourcing the utilities in /opt/glite/yaim/functions/utils
INFO: Detecting environment
INFO: Executing function: config_host_certs_check
INFO: Executing function: config_edgusers_check
INFO: Executing function: config_add_pool_env_check
INFO: Executing function: config_info_service_voms_check
INFO: Executing function: config_info_service_voms_admin_check
INFO: Executing function: config_voms_check
INFO: Executing function: config_voms_logrotate_check
INFO: Executing function: config_bdii_5.2_check
INFO: Executing function: config_host_certs
INFO: Executing function: config_edgusers
INFO: Executing function: config_add_pool_env_setenv
INFO: Executing function: config_add_pool_env
INFO: Executing function: config_crl
INFO: Now updating the CRLs - this may take a few minutes...
Enabling periodic fetch-crl: [60G[[0;32m OK [0;39m]
INFO: Executing function: config_info_service_voms_setenv
INFO: Executing function: config_info_service_voms
INFO: Executing function: config_info_service_voms_admin_setenv
INFO: Executing function: config_info_service_voms_admin
INFO: Executing function: config_voms_setenv
INFO: Executing function: config_voms
INFO: MySQL configuration
INFO: Check that java is installed
INFO: Check that tomcat is installed
INFO: Stop tomcat in case it's running
Stopping tomcat5: INFO: Copying hostcert to /etc/grid-security/tomcat-cert.pem for tomcat:root......
INFO: Copying hostkey to /etc/grid-security/tomcat-key.pem for tomcat:root...
INFO: Configuring /etc/tomcat5/server.xml...
INFO: Copying trustmanager log4j properties to tomcat configuration directory..
INFO: Linking log4j and bouncycastle jars to tomcat server lib directory..
INFO: Linking trustmanager jars to tomcat server lib directory..
INFO: Defining JAVA_HOME in the Tomcat configuration file
INFO: Starting Tomcat
Starting tomcat5: [60G[ OK ]
INFO: Ready to start VOMS configuration
voms-admin-configure, version 2.6.1
Checking glite installation...
VOMS_LOCATION: /usr
VOMS_LOCATION_VAR: /var
VOMS_LOCATION_CONF: /
VOMS_ADMIN_LOCATION: /usr/share/voms-admin
VOMS_ADMIN_LOCATION_VAR: /
Checking local installation...
Glite installation ok.
Setting up user credentials...
Using host credentials (/etc/grid-security/hostcert.pem) since running as root.
Setting defaults for the VOMS AA credentials
Setting host credentials defaults for VOMS AA.
Cheking input parameters
Installing vo vo.org
Skipping voms core configuration creation
VO vo.org configured correctly.
VO vo.org installation finished.
You can start the voms services using the following commands:
/etc/init.d/voms start vo.org
/etc/init.d/voms-admin start vo.org
INFO: Checking VOMS database schema existence and deploying one if missing...
Checking database connectivity...
Database contacted succesfully
Checking database existence...
No voms-admin database found.
Checking that the database is writable...
Database is writable.
create table acl2 (acl_id bigint not null auto_increment, group_id bigint not null, defaultACL bit not null, role_id bigint, primary key (acl_id), unique (group_id, defaultACL, role_id)) type=InnoDB
create table acl2_permissions (acl_id bigint not null, permissions integer, admin_id bigint not null, primary key (acl_id, admin_id)) type=InnoDB
create table admins (adminid bigint not null auto_increment, dn varchar(255) not null, email_address varchar(255), ca smallint not null, primary key (adminid), unique (dn, ca)) type=InnoDB
create table attributes (a_id bigint not null auto_increment, a_name varchar(255) not null unique, a_desc text, a_uniq bit default 0, primary key (a_id)) type=InnoDB
create table aup (id bigint not null auto_increment, name varchar(255) not null unique, description varchar(255), reacceptancePeriod integer not null, primary key (id)) type=InnoDB
create table aup_acc_record (id bigint not null auto_increment, aup_version_id bigint not null, usr_id bigint not null, last_acceptance_date datetime not null, valid bit, primary key (id), unique (aup_version_id, usr_id)) type=InnoDB
create table aup_version (id bigint not null auto_increment, aup_id bigint not null, version varchar(255) not null, url varchar(255), text varchar(255), creationTime datetime not null, lastForcedReacceptanceTime datetime, active bit not null, primary key (id), unique (aup_id, version)) type=InnoDB
create table ca (cid smallint not null auto_increment, subject_string varchar(255) not null unique, description varchar(255), creation_time datetime not null, primary key (cid)) type=InnoDB
create table capabilities (cid bigint not null auto_increment, capability varchar(255) not null, primary key (cid)) type=InnoDB
create table certificate (id bigint not null auto_increment, creation_time datetime not null, subject_string varchar(255) not null, suspended bit not null, suspended_reason varchar(255), suspension_reason_code varchar(255), ca_id smallint not null, usr_id bigint not null, primary key (id), unique (ca_id, subject_string)) type=InnoDB
create table certificate_request (certificate tinyblob, certificateIssuer varchar(255) not null, certificateSubject varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table group_attrs (a_id bigint not null, g_id bigint not null, a_value varchar(255), primary key (a_id, g_id)) type=InnoDB
create table group_membership_req (groupName varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table groups (gid bigint not null auto_increment, dn varchar(255) not null unique, description varchar(255), parent bigint, must bit not null, restricted bit, primary key (gid)) type=InnoDB
create table m (mapping_id bigint not null auto_increment, userid bigint not null, gid bigint not null, rid bigint, cid bigint, primary key (mapping_id), unique (userid, gid, rid)) type=InnoDB
create table memb_req (id bigint not null auto_increment, creation_date datetime not null, evaluation_date datetime, status integer not null, confirm_id varchar(255) not null, dn varchar(255) not null, ca varchar(255) not null, cn varchar(255), mail varchar(255) not null, primary key (id)) type=InnoDB
create table membership_rem_req (reason varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table personal_info (id bigint not null auto_increment, value varchar(255), visible bit, personal_info_type_id bigint not null, primary key (id)) type=InnoDB
create table personal_info_type (id bigint not null auto_increment, description varchar(255), type varchar(255) not null unique, primary key (id)) type=InnoDB
create table req (request_id bigint not null auto_increment, completionDate datetime, creationDate datetime, expirationDate datetime, status varchar(255) not null, requester_info_id bigint not null, primary key (request_id), unique (requester_info_id)) type=InnoDB
create table requester_info (id bigint not null auto_increment, address varchar(255), certificateIssuer varchar(255) not null, certificateSubject varchar(255) not null, emailAddress varchar(255) not null, institution varchar(255), name varchar(255), phoneNumber varchar(255), surname varchar(255), voMember bit, primary key (id)) type=InnoDB
create table requester_personal_info (requester_id bigint not null, pi_value varchar(255), pi_key varchar(255), primary key (requester_id, pi_key)) type=InnoDB
create table role_attrs (a_id bigint not null, g_id bigint not null, r_id bigint not null, a_value varchar(255), primary key (a_id, g_id, r_id)) type=InnoDB
create table role_membership_req (groupName varchar(255), roleName varchar(255), request_id bigint not null, primary key (request_id)) type=InnoDB
create table roles (rid bigint not null auto_increment, role varchar(255) not null unique, primary key (rid)) type=InnoDB
create table seqnumber (seq varchar(255) not null, primary key (seq)) type=InnoDB
create table sign_aup_task (task_id bigint not null, aup_id bigint not null, primary key (task_id)) type=InnoDB
create table tag_mapping (mapping_id bigint not null auto_increment, tag_id bigint not null, gid bigint not null, rid bigint, admin_id bigint not null, primary key (mapping_id), unique (tag_id, gid, rid, admin_id)) type=InnoDB
create table tags (id bigint not null auto_increment, name varchar(255) not null unique, implicit bit not null, permissions integer not null, permissionsOnPath integer, primary key (id)) type=InnoDB
create table task (task_id bigint not null auto_increment, completionDate datetime, creationDate datetime, expiryDate datetime, status varchar(255) not null, admin_id bigint, task_type_id bigint not null, usr_id bigint, primary key (task_id)) type=InnoDB
create table task_log_record (id bigint not null auto_increment, adminDn varchar(255), creation_time datetime not null, event varchar(255) not null, userDn varchar(255), task_id bigint not null, primary key (id)) type=InnoDB
create table task_type (id bigint not null auto_increment, description varchar(255), name varchar(255) not null unique, primary key (id)) type=InnoDB
create table user_request_task (task_id bigint not null, req_id bigint not null, primary key (task_id)) type=InnoDB
create table usr (userid bigint not null auto_increment, address varchar(255), creation_time datetime not null, dn varchar(255), email_address varchar(255) not null, end_time datetime not null, institution varchar(255), name varchar(255), phone_number varchar(255), surname varchar(255), suspended bit, suspension_reason varchar(255), suspension_reason_code varchar(255), ca smallint, primary key (userid)) type=InnoDB
create table usr_attrs (a_id bigint not null, u_id bigint not null, a_value varchar(255), primary key (a_id, u_id)) type=InnoDB
create table version (version integer not null, admin_version varchar(255), primary key (version)) type=InnoDB
create table vo_membership_req (confirmId varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
alter table acl2 add index FK2D98E8720C9B10 (role_id), add constraint FK2D98E8720C9B10 foreign key (role_id) references roles (rid) on delete cascade
alter table acl2 add index FK2D98E8FCFA8B04 (group_id), add constraint FK2D98E8FCFA8B04 foreign key (group_id) references groups (gid) on delete cascade
alter table acl2_permissions add index FK35C6CFADD91CE8A3 (acl_id), add constraint FK35C6CFADD91CE8A3 foreign key (acl_id) references acl2 (acl_id)
alter table acl2_permissions add index FK35C6CFADA4AD9904 (admin_id), add constraint FK35C6CFADA4AD9904 foreign key (admin_id) references admins (adminid)
alter table admins add index FKAB3A67047C6FEB32 (ca), add constraint FKAB3A67047C6FEB32 foreign key (ca) references ca (cid)
alter table aup_acc_record add index FKB1979B32EE2D4487 (usr_id), add constraint FKB1979B32EE2D4487 foreign key (usr_id) references usr (userid)
alter table aup_acc_record add index FKB1979B32815F1678 (aup_version_id), add constraint FKB1979B32815F1678 foreign key (aup_version_id) references aup_version (id)
alter table aup_version add index fk_aup_version_aup (aup_id), add constraint fk_aup_version_aup foreign key (aup_id) references aup (id) on delete cascade
alter table certificate add index FK745F4197EE2D4487 (usr_id), add constraint FK745F4197EE2D4487 foreign key (usr_id) references usr (userid)
alter table certificate add index FK745F419782107F70 (ca_id), add constraint FK745F419782107F70 foreign key (ca_id) references ca (cid)
alter table certificate_request add index FK47CA53E7D75D60A4 (request_id), add constraint FK47CA53E7D75D60A4 foreign key (request_id) references req (request_id)
alter table group_attrs add index FK40B1A2E2566C2A8F (a_id), add constraint FK40B1A2E2566C2A8F foreign key (a_id) references attributes (a_id)
alter table group_attrs add index FK40B1A2E2DEFC581C (g_id), add constraint FK40B1A2E2DEFC581C foreign key (g_id) references groups (gid) on delete cascade
alter table group_membership_req add index FKBD145E75D75D60A4 (request_id), add constraint FKBD145E75D75D60A4 foreign key (request_id) references req (request_id)
alter table groups add index FKB63DD9D4A3771CD3 (parent), add constraint FKB63DD9D4A3771CD3 foreign key (parent) references groups (gid)
alter table m add index fk_m_roles (rid), add constraint fk_m_roles foreign key (rid) references roles (rid) on delete cascade
alter table m add index fk_m_groups (gid), add constraint fk_m_groups foreign key (gid) references groups (gid) on delete cascade
alter table m add index fk_m_cap (cid), add constraint fk_m_cap foreign key (cid) references capabilities (cid)
alter table m add index fk_m_usr (userid), add constraint fk_m_usr foreign key (userid) references usr (userid)
alter table membership_rem_req add index FK1877BC10D75D60A4 (request_id), add constraint FK1877BC10D75D60A4 foreign key (request_id) references req (request_id)
alter table personal_info add index FK229FDF4DA8D3C6BC (personal_info_type_id), add constraint FK229FDF4DA8D3C6BC foreign key (personal_info_type_id) references personal_info_type (id)
alter table req add index FK1B89EC37E889D (requester_info_id), add constraint FK1B89EC37E889D foreign key (requester_info_id) references requester_info (id)
alter table requester_personal_info add index FK7E3D7FCAD500B8D2 (requester_id), add constraint FK7E3D7FCAD500B8D2 foreign key (requester_id) references requester_info (id)
alter table role_attrs add index FK6BDE9799566C2A8F (a_id), add constraint FK6BDE9799566C2A8F foreign key (a_id) references attributes (a_id)
alter table role_attrs add index FK6BDE979920304994 (r_id), add constraint FK6BDE979920304994 foreign key (r_id) references roles (rid) on delete cascade
alter table role_attrs add index FK6BDE9799DEFC581C (g_id), add constraint FK6BDE9799DEFC581C foreign key (g_id) references groups (gid)
alter table role_membership_req add index FK3B9C79ED75D60A4 (request_id), add constraint FK3B9C79ED75D60A4 foreign key (request_id) references req (request_id)
alter table sign_aup_task add index FK7FCB416A32B8C70C (task_id), add constraint FK7FCB416A32B8C70C foreign key (task_id) references task (task_id)
alter table sign_aup_task add index FK7FCB416ADA1C6363 (aup_id), add constraint FK7FCB416ADA1C6363 foreign key (aup_id) references aup (id)
alter table tag_mapping add index fk_tag_mapping_roles (rid), add constraint fk_tag_mapping_roles foreign key (rid) references roles (rid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_admins (admin_id), add constraint fk_tag_mapping_admins foreign key (admin_id) references admins (adminid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_groups (gid), add constraint fk_tag_mapping_groups foreign key (gid) references groups (gid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_tag (tag_id), add constraint fk_tag_mapping_tag foreign key (tag_id) references tags (id) on delete cascade
alter table task add index FK3635859AD54C57 (task_type_id), add constraint FK3635859AD54C57 foreign key (task_type_id) references task_type (id)
alter table task add index FK363585EE2D4487 (usr_id), add constraint FK363585EE2D4487 foreign key (usr_id) references usr (userid)
alter table task add index FK363585A4AD9904 (admin_id), add constraint FK363585A4AD9904 foreign key (admin_id) references admins (adminid)
alter table task_log_record add index FK77673CA632B8C70C (task_id), add constraint FK77673CA632B8C70C foreign key (task_id) references task (task_id)
alter table user_request_task add index FKACB7D2932B8C70C (task_id), add constraint FKACB7D2932B8C70C foreign key (task_id) references task (task_id)
alter table user_request_task add index FKACB7D299D73AC35 (req_id), add constraint FKACB7D299D73AC35 foreign key (req_id) references req (request_id)
alter table usr add index FK1C5947C6FEB32 (ca), add constraint FK1C5947C6FEB32 foreign key (ca) references ca (cid)
alter table usr_attrs add index FKA39E0E37566C2A8F (a_id), add constraint FKA39E0E37566C2A8F foreign key (a_id) references attributes (a_id)
alter table usr_attrs add index FKA39E0E3720331206 (u_id), add constraint FKA39E0E3720331206 foreign key (u_id) references usr (userid)
alter table vo_membership_req add index FK28EE8AFBD75D60A4 (request_id), add constraint FK28EE8AFBD75D60A4 foreign key (request_id) references req (request_id)
Deploying voms database...
Database deployed correctly!
INFO: Adding default admin from /etc/grid-security/hostcert.pem
Admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA' not found. It will be created...
Adding ALL permissions on '/vo.org' for admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA'
Adding ALL permissions on role '/vo.org/Role=VO-Admin' for admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA'
Stopping vo vo.org
Starting vo vo.org
Stopping siblings webapp
Starting siblings webapp
INFO: User and password for read-only database access for VOMS-CORE not specified.
INFO: Using the credentials for read-write access (VOMS-ADMIN).
Stopping tomcat5: [60G[ OK ]
Starting tomcat5: [60G[ OK ]
Stopping voms(vo.org): (already stopped)
Starting voms(vo.org): [60G[[0;32m OK [0;39m]
INFO: Executing function: config_voms_logrotate_setenv
INFO: Executing function: config_voms_logrotate
INFO: Executing function: config_bdii_5.2
Stopping BDII: BDII already stopped
Starting BDII slapd: [60G[[0;32m OK [0;39m]
Starting BDII update process: [60G[[0;32m OK [0;39m]
[80G[ [1;32mOK[0;39m ]
INFO: Configuration Complete.
INFO: YAIM terminated succesfully.
Experimental VOMS set up with users:
/C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root, /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=the trusted CA - root@myriad11.zcu.cz
/C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root client01, /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=the trusted CA - root@myriad11.zcu.cz
/DC=org/DC=terena/DC=tcs/C=CZ/O=CESNET/CN=Zdenek Sustr 4040, /C=NL/O=TERENA/CN=TERENA eScience Personal CA - root@myriad11.zcu.cz
groups:
/vo.org
/vo.org/Testers
roles:
Role=Tester
Role=VO-Admin
U org.glite.testsuites.ctb/gridsite/tests/gridsite-autonomous-test.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-common-testbeds.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-common.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-test-all.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-test-packaging.sh
U org.glite.testsuites.ctb/gridsite/tests/ping-local.sh
U org.glite.testsuites.ctb/gridsite/tests/ping-remote.sh
U org.glite.testsuites.ctb/gridsite/tests/test-common.sh
========================
REAL TESTS START HERE
========================
Mar 05 10:27:45 myriad11.zcu.cz ping-remote.sh:
start
Testing if all binaries are available
done
Testing ping to Apache server myriad11.zcu.cz
done
Testing Apache server at myriad11.zcu.cz:443
done
Mar 05 10:27:47 myriad11.zcu.cz ping-remote.sh:
end
Mar 05 10:27:47 myriad11.zcu.cz ping-local.sh:
start
Testing if all binaries are available
done
Testing if Apache is running
done
Testing if GridSite is loaded
done
Testing if Apache is listening on port 443
done
Mar 05 10:27:47 myriad11.zcu.cz ping-local.sh:
end
Mar 05 10:27:47 myriad11.zcu.cz gridsite-test-all.sh:
start
Testing if all binaries are available
done
READ (Read Permissions)
Plain read... Return code 403
done
With gacl... Return code 200
done
Get index (list & read permissions)
Plain read... Return code 403
done
With gacl... Return code 200
done
WRITE & DELETE (write permissions)
Plain write... Return code 403
done
With gacl... Return code 201
done
Try deletion... Return code 403
done
With gacl... Return code 200
done
Checking attributes passed on to the environment
Run test.cgi... Return code 200
done
Check for GRST_* veriables...
done
Test the basic commands (htcp, htls, htmkdir, htmv, htrm)
Testing htcp...
done
Checking by htls...
done
Testing htmv...
done
htcp, file 2...
done
Testing htrm...
done
Checking by htls...
done
Checking directory contents with htls...
done
File compare...
done
Test proxy delegation
id: 7a19444f74afc7c3
done
newid: 7a19444f74afc7c3
done
Test handling of VOMS .lsc files (Regression test for bug #39254 and #82023)
Trying with empty vomsdir. GRST_CRED_2 should not be present...
done
Setting up .lsc file and trying again
Possibly fake VOMS extensions. Regenerating... Your identity: /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root
Creating temporary proxy Done
Contacting myriad11.zcu.cz:15000 [/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz] "vo.org" Done
Creating proxy Done
Your proxy is valid until Mon Mar 5 22:27:49 2012
Generated /etc/grid-security/vomsdir/vo.org/myriad11.zcu.cz.lsc
done
Checking for presence of FQAN...
done
Test listing of VOMS attributes (Regression test for bug #92077)
Getting list of Role attributes from voms-proxy-info...
done
Getting list of Role attributes from test.cgi...
done
re-running voms extensions...
done
Getting another set of Role attributes from test.cgi...
done
Comparing attributes...
done
Test flavours and sonames
flavour '' /usr/lib64/libgridsite.so
done
flavour '_nossl' /usr/lib64/libgridsite_nossl.so
done
flavour '_globus' /usr/lib64/libgridsite_globus.so
done
Check interpretable DEFVERSION... Oct 203431, Hex 10719
done
Mar 05 10:27:50 myriad11.zcu.cz gridsite-test-all.sh:
end
Downloading common definitions 'LB/lb-common.sh'...done
Mar 05 10:27:50 myriad11.zcu.cz gridsite-test-packaging.sh:
start
Packages compliance check output:
Mar 05 10:27:51 myriad11.zcu.cz gridsite-test-packaging.sh:
end
==================
TESTS END HERE
==================
Upgrade from Production, Scientific 5 (x86_64)
Environment
Clean installation according to EMI guidelines (CA certificates, proxy certificate...).
OS Issue |
Scientific Linux SL release 5.7 (Boron) |
Platform |
x86_64 |
Host |
myriad11.zcu.cz |
Duration |
4 min |
Testbed uptime |
11:32:36 up 16 min, 1 user, load average: 2.33, 1.00, 0.42 |
Process
rpm -ivh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
yum install -y yum-priorities yum-protectbase
rpm -i http://emisoft.web.cern.ch/emisoft/dist/EMI/1/sl5/x86_64/base/emi-release-1.0.0-1.sl5.noarch.rpm
yum install -y gridsite-apache gridsite-commands gridsite-debuginfo gridsite-devel.x86_64 gridsite-gsexec gridsite-service-clients gridsite-services gridsite-shared
cd /etc/yum.repos.d/
wget http://etics-repository.cern.ch/repository/pm/registered/repomd/id/5208b166-0e0c-4b18-b517-d7d44314a8e7/sl5_x86_64_gcc412EPEL/etics-registered-build-by-id-protect.repo
echo priority=45 >> etics-registered-build-by-id-protect.repo
yum update -y
Full Output of the Installation
Retrieving http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
Preparing... ##################################################
epel-release ##################################################
Loaded plugins: downloadonly, kernel-module
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package yum-priorities.noarch 0:1.1.16-16.el5 set to be updated
---> Package yum-protectbase.noarch 0:1.1.16-16.el5 set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
yum-priorities noarch 1.1.16-16.el5 sl-base 14 k
yum-protectbase noarch 1.1.16-16.el5 sl-base 13 k
Transaction Summary
================================================================================
Install 2 Package(s)
Upgrade 0 Package(s)
Total download size: 27 k
Downloading Packages:
--------------------------------------------------------------------------------
Total 209 kB/s | 27 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : yum-priorities 1/2
Installing : yum-protectbase 2/2
Installed:
yum-priorities.noarch 0:1.1.16-16.el5 yum-protectbase.noarch 0:1.1.16-16.el5
Complete!
Loaded plugins: downloadonly, kernel-module, priorities, protectbase
465 packages excluded due to repository priority protections
0 packages excluded due to repository protections
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package gridsite-apache.x86_64 0:1.7.15-2.sl5 set to be updated
--> Processing Dependency: libcurl.so.3()(64bit) for package: gridsite-apache
--> Processing Dependency: libidn.so.11()(64bit) for package: gridsite-apache
---> Package gridsite-commands.x86_64 0:1.7.15-2.sl5 set to be updated
---> Package gridsite-debuginfo.x86_64 0:1.7.15-2.sl5 set to be updated
---> Package gridsite-devel.x86_64 0:1.7.15-2.sl5 set to be updated
---> Package gridsite-gsexec.x86_64 0:1.7.15-2.sl5 set to be updated
---> Package gridsite-service-clients.x86_64 0:1.7.15-2.sl5 set to be updated
--> Processing Dependency: libgsoapssl.so.0()(64bit) for package: gridsite-service-clients
---> Package gridsite-services.x86_64 0:1.7.15-2.sl5 set to be updated
---> Package gridsite-shared.x86_64 0:1.7.15-2.sl5 set to be updated
--> Running transaction check
---> Package curl.x86_64 0:7.15.5-9.el5_7.4 set to be updated
---> Package gsoap.x86_64 0:2.7.13-4.el5 set to be updated
---> Package libidn.x86_64 0:0.6.5-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:
gridsite-apache x86_64 1.7.15-2.sl5 EMI-1-updates 69 k
gridsite-commands x86_64 1.7.15-2.sl5 EMI-1-updates 28 k
gridsite-debuginfo x86_64 1.7.15-2.sl5 EMI-1-updates 514 k
gridsite-devel x86_64 1.7.15-2.sl5 EMI-1-updates 81 k
gridsite-gsexec x86_64 1.7.15-2.sl5 EMI-1-updates 12 k
gridsite-service-clients x86_64 1.7.15-2.sl5 EMI-1-updates 29 k
gridsite-services x86_64 1.7.15-2.sl5 EMI-1-updates 23 k
gridsite-shared x86_64 1.7.15-2.sl5 EMI-1-updates 131 k
Installing for dependencies:
curl x86_64 7.15.5-9.el5_7.4 sl-base 231 k
gsoap x86_64 2.7.13-4.el5 epel 444 k
libidn x86_64 0.6.5-1.1 sl-base 195 k
Transaction Summary
================================================================================
Install 11 Package(s)
Upgrade 0 Package(s)
Total download size: 1.7 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 1.3 MB/s | 1.7 MB 00:01
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libidn 1/11
Installing : gridsite-shared 2/11
Installing : curl 3/11
Installing : gsoap 4/11
Installing : gridsite-service-clients 5/11
Installing : gridsite-commands 6/11
Installing : gridsite-apache 7/11
Installing : gridsite-debuginfo 8/11
Installing : gridsite-services 9/11
Installing : gridsite-devel 10/11
Installing : gridsite-gsexec 11/11
warning: group apache does not exist - using root
Installed:
gridsite-apache.x86_64 0:1.7.15-2.sl5
gridsite-commands.x86_64 0:1.7.15-2.sl5
gridsite-debuginfo.x86_64 0:1.7.15-2.sl5
gridsite-devel.x86_64 0:1.7.15-2.sl5
gridsite-gsexec.x86_64 0:1.7.15-2.sl5
gridsite-service-clients.x86_64 0:1.7.15-2.sl5
gridsite-services.x86_64 0:1.7.15-2.sl5
gridsite-shared.x86_64 0:1.7.15-2.sl5
Dependency Installed:
curl.x86_64 0:7.15.5-9.el5_7.4 gsoap.x86_64 0:2.7.13-4.el5
libidn.x86_64 0:0.6.5-1.1
Complete!
Loaded plugins: downloadonly, kernel-module, priorities, protectbase
465 packages excluded due to repository priority protections
0 packages excluded due to repository protections
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package emi-release.noarch 0:1.0.1-1.sl5 set to be updated
---> Package gridsite-apache.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-commands.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-debuginfo.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-devel.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-gsexec.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-service-clients.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-services.x86_64 0:1.7.19-1.el5 set to be updated
---> Package gridsite-shared.x86_64 0:1.7.19-1.el5 set to be updated
--> Finished Dependency Resolution
Beginning Kernel Module Plugin
Finished Kernel Module Plugin
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
emi-release noarch 1.0.1-1.sl5 EMI-1-updates 4.9 k
gridsite-apache x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
69 k
gridsite-commands x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
28 k
gridsite-debuginfo x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
434 k
gridsite-devel x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
81 k
gridsite-gsexec x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
12 k
gridsite-service-clients x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
29 k
gridsite-services x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
23 k
gridsite-shared x86_64 1.7.19-1.el5 ETICS-registered-build-5208b166-0e0c-4b18-b517-d7d44314a8e7-sl5_x86_64_gcc412EPEL
131 k
Transaction Summary
================================================================================
Install 0 Package(s)
Upgrade 9 Package(s)
Total download size: 812 k
Downloading Packages:
--------------------------------------------------------------------------------
Total 61 kB/s | 812 kB 00:13
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : gridsite-shared 1/18
Updating : gridsite-commands 2/18
Updating : gridsite-gsexec 3/18
warning: group apache does not exist - using root
Updating : emi-release 4/18
Updating : gridsite-services 5/18
Updating : gridsite-service-clients 6/18
Updating : gridsite-apache 7/18
Updating : gridsite-devel 8/18
Updating : gridsite-debuginfo 9/18
Cleanup : gridsite-commands 10/18
Cleanup : gridsite-gsexec 11/18
Cleanup : emi-release 12/18
Cleanup : gridsite-services 13/18
Cleanup : gridsite-service-clients 14/18
Cleanup : gridsite-apache 15/18
Cleanup : gridsite-devel 16/18
Cleanup : gridsite-shared 17/18
Cleanup : gridsite-debuginfo 18/18
Updated:
emi-release.noarch 0:1.0.1-1.sl5
gridsite-apache.x86_64 0:1.7.19-1.el5
gridsite-commands.x86_64 0:1.7.19-1.el5
gridsite-debuginfo.x86_64 0:1.7.19-1.el5
gridsite-devel.x86_64 0:1.7.19-1.el5
gridsite-gsexec.x86_64 0:1.7.19-1.el5
gridsite-service-clients.x86_64 0:1.7.19-1.el5
gridsite-services.x86_64 0:1.7.19-1.el5
gridsite-shared.x86_64 0:1.7.19-1.el5
Complete!
Tests
Certificate file: none
gLite user: glite
Terminal width: 80
Output format: -x
Package curl-7.15.5-9.el5_7.4.x86_64 already installed and latest version
Package wget-1.11.4-2.el5_4.1.x86_64 already installed and latest version
Package lsof-4.78-3.x86_64 already installed and latest version
Starting httpd -f /etc/httpd/gridsite-webserver.conf
CVS binary not present`/tmp/test-certs.3262/grid-security/certificates/5a762d74.0' -> `/etc/grid-security/certificates/5a762d74.0'
`/tmp/test-certs.3262/grid-security/certificates/5a762d74.namespaces' -> `/etc/grid-security/certificates/5a762d74.namespaces'
`/tmp/test-certs.3262/grid-security/certificates/5a762d74.r0' -> `/etc/grid-security/certificates/5a762d74.r0'
`/tmp/test-certs.3262/grid-security/certificates/5a762d74.signing_policy' -> `/etc/grid-security/certificates/5a762d74.signing_policy'
Installing experimental VOMS server
Package wget-1.11.4-2.el5_4.1.x86_64 already installed and latest version
`/tmp/test-certs.4806/grid-security/certificates/5a762d74.0' -> `/etc/grid-security/certificates/5a762d74.0'
`/tmp/test-certs.4806/grid-security/certificates/5a762d74.namespaces' -> `/etc/grid-security/certificates/5a762d74.namespaces'
`/tmp/test-certs.4806/grid-security/certificates/5a762d74.r0' -> `/etc/grid-security/certificates/5a762d74.r0'
`/tmp/test-certs.4806/grid-security/certificates/5a762d74.signing_policy' -> `/etc/grid-security/certificates/5a762d74.signing_policy'
Initializing MySQL database: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h myriad11.zcu.cz password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[60G[[0;32m OK [0;39m]
Starting MySQL: [60G[[0;32m OK [0;39m]
WARNING:
WARNING: *****************************************************************************
WARNING: Your siteinfo directory is world readable. This is generally a bad idea
WARNING: as configuration files may contain passwords and other sensitive information.
WARNING: *****************************************************************************
WARNING:
INFO: Using site configuration file: site-info-voms.def
INFO: Sourcing service specific configuration file: ./services/glite-voms
INFO:
###################################################################
. /'.-. ')
. yA,-"-,( ,m,:/ ) .oo. oo o ooo o. .oo
. / .-Y a a Y-. 8. .8' 8'8. 8 8b d'8
. / ~ ~ / 8' .8oo88. 8 8 8' 8
. (_/ '====' 8 .8' 8. 8 8 Y 8
. Y,-''-,Yy,-.,/ o8o o8o o88o o8o o8o o8o
. I_))_) I_))_)
current working directory: /root/yaim
site-info.def date: Mar 5 11:30 site-info-voms.def
yaim command: -c -s site-info-voms.def -n VOMS
log file: /opt/glite/yaim/bin/../log/yaimlog
Mon Mar 5 11:30:19 CET 2012 : /opt/glite/yaim/bin/yaim
Installed YAIM versions:
glite-yaim-bdii 4.3.8-1
glite-yaim-core 5.0.2-1
glite-yaim-voms 1.0-10
####################################################################
INFO: The default location of the grid-env.(c)sh files will be: /usr/libexec
INFO: Sourcing the utilities in /opt/glite/yaim/functions/utils
INFO: Detecting environment
INFO: Executing function: config_host_certs_check
INFO: Executing function: config_edgusers_check
INFO: Executing function: config_add_pool_env_check
INFO: Executing function: config_info_service_voms_check
INFO: Executing function: config_info_service_voms_admin_check
INFO: Executing function: config_voms_check
INFO: Executing function: config_voms_logrotate_check
INFO: Executing function: config_bdii_5.2_check
INFO: Executing function: config_host_certs
INFO: Executing function: config_edgusers
INFO: Executing function: config_add_pool_env_setenv
INFO: Executing function: config_add_pool_env
INFO: Executing function: config_crl
INFO: Now updating the CRLs - this may take a few minutes...
Enabling periodic fetch-crl: [60G[[0;32m OK [0;39m]
INFO: Executing function: config_info_service_voms_setenv
INFO: Executing function: config_info_service_voms
INFO: Executing function: config_info_service_voms_admin_setenv
INFO: Executing function: config_info_service_voms_admin
INFO: Executing function: config_voms_setenv
INFO: Executing function: config_voms
INFO: MySQL configuration
INFO: Check that java is installed
INFO: Check that tomcat is installed
INFO: Stop tomcat in case it's running
Stopping tomcat5: INFO: Copying hostcert to /etc/grid-security/tomcat-cert.pem for tomcat:root......
INFO: Copying hostkey to /etc/grid-security/tomcat-key.pem for tomcat:root...
INFO: Configuring /etc/tomcat5/server.xml...
INFO: Copying trustmanager log4j properties to tomcat configuration directory..
INFO: Linking log4j and bouncycastle jars to tomcat server lib directory..
INFO: Linking trustmanager jars to tomcat server lib directory..
INFO: Defining JAVA_HOME in the Tomcat configuration file
INFO: Starting Tomcat
Starting tomcat5: [60G[ OK ]
INFO: Ready to start VOMS configuration
voms-admin-configure, version 2.6.1
Checking glite installation...
VOMS_LOCATION: /usr
VOMS_LOCATION_VAR: /var
VOMS_LOCATION_CONF: /
VOMS_ADMIN_LOCATION: /usr/share/voms-admin
VOMS_ADMIN_LOCATION_VAR: /
Checking local installation...
Glite installation ok.
Setting up user credentials...
Using host credentials (/etc/grid-security/hostcert.pem) since running as root.
Setting defaults for the VOMS AA credentials
Setting host credentials defaults for VOMS AA.
Cheking input parameters
Installing vo vo.org
Skipping voms core configuration creation
VO vo.org configured correctly.
VO vo.org installation finished.
You can start the voms services using the following commands:
/etc/init.d/voms start vo.org
/etc/init.d/voms-admin start vo.org
INFO: Checking VOMS database schema existence and deploying one if missing...
Checking database connectivity...
Database contacted succesfully
Checking database existence...
No voms-admin database found.
Checking that the database is writable...
Database is writable.
create table acl2 (acl_id bigint not null auto_increment, group_id bigint not null, defaultACL bit not null, role_id bigint, primary key (acl_id), unique (group_id, defaultACL, role_id)) type=InnoDB
create table acl2_permissions (acl_id bigint not null, permissions integer, admin_id bigint not null, primary key (acl_id, admin_id)) type=InnoDB
create table admins (adminid bigint not null auto_increment, dn varchar(255) not null, email_address varchar(255), ca smallint not null, primary key (adminid), unique (dn, ca)) type=InnoDB
create table attributes (a_id bigint not null auto_increment, a_name varchar(255) not null unique, a_desc text, a_uniq bit default 0, primary key (a_id)) type=InnoDB
create table aup (id bigint not null auto_increment, name varchar(255) not null unique, description varchar(255), reacceptancePeriod integer not null, primary key (id)) type=InnoDB
create table aup_acc_record (id bigint not null auto_increment, aup_version_id bigint not null, usr_id bigint not null, last_acceptance_date datetime not null, valid bit, primary key (id), unique (aup_version_id, usr_id)) type=InnoDB
create table aup_version (id bigint not null auto_increment, aup_id bigint not null, version varchar(255) not null, url varchar(255), text varchar(255), creationTime datetime not null, lastForcedReacceptanceTime datetime, active bit not null, primary key (id), unique (aup_id, version)) type=InnoDB
create table ca (cid smallint not null auto_increment, subject_string varchar(255) not null unique, description varchar(255), creation_time datetime not null, primary key (cid)) type=InnoDB
create table capabilities (cid bigint not null auto_increment, capability varchar(255) not null, primary key (cid)) type=InnoDB
create table certificate (id bigint not null auto_increment, creation_time datetime not null, subject_string varchar(255) not null, suspended bit not null, suspended_reason varchar(255), suspension_reason_code varchar(255), ca_id smallint not null, usr_id bigint not null, primary key (id), unique (ca_id, subject_string)) type=InnoDB
create table certificate_request (certificate tinyblob, certificateIssuer varchar(255) not null, certificateSubject varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table group_attrs (a_id bigint not null, g_id bigint not null, a_value varchar(255), primary key (a_id, g_id)) type=InnoDB
create table group_membership_req (groupName varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table groups (gid bigint not null auto_increment, dn varchar(255) not null unique, description varchar(255), parent bigint, must bit not null, restricted bit, primary key (gid)) type=InnoDB
create table m (mapping_id bigint not null auto_increment, userid bigint not null, gid bigint not null, rid bigint, cid bigint, primary key (mapping_id), unique (userid, gid, rid)) type=InnoDB
create table memb_req (id bigint not null auto_increment, creation_date datetime not null, evaluation_date datetime, status integer not null, confirm_id varchar(255) not null, dn varchar(255) not null, ca varchar(255) not null, cn varchar(255), mail varchar(255) not null, primary key (id)) type=InnoDB
create table membership_rem_req (reason varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
create table personal_info (id bigint not null auto_increment, value varchar(255), visible bit, personal_info_type_id bigint not null, primary key (id)) type=InnoDB
create table personal_info_type (id bigint not null auto_increment, description varchar(255), type varchar(255) not null unique, primary key (id)) type=InnoDB
create table req (request_id bigint not null auto_increment, completionDate datetime, creationDate datetime, expirationDate datetime, status varchar(255) not null, requester_info_id bigint not null, primary key (request_id), unique (requester_info_id)) type=InnoDB
create table requester_info (id bigint not null auto_increment, address varchar(255), certificateIssuer varchar(255) not null, certificateSubject varchar(255) not null, emailAddress varchar(255) not null, institution varchar(255), name varchar(255), phoneNumber varchar(255), surname varchar(255), voMember bit, primary key (id)) type=InnoDB
create table requester_personal_info (requester_id bigint not null, pi_value varchar(255), pi_key varchar(255), primary key (requester_id, pi_key)) type=InnoDB
create table role_attrs (a_id bigint not null, g_id bigint not null, r_id bigint not null, a_value varchar(255), primary key (a_id, g_id, r_id)) type=InnoDB
create table role_membership_req (groupName varchar(255), roleName varchar(255), request_id bigint not null, primary key (request_id)) type=InnoDB
create table roles (rid bigint not null auto_increment, role varchar(255) not null unique, primary key (rid)) type=InnoDB
create table seqnumber (seq varchar(255) not null, primary key (seq)) type=InnoDB
create table sign_aup_task (task_id bigint not null, aup_id bigint not null, primary key (task_id)) type=InnoDB
create table tag_mapping (mapping_id bigint not null auto_increment, tag_id bigint not null, gid bigint not null, rid bigint, admin_id bigint not null, primary key (mapping_id), unique (tag_id, gid, rid, admin_id)) type=InnoDB
create table tags (id bigint not null auto_increment, name varchar(255) not null unique, implicit bit not null, permissions integer not null, permissionsOnPath integer, primary key (id)) type=InnoDB
create table task (task_id bigint not null auto_increment, completionDate datetime, creationDate datetime, expiryDate datetime, status varchar(255) not null, admin_id bigint, task_type_id bigint not null, usr_id bigint, primary key (task_id)) type=InnoDB
create table task_log_record (id bigint not null auto_increment, adminDn varchar(255), creation_time datetime not null, event varchar(255) not null, userDn varchar(255), task_id bigint not null, primary key (id)) type=InnoDB
create table task_type (id bigint not null auto_increment, description varchar(255), name varchar(255) not null unique, primary key (id)) type=InnoDB
create table user_request_task (task_id bigint not null, req_id bigint not null, primary key (task_id)) type=InnoDB
create table usr (userid bigint not null auto_increment, address varchar(255), creation_time datetime not null, dn varchar(255), email_address varchar(255) not null, end_time datetime not null, institution varchar(255), name varchar(255), phone_number varchar(255), surname varchar(255), suspended bit, suspension_reason varchar(255), suspension_reason_code varchar(255), ca smallint, primary key (userid)) type=InnoDB
create table usr_attrs (a_id bigint not null, u_id bigint not null, a_value varchar(255), primary key (a_id, u_id)) type=InnoDB
create table version (version integer not null, admin_version varchar(255), primary key (version)) type=InnoDB
create table vo_membership_req (confirmId varchar(255) not null, request_id bigint not null, primary key (request_id)) type=InnoDB
alter table acl2 add index FK2D98E8720C9B10 (role_id), add constraint FK2D98E8720C9B10 foreign key (role_id) references roles (rid) on delete cascade
alter table acl2 add index FK2D98E8FCFA8B04 (group_id), add constraint FK2D98E8FCFA8B04 foreign key (group_id) references groups (gid) on delete cascade
alter table acl2_permissions add index FK35C6CFADD91CE8A3 (acl_id), add constraint FK35C6CFADD91CE8A3 foreign key (acl_id) references acl2 (acl_id)
alter table acl2_permissions add index FK35C6CFADA4AD9904 (admin_id), add constraint FK35C6CFADA4AD9904 foreign key (admin_id) references admins (adminid)
alter table admins add index FKAB3A67047C6FEB32 (ca), add constraint FKAB3A67047C6FEB32 foreign key (ca) references ca (cid)
alter table aup_acc_record add index FKB1979B32EE2D4487 (usr_id), add constraint FKB1979B32EE2D4487 foreign key (usr_id) references usr (userid)
alter table aup_acc_record add index FKB1979B32815F1678 (aup_version_id), add constraint FKB1979B32815F1678 foreign key (aup_version_id) references aup_version (id)
alter table aup_version add index fk_aup_version_aup (aup_id), add constraint fk_aup_version_aup foreign key (aup_id) references aup (id) on delete cascade
alter table certificate add index FK745F4197EE2D4487 (usr_id), add constraint FK745F4197EE2D4487 foreign key (usr_id) references usr (userid)
alter table certificate add index FK745F419782107F70 (ca_id), add constraint FK745F419782107F70 foreign key (ca_id) references ca (cid)
alter table certificate_request add index FK47CA53E7D75D60A4 (request_id), add constraint FK47CA53E7D75D60A4 foreign key (request_id) references req (request_id)
alter table group_attrs add index FK40B1A2E2566C2A8F (a_id), add constraint FK40B1A2E2566C2A8F foreign key (a_id) references attributes (a_id)
alter table group_attrs add index FK40B1A2E2DEFC581C (g_id), add constraint FK40B1A2E2DEFC581C foreign key (g_id) references groups (gid) on delete cascade
alter table group_membership_req add index FKBD145E75D75D60A4 (request_id), add constraint FKBD145E75D75D60A4 foreign key (request_id) references req (request_id)
alter table groups add index FKB63DD9D4A3771CD3 (parent), add constraint FKB63DD9D4A3771CD3 foreign key (parent) references groups (gid)
alter table m add index fk_m_roles (rid), add constraint fk_m_roles foreign key (rid) references roles (rid) on delete cascade
alter table m add index fk_m_groups (gid), add constraint fk_m_groups foreign key (gid) references groups (gid) on delete cascade
alter table m add index fk_m_cap (cid), add constraint fk_m_cap foreign key (cid) references capabilities (cid)
alter table m add index fk_m_usr (userid), add constraint fk_m_usr foreign key (userid) references usr (userid)
alter table membership_rem_req add index FK1877BC10D75D60A4 (request_id), add constraint FK1877BC10D75D60A4 foreign key (request_id) references req (request_id)
alter table personal_info add index FK229FDF4DA8D3C6BC (personal_info_type_id), add constraint FK229FDF4DA8D3C6BC foreign key (personal_info_type_id) references personal_info_type (id)
alter table req add index FK1B89EC37E889D (requester_info_id), add constraint FK1B89EC37E889D foreign key (requester_info_id) references requester_info (id)
alter table requester_personal_info add index FK7E3D7FCAD500B8D2 (requester_id), add constraint FK7E3D7FCAD500B8D2 foreign key (requester_id) references requester_info (id)
alter table role_attrs add index FK6BDE9799566C2A8F (a_id), add constraint FK6BDE9799566C2A8F foreign key (a_id) references attributes (a_id)
alter table role_attrs add index FK6BDE979920304994 (r_id), add constraint FK6BDE979920304994 foreign key (r_id) references roles (rid) on delete cascade
alter table role_attrs add index FK6BDE9799DEFC581C (g_id), add constraint FK6BDE9799DEFC581C foreign key (g_id) references groups (gid)
alter table role_membership_req add index FK3B9C79ED75D60A4 (request_id), add constraint FK3B9C79ED75D60A4 foreign key (request_id) references req (request_id)
alter table sign_aup_task add index FK7FCB416A32B8C70C (task_id), add constraint FK7FCB416A32B8C70C foreign key (task_id) references task (task_id)
alter table sign_aup_task add index FK7FCB416ADA1C6363 (aup_id), add constraint FK7FCB416ADA1C6363 foreign key (aup_id) references aup (id)
alter table tag_mapping add index fk_tag_mapping_roles (rid), add constraint fk_tag_mapping_roles foreign key (rid) references roles (rid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_admins (admin_id), add constraint fk_tag_mapping_admins foreign key (admin_id) references admins (adminid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_groups (gid), add constraint fk_tag_mapping_groups foreign key (gid) references groups (gid) on delete cascade
alter table tag_mapping add index fk_tag_mapping_tag (tag_id), add constraint fk_tag_mapping_tag foreign key (tag_id) references tags (id) on delete cascade
alter table task add index FK3635859AD54C57 (task_type_id), add constraint FK3635859AD54C57 foreign key (task_type_id) references task_type (id)
alter table task add index FK363585EE2D4487 (usr_id), add constraint FK363585EE2D4487 foreign key (usr_id) references usr (userid)
alter table task add index FK363585A4AD9904 (admin_id), add constraint FK363585A4AD9904 foreign key (admin_id) references admins (adminid)
alter table task_log_record add index FK77673CA632B8C70C (task_id), add constraint FK77673CA632B8C70C foreign key (task_id) references task (task_id)
alter table user_request_task add index FKACB7D2932B8C70C (task_id), add constraint FKACB7D2932B8C70C foreign key (task_id) references task (task_id)
alter table user_request_task add index FKACB7D299D73AC35 (req_id), add constraint FKACB7D299D73AC35 foreign key (req_id) references req (request_id)
alter table usr add index FK1C5947C6FEB32 (ca), add constraint FK1C5947C6FEB32 foreign key (ca) references ca (cid)
alter table usr_attrs add index FKA39E0E37566C2A8F (a_id), add constraint FKA39E0E37566C2A8F foreign key (a_id) references attributes (a_id)
alter table usr_attrs add index FKA39E0E3720331206 (u_id), add constraint FKA39E0E3720331206 foreign key (u_id) references usr (userid)
alter table vo_membership_req add index FK28EE8AFBD75D60A4 (request_id), add constraint FK28EE8AFBD75D60A4 foreign key (request_id) references req (request_id)
Deploying voms database...
Database deployed correctly!
INFO: Adding default admin from /etc/grid-security/hostcert.pem
Admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA' not found. It will be created...
Adding ALL permissions on '/vo.org' for admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA'
Adding ALL permissions on role '/vo.org/Role=VO-Admin' for admin '/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz,/C=NL/O=TERENA/CN=TERENA eScience SSL CA'
Stopping vo vo.org
Starting vo vo.org
Stopping siblings webapp
Starting siblings webapp
INFO: User and password for read-only database access for VOMS-CORE not specified.
INFO: Using the credentials for read-write access (VOMS-ADMIN).
Stopping tomcat5: [60G[ OK ]
Starting tomcat5: [60G[ OK ]
Stopping voms(vo.org): (already stopped)
Starting voms(vo.org): [60G[[0;32m OK [0;39m]
INFO: Executing function: config_voms_logrotate_setenv
INFO: Executing function: config_voms_logrotate
INFO: Executing function: config_bdii_5.2
Stopping BDII: BDII already stopped
Starting BDII slapd: [60G[[0;32m OK [0;39m]
Starting BDII update process: [60G[[0;32m OK [0;39m]
[80G[ [1;32mOK[0;39m ]
INFO: Configuration Complete.
INFO: YAIM terminated succesfully.
Experimental VOMS set up with users:
/C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root, /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=the trusted CA - root@myriad11.zcu.cz
/C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root client01, /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=the trusted CA - root@myriad11.zcu.cz
/DC=org/DC=terena/DC=tcs/C=CZ/O=CESNET/CN=Zdenek Sustr 4040, /C=NL/O=TERENA/CN=TERENA eScience Personal CA - root@myriad11.zcu.cz
groups:
/vo.org
/vo.org/Testers
roles:
Role=Tester
Role=VO-Admin
U org.glite.testsuites.ctb/gridsite/tests/gridsite-autonomous-test.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-common-testbeds.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-common.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-test-all.sh
U org.glite.testsuites.ctb/gridsite/tests/gridsite-test-packaging.sh
U org.glite.testsuites.ctb/gridsite/tests/ping-local.sh
U org.glite.testsuites.ctb/gridsite/tests/ping-remote.sh
U org.glite.testsuites.ctb/gridsite/tests/test-common.sh
========================
REAL TESTS START HERE
========================
Mar 05 11:32:30 myriad11.zcu.cz ping-remote.sh:
start
Testing if all binaries are available
done
Testing ping to Apache server myriad11.zcu.cz
done
Testing Apache server at myriad11.zcu.cz:443
done
Mar 05 11:32:32 myriad11.zcu.cz ping-remote.sh:
end
Mar 05 11:32:32 myriad11.zcu.cz ping-local.sh:
start
Testing if all binaries are available
done
Testing if Apache is running
done
Testing if GridSite is loaded
done
Testing if Apache is listening on port 443
done
Mar 05 11:32:32 myriad11.zcu.cz ping-local.sh:
end
Mar 05 11:32:32 myriad11.zcu.cz gridsite-test-all.sh:
start
Testing if all binaries are available
done
READ (Read Permissions)
Plain read... Return code 403
done
With gacl... Return code 200
done
Get index (list & read permissions)
Plain read... Return code 403
done
With gacl... Return code 200
done
WRITE & DELETE (write permissions)
Plain write... Return code 403
done
With gacl... Return code 201
done
Try deletion... Return code 403
done
With gacl... Return code 200
done
Checking attributes passed on to the environment
Run test.cgi... Return code 200
done
Check for GRST_* veriables...
done
Test the basic commands (htcp, htls, htmkdir, htmv, htrm)
Testing htcp...
done
Checking by htls...
done
Testing htmv...
done
htcp, file 2...
done
Testing htrm...
done
Checking by htls...
done
Checking directory contents with htls...
done
File compare...
done
Test proxy delegation
id: 2b9a4840ab844fe7
done
newid: 2b9a4840ab844fe7
done
Test handling of VOMS .lsc files (Regression test for bug #39254 and #82023)
Trying with empty vomsdir. GRST_CRED_2 should not be present...
done
Setting up .lsc file and trying again
Possibly fake VOMS extensions. Regenerating... Your identity: /C=UG/L=Tropic/O=Utopia/OU=Relaxation/CN=root
Creating temporary proxy Done
Contacting myriad11.zcu.cz:15000 [/DC=org/DC=terena/DC=tcs/C=CZ/O=University of West Bohemia/CN=myriads.zcu.cz] "vo.org" Done
Creating proxy Done
Your proxy is valid until Mon Mar 5 23:32:34 2012
Generated /etc/grid-security/vomsdir/vo.org/myriad11.zcu.cz.lsc
done
Checking for presence of FQAN...
done
Test listing of VOMS attributes (Regression test for bug #92077)
Getting list of Role attributes from voms-proxy-info...
done
Getting list of Role attributes from test.cgi...
done
re-running voms extensions...
done
Getting another set of Role attributes from test.cgi...
done
Comparing attributes...
done
Test flavours and sonames
flavour '' /usr/lib64/libgridsite.so
done
flavour '_nossl' /usr/lib64/libgridsite_nossl.so
done
flavour '_globus' /usr/lib64/libgridsite_globus.so
done
Check interpretable DEFVERSION... Oct 203431, Hex 10719
done
Mar 05 11:32:35 myriad11.zcu.cz gridsite-test-all.sh:
end
Downloading common definitions 'LB/lb-common.sh'...done
Mar 05 11:32:35 myriad11.zcu.cz gridsite-test-packaging.sh:
start
Packages compliance check output:
Mar 05 11:32:36 myriad11.zcu.cz gridsite-test-packaging.sh:
end
==================
TESTS END HERE
==================
Unit Tests
The current code of GridSite does not include any unit tests.
Resolution of Linked Bugs (Regression Tests where applicable)
- Functionality test
gridsite-test-all.sh
has been extended to regression-test this bug.
- Relevant section of output before the fix (GridSite 1.7.15-2):
Test listing of VOMS attributes (Regression test for bug #92077)
Getting list of Role attributes from voms-proxy-info...
done
Getting list of Role attributes from test.cgi...
done
re-running voms extensions...
done
Getting another set of Role attributes from test.cgi...
-TEST FAILED-
Error: List of role attributes is empty!
- The same section after the fix:
Test listing of VOMS attributes (Regression test for bug #92077)
Getting list of Role attributes from voms-proxy-info...
done
Getting list of Role attributes from test.cgi...
done
re-running voms extensions...
done
Getting another set of Role attributes from test.cgi...
done
Comparing attributes...
done
--
ZdenekSustr - 05-Mar-2012