[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: FreeRadius overview
From:       Dennis Skinner <dskinner () bluefrog ! com>
Date:       2006-12-28 20:13:08
Message-ID: 45942554.4070202 () bluefrog ! com
[Download RAW message or body]

David Covert wrote:
> Ok, I almost get it...  question:
>  
> The mssql.conf file has an entry like this:
>  
> #Database table configutation
> radius_db = "radius"
>  
> I assume that "radius" refers to a pre-determined schema that freeRadius

That is not a schema, that is the database name.  As in:

SELECT * FROM radius.radcheck WHERE UserName='user@domain.com'

in the MySQL world.

As for Platy, no.  You really should use the radius schema.  It will
save you a lot of grief down the road.  Create a new set of tables and
have platy make mods to both its main tables and the radius ones at the
same time.  We have that exact setup.

If you have a *very* simple radcheck setup (no usergroups, time limits,
etc....basically just the password), then you may be able to get away
with modding the query to only pull the username and password from the
Platy table.  Something like:

SELECT id,username,"Password",password,"==" from customers where
username="blah"

So you are "hardcoding" the attribute and operator into the query.  But
as I said, you really should use a separate set of tables.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]