12.6.2.1 Configuring the SQL Server database connectivity
Before you configure the SQL Server data source,
you must have the LiveCycle database created on SQL Server. (See
Creating a SQL Server database.)
12.6.2.2 Edit lc_turnkey.xml file
-
Copy the lc_turnkey.xml file from the
[DVD_root]
/third_party/additional/datasources/lc_sqlserver/deploy
directory to the
[appserver root]
/standalone/configuration/
directory.
-
Open the adobe-ds.xml file in a text editor and modify the
<local-tx-datasource>
element
with your SQL Server connection settings:
<connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=adobe</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
-
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
.
-
1433
:
The port used to access the database.
-
adobe
:
The name of the database that stores
the LiveCycle data. You will need to update the default value,
adobe
,
with your database name.
-
Change the
<driver-class>
element
as follows:
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
-
In the lines that follow the
<driver-class>
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. 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>30</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.
-
Save and close the file.
12.6.2.3 Set MSSQL as the data source
If you are running LiveCycle with Oracle database, you
must create three datasources
IDP_DS
,
EDC_DS
,
and
DefaultDS
.
-
Open the [JBoss_root]/domain/configuration/domain_mssql.xml
file for editing.
-
Locate the
<datasources>
tag and delete
all the child nodes.
-
To create the IDP_DS datasource, in the <datasources>
node, add the following lines:
<datasource jta="true" jndi-name="java:/IDP_DS" pool-name="IDP_DS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
To create the EDC_DS datasource, after the IDP_DS datasource
nodes, in the <datasources> node, add the following lines:
<datasource jndi-name="java:/EDC_DS" pool-name="EDC_DS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
To create the DefaultDS datasource, after the EDC_DS datasource
nodes, in the <datasources> node, add the following lines:
<datasource jndi-name="java:/DefaultDS" pool-name="DefaultDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
Set the following database specfic values for datasources
IDP_DS, EDC_DS, and DefaultDS:
-
Localhost
:
The name, IP address, or fully-qualified path of the computer that
hosts the database. The default is localhost
-
1521
: If Oracle does not uses the default port, provide
the appropriate port number.
-
ORACLE_SID
: Replace the ORACLE_SID with your Oracle
System Identifier.�
-
DB_USER
,
DB_PASSWORD
: Provide the credentials
that the application server uses to access your database.
-
Modify the minimum and maximum values for the data source
connections:
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.
-
Add the following lines as child of the <datasource>
tag:
<datasources> tag.
<drivers>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
</drivers>
-
Save and close the file.
12.6.2.4 Edit the lc_turnkey.xml file
-
Open the
[appserver root]
/standalone/configuration/lc_turnkey.xml
file in a text editor and add the following lines within the
<authentication>
element:
Replace :�
�
<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>�
-
Replace the bold values with values that are specific to
your database.
-
Save and close the file.
-
Start JBoss.
12.6.2.5 Configure Integrated Security on Windows
-
Modify
the adobe-ds.xml and mssql-ds.xml files, located in
[appserver root]
\server\<profile_name>\deploy,
to add
integratedSecurity=true
to the connection
URL, as shown in this example:
Modify the domain_mssql.xml
files, located in
[appserver root]
\domain\configuration,
to add
integratedSecurity=true
to the connection
URL, as shown in this example:
<connection-url>jdbc:sqlserver://<serverhost>:<port>; databaseName=<dbname>;integratedSecurity=<true></connection-url>
-
Add the sqljdbc_auth.dll file to the Windows systems path
(C:\Windows) on the computer that is running JBoss. The sqljdbc_auth.dll
file is located within the Microsoft SQL JDBC 3.0 driver installation.
The default location is
[
SQL_root
]/sqljdbc_3.0/enu/auth/x86
for
32-bit operating systems and
[SQL_root]/sqljdbc_3.0/enu/auth/x64
for
64-bit operating systems.
-
Open the properties for the JBoss for Adobe LiveCycle ES3
service or the JBoss service that you configured, and click the
Log On
tab.
-
Select
This
Account
and type the value of a
valid user account. This change is not required if you are running
JBoss from the command line.
-
Change SQL Server Security from Mixed mode to Windows Authentication only.
|
|
|