Assign IP based on CallingStationID.

[banga]

John , I see the way now. 
Thx, for help. I’m going to install test radius in nearest future.
I’ll try to check this query there. 


John Longland wrote:
> 
> 
> 
> Here is the query that I put into sql.conf
> Maybe use it and build on it for your 
> specific example ??
> 
> authorize_check_query = "select id,UserName,Attribute,Value,op FROM 
> ${authcheck_table} WHERE UserName in
> (select UserName from ${authcheck_table} WHERE Value =
> '%{Calling-Station-ID}')
> ORDER BY id"
> 
> John
> 
> -----Original Message-----
> From:
> freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.org
> [mailto:freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.
> org]On Behalf Of banga
> Sent: 08 November 2006 15:14
> To: freeradius-users at lists.freeradius.org
> Subject: Assign IP based on CallingStationID.
> 
> 
> 
> I use dafault table-layout.
> How I understand you just change username authentication to
> callingstationid
> authentication inside sql.conf. Thx, it’s really good idea. I think that I
> could do the same by myself, but it will take a time. 
> Therefore any examples will be very useful. Can you post it here?
> If It’s too big you can send it to me - “nebula-at-inbox-lv”.
> 
>>From other side, I need username/password authentication also (for other
> users) therefore it will be difficult to implement this ( may be I’ll
> install another freeradius specially for that).
> 
> In my situation radius for some users check username/password, for other
> users it should do the next:
> check username/password/callingstationid  (in fact username and password
> always the same)
> if callingstationid  has specific value (can be dosen specifc
> callingstationid_s) then replay accept and some specific IP for each
> specific callingstationid  or just assign ip from radius pool. 
> if callingstationid  is not in the list of “specific callingstationid”
> then
> just replay accept and NAS will assign ip from equipment’s IP pool
> 
> Main Idea: For now most users has the same username and password and it is
> not possible to change anything in that. Some callingstationid is not
> friendly for my network (they should have only http traffic). That’s why I
> want to assign them IP from specific pool – I going to setup firewall
> rules
> for a such IPs.
> 
> Any idea ?
> 
> 
> John Longland wrote:
>> 
>> Yes, I have just done it.
>> 
>> You need to change the sql-statement in /etc/raddb/sql.conf
>> 
>> That is the 
>> autorize_check_query.Depending on how you use your tables, the query
>> that I am using may or may not work. If you want I can give you the
>> one that works for me if you supply your table-layout.
>> 
>> JOhn
>> P.S> The statement I use does NOT check username/password !!!
>> 
>> -----Original Message-----
>> From:
>> freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.org
>> [mailto:freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.
>> org]On Behalf Of banga
>> Sent: 08 November 2006 11:37
>> To: freeradius-users at lists.freeradius.org
>> Subject: Assign IP based on CallingStationID.
>> 
>> 
>> 
>> Hello all.
>> I use freeradius ver. 1.1.1 + mysql.
>> I use same login/password for couple of users but they has different
>> callingstationid. 
>> Is it possible to check callingstationid and asiighn IP based on it? 
>> Do I need to create some additional tables in mysql for that?
>> 
>> Thx.
>> 
>> -- 
>> View this message in context:
>>
> http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7
>> 235317
>> Sent from the FreeRadius - User mailing list archive at Nabble.com.
>> 
>> - 
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>> 
>> - 
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7
> 238235
> Sent from the FreeRadius - User mailing list archive at Nabble.com.
> 
> 
> - 
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> 
> - 
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> 

-- 
View this message in context: http://www.nabble.com/Assign-IP-based-on-CallingStationID.-tf2594146.html#a7257034
Sent from the FreeRadius - User mailing list archive at Nabble.com.