Accounting and Acct-Delay-Time in MySQL

[Alan DeKok]

Stefan Winter wrote:
> Okay, I'll see what I can do. One thing I noticed is that the default
> schema has a column
> 
> xascendsessionsvrkey varchar(10) default NULL,
> 
> A VSA, of a vendor that's long dead? This is one column that I would
> wipe out. If some people find they need it, they can always modify the
> tables to their (peculiar ;-) ) needs. No reason to push this column
> into every FreeRADIUS installation on the planet.

  Yup.

> Another thing I miss very much is in radpostauth:
> * some gear sends a different User-Name attribute in its reply than was
> in the request. It would be good to have these two names correlated
> easily, at least for forensics. Adding a column "reply-username" would
> do a lot of good here.

  "reply-username" ?  Or "accounting-request" ?

> * callingstationid would also be nice to have
> * and an indication which NAS the user used to log in (and/or which
> virtual server was used to handle the request)
> 
> All of that is info one typically has to dig out of detail files; which
> is much more cumbersome than having it in SQL.
> 
> Any thoughts here?

  It sounds good to me.

  Alan DeKok.