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.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to