Installation and Upgrade Guides › Directory Configuration Guide › MySQL Server › How to Configure a MySQL User Store › Configure MySQL Server Directory Connections

Configure MySQL Server Directory Connections

You configure a user directory connection to let the Policy Server communicate with a MySQL Server user store.

To connect the user store

1. Click Edit, System Configuration, Create User Directory.

   The User Directories Properties dialog appears with the Directory Setup tab open.

2. Complete the following:
   • Enter the user directory name in Name field.
   • Select ODBC from the NameSpace list.
   • Enter the data source name in the Data Source field.
   • Select a SQL query scheme from the SQL Query Scheme list.

     Note: If you have not created a SQL query scheme, click New. More information on creating SQL query schemes exists in the Policy Design Guide.

3. Click the Credentials and Connection tab.

   The Credentials and Connection tab opens.

4. Complete the following:
   1. Select Require Credentials.
   2. Type root in the Username field.
   3. Enter the administrator password in the Password and Confirm Password fields.
5. Click the User Attributes tab.

   The User Attributes tab opens.

6. Specify the database attribute record attributes that correspond to the following fields:
   • Universal ID (R)

     Example: Name

   • Disabled Flag (RW)

     Example: Disabled

   • Password Attribute (RW)

     Example: Password

   • Password Data (RW)

     Example: PasswordData

7. Click OK.

   SiteMinder saves the user directory settings, and the user directory appears in the User Directory List.