No problem for me except that I wouldn't see any reason to burn the resources to run both methods if one was sufficient.
Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Daniel Monjar Sent: Thursday, November 21, 2002 9:10 AM To: [EMAIL PROTECTED] Subject: Re: Using MYSQL for accounting only any problem running both accoutning methods (the detail file and the mysqldb)? --On Thursday, November 21, 2002 11:51 AM -0500 Dave Vondracek <[EMAIL PROTECTED]> wrote: > On Thu, 21 Nov 2002 08:41:08 -0800 > "Mike Denka" <[EMAIL PROTECTED]> wrote: >> >> 1) anyone using mysql for accounting only - using another >> authentication >> and authorization? If so is the setup as simple as using >> the sql schema >> included with freeradius and just including "sql" in the >> accounting >> section of the radiusd.conf file? > > Yes, we run mysql for accounting only. The setup was > incredibly simple as well as customization. That's about > all you will need for the default installation. Specific > server information is in sql.conf. > >> >> 2) are there significant gains to be made in terms of >> access to data and >> report generation using mysql over perl scripts or other >> programs >> written to parse the detail file and generate flat files >> with relevant >> information? My guess is that with a mysql database of >> accounting data, >> I should be able to access just about any kind of >> information I wanted >> from a properly formed sql query (like ip address usage >> data, >> time-on-line information for customers and just about any >> other kind of >> trending data I could imagine). Am I correct in that >> assumption or are >> there significant hurdles to using a mysql >> accounting-only system that I >> should be aware of? >> > > Yes. As long as you store the data, it's much easier to > access. It is also easy to add to the schema and log > additional data requiring changes only to sql.conf and the > table structure. (mailing list archive and > docs/variables.txt will prove valuable here) > >> 3) If the idea of using mysql as an accounting system >> makes sense, are >> there existing tools that anyone knows of that are >> already written to >> generate various reports on radius accounting data? >> > > Sorry, haven't investigated. > >> Thanks, >> >> Mike >> >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html -- Daniel Monjar IS Manager, Technical Services bioM�rieux, Inc. Durham, NC US - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
