On Thu, 19 Jun 2003 at 08:24 (-0400), Jeff Sullivan wrote:
JS> Accounting is going to Postgres. Rebooted a hyper and radius was
JS> showing
JS>
JS> Thu Jun 19 04:48:09 2003 : Error: rlm_sql (sql): Couldn't update SQL
JS> accounting for Acct On/Off packet - ERROR: parser: parse error at or
JS> near "'2003-06-19 04:48:09'" at character 102
The accounting_onoff_query in postgresql.conf prior to is wrong and
won't work. You can update to the latest CVS version which has a fix
or just replace that query with the following:
accounting_onoff_query = "UPDATE ${acct_table1} SET AcctStopTime='%S', A
cctSessionTime=date_part('epoch'::text, ('%S'::timestamp without time zone - Acc
tStartTime::timestamp without time zone)), AcctTerminateCause='%{Acct-Terminate-
Cause}', AcctStopDelay = %{Acct-Delay-Time:-0} WHERE AcctSessionTime=0 AND AcctS
topTime IS NULL AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
Michael
----------------------------------------------------------------------
Michael J. Hartwick, VE3SLQ [EMAIL PROTECTED]
Hartwick Communications Consulting (519) 396-7719
Kincardine, ON, CA http://www.hartwick.com
----------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
