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
