FR and Pgsql - null acctstoptime

Humberto Diogenes adm.humberto at digi.com.br
Thu Nov 17 08:32:34 CET 2005


Paul,

  SELECT * FROM radacct WHERE acctstoptime IS NULL;


On Wed, 16 Nov 2005 14:45:21 -0500
Paul Khavkine <paul.khavkine at distributel.ca> wrote:

> (...)
> When a Start record gets written to radacct table, AcctStopTime is not
> being set to anything. The field is empty. Since AcctStopTime is
> of type "timestamp with time zone" it does not seem to equal to NULL or
> '0' or anything at all.
> (...)
> How do you buidl a query to fetch a list of sessions without
> AcctStopTime (sessions in progress for example) ?



-- 
Humberto Diógenes
Diginet Brasil

-- 
Esta mensagem foi verificada pelo sistema de anti-virus e
 acredita-se estar livre de perigo.





More information about the Freeradius-Users mailing list