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

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.

firefox

@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.

what is ldap settings
and what is sysadmin config

firefox

Scheduling

marcelloc

sysadmin means system administrator, in this case, you.

check user tab if you have configured ldap settings.

Also, uncheck graphs on first tab, the compilation of this feature on 2.1 is still pending.

firefox

Same result

marcelloc

Did you read all the post and checked user tab to see if you have configured ldap settings?

Latest update by ccesario fixed sarg packages on 2.1. Check your config again please.

firefox

I removed the check from the graphs
and from ldap

firefox

Well
I installed the whole system again
Because there were some problems I could not fix

About sarg
I reinstalled and it works well
I have a question about the configuration

I want to see a list of the 48 reports

Every hour a new report
Means a list of 48 reports
When it comes Report No. 49
Then the first report is deleted

There will always be 48 Reports

Example {should see from the bottom}

11Oct2013-11Oct2013 Fri Oct 11 06:00:03 2013 When this report iis generated
11Oct2013-11Oct2013 Fri Oct 11 05:00:03 2013
11Oct2013-11Oct2013 Fri Oct 11 04:00:03 2013
11Oct2013-11Oct2013 Fri Oct 11 03:00:03 2013
11Oct2013-11Oct2013 Fri Oct 11 02:00:03 2013
11Oct2013-11Oct2013 Fri Oct 11 01:00:03 2013
11Oct2013-11Oct2013 Fri Oct 11 00:00:03 2013
10Oct2013-10Oct2013 Thu Oct 10 23:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 22:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 21:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 20:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 19:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 18:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 17:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 16:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 15:00:20 2013
10Oct2013-10Oct2013 Thu Oct 10 14:00:20 2013 The last report in list is deleted

The last report in list is deleted ?

marcelloc

Why don't you check overwrite report option and have on report per day updated every hour?

firefox

how do i do that ?

firefox

Sarg Schedules

firefox

It's a whole new setup
I just need to know what parameters I need write
For this to work

I looked at the schedule

I did not see an example