Security

I want to limit concurrent 802.1x sessions based on user role and I use this rule but there's error.

What is my wrong ?

I'm sure in from statement (from radius_acc). My authentication source is AD_Crop but how can I find name of table ? in this statement

 

 

 

Thank you

You are going to need to send that screenshot at full size so that we can read it. :)

 

 

 

 

Thank you for your reply

Oh, you are trying to do an SQL query in an LDAP source. You need to create a new source, SQL Type, and put it in there. Point the new SQL source at the tipsdb. Just take a look at Endpoints Repository source for configuration.

Do you mean I can't put SQL command to query data with in LDAP ?

but If i use LDAP , How i limit concurrent 802.1x sessions

 

 

Thank you

Yes. That is what I mean. You need to add it to your service as an Authorization source. Then in Enforcement you can do something like:

Authorization:SQL-Session-Check Session Equals 1

Captive portal redirect to a page that tells them they are only allowed one device on the 802.1x network.