RE: Using MYSQL for accounting only

2002-11-21 Thread Kostas Kalevras
On Thu, 21 Nov 2002, Mike Denka wrote: > > > Thanks to Dave and Kostas for the feedback. Sounds great. So now I'm > wondering how you age the accounting data if it all goes to a mysql db. > You would certainly not want to keep accounting data indefinitely. So > what process do you guys use to t

RE: Using MYSQL for accounting only

2002-11-21 Thread Mike Denka
is supposed to support mysql databases, I see. Thanks, Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Vondracek Sent: Thursday, November 21, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Using MYSQL for accounting only Mike, I haven&

Re: Using MYSQL for accounting only

2002-11-21 Thread Dave Vondracek
Mike, I haven't really looked into this, as I've only run the mysql accounting for a couple months, and we need the data much longer to reconcile with some of our providers. I'm planning on doing it by hand with a simple sql statment based on AcctStartTime or AcctStopTime for the time being. I ha

Re: Using MYSQL for accounting only

2002-11-21 Thread Simon White
21-Nov-02 at 10:09, Mike Denka ([EMAIL PROTECTED]) wrote : > > No problem for me except that I wouldn't see any reason to burn the > resources to run both methods if one was sufficient. Redundancy, especially if you're relying on accounting to actually bill your customers... -- |-Simon White, I

RE: Using MYSQL for accounting only

2002-11-21 Thread Mike Denka
PROTECTED] Subject: Re: Using MYSQL for accounting only On Thu, 21 Nov 2002, Mike Denka wrote: > I'm using LDAP for authentication and authorization across several > radius servers. I'm thinking that using a single mysql server for > accounting from all my radius servers mig

RE: Using MYSQL for accounting only

2002-11-21 Thread Mike Denka
ECTED] 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"

Re: Using MYSQL for accounting only

2002-11-21 Thread Dave Vondracek
Nope, we run both perfectly. I added the mysql config long after detail was running properly and had no problems caused by the additional accounting method. On Thu, 21 Nov 2002 12:09:58 -0500 Daniel Monjar <[EMAIL PROTECTED]> wrote: > > any problem running both accoutning methods (the detail >

RE: Using MYSQL for accounting only

2002-11-21 Thread Brian Johnson
I was doing this with no issues. :) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Daniel Monjar > Sent: Thursday, November 21, 2002 11:10 AM > To: [EMAIL PROTECTED] > Subject: Re: Using MYSQL for accounting only &

Re: Using MYSQL for accounting only

2002-11-21 Thread Daniel Monjar
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 mys

Re: Using MYSQL for accounting only

2002-11-21 Thread Dave Vondracek
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 freeradi

Re: Using MYSQL for accounting only

2002-11-21 Thread Kostas Kalevras
tail files on multiple servers and parsing these > detail files with a script. Before I dive into this, I'd like to get > opinions from others who are using mysql for accounting: > > 1) anyone using mysql for accounting only - using another authentication > and authorization?

Using MYSQL for accounting only

2002-11-21 Thread Mike Denka
les with a script. Before I dive into this, I'd like to get opinions from others who are using mysql for accounting: 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