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.cudbardb@freeradius.org RADIUS - Half the complexity of Diameter