Re: Quick question about accounting.

[Keith Yoder]

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