Maybe you are right...I'm thinking to write a small script witch will look in the database and will sum the records for each user.
NN -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of tywe Sent: Wednesday, July 31, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: Re: mysql accounting ----- Original Message ----- > Hi all, > > I have an accounting record in my mysql database for every session for each > user. > I there a possible way to make radius add this accounting information for > each user in one record? > > NN I can't think of any way to do that. But, all of the SQL statements are customizable in the sql.conf, so I'm sure almost anything is possible. If you do somehow manage to make that work, be prepared for lots of things to not work though, such as Simultaneous-Use, etc. since each session has a unique AcctSessionId that is needed to identify which data goes with which session. I'm sure there are plenty of other bad things that would happen by changing the functionality like that, but it's up to you. What's wrong with having a new record for each session anyhow? Frank - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
