Yes this query is configurable. The table name and the
query can all be found in /etc/raddb/postgresql.conf
this is for the query table
authcheck_table = "radcheck"
and this is the query
authenticate_query = "SELECT Value,Attribute FROM
${authcheck_table} \
WHERE UserName = '%{User-Name}' AND (
Attribute = 'User-Password' OR Attribute =
'Crypt-Password' ) \
ORDER BY Attribute DESC"
I hope this helps.
Kafui Amedzekor.
--- Thor Spruyt <[EMAIL PROTECTED]> wrote:
> Alan DeKok wrote:
> > "Thor Spruyt" <[EMAIL PROTECTED]> wrote:
> >> Does this mean that the sql module will always
> use the standard
> >> radcheck table for authentication and that can't
> be changed anymore?
> >
> > The SQL module hasn't done authentication for
> over 2 years.
>
> What I mean is that the username and password are in
> the database and
> freeradius must somehow retrieve that from the
> database.
> I'm wondering what query freeradius does to retrieve
> the information and if
> that query is configurable.
>
> --
> Regards,
>
> Thor Spruyt
> E: [EMAIL PROTECTED]
> W: www.thor-spruyt.com
> M: +32 (0)475 67 22 65
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
