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...@lists.freeradius.org [freeradius-users-bounces+kai.zemke=smartnet...@lists.freeradius.org] im Auftrag von Ivan Kalik [...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
