> From: Ali Gunduz
> Sent: Wednesday, 27 August 2003 6:23 PM
> We have a problem with getting the group name into Group attribute from
> SQL and then checking it in users file.
> user <-> group matching info is stored in Postgresql.
>
> A sample entry (Id field not show) is like below
> username groupname
> -------- ---------
> foo bar
> We want to assign reply A/V pairs per group and we want
> to do it in users file.
Yeah, this got me too.
Try added ('bar' 'Group' ':=' 'bar') to your radgroupreply
table. The way the SQL queries work, the usergroup table is
joined to the radgroup{check,reply} table, and attributes
are gotten. There's no actual connection between the usergroup
table and the Group attribute in FreeRADIUS.
> We do NOT want to store ANY reply A/V pair in an SQL table. This why
> we're looking for a solution in users file.
If you're worried about SQL-sourced data being returned to the
NAS, the Group attribute is FreeRADIUS-internal so it won't
propogate.
Alternatively, modify the queries in your sql.conf (or whichever
you're using) to fill in the Group field... I dunno if that's
actually possible with the code base, you'd prolly have to poke
around in the rlm_sql module code to see how it works.
Why do you not want to store ANY reply A/V pair in an SQL table?
--
=========================================================
Paul "TBBle" Hampson
Bubblesworth Pty Ltd (ABN: 51 095 284 361)
[EMAIL PROTECTED]
This is a one line proof...if we start
sufficiently far to the left.
-- Cambridge University Math Department
---------------------------------------------------------
Random signature generator 3.0 by Paul "TBBle" Hampson
=========================================================
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
