i have solved the problem....this is my sql-hotspot.conf # Set to 'yes' to read radius clients from the database ('nas' table) readclients = yes ## Table to keep radius client info nas_table = "nas_10" ####################################################################### # NAS Query ####################################################################### # This query retrieves the radius clients # # 0. Row ID (currently unused) # 1. Name (or IP address) # 2. Shortname # 3. Type # 4. Secret ####################################################################### nas_query = "SELECT id, nasip, shortname, secret FROM ${nas_table}" i just do the stupid trial and error....avrakadavra..... mysql> desc nas_10; +-------------+--------------+------+-----+---------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | nasip | varchar(128) | NO | MUL | NULL | | | shortname | varchar(32) | YES | | NULL | | | community | varchar(50) | YES | | NULL | | | description | varchar(200) | YES | | RADIUS Client | | | *secret* | varchar(60) | NO | | secret | | | tgl_pasang | date | NO | | NULL | | +-------------+--------------+------+-----+---------------+----------------+ 7 rows in set (0.00 sec) i place 'secret' on 6th field. and the query works...... but i still confuse .......WHY ??? 2008/9/17 Alan DeKok <aland@deployingradius.com>
fibie roosadhy wrote:
dear all, i use command 'radiusd -X' to debug.i found this : rlm_sql (hotspot): - generate_sql_clients rlm_sql (hotspot): Query: SELECT * FROM nas_10
You edited the default queries, and broke the server.
Don't do that unless you understand the queries, and understand what they're doing.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html