Koozali.org: home of the SME Server

[Announce] Sarg on sme server 7

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[Announce] Sarg on sme server 7
« on: April 27, 2006, 08:32:18 AM »
Hello everyone,

I've finished my last howto, it concerne the installation of sarg on sme server 7.
You can find it http://www.vanhees.cc/index.php?module=ContentExpress&func=display&ceid=41.

Regards.

Offline ajkeane

  • ****
  • 187
  • +0/-0
    • http://keane.co.nz
[Announce] Sarg on sme server 7
« Reply #1 on: April 27, 2006, 11:34:13 AM »
Thanks for this great to see.

I am however having issues.

When I reboot my server I am getting the following error on screen and am unable to use the local web server.

Syntax Error on line 1690 of /etc/httpd/cpnf/httpd.conf:
Invalid Command'_______',Perhaps mis-spelled or defined by module not included in the server configuration

I can confirm that line 1690 is the start of the entry for sarg and that if I remove the custom template and reconfigure/reboot the server the error disapears.

I have double checked the template fragment and cannot see anything.

Any ideas.

Thanks

Tony
...

Offline ajkeane

  • ****
  • 187
  • +0/-0
    • http://keane.co.nz
[Announce] Sarg on sme server 7
« Reply #2 on: April 27, 2006, 12:02:59 PM »
Managed to sort this.

This is my copy of the 90e-smithAccess20sarg custom template

{
my $externalSSLAccess = '';
my $validFrom = db_get_prop($confref, "httpd-admin", "ValidFrom") || 'none';

$validFrom =~ s/,/ /g;
$validFrom =~ s:/255.255.255.255::g;

unless ($validFrom eq 'none')
{
$externalSSLAccess = $validFrom;
}

$OUT .= <<HERE;

#-----------------------------------------------------------------------------
# SARG generated squid access log reports web repository
#
#-----------------------------------------------------------------------------

Alias /squid /var/www/sarg
<Directory /var/www/sarg>
Options +Includes
AllowOverride None
order deny,allow
deny from all
allow from $localAccess $externalSSLAccess
AuthName "e-smith manager"
AuthType Basic
AuthExternal pwauth
require user admin
</Directory>

#-----------------------------------------------------------------------------
# End of SARG generated squid access log reports web repository
#
#-----------------------------------------------------------------------------
HERE
}

The problem was the # at the start and end of the sarg generated squid access log reports.

Thanks again

Tony
...

Offline byte

  • *
  • 2,183
  • +2/-0
[Announce] Sarg on sme server 7
« Reply #3 on: April 27, 2006, 12:10:58 PM »
I can confirm with you Tony that exactly what I had to do too is add the # to the...

#-----------------------------------------------------------------------------
# SARG generated squid access log reports web repository
#
#-----------------------------------------------------------------------------


Start & end.

Mastersleepy many thanks for this great contrib that I've used for many years!! have a  :pint:  on me
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[Announce] Sarg on sme server 7
« Reply #4 on: April 27, 2006, 01:02:50 PM »
Great thanks.
I've made a too fast copy-paste.

I've correct the howto now.

 :pint: byte
 :pint: ajkeane

Offline briank

  • ***
  • 146
  • +0/-0
[Announce] Sarg on sme server 7
« Reply #5 on: April 27, 2006, 08:23:05 PM »
Just installed and works fine thankyou.
Small details you might like to change in the howto -
when you try and edit /etc/e-smith/web/functions/sarg the file did not initially exist, need to pico /etc/e-smith/web/functions/sarg
At the end

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

to get rid of Unknown in the server-manager.
Many thanks for updating this contrib. Not having it has been one reason I have not gone to sme 7 :)
Regards
Brian Kirk

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[Announce] Sarg on sme server 7
« Reply #6 on: April 28, 2006, 11:08:05 AM »
Howto has been modified.

 :pint: briank

Offline byte

  • *
  • 2,183
  • +2/-0
