HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Technical (http://www.howtoforge.com/forums/forumdisplay.php?f=8)
-   -   FreeRadius and MySQL query question (http://www.howtoforge.com/forums/showthread.php?t=34303)

MisterVlad 29th April 2009 15:11

FreeRadius and MySQL query question
 
OK, I am not sure if this is possible, but I am trying to query the FreeRadius MySQL radacct table, to get a general idea of who has been authenticated, and is still logged in, and if possible who has multiple logins with the same username.

I am not sure how to write the query to do that... so far, the radacct table is about 4billion lines and growing...

Can anyone either explain how i can do this, or point me in the right direction?

basically, what I am looking to do, is search the MySQL table, where the sessionid doesn't have a matching sessionid.

Thanks in advance :)

MisterVlad.

MisterVlad 29th April 2009 16:32

Ok, i realized that we're actually missing a SQL query in our radius, so this may actually clear up a lot of things.


All times are GMT +2. The time now is 06:45.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.