Problem FreeRadius EAP/TTLS and MySQL

2003-09-01 Thread Fastbyte 
Hi,

1046 means PW_NO_SUCH_ATTRIBUTE, so imho it means that the value of the 
sql field attribute Password is false, but after changing it to 
User-Password i get the same error.. whats the right attribute?

radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'XXX' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM 
radcheck WHERE Username = 'XXX' ORDER BY id
rlm_sql_mysql: MYSQL check_error: 1046 received
rlm_sql_getvpdata: database query error
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
  modcall[authorize]: module sql returns fail
modcall: group authorize returns fail

--
Sergio
FutureBrain


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

Re: Problem FreeRadius EAP/TTLS and MySQL

2003-09-01 Thread Alan DeKok 
Fastbyte [EMAIL PROTECTED] wrote;
 1046 means PW_NO_SUCH_ATTRIBUTE, so imho it means that the value of the 
 sql field attribute Password is false, but after changing it to 
 User-Password i get the same error.. whats the right attribute?

  That all depends on what you want.

 radcheck WHERE Username = 'XXX' ORDER BY id
 rlm_sql_mysql: MYSQL check_error: 1046 received

  That is a MySQL error, and has nothing to do with FreeRADIUS.  See
what '1046' means to MySQL

  Alan DeKok.

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