[Announce] Sarg on sme server 7
« Reply #7 on: April 28, 2006, 11:49:22 AM »
Just re-reading this and this line...

 #
-----------------------------------------------------------------------------
# End of SARG generated squid access log reports web repository
#
-----------------------------------------------------------------------------

needs to be...


#-----------------------------------------------------------------------------
# End of SARG generated squid access log reports web repository
#
#-----------------------------------------------------------------------------

Otherwise httpd will complain about incorrect usage.

Mastersleepy will you be doing this an RPM for this? if not I may look into this, the only thing with that code is it's not done in FormMagick, but still it works and that's great...Thanks again
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[Announce] Sarg on sme server 7
« Reply #8 on: April 28, 2006, 04:24:35 PM »
Now it's corrected.

Effectively, rpm should be a good idea.
I'll take a look at that this week-end.

Thanks for feedback.

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[UPDATED] Sarg Howto and contrib
« Reply #9 on: May 02, 2006, 07:59:21 AM »
Hello all,

Following the byte's idea, thanks to him  :pint: , I build rpm for sarg installation.
Howto have been modified.
http://www.vanhees.cc/index.php?module=ContentExpress&func=display&ceid=41

Regards.

Offline ajkeane

  • ****
  • 187
  • +0/-0
    • http://keane.co.nz
[Announce] Sarg on sme server 7
« Reply #10 on: May 07, 2006, 06:04:49 AM »
I have noticed that every saturday night I get no records for the day and that the weekly stats fail as well stating no records found.

Is anyone else having this issue?

Tony
...

Offline GMa

  • 6
  • +0/-0
[Announce] Sarg on sme server 7
« Reply #11 on: May 07, 2006, 11:40:49 AM »
Quote from: "ajkeane"
I have noticed that every saturday night I get no records for the day and that the weekly stats fail as well stating no records found.

Is anyone else having this issue?

Tony


Hi,

I've installed Sarg a few days ago, and I've just noticed the same problem:
- no Saturday report
- no Weekly report

this email was sent to the admin:
/etc/cron.weekly/sarg:

SARG: No records found
SARG: End

Offline ajkeane

  • ****
  • 187
  • +0/-0
    • http://keane.co.nz
[Announce] Sarg on sme server 7
« Reply #12 on: May 07, 2006, 08:49:25 PM »
I have also installed dansguardian as per the how to here: http://mirror.contribs.org/smeserver/contribs/rmitchell/smeserver/howto/dansguardian%20instal%20&%20configure%20HOWTO%20for%20sme%20server.htm

I have configured the proxy to use port 8080 with the following code:

db configuration setprop squid TransparentPort 8080

signal-event post-upgrade

signal-event reboot

However now all internet usage is listed under localhost. Is there a way to correct this?

Thanks.

Tony
...

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[Announce] Sarg on sme server 7
« Reply #13 on: May 08, 2006, 08:06:53 AM »
Hello all,

for weekly report, i found the solution this week-end, I apply the solution for monthly report but I forget to a apply it to daily  :-x
So I will correct it this evening.
There is a new version
http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=viewsdownload&orderby=dateD
but not the final.

Regards.

Offline ajkeane

  • ****
  • 187
  • +0/-0
    • http://keane.co.nz
[Announce] Sarg on sme server 7
« Reply #14 on: May 08, 2006, 08:55:15 AM »
Thanks for the update.

However when I try o install I get the following error:

rpm -Uvh smeserver-sarg-1.0-2.noarch.rpm
Preparing...                ########################################### [100%]
        file /etc/cron.monthly/sarg from install of smeserver-sarg-1.0-2 conflicts with file from package sarg-1.4.1-5.2.el4.rf
        file /etc/cron.weekly/sarg from install of smeserver-sarg-1.0-2 conflicts with file from package sarg-1.4.1-5.2.el4.rf

Thanks

Tony
...