racct and radpostauth

[andreapepa]

>> My question is about the correlation beetwen the tables in subject, how
can
>> i correlate records without using timestamp but maybe a unique session
>> id?
>
>  Use the unique session ID. 

Ok, but that field is not present in radpostauth too...and i mean
...correlate between tables

>> I think this would be helpful when listing  online users, for example
>> when
>> there is no acctstoptime value in radacct and maybe that user in not
>> online
>> anymore,
>
>  How do you know?

doing the tests with jradius i've noticed that if you send an auth + start
request without a stop you can create this situation, would be the case when
the nas reboot  or power down  in the middle of the auth phase, and so you
have this kind of entry in DB.

>Do you want to link postauth records with accounting records using a shared
unique ID?

Yes  reject auth are not stored but  replies are, if configured to log them,
would be helpful to modify the postauth query to insert the "unique session
ID" in  a new radpostauth field?

I didn't made test in the real till now, and based on my tests i cant see
two records in radacct with the same "unique session ID"  so i cannot link
them.

Finally.. i also can check fro time to time the packets or byte fields to
see if the sessios is still alive...but this metod would not be better than
matching with replies in radpostauth , ...i believe.

--
View this message in context: http://freeradius.1045715.n5.nabble.com/racct-and-radpostauth-tp4782906p4785334.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.