On Thu, 7 Nov 2002, Gloria Chung wrote: > Hi, > I'm wondering if there's any documentation on the free-radius database > schema. I'm especially interested in the user-group (which table > contains the roles and how is that associated with an individual user). > > From the database that I built from the file > src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql, it doesn't > look like there are any relationship between the user (radcheck table) > and the user groups (assuming usergroup table). > Have I missed a step in building the database? > > Any help will be appreciated. Thanks in advance. > > Gloria
Also check raddb/sql.conf. Apart from the usergroup table there are also radgroupcheck and radgroupreply. The queries in sql.conf should explain their associations. -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
