Using MySQL and assigning IP-Addresses based onCalling-Station-ID

Ackbar Joolia ackbar.joolia at
Mon Jan 15 17:44:42 CET 2007

Thanks for your reply. I didn’t know about the Fall-Through.

I have got a list of static addresses, which I will need to assign through the Framed-IP-Address attribute. 

This is what I am trying to do: 
When I receive requests, they all come with the same username and password, but with different Calling-Station-ID. I have to authenticate and differentiate on the calling-station-id, and then assign static IP-Address to these users, based on the calling-station-id.

I know it sounds simple, but I can't get it to work or am not getting the logic right. Can you advise please?

My model has to work in the way described above i.e. same username and password, and assigning Framed-IP-Address based on the calling-station-id, in MySql.



-----Original Message-----
From: at [ at] On Behalf Of Phil Mayers
Sent: 15 January 2007 16:32
To: FreeRadius users mailing list
Subject: Re: Using MySQL and assigning IP-Addresses based onCalling-Station-ID

Ackbar Joolia wrote:

> The radcheck table contains an entry for the password.
> The radreply table contains a Fall-Through = Yes for the user user1.
> The radgroupcheck contains groupnames (coming from the usergroup table) and Calling-Station-Id which I need to authenticate against.
> The radgroupreply table contains the replies I want to send to the different groups, which would have been authenticated/differentiated through their calling-station-id.

That's not right, and if I'm understanding you correctly you can't do 
exactly what you want with the current release version of FreeRadius.

Fall-Through does nothing on the current release version of FreeRadius - 
the SQL module merges the user and all the group check items into one, 
checks them, then puts all the reply items in. Since they're all merged, 
putting users into >1 group with conflicting check items will fail, as 
will putting users into >1 group with the same reply items.

Also, you would not normally assign IPs to groups - you would assign 
them to sessions from a pool (see rlm_sqlippool) or statically to users 
(using Framed-IP-Address in the radreply items)

Could you be a bit more specific about what you're trying to do?
List info/subscribe/unsubscribe? See

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.10/624 - Release Date: 12/01/2007 14:04

More information about the Freeradius-Users mailing list