5.4.1 Configuring MySQL for Adobe pre-configured JBoss

Before configuring the MySQL data source, you must have already created the database on MySQL as described in 4.6 Creating a MySQL database .

1. Open the [appserver root] \standalone\configuration\lc_turnkey.xml file in a text editor and locate this line for both IDP_DS and EDC_DS:

   <connection-url>jdbc:mysql://localhost:3306/adobe</connection-url> 
   <driver-class>com.mysql.jdbc.Driver</driver-class> 
   <security-domain>MySqlDbRealm</security-domain>

2. Replace the following text in the file with values that are specific to your database:

   • localhost: The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost .

   • 3306: The port used to access the database. The default port is 3306 .

   • adobe: The name of the database that stores the data. Replace the default value, adobe , with your database name.

3. In the lines that follow the <connection-url> settings, locate the user-name and password settings and replace the default values with the user name and password that the application server uses to access your database.

4. Ensure that the minimum and maximum values for the data source connections are set as follows:

   • For IDP_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

   • For EDC_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

     Note: If your AEM forms on JEE server handles heavy load, increase the maximum number of JDBC connections to ensure that all jobs are processed. In such cases, increase <max-pool-size> to 50 or more for both IDP_DS and EDC_DS.

5. Save and close the file.

1. Open the [appserver root] /standalone/configuration/lc_turnkey.xml file in a text editor and modify the following code within the <authentication> element:

   <security-domain name="EncryptDBPassword"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=DefaultDS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication> 
                   </security-domain> 
             <security-domain name="EncryptDBPassword_IDP_DS"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=IDP_DS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication> 
                   </security-domain> 
           <security-domain name="EncryptDBPassword_EDC_DS"> 
                       <authentication> 
                           <login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required"> 
                               <module-option name="userName" value="adobe"/> 
                               <module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/> 
                               <module-option name="managedConnectionFactoryName" value="jboss.jca:name=EDC_DS,service=LocalTxCM"/> 
                           </login-module> 
                       </authentication> 
                   </security-domain>

2. Replace the bold text with values that are specific to your database so that the application server can access your database.

3. Save and close the file.

4. Start JBoss.