Multiple ISPs and big user database
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.
Felipe Neuwald wrote:
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
Try this: huntgroups file: #### ISP1 Client-IP-Address == 10.1.1.1 SQL-Group == ISP1 ISP1 Client-IP-Address == 10.1.1.2 SQL-Group == ISP1 ISP1 Client-IP-Address == 10.1.1.3 SQL-Group == ISP1 ISP2 Client-IP-Address == 10.2.2.1 SQL-Group == ISP1 ISP2 Client-IP-Address == 10.2.2.2 SQL-Group == ISP1 ISP2 Client-IP-Address == 10.2.2.3 SQL-Group == ISP1 #### Now instead of the radcheck table, use the usergroup table like this: +-------+--------------------+-----------+ | id | UserName | GroupName | +-------+--------------------+-----------+ | 1 | user@example.com | ISP1 | | 2 | user2@example.com | ISP2 | +-------+--------------------+-----------+ It should just work. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com
participants (2)
-
Dennis Skinner -
Felipe Neuwald