JOSSO configuration complete manual

After downloading the JOSSO-Tomcat package, you can decompressed directly, then point Catalina_Home and Tomcat_Home to this package, which is relatively simple because it is basically configured. If you are configured separately, remember to add the following jar: jaxrpc.jaraxis.jarcommons-configuration-1.0-rc1.jarcommons-discovery.jarsaj.jar / webapps / josso / web-inf / class / josso- Gateway-config.xml This file needs to be configured according to the database. If it is mysql, specify in Test Database root JDBC: mysql: // localhost / test com.mysql.jdbc.driver Built table script as follows: Name Varchar (16) Not Null, Description Varchar (64) null;

CREATE TABLE JOSSO_USER (LOGIN VARCHAR (16) NOT NULL, PASSWORD VARCHAR (20) NOT NULL, NAME VARCHAR (64) NULL, DESCRIPTION VARCHAR (64) NULL); CREATE TABLE JOSSO_USER_PROPERTY (LOGIN VARCHAR (16) NOT NULL, NAME VARCHAR ( 255) Not null, value varchar (255) Not null; Create Table Josso_user_role (login varchar (16) Not null, Name Varchar (255) Not null;

ALTER TABLE JOSSO_USER_ROLE AD (Primary Key (Login, Name));

ALTER TABLE JOSSO_USER_PROPERTY ADD (Foreign Key (Login) References Josso_user;

ALTER TABLE JOSSO_USER_ROLE AD (Foreign Key (Name) References Josso_Role);