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@lists.freeradius.org [freeradius-users-bounces+kai.zemke=smartnet.de@lists.freeradius.org] im Auftrag von Ivan Kalik [tnt@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