Using MySQL and assigning IP-Addressesbased onCalling-Station-ID
Ackbar Joolia
ackbar.joolia at bglobalmetering.com
Tue Jan 16 13:53:00 CET 2007
Thanks Phil,
I will try that. What is the CVS code you are referring to?
Al
Sent: 15 January 2007 18:28
To: FreeRadius users mailing list
Subject: Re: Using MySQL and assigning IP-Addressesbased onCalling-Station-ID
Ackbar Joolia wrote:
> Phil, 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.
Ah.
>
> I know it sounds simple, but I can't get it to work or am not getting
> the logic right. Can you advise please?
You won't be able to do that on the current SQL code. Since the SQL
groups are all "squashed together" and you're using the same user.
>
> 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.
You could try the CVS code - it should work as you expect. Set the
user-password on the "radcheck" table, then have a group per station
with a single check item of calling-station-id, and a single reply item
of framed-ip-address
If you can't upgrade, you could possibly re-write the username to the
calling-station-id in the hints file, then put the calling-station-id as
the username in radcheck, and the framed-ip-address in radreply.
I know you said it "has to" be in mysql, but you should also investigate
the rlm_passwd module (which does not do what it sounds like). It ought
to be trivial to dump the SQL to a file of the form:
calling-station-id:framed-ip-address
...and set it on the reply. See "man rlm_passwd"
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
*** Email COnfidentiality Notice ***
This message is private and confidential.If you have received this in error, please notify us and remove it from your system. Contact info at bglobalmetering.com
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.10/624 - Release Date: 12/01/2007 14:04
--
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