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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
