802.1x/EAP-TLS and MAC authentication via SQL with dynamic VLANs

2012-03-22 Thread PENZ Robert
Hi! We've currently a MAC authentication running with dynamic VLANs via SQL for wired clients. We return the wished VLAN for the client by using the SQL function authorize_reply_query. We now want to add 802.1x EAP-TLS as supported authentication method. I got the setup sofar that I'm able to

AW: 802.1x/EAP-TLS and MAC authentication via SQL with dynamic VLANs

2012-03-22 Thread PENZ Robert
users mailing list Betreff: Re: 802.1x/EAP-TLS and MAC authentication via SQL with dynamic VLANs Hi, On Thu, Mar 22, 2012 at 03:24:41PM +0100, PENZ Robert wrote: And how can I use the CN of the certificate in the SQL query? I believe I need one query for MAC and one for EAP-TLS, as for one I

Re: 802.1x/EAP-TLS and MAC authentication via SQL with dynamic VLANs

2012-03-22 Thread Matthew Newton
Hi, On Thu, Mar 22, 2012 at 04:27:14PM +0100, PENZ Robert wrote: But how to I execute the SQL authorize_reply_query query after I did a EAP authentication? I don't do that currently in post-auth. I just have the sql modul activated in authorize. Sorry, can't help here. I've never done any SQL

Re: AW: 802.1x/EAP-TLS and MAC authentication via SQL with dynamic VLANs

2012-03-22 Thread Phil Mayers
On 22/03/12 15:27, PENZ Robert wrote: Hi! Thx for the fast response! But how to I execute the SQL authorize_reply_query query after I did a EAP authentication? I don't do that currently in post-auth. I just have the sql modul activated in authorize. Like this: post-auth { if