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

To configure a connection from the Policy Server to a MySQL Server user store, create a new User Directory object.

To configure a connection from the Policy Server to a MySQL Server user store

1. Click Infrastructure, Directory.
2. Click User Directory, Create User Directory.

   The Create User Directory pane opens.

   Note: You can specify user directory properties on this pane. For more information on the fields, settings, and options, click Help.

3. Type the name and a description of the new User Directory object in the fields on the General group box.
4. Select ODBC from the Namespace list, and type the data source name in the Data Source field on the Directory Setup group box.
5. Select the Require Credentials check box, and type the full DN and password of the administrator in the fields on the Administrator Credentials group box.
6. Select a scheme from the SQL Query Scheme list on the SQL Query Scheme group box.
7. (Optional) Complete the fields on the User Attributes group box.
   1. Type the Universal ID in the Universal ID field.

      Attribute type: string

   2. Type the flag that tracks disabled users in the Disabled Flag field.

      Attribute type: string

   3. Type the location of user passwords in the Password field.

      Attribute type: binary

   4. Type the location of user password history in the Password Data field.

      Attribute type: binary

      Note: This attribute is required by Password Services.

   5. Type the user's anonymous ID in the Anonymous ID field.

      Attribute type: string

   6. Leave the Email field blank.

      Note: The email feature is not implemented in the current version of SiteMinder.

   7. Type a response in the Challenge/Response field.

      Attribute type: string

      Note: This string is sent to the user after each challenge.

8. (Optional) Click Create on the Attribute Mapping List group box.

   The Create Attribute Mapping pane opens.

   Note: For more information about user attribute mapping, see the Policy Configuration Guide.

9. Click Submit.

   The Create User Directory task is submitted for processing.