Problem after upgrade from 2.1 to 2.2

Nadir Aliyev nadiritus at gmail.com
Sat Jun 8 23:07:49 CEST 2013


Dear All i have problem after upgrade from 2.1 to 2.2!

I use postgresql module. After upgrade to 2.2 i get sql errors of
accounting updates!

I checked logs and i see that Acct-Input-Gigawords
Acct-Output-Gigawords values are NULL.


[sql] 	expand: UPDATE radacct
SET AcctStopTime = ('%S'::timestamp - '%{Acct-Delay-Time:-0}'::interval),
AcctSessionTime = NULLIF('%{Acct-Session-Time}', '')::bigint,
AcctInputOctets = (('%{Acct-Input-Gigawords:-0}'::bigint << 32) +
'%{Acct-Input-Octets:-0}'::bigint),
AcctOutputOctets = (('%{Acct-Output-Gigawords:-0}'::bigint << 32) +
'%{Acct-Output-Octets:-0}'::bigint),
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = 0,
FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet,
ConnectInfo_stop = '%{Connect-Info}'
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime IS NULL
->
UPDATE radacct
SET AcctStopTime = ('2013-06-09 02:01:40'::timestamp - '73'::interval),
AcctSessionTime = NULLIF('5819', '')::bigint,
AcctInputOctets = ((''::bigint << 32) + '5359232'::bigint),
AcctOutputOctets = ((''::bigint << 32) + '39447747'::bigint),

I cant get values for Acct-Input-Gigawords and Acct-Output-Gigawords
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130609/227d11fc/attachment.html>


More information about the Freeradius-Users mailing list