Configure sarg or lightsquid

squidadmin

Hi together,

i need help to configure sarg or lightsquid. (I'm not very familiar with pfsense)
I have configure a working squid environment with ldap access. (I can access with ldap login and the realtime log works too)
I tested both report tools:

lightsquid:
If i open lightsquid report, i dont see any usernames, only IP-Adresses.

sarg:
Realtime report works well.
If i go to "view report" it shows me:

Error: Could not find report index file.
Check and save sarg settings and try to force sarg schedule.

I read from some cases in these community but i dont understand the problems.

reagrds

KOM

If i open lightsquid report, i dont see any usernames, only IP-Adresses.

So change your IP Resolve Method to something useful, like DNS or Demo.

Error: Could not find report index file.

Is there any actual data to report on? Did you click the Refresh Full and Refresh Now buttons? Some recent fixes were made to Lightsquid but perhaps you still need the manual symlink fix. Connect via SSH (or go to Diagnostics - Command Prompt) and then run these commands:

rm -r /usr/local/sarg-reports
ln -s /usr/pbi/sarg-amd64/local/sarg-reports /usr/local/sarg-reports

Then try to force a refresh and check the report again.

squidadmin

thx for reply,

So change your IP Resolve Method to something useful, like DNS or Demo.
Did you click the Refresh Full and Refresh Now buttons?

Yes of course i tested all options and press the refresh button. Currently i configuredthe option "DNS".

Is there any actual data to report on?

Yes, i hope so, beacause realtime report works. And i see IP-Adresses and Websites on the report site from lightsquid.

Connect via SSH (or go to Diagnostics - Command Prompt) and then run these commands:

I run the commands succesly but i dont see any changes. Are the commands for lightsquid or sarg?

KOM

Are the commands for lightsquid or sarg?

Sorry, I'm an idiot. I grabbed the wrong section from my pfSense cheat sheet. Try this for Lightsquid:

ln -s /usr/pbi/lightsquid-amd64/local/www/lightsquid /usr/local/www/lightsquid
ln -s /usr/pbi/lightsquid-amd64/local/etc/lightsquid /usr/local/etc/lightsquid
pkg install perl5
pkg install p5-gd
/usr/bin/perl /usr/pbi/lightsquid-amd64/www/lightsquid/lightparser.pl today

This works for getting Lightsquid working with 2.1.5. I haven't played much with 2.2 packages for a few weeks now so I have no idea if this works with the latest stuff.