modify sql table structure for additional logging

[Cory Robson]

I have modified the schema for postauth without problems but its one of
those seldom used tables. My main concern was with diakupadmin, in some php
coding depending on the method used its not always advisable to modify the
schema after the event. It stuffs up the sql queries.


-----Original Message-----
From: freeradius-users-bounces+cory=cmi.net.au at lists.freeradius.org
[mailto:freeradius-users-bounces+cory=cmi.net.au at lists.freeradius.org] On
Behalf Of Alan DeKok
Sent: Wednesday, 20 December 2006 1:37 PM
To: FreeRadius users mailing list
Subject: Re: modify sql table structure for additional logging

Cory Robson wrote:
> 
> Is it possible to modify the existing radacct table with some extra fields
> for logging.

  Yes.  You can add anything you want to the SQL schema, and then edit
the queries/inserts to write the appropriate data.

> My upstream also sends Attr-151 X-Ascend-Session-Svr-Key which I would
also
> like logged (its used for terminating a user if need be). I could use it
in
> the unique session server key field instead of the calculated one but
would
> need a step by step on how to go about that.

  See raddb/radiusd.conf, look for "acct_unique" & read the docs.

  Alan DeKok.
--
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

__________ NOD32 1929 (20061219) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com