Re: From users file to SQL

2007-06-07 Thread tnt
It doesn't work. When the user is member of SUSPENDED and has a static IP address, rlm_sqlippool doesn't override the Framed-IP-Address. This is the behavior I expect for all other cases/groups. I am not sure if sqlippool has the option to override Framed-IP-Address if it is already set.

Re: From users file to SQL

2007-06-06 Thread David Majorel
It doesn't work. When the user is member of SUSPENDED and has a static IP address, rlm_sqlippool doesn't override the Framed-IP-Address. This is the behavior I expect for all other cases/groups. I had another problem with this configuration. A user can be member of multiple groups. If he is

Re: From users file to SQL

2007-06-05 Thread tnt
It will work fine if you set the pool to override the IP address already set. 1. Leave the # Default profile for everyone in the users file 2. Make groups SUSPENDED, DSL500 etc. in groupcheck table. You need 2 entries for group SUSPENDED, and one for others: (GroupName, Attribute, op, Value)

From users file to SQL

2007-06-04 Thread David Majorel
Hi, I need to convert my users/group file to rlm_sql, but after reading the wiki, I can't figure out how to reproduce the flow. I want to authorize all connections, except if the user exists and the password is wrong. If the users doesn't exist or is disabled, I set an unrouteable address to