Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Technical

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th April 2009, 16:11
MisterVlad MisterVlad is offline
Member
 
Join Date: Jun 2007
Location: Windsor, Ontario, CANADA
Posts: 61
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via MSN to MisterVlad Send a message via Skype™ to MisterVlad
Default 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.
Reply With Quote
Sponsored Links
  #2  
Old 29th April 2009, 17:32
MisterVlad MisterVlad is offline
Member
 
Join Date: Jun 2007
Location: Windsor, Ontario, CANADA
Posts: 61
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via MSN to MisterVlad Send a message via Skype™ to MisterVlad
 
Default

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

Bookmarks

Tags
freeradius, mysql, query

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Chillispot / FreeRadius / Mysql / FreeBSD the2ofusHER Smalltalk 3 12th October 2010 15:25
Setting Up A FreeRadius Based AAA Server With MySQL & Management With Daloradius herbie HOWTO-Related Questions 3 15th September 2008 06:37
Freeradius + Mysql +dhcp3 eduardo28 Installation/Configuration 2 6th November 2007 08:26
php mysql freeradius alkhalil Installation/Configuration 1 12th February 2006 16:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 11:54.


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