12.6.1 Configuring MySQL for manually installed JBoss

Before you configure the MySQL data source, you must have the database created on MySQL. (See Creating a MySQL database.)

• Copy the mysql-connector-java-5.1.6-bin.jar driver file from the [DVD_root]/third_party/db/mysql directory on the installation DVD to the [appserver root]/server/<profile_name>/lib directory.

• Copy the mysql-connector-java-5.1.6-bin.jar driver file from the [DVD_root]/third_party/db/mysql directory on the installation DVD to the [appserver root]/server/<profile_name>/lib directory.

1. Copy the adobe-ds.xml file from the [DVD_root]/third_party/additional/datasources/lc_mysql/deploy directory on the installation DVD to the [appserver root]/server/<profile_name>/deploy directory.

2. Open the adobe-ds.xml file in a text editor and locate this line:

   <connection-url>jdbc:mysql://localhost:3306/adobe</connection-url> 
   <driver-class>com.mysql.jdbc.Driver</driver-class> 
   <user-name>adobe</user-name> 
   <password>adobe</password> 

3. Replace the following values 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 LiveCycle data. You will need to update the default value, adobe, with your database name.

4. 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.

5. Modify the minimum and maximum values for the data source connections:

   • IDP_DS:

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

   • EDC_DS:

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

     Note: If your LiveCycle Server handles heavy load, increase the number of maximum 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.

6. Save and close the file.

1. Navigate to the [appserver root]/server/<profile_name>/deploy directory and delete the hsqldb-ds.xml file.

2. Navigate to the [appserver root]/server/<profile_name>/deploy directory and delete the hsqldb-ds.xml file.

3. Navigate to the [appserver root]/docs/examples/jca directory and copy the mysql-ds.xml file to the [appserver root]/server/<profile_name>/deploy directory.

4. Navigate to the [appserver root]/docs/examples/jca directory and copy the mysql-ds.xml file to the [appserver root]/server/<profile_name>/deploy directory.

5. Open the [appserver root]/server/<profile_name>/deploy/mysql-ds.xml file in a text editor and modify the <local-tx-datasource> element with your MySQL connection settings:

   <jndi-name>MySqlDS</jndi-name> 
   <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url> 
   <driver-class>com.mysql.jdbc.Driver</driver-class> 
   <user-name>x</user-name> 
   <password>y</password>

6. Replace the bold values with values that are specific to your database:

   • MySqlDS: Change to DefaultDS.

   • mysql-hostname, 3306, jbossdb, x, and y: The database values that the application server uses to access the database.

7. Add the following line to the <local-tx-datasource> section, if it does not already exist.

   <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

8. Save and close the file.

1. Open the [appserver root]\server\<profile_name>\conf\login-config.xml file in a text editor and add the following text within the <policy> element:

   <application-policy name="MySqlDbRealm"> 
       <authentication> 
           <login-module 
           code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag 
           = "required"> 
           <module-option name="principal">adobe</module-option> 
           <module-option name="userName">adobe</module-option> 
           <module-option name="password">adobe</module-option> 
           <module-option  
           name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM, 
           name=DefaultDS </module-option> 
           </login-module> 
       </authentication> 
   </application-policy>

2. Replace the bold values with values that are specific to your database.

3. Save and close the file.

4. Start JBoss.