sqlippool.conf in mysql format

MSamir my007ms at yahoo.com
Sun Mar 11 18:18:21 CET 2007


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070311/08452953/attachment.html>


More information about the Freeradius-Users mailing list