hi,
the problem is with the syntax,
the quotes are missing for the %{Acct-Delay-Time}
just add the quotes like in AcctStopDelay = '%{Acct-Delay-Time}'
WHERE.........
this shld solve the problem
regards,
manjunath
-----Original Message-----
From: Ernesto Freyre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 1:33 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL problem
send the complete query please, here appears as a sintax error, would help
seeing the query....
----- Original Message -----
From: "Szabó György" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 11:01 AM
Subject: MySQL problem
> Hi.
> The radius.log contains the following lines:
>
> Info: rlm_sql (sql): received Acct On/Off packet
> Error: rlm_sql (sql): Couldn't update SQL accounting for Acct On/Off
packet -
> You have an error in your SQL syntax near 'WHERE AcctSessionTime=0 AND
> AcctStopTime=0 AND NASIPAddress= '192.168.1.4' AND A' at line 1
>
> What is the problem ?
> I'm generate the database with db_mysql.sql
>
> --
> technik :-)
> ICQ: 270532579
> AIM: gyuriszabo
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
