Administrator Guide

210 | Authentication and Authorization Dell Networking W-ClearPass Policy Manager 6.6 | User Guide
The following table describes the Generic SQLDB - Primary parameters:
Table 96: Generic SQLDB - Primary Tab Parameters
Parameter Description
Server
Name
Enter the hostname or IP address of the database server.
Port
(Optional)
Specify a port value to override the default port.
Database
Name
Enter the name of the database from which records can be retrieved.
Login
Username
Enter the name of the user used to log into the database. This account must have read access to all
the attributes that need to be retrieved by the specified filters.
Password Enter the password for the user account entered in the Login Username field.
Timeout Enter the duration in seconds that Policy Manager waits before attempting to fail over from primary
to backup servers (in the order in which they are configured).
ODBC
Driver
Select the ODBC driver (Postgres, Oracle11g, or MSSQL) to connect to the database.
MySQL is supported in versions 6.0 and later. Dell does not ship MySQL drivers by default. If you
require MySQL, contact Dell support at dell.com/support to get the required patch. This patch does
not persist across upgrades. If you are using MySQL, you should contact support before upgrading.
If you connect to a Microsoft SQL server using Integrated Authentication, the login username in the
authentication source, formatted as either domain/username or UPN (User Principal Name), the
backslash ( \ ) and at-sign (@) characters in addition to the hyphen and underscore characters are
supported.
Password
Type
Specify how the user password is stored in the database:
l Cleartext : Password is stored as clear, unencrypted text.
l NT Hash: Password is stored with an NT hash using MD4.
l LM Hash : Password is stored with a LAN Manager Hash using DES.
l SHA: Password is stored with a Secure Hash Algorighm (SHA) hash.
l SHA256: Password is stored with an SHA-256 hash function.
Attributes Tab
The Attributes tab defines the SQL DB query filters and the attributes to be fetched by using those filters. The
following figure displays the Generic SQL DB- Attributes tab: