How to convert a users file into a rlm_sql one?
Hi I have a setup like this for most of the users in the users file: rokky Huntgroup-Name == "ADSL", Password == "xyx" Framed-Protocol = PPP, Framed-IP-Address = 203.173.162.107, IHUG-Speed-Down = 5000, Service-Type = Framed-User rokky Huntgroup-Name == "DIALUP", Password == "xyx" Framed-Protocol = PPP, Service-Type = Framed-User, Session-Timeout = 600 - so depending on the used method of connection they get different replies. Is it possible to store such a setup in the database? I know i can organise users into groups, but then the answer is group-specific, not group-and-user-specific. Or have I missed something obvious? kind regards pshem
Yes. User specific check (password) in radcheck, group specific checks (connection type) in radgruopcheck: group specific replies in radgroupreply, user specific replies in radreply; assign users to groups in usergroup. And you can always combine sql with users file. Looking at your user entries it looks like with ADSL he should have static IP address, while on dialup IP would be assigned by DHCP. You should than make a radreply entry for the static IP and then override that for dialup with entry in users file: DEFAULT SQL-Group == "DIALUP" Framed-IP-Address := 255.255.255.254 Ivan Kalik Kalik Informatika ISP Dana 30/6/2007, "Pshem Kowalczyk" <pshem.k@gmail.com> piše:
Hi
I have a setup like this for most of the users in the users file:
rokky Huntgroup-Name == "ADSL", Password == "xyx" Framed-Protocol = PPP, Framed-IP-Address = 203.173.162.107, IHUG-Speed-Down = 5000, Service-Type = Framed-User
rokky Huntgroup-Name == "DIALUP", Password == "xyx" Framed-Protocol = PPP, Service-Type = Framed-User, Session-Timeout = 600
- so depending on the used method of connection they get different replies. Is it possible to store such a setup in the database? I know i can organise users into groups, but then the answer is group-specific, not group-and-user-specific. Or have I missed something obvious?
kind regards pshem - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, I would prefer to avoid user files all together. Currently we have over 100k customers (heaps of them have 'user-specific' setup, not just static ips). Customers change connection properties through a web-based interface and we need to speed up the propagation of those changes (currently we re-create the files every 5 minutes). I'll try to remove the unwanted ones with rlm_attr. kind regards pshem
participants (2)
-
Pshem Kowalczyk -
tnt@kalik.co.yu