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@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