Hello guys Talking about report generator anyone got using Username too see the report i mean the user can enter his username and password and see his usage? thanks On 8/24/06, Guy Fraser <guy@incentre.net> wrote:

Me too.

I have also built a report generator, into the management system I built.

I can provide snippets, but not the whole source until I get authorization.

Here is a little snippet that allows the PHP output to be automatically opened in a spreadsheet :

---begin--- // $output contains tab ["\t"] delimited fields // and linefeed ["\n"] delimited records $size_in_bytes = strlen($output);

if(strstr($_SERVER['HTTP_USER_AGENT'],'Safari') != false){ // User Agent is Safari = Broken // Document must be opend and saved with a text editor // before excel can open it header("Content-type: application/vnd.ms-excel"); header("Content-disposition: attachment; filename=report-" . $_SESSION['report'] . "-" . $syear . $smonth . "_" . $eyear . $emonth . "-" . $gmatch . "_" . $umatch . "-" . date("Y-m-d") . ".txt; size= $size_in_bytes"); } else { header("Content-type: application/vnd.ms-excel"); header("Content-disposition: attachment; filename=report-" . $_SESSION['report'] . "-" . $syear . $smonth . "_" . $eyear . $emonth . "-" . $gmatch . "_" . $umatch . "-" . date("Y-m-d") . ".tab; size= $size_in_bytes"); }

echo $output ; ---End---

Note: When this works, the web page does not change since the data is output as the attachment.

On Thu, 2006-08-24 at 11:04 -0600, Scott Miller wrote:

...

I've also created a report generator - but mine does not require you to input the IP address. It just authenticates the user, asks for the month they want to display, and if they want a summary report or a detailed report. It is actually an old ICRadius script (written in PHP) that I found and modified to fit my needs. I'm willing to share this one as well if anyone is interested.

Scott

-----Original Message----- From: freeradius-users-bounces+srmiller= interbel.net@lists.freeradius.org [mailto: freeradius-users-bounces+srmiller=interbel.net@lists.freeradius.org] On Behalf Of Sean Sent: Wednesday, August 23, 2006 1:58 PM To: freeradius-users@lists.freeradius.org Subject: Report Generator

Hi,

Ive written a report generator in PHP and HTML that will allow your clients to generate usage reports from the FreeRadius log files. When the user logs in he/she is asked for their IP address and the Month that they want to display. If anyone wants a copy let me know. If there is enough interest I'll make it available for public download.

Regards,

Sean Bracken

http://swarmhotspots.com - 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

yes im using mysql backend and dialu[_admin on ppp server. regards On 8/25/06, Guy Fraser <guy@incentre.net> wrote:

That used to work in dialup_admin, I have not worked with it in a long time. The last time I attempted to test dialup_admin, it seemed more difficult to get working than it had been in the past when I was helping with it. I did not spend much time trying to figure out what was causing the problem. I was on a dead line, and I knew it would need extensive modifications to do what we needed, so I built something totally different from scratch.

Authenticating users is not terribly difficult using PHP.

Are your users accounts stored in a DB or somewhere else ?

I can possibly provide a snippet of code you can use to authenticate your users, then you just need to build an HTML table from one or more SQL queries.

There are public domain resources that can do most or all of those tasks with PEAR modules.

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