On Thursday 24 October 2002 16:15, Igor Chen wrote:
> On Thu, 10 Oct 2002, Sergey Holod wrote:
> > On Monday 07 October 2002 21:42, Aleksandar Zhelyazkov wrote:
> Replace Nas-Port field name with Nas-Port-id and leave %{NAS-Port}
..
> NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime,
^^^^^^^^^^^^^^^^^^^^^
So "Nas-Port-id" or "NASPortId"?..))
> -1 in AcctSessionTime field indicates opened users session.
Why not to use "AcctStopTime IS NULL"?????????
It is much simply and logical.
Before "acct-stop" packet "AcctStopTime" is unknown, so it is NULL
and we know that session is opened..
> Accounting on/off i've tested on cisco 3620 NAS and
> fr 0.4. I did not see any mistakes.
In accton/off query:
WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress=
'%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
"AcctStopTime=0" - is completely wrong
PostgreSQL (>7.1..) can't convert 0 to "0000-00-00 00-00" or something like,
it simply generates error..
--
With Best Regards,
Sergey Holod
SAH1-RIPE
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
