Sarg Not working There is a failure

firefox

I had a problem with sarg

I adjusted the sarg so I will receive report every hour
It did not work

http://forum.pfsense.org/index.php/topic,66031.0.html

I tried to delete the reports manually
According to what is listed in this post

http://forum.pfsense.org/index.php?topic=57219.0

Now I have another problem
This is what appears in the page of the reports

The second picture is what appears on the page of a real-time

I tried to uninstall and reinstall twice
It comes to the same result

How can I fix it

sarg1.png_thumb

sarg2.png_thumb

firefox

Please help

No one knows how to fix it ?

marcelloc

Run sarg on console until I find a way to work around Lcc_all error.

firefox

First of all thanks

Secondly

@marcelloc:

Run sarg on console

How do I do that ?

I do not know if this helps

SARG folder is empty /usr/local/sarg-reports
No files or sub-folders

maverick_slo

Hi!

You can do it like this:

/usr/local/bin/php /usr/local/www/sarg.php 0

firefox

Where do I write this

marcelloc

@firefox:

Where do I write this

via console/ssh

firefox

Here is what I received

Content-type: text/html

and sarg Still not working

marcelloc

run only sarg -x on console and see what you get.

firefox

Here is what I received

SARG: Init
SARG: Loading configuration from /usr/pbi/sarg-i386/etc/sarg/sarg.conf
SARG: (info) No graphs available as sarg was not compiled with libgd. Set "graphs" to "no" in /usr/pbi/sarg-i386/etc/sarg/sarg.conf to disable this warning
SARG: Chaining IP resolving module "dns"
SARG: Loading exclude host file from: /usr/pbi/sarg-i386/etc/sarg/exclude_hosts.conf
SARG: Loading exclude file from: /usr/pbi/sarg-i386/etc/sarg/exclude_users.conf
SARG: Reading host alias file "/usr/pbi/sarg-i386/etc/sarg/hostalias"
SARG: List of host names to alias:
SARG: Deleting temporary directory "/tmp/sarg"
SARG: Parameters:
SARG:           Hostname or IP address (-a) = 
SARG:                    Useragent log (-b) = 
SARG:                     Exclude file (-c) = /usr/pbi/sarg-i386/etc/sarg/exclude_hosts.conf
SARG:                  Date from-until (-d) = 
SARG:    Email address to send reports (-e) = 
SARG:                      Config file (-f) = /usr/pbi/sarg-i386/etc/sarg/sarg.conf
SARG:                      Date format (-g) = Europe (dd/mm/yyyy)
SARG:                        IP report (-i) = No
SARG:             Keep temporary files (-k) = No
SARG:                        Input log (-l) = /var/squid/logs/access.log
SARG:               Resolve IP Address (-n) = Yes
SARG:                       Output dir (-o) = /usr/local/sarg-reports/
SARG: Use Ip Address instead of userid (-p) = Yes
SARG:                    Accessed site (-s) = 
SARG:                             Time (-t) = 
SARG:                             User (-u) = 
SARG:                    Temporary dir (-w) = /tmp/sarg
SARG:                   Debug messages (-x) = Yes
SARG:                 Process messages (-z) = No
SARG:  Previous reports to keep (--lastlog) = 24
SARG: 
SARG: sarg version: 2.3.6 Arp-21-2013
SARG: Loading User table: ldap
SARG: Cannot bind to LDAP server: Can't contact LDAP server

marcelloc

ccesario fixed it few minutes ago, reinstall the package and try again.

marcelloc

[quote]
SARG: sarg version: 2.3.6 Arp-21-2013
SARG: Loading User table: ldap
SARG: Cannot bind to LDAP server: Can't contact LDAP server
[/quote]

You have problems with ldap settings on sarg config too.

firefox

I removed and re-installed
And still no change

marcelloc

The LC_ALL error or ldap error?

firefox

Do not know
I did not know there were two failures

After reinstalling
I still see the two screens in the image above

What has changed
I went Scheduling tab
And pressed the forced Update Now
It took a minute until it returned to the previous screen
As if he collects the reports or something

marcelloc

run sarg -x on console to check if it is still complaining about LDAP options.

firefox

I think it's the same

SARG: Init
SARG: Loading configuration from /usr/pbi/sarg-i386/etc/sarg/sarg.conf
SARG: (info) No graphs available as sarg was not compiled with libgd. Set "graphs" to "no" in /usr/pbi/sarg-i386/etc/sarg/sarg.conf to disable this warning
SARG: Chaining IP resolving module "dns"
SARG: Loading exclude host file from: /usr/pbi/sarg-i386/etc/sarg/exclude_hosts.conf
SARG: Loading exclude file from: /usr/pbi/sarg-i386/etc/sarg/exclude_users.conf
SARG: Reading host alias file "/usr/pbi/sarg-i386/etc/sarg/hostalias"
SARG: List of host names to alias:
SARG: Deleting temporary directory "/tmp/sarg"
SARG: Parameters:
SARG:           Hostname or IP address (-a) = 
SARG:                    Useragent log (-b) = 
SARG:                     Exclude file (-c) = /usr/pbi/sarg-i386/etc/sarg/exclude_hosts.conf
SARG:                  Date from-until (-d) = 
SARG:    Email address to send reports (-e) = 
SARG:                      Config file (-f) = /usr/pbi/sarg-i386/etc/sarg/sarg.conf
SARG:                      Date format (-g) = Europe (dd/mm/yyyy)
SARG:                        IP report (-i) = No
SARG:             Keep temporary files (-k) = No
SARG:                        Input log (-l) = /var/squid/logs/access.log
SARG:               Resolve IP Address (-n) = Yes
SARG:                       Output dir (-o) = /usr/local/sarg-reports/
SARG: Use Ip Address instead of userid (-p) = Yes
SARG:                    Accessed site (-s) = 
SARG:                             Time (-t) = 
SARG:                             User (-u) = 
SARG:                    Temporary dir (-w) = /tmp/sarg
SARG:                   Debug messages (-x) = Yes
SARG:                 Process messages (-z) = No
SARG:  Previous reports to keep (--lastlog) = 24
SARG: 
SARG: sarg version: 2.3.6 Arp-21-2013
SARG: Loading User table: ldap
SARG: Cannot bind to LDAP server: Can't contact LDAP server

marcelloc

[quote]
SARG: Loading User table: ldap
SARG: Cannot bind to LDAP server: Can't contact LDAP server
[/quote]

Still problems with  your ldap config on sarg gui...

firefox

Is it possible to fix it
Or should reinstalled

marcelloc

@firefox:

Is it possible to fix it

What ldap settings did you configured? it's not a package issue, it's a sysadmin config issue.