dear all, i try find sqlippool.conf in mysql format it try http://wiki.freeradius.org/Talk:Rlm_sqlippool but it's not work with me this is what i see in debug ============================ Processing the post-auth section of radiusd.conf modcall: entering group post-auth for request 0 Value Of the Pool-Name is [sqlippool] and its [9] Chars rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'BEGIN' rlm_sql_mysql: query: BEGIN radius_xlat: 'UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE pool_key = ''' rlm_sql_mysql: query: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE pool_key = '' rlm_sql_mysql: MYSQL check_error: 1064 received sqlippool_command: database query error radius_xlat: 'SELECT framedipaddress FROM radippool WHERE pool_name = '' AND expiry_time < 'now'::timestamp(0) ORDER BY pool_name, (username <> 'test1'), (callingstationid <> ''), expiry_time LIMIT 1 FOR UPDATE' rlm_sql_mysql: query: SELECT framedipaddress FROM radippool WHERE pool_name = '' AND expiry_time < 'now'::timestamp(0) ORDER BY pool_name, (username <> 'test1'), (callingstationid <> ''), expiry_time LIMIT 1 FOR UPDATE rlm_sql_mysql: MYSQL check_error: 1064 received sqlippool_query1: database query error rlm_sqlippool: ip=[] len=0 radius_xlat: 'COMMIT' rlm_sql_mysql: query: COMMIT rlm_sqlippool: IP number could not be allocated. rlm_sql (sql): Released sql socket id: 2 modcall[post-auth]: module "sqlippool" returns notfound for request 0 =================================================== thanks --------------------------------- Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A.