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='[EMAIL PROTECTED]' 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