Ips dont get assigned using sqlippool
Hi, im currently configuring and testing mysqlipool for freeradius. I followed the instructions from the freeradius wiki nad have my radius server running. Im Running the server with the "-X" Option and whenever a user is connecting I get the following output: Thu Jul 9 14:44:08 2009 : Info: [sqlippool] expand: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time IS NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND; -> UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time IS NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND; 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;' 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 The user with that I'am testing has the following attributes (in table radreply): Service-Type = Framed-User Framed-Protocoll = PPP Fall-Through = Yes And the following in radcheck: Cleatext-Password := testzugang Pool-Name := pool I'm missing something essential I think but I can't see my mistake so far. Anyone who can point me in the correct direction? Mit freundlichen Grüßen Kai Zemke =========================================================== smartnet Online Service GmbH, Schnackenburgallee 177, 22525 Hamburg =========================================================== Geschäftsführer: Christian Suding, Claus Masch Ust.IdNr.:DE191136350 Handelsregister HRB 66463 Steuernummer: FA: Hamburg 54/855/01047 Fon: +49 (0) 40 5540-0 Fax: +49 (0) 40 5540-1040 kai.zemke@smartnet.de<mailto:kai.zemke@smartnet.de> Weitere Informationen siehe: http://www.smartnet.de<http://www.smartnet.de/> =========================================================== Hinweis: Diese Email kann vertrauliche und/oder rechtlich geschützte Informationen enthalten. Wenn Sie nicht der beabsichtigte Empfänger sind oder diese Email irrtümlich erhalten haben, informieren Sie bitte sofort den Absender telefonisch oder per Email und löschen Sie diese Email aus Ihrem System. Das unerlaubte Kopieren, sowie die unbefugte Weitergabe dieser Email ist nicht gestattet.Wir haften nicht für die Unversehrtheit von Emails, nachdem sie unseren Einfluss- Bereich verlassen haben.
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
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
participants (3)
-
Alan DeKok -
Ivan Kalik -
Zemke, Kai