dhcp_sqlippool: IP address could not be allocated
Hi Guys, No matter what I do I always get this error: Executing select query: SELECT id FROM radippool WHERE pool_name='my_pool' LIMIT 1 (17) dhcp_sqlippool: ERROR: SQL query did not return any results if I do the same query on my database server it always retrieve a line. so I got no ip for my clients. Does anyone can help me? Regards, Elton *_____________________________________* Elton Machado System Administrator phone: +32 (0) 16 36 02 19 mobile: +32 (0) 476 56 08 32 email: elton.machado@tenforce.com Havenkant 38, 3000 Leuven www.tenforce.com *_____________________________________*
On Feb 4, 2016, at 9:55 AM, Elton Machado <elton.machado@tenforce.com> wrote:
No matter what I do I always get this error:
Executing select query: SELECT id FROM radippool WHERE pool_name='my_pool' LIMIT 1 (17) dhcp_sqlippool: ERROR: SQL query did not return any results
if I do the same query on my database server it always retrieve a line.
The RADIUS user probably doesn't have permission to read the database. When the server does a query and doesn't get the results you want... blame the database. Alan DeKok.
participants (2)
-
Alan DeKok -
Elton Machado