Cisco Cisco Identity Services Engine 2.1 Manual Técnica

Note: Treat SQL code in this document as an example. Usually there is more than one way
to code desired functionality and all of them have their advantages and disadvantages.

Configuration steps include database creation and one user for ISE with permissions to access
that database.

1. From postgres user create isedb user:

2. Create a database

or with SQL:

3. Allow access to PostgreSQL

Find the lines that looks like this, near the bottom of the file:

Then replace ident with md5, so they look like this:

4. Allow remote connections to PgSQL

You need to open PostgreSQL configuration file /var/lib/pgsql/data/postgresql.conf. Find
configuration line that reads:

 and change to

Allow connections from all addresses. Uncomment port configuration line (if commented):

5. Restart PgSQL:

Create an ODBC Identity Source at Administration > External Identity Source > ODBC and test
connection: