AW: Ips dont get assigned using sqlippool

[Zemke, Kai]

I created the table with the statements that come with the freeradius installation (ippool.sql) and I'm using the standard querries from ippool.conf.
I continued to search the mailinglist and discovered an earlyer post where there was described a similiar problem. Concerning to this post i changed the default sql scheme from ippool.sql so that expiry_time now has a default value. I didnt had much time since i had to leave office but my first tests showed that the error did not occur anymore and an Ip address got assigned to my cliennt.

Can i have encounter special problems in the future now that i changed the default sql scheme
________________________________________
Von: freeradius-users-bounces+kai.zemke=smartnet.de at lists.freeradius.org [freeradius-users-bounces+kai.zemke=smartnet.de at lists.freeradius.org] im Auftrag von Ivan Kalik [tnt at kalik.net]
Gesendet: Donnerstag, 9. Juli 2009 20:29
An: FreeRadius users mailing list
Betreff: Re: Ips dont get assigned using sqlippool

> 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

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html