Hi, > Hi Alan > Thx for your input I did the following: > In radiusd.conf file, within the instantiate section the following was > added: > sql
> authorize { > ... > update control { > Cleartext-Password := "%{sql: SELECT password FROM fusion > ...}" > > } do you really mean that you added the above into the instatiate section? dont. you instantiate SQL - but you have things configured in your sql module and are calling it elsewhere..which is why you get this: > rlm_sql (sql): Reserving sql socket id: 4 > [sql] expand: SELECT id, username, attribute, value, op > FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER > BY id -> SELECT id, username, attribute, value, op FROM radcheck > WHERE username = '' ORDER BY id > rlm_sql_mysql: MYSQL check_error: 1146 received > rlm_sql_getvpdata: database query error > [sql] SQL query error; rejecting user you've still got 'sql' being called..and still have default calls looking for that statement and using radcheck table alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html