JBoss For MySQL

Modify web.xml

Modify <%JBOSS-HOME%>/server/default/deploy/cms.war/WEB-INF/web.xml with following content:

<resource-ref>
       <res-ref-name>jdbc/repositoryDS</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
</resource-ref>

Create jboss-web.xml

Create <%JBOSS-HOME%>/server/default/deploy/cms.war/WEB-INF/jboss-web.xml with following content:

<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
     <resource-ref>
          <res-ref-name>jdbc/repositoryDS</res-ref-name>
          <jndi-name>java:/jdbc/repositoryDS</jndi-name>
          <res-type>javax.sql.DataSource</res-type>
          <res-auth>Container</res-auth>
     </resource-ref>
</jboss-web>

Modify login-config.xml

Modify <%JBOSS-HOME%>/server/default/conf/login-config.xml with following contents:

     <application-policy name="Jackrabbit">
       <authentication>
         <login-module code="org.hippoecm.repository.security.HippoLoginModule" flag="required" >
             <module-option name="usersProperties">props/users.properties</module-option>
             <module-option name="rolesProperties">props/roles.properties</module-option>
             <module-option name="unauthenticatedIdentity">anonymous</module-option>
         </login-module>
       </authentication>
     </application-policy>

Create mysql-dx.xml

Create <%JBOSS-HOME%>/server/default/deploy/mysql-dx.xml with following content:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>/jdbc/repositoryDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/hippocms</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <user-name>javauser</user-name>
    <password>javadude</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

Create database

Create the hippocms dabase in Mysql Database.