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: stefan.winter at restena.lu     Tel.:     +352 424409-1
http://www.restena.lu                Fax:      +352 422473
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080303/f1ddff52/attachment.pgp>