• Registered: 2009-02-10
  • Posts: 1

Topic: Online Data(Radius Server)

Hi all,

I'm busy working with a Radius Server and want to get the data while the person is online but the problem is that I can only get the data while the person logs off.

The Data is stored in the Radacct Table and the two columns are AcctInputOctets and AcctOutputOctets.

Is it still possible to get the data of the uploaded and downloaded data while the person is online.

Regards,

Stephen Alistoun

  • Registered: 2008-02-04
  • Posts: 15

Re: Online Data(Radius Server)

YES of course! try to execute this command on your mysql

SELECT SUM(AcctInputOctets) AS total_upload, SUM(AcctOutputOctets) AS total_download FROM radacct WHERE UserName='$username'

to the total of your download upload while online....

Good luck!

  • From: Thailand
  • Registered: 2008-06-19
  • Posts: 159

Re: Online Data(Radius Server)

try to use attribute Acct-Interim-Interval and add Value in second begin from 60

easyzonecorp's Website