When running the ODBC test function from ISE I see the connection as passed but the stored procedures fail. I have built 2 IPSK servers. The first one was built on version 1 and has been upgraded to version 2. This server passes all the ODBC tests from ISE (even after upgrade to version 2). The second server I built on version 2. This server fails the stored procedure portion of the test.
Even though the test fails on the second server I am still able to query the database from ISE and retrieve user attributes and groups. Testing shows that clients are able to authenticate against the second server without issue. I believe this is a cosmetic error but I want to make sure before going into production. Has anyone else seen this and resolved the issue?
I have included details of my setup below:
ISE 2.4.0.35 patch 10
5520 8.5.140
iPSK Manager Database Scheme Version: 2
Lookup from the second server:
24869 Perform fetching of the user groups in external ODBC database
24870 Fetching of the user groups in external ODBC database succeeded
24872 Perform fetching of the user attributes in external ODBC database
24873 Fetching of the user attributes in external ODBC database succeeded
15048 Queried PIP - iPSK.ExternalGroups
24869 Perform fetching of the user groups in external ODBC database
24849 Connecting to external ODBC database
24850 Successfully connected to external ODBC database
24870 Fetching of the user groups in external ODBC database succeeded
24872 Perform fetching of the user attributes in external ODBC database
24873 Fetching of the user attributes in external ODBC database succeeded
15048 Queried PIP - iPSK02.ExternalGroups
15016 Selected Authorization Profile - AUTHZ_IPSK_INTERNET
11002 Returned RADIUS Access-Accept
