Can you use MySQL for accounting only? And if so is there documentation? -Drew
-----Original Message----- From: Keith Yoder [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:40 PM To: [EMAIL PROTECTED] Subject: Re: Quick question about accounting. If you were using mysql for accounting you could use the following query to find the accounting record: SELECT * FROM radius.radacct WHERE FramedIPAddress = "xxx.xxx.xxx.xxx" AND "2003-12-12 06:00:00" BETWEEN AcctStartTime AND AcctStartTime Keith Yoder Drew Weaver wrote: >Right but I need to be able to do this when an abuse report crosses my desk >from a week ago that says Johnny-jackhole decided to spam 9000000 people on >one of my dial-ups and I need to figure out who it was so I can throttle >them. > >-Drew > > >-----Original Message----- >From: Alan DeKok [mailto:[EMAIL PROTECTED] >Sent: Tuesday, December 23, 2003 1:54 PM >To: [EMAIL PROTECTED] >Subject: Re: Quick question about accounting. > >Drew Weaver <[EMAIL PROTECTED]> wrote: > > >> Hi, I'm authenticating from System and accounting to text >> >> >files. > > >>Is there a way (a php script?) for me to find out what user was using an >> >> >IP > > >>address at a specific time? >> >> > > radwho, to see who's logged on, and then grep for the IP. > > Alan DeKok. > >- >List info/subscribe/unsubscribe? See >http://www.freeradius.org/list/users.html > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
