Ips dont get assigned using sqlippool

[Ivan Kalik]

> Thu Jul  9 14:44:08 2009 : Debug: rlm_sql_mysql: MYSQL check_error: 1064
> received
> Thu Jul  9 14:44:08 2009 : Error: sqlippool_command: database query error
> in: 'UPDATE radippool   SET nasipaddress = '', pool_key = 0,
> callingstationid = '', username = '',   expiry_time IS NULL   WHERE
> expiry_time <= NOW() - INTERVAL 1 SECOND;'
>

Error 1064 is syntax error.

> Im a bit stuck here since I don't understand why this error occurs.
>
> I have thre IPs configured in my radipppool table:
>
> pool_name        framedipaddress
> pool                  192.168.35.178
> pool                  192.168.35.179
> pool                  192.168.35.180

Is that the table or are there more fields to it? Did you make the table
using ippool.sql?

Ivan Kalik
Kalik Informatika ISP