ページ履歴

...

1. Create Database
   Create a database shibboleth used by the Shibboleth IdP:

   パネル
   borderColor silver bgColor white
   db$ mysql -u root mysql> CREATE DATABASE shibboleth;

2. Create User
   Create a user shibboleth for access to database shibboleth from IdP. In addition, grant permissions to the database shibboleth to the created user:

   パネル
   borderColor silver bgColor white
   db$ mysql -u root mysql> CREATE USER 'shibboleth'@'localhost' IDENTIFIED BY 'shibpassword';           # ←arbitrary password GRANT INSERT, SELECT, UPDATE, DELETE ON shibboleth.* TO 'shibboleth'@'localhost';

3. Create Table

   Create a table StorageRecords used by JPAStorageService:

   パネル
   borderColor silver bgColor white
   db$ mysql -u root mysql> use shibboleth; CREATE TABLE `StorageRecords` (     `context` varchar(255) NOT NULL,     `id` varchar(255) NOT NULL,     `expires` bigint(20) DEFAULT NULL,     `value` longtext NOT NULL,     `version` bigint(20) NOT NULL,     PRIMARY KEY (`context`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2.1.3. MySQL

...

Connector/J Installation

1. Install the MySQL Connector/J (mysql-connector-java.jar) required to access the MySQL:

   書式設定済み
   # yum install mysql-connector-java

2. The libraries are installed under /usr/share/java. Create a symbolic link from they to the lib directory of Tomcat:

   書式設定済み
   # rpm -ql mysql-connector-java ... /usr/share/java/mysql-connector-java.jar ... # ln -s /usr/share/java/mysql-connector-java.jar $CATALINA_BASE$/lib/

...