Re: Realms and SQL

[Chris Parker]

At 05:57 PM 12/12/2002 +1100, Alan Wong wrote:

Dear all,

I was just wondering when I set up realms through the proxy.conf file how do
I specify when it gets authenticated locally that it will check the SQL
Database. At the moment in the proxy.conf file it has

realm paris {
        type              = radius
        authhost        = LOCAL
        accthost        = LOCAL
}

I want it to authenticate against the mysql database instead of the user
file currently specified. Sorry I have tried a few different combinations
and have read the mailing list but the threads I have read has either no
responses or responses that are vague.

Not sure what is confusing about it. And you don't want to actually
authenticate against the mysql database. What you want to do is retrieve
the users password from the database.

You'll need to add an 'sql' module instance to your 'authorize' block and
remove the 'files' module instance to use one over the other. You should
not need to change anything in the 'authenticate' block.

-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net



- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html