> Hi all,
> I have a freeradius configured with postgresql , both are work well.
>
> Because we have two groups of users in two different authentication tables
> in the DB, and I want freeradius will check both table when it get
> access-request.
>
> My question is in the configure file ---postgresql.conf, can I add another
> "authcheck_table", which means can I have two (or multiple)
> "authcheck_table" in that file? Of course I have to create two
> tables(radcheck and radcheck_2) in DB first.
>
> Do you think it is possible?if so ,how?
>
> Thanks
>
> Brian
I never use postgres, but could you just use a union on the two tables?
In mysql, it would look something like this.
"(SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table1} WHERE
STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER by id) UNION (SELECT
id,UserName,Attribute,Value,op FROM ${authcheck_table2} WHERE
STRCMP(Username, '%{SQL-User-Name}')"
I use something like that for reply_queries with mysql, I imagine it would
work for authorization as well.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
