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@restena.lu Tel.: +352 424409-1 http://www.restena.lu Fax: +352 422473