Topic: Internet Usage Report

[Bud]

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.

[Frank VB]

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.

[Bud]

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?

[janet]

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.

[Bud]

mary

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

still no info

any ideas?

[cactus]

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

Did you already run above command on your server?

[Bud]

cactus

thanks for the reply

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 
 

[janet]

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.

[raem]

Bud

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

[Bud]

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 

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

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? 

[janet]

Bud

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

[chris burnat]

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:

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.

[Bud]

chris burnat, mary and sme team

thanks for your help

problem solved