Problem with the query. Run that query with mysql client and see what the output shows...and tell us what that entry for user looks like in radcheck table.
Default sql configuration works alan
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html