Multiple ISPs and big user database

Felipe Neuwald felipe at neuwald.biz
Thu Dec 21 18:21:00 CET 2006


Hi Folks,

My MySQL database is working ok, thank you all of you guys.

More one problem:

I have two ISPs here, each one with 3 NAS IP addresses:

ISP1:
NAS 1: 10.1.1.1
NAS 2: 10.1.1.2
NAS 3: 10.1.1.3

ISP2:
NAS 1: 10.2.2.1
NAS 2: 10.2.2.2
NAS 3: 10.2.2.3


And my radcheck table is like this:
id: (incremental)
username: the user name
attribute: (always Password)
op: (always ==)
value: the password
isp: (can be 1 or 2)

A simple example:
id: 33934
username: john
attribute: Password
op: ==
value: smith
isp: 1

The question is. When a user come from ISP1, can I pass one SQL 
paramether, and whan a user come from ISP2, can I pass other SQL paramether?

Thanks,

Felipe Neuwald.





More information about the Freeradius-Users mailing list