Re: How do I used my customized table in.

[Stefan Winter]

Hi,

>         expand: SELECT UserName,Value FROM checking WHERE Username =
> '%{SQL-User-Name}' -> SELECT UserName,Value FROM checking WHERE Username =
> 'John'
> query:  SELECT UserName,Value FROM checking WHERE Username = 'John'
> rlm_sql_getvpdata: database query error
> rlm_sql (sql): SQL query error; rejecting user
> rlm_sql (sql): Released sql socket id: 3

Ah, no. FreeRADIUS always needs to get its four columns back from SQL. You 
only have two, user's name and cleartext password. You need

username  = <username> <- fetched in query
attribute = "Cleartext-Password" <- FIXED in query
op        = ":=" <- FIXED in query
value     = <password> <- fetched in query

This means something like

SELECT UserName,"Cleartext-Password" as attribute, ":=" as op, Value FROM 
checking WHERE Username = 'John'

Something like that. I use MySQL, but you should get the idea...

Stefan

-- 
Stefan WINTER

Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de 
la Recherche
Ingenieur Forschung & Entwicklung

6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg
E-Mail: [EMAIL PROTECTED]     Tel.:     +352 424409-1
http://www.restena.lu                Fax:      +352 422473

signature.asc
Description: This is a digitally signed message part.

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