Problem after upgrade from 2.1 to 2.2
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
Nadir Aliyev wrote:
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.
Those attributes are sent by the NAS.
[sql] expand: UPDATE radacct SET AcctStopTime = ('%S'::timestamp - '%{Acct-Delay-Time:-0}'::interval),
That shoult be %{%{Acct-Delay-Time}:-0} See "man unlang". All of the other expansions need to be changed, too. i.e.: OLD: %{foo:-0} NEW: %{%{foo}:-0} Alan DeKok.
Yes i found problem 20 minutes ago. Seems to be syntax again change to %{%{foo}:-0} last time %{foo:-0} worked with 2.1 Thanks Alan :) On Sun, Jun 9, 2013 at 2:26 AM, Alan DeKok <aland@deployingradius.com>wrote:
Nadir Aliyev wrote:
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.
Those attributes are sent by the NAS.
[sql] expand: UPDATE radacct SET AcctStopTime = ('%S'::timestamp - '%{Acct-Delay-Time:-0}'::interval),
That shoult be %{%{Acct-Delay-Time}:-0}
See "man unlang". All of the other expansions need to be changed, too. i.e.:
OLD: %{foo:-0}
NEW: %{%{foo}:-0}
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Nadir Aliyev