How to convert a users file into a rlm_sql one?

[tnt at kalik.co.yu]

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