Can we configure it via MySQL as well?

On 07-Aug-2018, at 5:19 PM, Elias Pereira <empbilly@gmail.com> wrote:

You can configure it in the post-auth option of the sites-enable/default configuration file.

E.g:

... ldap if (Ldap-Group == "CN=ADM,OU=GRUPOS,DC=mycompany,DC=intra") { update reply { &Tunnel-Type = VLAN &Tunnel-Medium-Type = IEEE-802 &Tunnel-Private-Group-Id = "51" } } elsif (Ldap-Group == "CN=ALUNOS,OU=GRUPOS,DC=mycompany,DC=intra") { update reply { &Tunnel-Type = VLAN &Tunnel-Medium-Type = IEEE-802 &Tunnel-Private-Group-Id = "40" elseif ... ...

On Tue, Aug 7, 2018 at 8:05 AM aseem kaushal <aseemkaushal91@gmail.com> wrote:

...

Need to configure freeradius for dynamic vlan assignment. What could be the various methods for the above. Thanks in advance.

Regards -Aseem Kaushal - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- Elias Pereira - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

On 07/08/18 18:08, Deepak Sehrawat wrote:

Can we configure it via MySQL as well?

From a post I made in April. I have a long complicated query which checks if the user has been deleted, or the user's account has been suspended, etc. It returns a value which is then used in various ways. update control { CustomVal := "%{sql:SELECT \ CASE \ WHEN (cs_suspended.value = '1') THEN 5010 \ WHEN (u.deleted != '0') THEN 5011 \ // etc Then the unlang code "decodes" the return value: if ( &control:CustomVal < 5000 ) { update reply { Filter-Id := &control:CustomVal Reply-Message += "Accept: MAC found." } } elsif (....