07-22-2019 02:35 AM
Hello,
This setup uses a pair of SQL DB with replication, each server is setup as separated ODBC ID source in ISE (2.3 patch 6). Policies are made so that if attributes can't get retrieved from ODBC1, ODBC2 source would be used instead (OR condition or doubled rules).
Problem: If one ODBC server fails, the rule will be impacted by a connection timeout, sometime leading to radius timeout with the NAD - and this for each authentication request.
Question: IS there an attribute similar to the MDM.isServerReachable that could be used to detect one server failure condition?
Alternatively, is there a plan to provide some HA, or which way is recommended at the server-side (unsure if MS SQL provides some way of HA)?
Many thanks in advance.
Christophe
Solved! Go to Solution.
07-23-2019 12:31 AM
Thanks for your reply, of course using a reachability attribute is just a possible way, whatever helps handling the loss and recovery of one server in a redundant setup is welcome - we will check what the SQL infra can offer, as well as solutions based on SQL clustering or load-balancers.
Thanks and regards,
Christophe
07-22-2019 06:13 AM
ISE is not currently supporting an attribute to check for ODBC availability. Please connect with our PM team directly, due to No Comment on Roadmaps or Fixes in this forum.
07-22-2019 08:22 PM
Microsoft has implemented a connection string parameter to activate failover within the client called "MultiSubnetFailover". It seems however that there is no way to enter in that parameter within the ISE ODBC configuration.
We don't have control over connection string parameters to enable this within ISE, even assuming the driver underlying ISE is the microsoft-developed one.
07-23-2019 12:31 AM
Thanks for your reply, of course using a reachability attribute is just a possible way, whatever helps handling the loss and recovery of one server in a redundant setup is welcome - we will check what the SQL infra can offer, as well as solutions based on SQL clustering or load-balancers.
Thanks and regards,
Christophe
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide