On 8 Sep 2011, at 17:48, Alan DeKok wrote: > andreapepa wrote: >> 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. > >> 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? > >> or just to sort out a list of the access request/accept/reject >> report not only by timestamp. > > Rejected authentications are *not* stored in the accounting database. > >> In Dialupadmin the online user page list users only by null acctstoptime, >> but doesn't check( and how would it be possible ) if records belong to a >> rejected request in radpostauth. > > See above. >
Do you want to link postauth records with accounting records using a shared unique ID? As Alan says your NAS won't generate Accounting-Requests if the RADIUS server rejects the user (unless its very broken). -Arran Arran Cudbard-Bell a.cudba...@freeradius.org RADIUS - Half the complexity of Diameter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html