Re: Quick question about accounting.

[Guy Fraser]

Yes.

You can also still use detail file accounting at the same time as well.
Configure sql.conf for your MySQL setup, and create the radacct table
then add sql to the accounting section of your radius.conf. You should
then get the accounting in MySQL and in detail files.
I have setup PostgreSQL + detail files, and it works fine. If you don't put
sql in the authorize section then the MySQL will not be used to 
authenticate.

If I left something out could someone else fill in what I missed.

I will see if the program I wrote to parse a detail file and send it to 
a PostgreSQL
database, or cvs file is still around. It may be possible to do what you 
want without
using SQL. Using SQL will save you a lot of time, and gives you the 
ability to
have online time checking and makes generation of reports simple.

By the way the SQL statement below has a simple mistake, the second
AcctStartTime should be AcctStopTime.
Drew Weaver wrote:

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

 

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html