Configuration Guides › Directory Configuration Guide › MySQL Server › Configure a MySQL Policy Store › How to Configure the Policy Store › Point the Policy Server to the Database

Point the Policy Server to the Database

You point the Policy Server to the database so the Policy Server can access the SOA Security Manager data in the policy store.

To point the Policy Server to the data store

1. Open the Policy Server Management Console, and click the Data tab.

   Database settings appear.

2. Select ODBC from the Storage list.

   ODBC settings appear.

3. Select Policy Store from the Database list.
4. Enter the name of the data source in the Data Source Information field.
   • (Windows) this entry must match the name you entered in the Data Source Name field when you created the data source.
   • (UNIX) this entry must match the first line of the data source entry in the system_odbc.ini file. By default, the first line in the file is [SOA Security Manager Data Sources]. If you modified the first entry, be sure that you enter the correct value.
5. Enter and confirm the user name and password of the database account that has full access rights to the database instance in the respective fields.
6. Specify the maximum number of database connections allocated to SOA Security Manager.

   Note: We recommend retaining the 25 connection default for best performance.

7. Click Apply.

   The settings are saved.

8. Select Key Store from the Database list.

   Data source information appears.

9. Select the Use the policy store database check box and click Apply.
10. Select Audit Logs from the Database list.

    Data source settings appear.

11. Click Test Connection.

    <stmdnr> returns a confirmation that the Policy Server can access the data store.

12. Click OK.

    The Policy Server is configured to use the database as a policy store, key store, and logging database.