modify sql table structure for additional logging
Is it possible to modify the existing radacct table with some extra fields for logging. 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. Alternatively as stated above if I could add additional fields then I would also like to log the Ascend-Xmit-Rate & Ascend-data-rate into my database as well as the Ascend-Session-Server-Key. But I don't want to stuff up function ability with Dialup Admin. Thoughts and suggestions please
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
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@lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au@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
On Wed 20 Dec 2006 05:05, Cory Robson wrote:
Is it possible to modify the existing radacct table with some extra fields for logging.
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 have added X-Ascend-Session-Svr-Key to the radacct table (for Postgresql) to allow Packet of Disconnects and committed to cvs. I have been using this in production for ages along with a perl script to kill online users with Packet Of Disconnect. I will try to get around to cleaning up the perl code and committing it also in the near future.
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.
Nope. Bad idea.
Alternatively as stated above if I could add additional fields then I would also like to log the Ascend-Xmit-Rate & Ascend-data-rate into my database as well as the Ascend-Session-Server-Key. But I don't want to stuff up function ability with Dialup Admin.
Feel free to add this yourself. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
Would be interested in a copy of that perl script to see if I could utilise it. Thanks -----Original Message----- From: freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org] On Behalf Of Peter Nixon Sent: Saturday, 6 January 2007 12:30 AM To: FreeRadius users mailing list Subject: Re: modify sql table structure for additional logging On Wed 20 Dec 2006 05:05, Cory Robson wrote:
Is it possible to modify the existing radacct table with some extra fields for logging.
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 have added X-Ascend-Session-Svr-Key to the radacct table (for Postgresql) to allow Packet of Disconnects and committed to cvs. I have been using this in production for ages along with a perl script to kill online users with Packet Of Disconnect. I will try to get around to cleaning up the perl code and committing it also in the near future.
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.
Nope. Bad idea.
Alternatively as stated above if I could add additional fields then I would also like to log the Ascend-Xmit-Rate & Ascend-data-rate into my database as well as the Ascend-Session-Server-Key. But I don't want to stuff up function ability with Dialup Admin.
Feel free to add this yourself. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
participants (3)
-
Alan DeKok -
Cory Robson -
Peter Nixon