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