Re: Getting required information from freeradius accounting log
This is a discussion on Re: Getting required information from freeradius accounting log within the FreeRADIUS Users forums, part of the Networking and Network Related category; --===============1179449663== Content-Type: multipart/alternative; boundary="0-1057085556-1175853418=:75345" Content-Transfer-Encoding: 8bit --0-1057085556-1175853418=:75345 ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-06-2007
|
|||
|
|||
Re: Getting required information from freeradius accounting log
--===============1179449663==
Content-Type: multipart/alternative; boundary="0-1057085556-1175853418=:75345" Content-Transfer-Encoding: 8bit --0-1057085556-1175853418=:75345 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit in radius source some useful script which is genrate some report for users so u can modify thoes script and use it "Diot, Sylvain" <sylvain.diot@abdn.ac.uk> wrote: st1\:*{behavior:url(#default#ieooui) } Hi all, Is there any kind of tool like a log viewer that would allow me to “extract” the information I want from the /var/log/radius/acct-radius.log? I’d like to be able to obtain a report that would look like this: +-----------------------------------------+ | Session Start Date/Time | +-----------------------------------------+ | Session Stop Date/Time | +-----------------------------------------+ | Session Duration | +-----------------------------------------+ | Client Username | +-----------------------------------------+ | Client MAC Address (Calling ID Station) | +-----------------------------------------+ | User IP Address | +-----------------------------------------+ | NP Policy Name | +-----------------------------------------+ | Tunnel Private Group ID | +-----------------------------------------+ I have to mention I don’t have any experience in scripting. Cheers, Sylvain Sylvain Diot Network Support Officer Infrastructure Services Directorate of Information Technology University of Aberdeen sylvain.diot@abdn.ac.uk Tel: 01224 272083 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com --------------------------------- Here’s a new way to find what you're looking for - Yahoo! Answers --0-1057085556-1175853418=:75345 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit in radius source some useful script which is genrate some report for users so u can modify thoes script and use it <br><br><b><i>"Diot, Sylvain" <sylvain.diot@abdn.ac.uk></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 11 (filtered medium)"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceName"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"> <!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </o:SmartTagType></o:SmartTagType></o:SmartTagType><div class="Section1"> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">Hi all,<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">Is there any kind of tool like a log viewer that would allow me to “extract” the information I want from the /var/log/radius/acct-radius.log?<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">I’d like to be able to obtain a report that would look like this:<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Session Start Date/Time &nbs p;   ; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Session Stop Date/Time &nbs p; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Session Duration &n bsp; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Client Username &n bsp; &nbs p; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Client MAC Address (Calling ID Station) |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| User IP Address & nbsp; &nb sp;   ; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| NP Policy Name &nbs p; &n bsp; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">| Tunnel Private Group ID   ; |<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">+-----------------------------------------+<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">I have to mention I don’t have any experience in scripting.<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">Cheers,<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">Sylvain<o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";">Sylvain Diot<br> Network Support Officer<br> Infrastructure Services<br> Directorate of Information Technology<br> <st1:place w:st="on"><st1:PlaceType w:st="on">University</st1:PlaceType> of <st1:PlaceName w:st="on">Aberdeen</st1:PlaceName></st1:place><br> <a href="mailto:sylvain.diot@abdn.ac.uk">sylvain.diot @abdn.ac.uk</a><br> Tel: 01224 272083</span></font><font face="Courier New" size="2"><span style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></font></div> <div class="MsoNormal"><font face="Courier New" size="3"><span style="font-size: 12pt; font-family: "Courier New";"><o:p> </o:p></span></font></div> </div> - <br>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html</blockquote><br><BR><BR>$ cat ~/satish/url.txt<br><br>System administrator ( Data Center )<br><br>please visit this site<br><br>http://linux.tulipit.com <p> <hr size=1></hr> Here’s a new way to find what you're looking for - <a href="http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/">Yahoo! Answers</a> --0-1057085556-1175853418=:75345-- --===============1179449663== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --===============1179449663==-- 
|
Linear Mode
