Installing OpenId-server on mysql

1) Download the JosID war file.
wget http://mirrors.redv.com/pub/jos/jos-1.2.1/jos-webapp-1.2.1.war
2) Deploy it on tomcat server
cp jos-webapp-1.2.1.war /usr/share/tomcat7/webapps/josid.war
3) start tomcat and stop it in order to extract the war content.
5) Copy the context.xml from the WAR to the tomcat/conf dir
cp /usr/share/tomcat7/webapps/josid/META-INF/context.xml /usr/share/tomcat7/conf/Catalina/localhost/josid.xml
6) Edit /usr/share/tomcat7/conf/Catalina/localhost/josid.xml and change the jdbc/jos resource and the Hybernate dialect:


<Resource
name="jdbc/jos"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/jos"
username="jos"
password="secret" />

<Environment
name="hibernate.dialect"
type="java.lang.String"
value="org.hibernate.dialect.MySQL5Dialect" />

Also change the password
<Environment
name="domain.configurator.password"
type="java.lang.String"
value="secret"
override="false" />

7) Download the mysql-connector and put it in tomcat/lib directory
8) Create the mysql database
CREATE USER 'jos'@'localhost' IDENTIFIED BY 'secret';
CREATE DATABASE jos;
GRANT ALL ON jos.* TO 'jos'@'localhost';
FLUSH PRIVILEGES;
9) start tomcat
10) open the josid URL and use the password previously configured in josid.xml