Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: Bud on October 18, 2010, 09:39:11 AM

Title: Internet Usage Report
Post by: Bud on October 18, 2010, 09:39:11 AM

SME Team

Could you indicate what contrib will be the best to use that will give me a usage report of what computers have downloaded, where from and the amount of downloads from those computers.

I have looked at "NTOP" and "CACTI" but I'm not sure which one to use. All I need to show is a Report of what is happening or has happend on the Network ie: What PC's are Downloading what and the Total Size of Downloads.

Any help greatly appreciated.

Title: Re: Internet Usage Report
Post by: Frank VB on October 18, 2010, 10:08:10 AM

I'd suggest you give SARG a try: http://wiki.contribs.org/Sarg. With SARG you can generate all kind of reports on the web traffic that passes through the Squid proxyserver.

Title: Re: Internet Usage Report
Post by: Bud on October 18, 2010, 02:29:10 PM

Frank VB

Thanks for the Tip

I have installed the " sarg " contrib and have issued the commands as mentioned

I also have the " dungog dansguardian " contrib installed in order for me to control user web browsing via sme proxy.

My problem is that I can see no data when i choose " Administration > SARG reports > ONE-SHOT " or Daily Reports from the " Squid Analysis Report Generator "

All I get is:

Your seeing this because either no data was found
or you have just updated the sarg rpm.

You can force an update with /etc/cron.daily/sarg

Note: this page may be cached, try refreshing this frame
right click, this frame, refresh

Any Ideas what I'm doing wrong?

Title: Re: Internet Usage Report
Post by: janet on October 18, 2010, 03:04:40 PM

Bud

Did you follow this to set sarg to use dansguardian logs
http://wiki.contribs.org/Sarg#Dansguardian

If you did, have you checked the settings you made for correctness.

Title: Re: Internet Usage Report
Post by: Bud on October 18, 2010, 05:52:57 PM

mary

yes i followed the exact instructions as per http://wiki.contribs.org/Sarg#Dansguardian

still no info

any ideas?

Title: Re: Internet Usage Report
Post by: cactus on October 18, 2010, 06:53:56 PM

Quote from: Bud on October 18, 2010, 02:29:10 PM

You can force an update with /etc/cron.daily/sarg

Did you already run above command on your server?

Title: Re: Internet Usage Report
Post by: Bud on October 20, 2010, 06:13:18 AM

cactus

thanks for the reply

Quote

You can force an update with /etc/cron.daily/sarg

i have run this command and then after waiting for a day when i look at smeserver > sarg reports > one-shot or " daily " this is what i get

Squid Analysis Report Generator
 
Data not found
Your seeing this because either no data was found
or you have just updated the sarg rpm.
You can force an update with /usr/bin/sarg

Note: this page may be cached, try refreshing this frame
right click, this frame, refresh

i'm lost

please HELP as i need to give my manager the outout of what the users on the lan have been doing  :smile:
 

Title: Re: Internet Usage Report
Post by: janet on October 20, 2010, 11:41:49 AM

Bud

Do what the message says !
At the SME command prompt
/usr/bin/sarg

Then check server manager again.
The same concept will apply for the daily, weekly & monthly reports, but the command will be different for each one, as advised in the error message.

Title: Re: Internet Usage Report
Post by: raem on October 20, 2010, 04:24:33 PM

Bud

Wiki updated here
http://wiki.contribs.org/Sarg#Troubleshooting

Title: Re: Internet Usage Report
Post by: Bud on October 22, 2010, 06:33:31 AM

mary and RayMitchell

thanks for your help

i have done as recommended and after two days all i can get info from is by using the " daily " - daily reports option
so the " daily " reports option is working  :smile:

any reason why " ONE-SHOT " does not give me any data?  :shock:

all i get from the " ONE-SHOT " option is

Squid Analysis Report Generator
 
Data not found
Your seeing this because either no data was found
or you have just updated the sarg rpm.
You can force an update with /usr/bin/sarg

Note: this page may be cached, try refreshing this frame
right click, this frame, refresh

any ideas?  :smile:

Title: Re: Internet Usage Report
Post by: janet on October 22, 2010, 07:31:29 AM

Bud

Issue all these commands
/usr/bin/sarg
/etc/cron.daily/sarg
/etc/cron.weekly/sarg
/etc/cron.monthly/sarg

Title: Re: Internet Usage Report
Post by: chris burnat on October 22, 2010, 08:34:47 AM

If it still does not work after all of this, check:

Code: [Select]

[root@gateway0 ~]# config show sarg logfile
It should return:

Code: [Select]

sarg=service
    language=English
    logfile=dansguardian <-----Here
    values=abbreviation
If logfile=squid, you need to change to Dansguardian log files with this command:

Code: [Select]

/usr/bin/sarglog dansguardian
Also ensure that Dans is enabled and creating logs.  You can check this in the Dungog Dansguardian panel.
Go into the Global settings  / Options and click on the link "dansguardian" in the text just under Options.
It will bring you into the view logs files, if it is empty, danguardian is not creating log files.

It looks like this:

Quote

Review dansguardian or squid access in the View log files panel. Or install and use smeserver-sarg
Log Level    = [all text based}
Format of Logfile =  [Dansguardian format]   <<<----Check this also

Sorry to butt in.

Title: Re: Internet Usage Report - SOLVED
Post by: Bud on October 23, 2010, 11:02:30 AM

chris burnat, mary and sme team

thanks for your help

problem solved