AW: Ips dont get assigned using sqlippool
Kai.Zemke at smartnet.de
Thu Jul 9 21:03:48 CEST 2009
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
> 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
Kalik Informatika ISP
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users