topic Use ODBC connection to check against MAC address Database in Network Access Control

Use ODBC connection to check against MAC address Database

umahar — Fri, 10 Mar 2017 16:16:34 GMT

Hi,

I have a use case where I want to extract MAC addresses from Radius requests and want to check against an external database using ODBC connection feature in ISE 2.1

Is this use case possible to achieve ?

Re: Use ODBC connection to check against MAC address Database

Charlie Moreton — Fri, 10 Mar 2017 16:28:54 GMT

Yes. Here it is in the Cisco Identity Services Engine Administrator Guide, Release 2.1

Re: Use ODBC connection to check against MAC address Database

umahar — Fri, 10 Mar 2017 16:34:14 GMT

Thanks Charles,

I just found the document too. We may have to create a procedure for

This would work well for MAB but I have a use case which would require taking MAC address from dot1x requests.

I dont think ISE can query calling-station-id against an external database.

Re: Use ODBC connection to check against MAC address Database

hslai — Sat, 11 Mar 2017 03:01:25 GMT

You are correct that it only supported with MAB auth. There are similar requests to use ODBC for endpoint lookup in DOT1X. Please bring your use case with our product management team.