Configuring JBoss for SkyVault

1. To install the required JDBC driver as a core module, create the <JBOSS_EAP_HOME>\modules\com\mysql\main directory.
2. Copy the JDBC driver, mysql-connector-java-5.1.20-bin.jar to <JBOSS_EAP_HOME>\modules\com\mysql\main.
3. Create the <JBOSS_EAP_HOME>\modules\com\mysql\main\module.xml file with the following contents:

   <?xml version="1.0" encoding="UTF-8"?>
     <module xmlns="urn:jboss:module:1.0" name="com.mysql">
       <resources>
        <resource-root path="mysql-connector-java-5.1.20-bin.jar"/>
       </resources>
       <dependencies>
        <module name="javax.api"/>
       </dependencies>
     </module>

Modify the subsystem datasources in the <JBOSS_EAP_HOME>\standalone\configuration\standalone.xml file to have the following content:

<subsystem xmlns="urn:jboss:domain:datasources:1.1">
  <datasources>
    <datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true">
    <connection-url>jdbc:mysql://localhost:3306/alfresco</connection-url>
    <driver>com.mysql</driver>
        <pool>
          <min-pool-size>10</min-pool-size>
          <max-pool-size>100</max-pool-size>
          <prefill>true</prefill>
        </pool>
        <security>
          <user-name>alfresco</user-name>
          <password>alfresco</password>
        </security>
        <statement>
          <prepared-statement-cache-size>32</prepared-statement-cache-size>
          <share-prepared-statements>true</share-prepared-statements>
        </statement>
    </datasource>
    <drivers>
        <driver name="com.mysql" module="com.mysql">
        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
        </driver>
    </drivers>
  </datasources>
</subsystem>

<new-connection-sql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT;</new-connection-sql>

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE jboss-web PUBLIC"-//JBoss
//DTD Web Application 4.2//EN"
  "http://www.jboss.org/j2ee/dtd/jboss-web_4_2.dtd">
<jboss-web>
   <resource-ref>
     <res-ref-name>jdbc/dataSource</res-ref-name>
     <jndi-name>java:jboss/datasources/MySqlDS</jndi-name>
   </resource-ref>
   <resource-ref>
     <res-ref-name>jdbc/activitiIdGeneratorDataSource</res-ref-name>
     <jndi-name>java:jboss/datasources/MySqlDS</jndi-name>
   </resource-ref>
</jboss-web>

1. (For Windows): In <JBOSS_EAP_HOME>\bin\standalone.conf.bat, add the following to JAVA_OPTS.

   set "JAVA_OPTS=%JAVA_OPTS% -Dorg.jboss.as.logging.per-deployment=false"

   (For Unix/Linux): In <JBOSS_EAP_HOME>/bin/standalone.conf, add the following to JAVA_OPTS:

   JAVA_OPTS="$JAVA_OPTS -Dorg.jboss.as.logging.per-deployment=false"

2. Modify logging subsystem in <JBOSS_EAP_HOME>\standalone\configuration\standalone.xml.
   • Change the default level for <root-logger> from INFO to ERROR in <subsystem xmlns="urn:jboss:domain:logging:1.3">.
   • Add the logger elements as children to <subsystem xmlns="urn:jboss:domain:logging:1.3”> with logging configuration taken from SkyVault-enterprise-4.2.7.ear\alfresco.war\WEB-INF\classes\log4j.properties.
   Note: For more information on logging mapping elements, see JBoss logging.

• <JBOSS_EAP_HOME>\bin\standalone.conf.bat (For Windows platform) or
• <JBOSS_EAP_HOME>/bin/standalone.conf (For Unix/Linux OS).

<system-properties>
 <property name="org.apache.catalina.connector.URI_ENCODING" value="UTF-8"/>
 <property name="org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING" value="true"/>
</system-properties>

<extension module="org.jboss.as.webservices"/>

<subsystem xmlns="urn:jboss:domain:webservices:1.2">
    <modify-wsdl-address>true</modify-wsdl-address>
    <wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>
    <endpoint-config name="Standard-Endpoint-Config"/>
    <endpoint-config name="Recording-Endpoint-Config">
      <pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">
        <handler name="RecordingHandler" class="org.jboss.ws.common.invocation.RecordingServerHandler"/>
      </pre-handler-chain>
    </endpoint-config>
</subsystem>

1. Open the JBoss Management Console.
2. Set the server's IP address in Profiles > General Configurations > Interfaces > Network Interfaces > Available Interfaces.

1. Open the JBoss Management Console.
2. Navigate to Runtime > Manage Deployments.
3. Click the Add button.
4. Browse and select the modified SkyVault-enterprise-4.2.7.ear file.
5. After the EAR file is added, click the Enable button.