2015-08-31 - Re: [GRASE-Hotspot] Squid log

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: b47926d8faf2e914be23153a1d4c4fccbd393195b14edf781e95a1d8f2398088
Message ID: <CAESLx0LzW0hhXVKF1qcEKCAzf9YRfLBw3JdW44t6TCA-fqewKA@mail.gmail.com>
Reply To: <dccccefb-f9a7-4f8c-b944-d84b1328f23e@grasehotspot.org>
UTC Datetime: 2015-08-31 21:40:33 UTC
Raw Date: Tue, 01 Sep 2015 11:40:33 +0700

Raw message 

Hi

I believe we are currently using the native squid log format
(http://wiki.squid-cache.org/Features/LogFormat#Squid_native_access.log_format_in_detail)
which allows us to use tools designed for squid logs to process them.
I.e. you can use something like sarg to process the logs.

I'm not sure where you are getting a MAC address of 00:00:00:00:00:00.
Your Free Login username is based off your MAC address. Have a look at
the users in the Grase Admin section, and you should be able to find
the Free User for each MAC, and the username it's been given, then you
can search with that.

However, maybe the first thing is to explain how the built in tools in
the Web interface for viewing the squid logs, don't suit your needs.
Then we can work on improving them.

Feel free to fork it on Github, fix things, and submit merge requests.

Regards

Tim

On Tue, Aug 25, 2015 at 11:08 PM, sebi.klos <se***s@icloud.com> wrote:
> Hi together,
>
>
> can somebody please update the  /etc/squid3/squid.conf.grase for a normal
> date to read?
>
> This is what everybody need i think.
> Why i only get  MAC Address 00:00:00:00:00?
> By free login is the MAC Address my username but i can't search if everybody
> is 00:00:00:00:00
>
> this is for /etc/squid3/squid.conf.grase for see normal date
>
> logformat  lesbar %{%d.%m.%y %H:%M:%S}tl  %>a %>eui %Ss %ru %<st %<sS
>
>
>
> this is a little shell for get infos about users but it only work at the
> moment with IP-Address and not with MAC-ADDRESS
>
> someone can make this in the grasewebinterface?
>
>
>
>
>
> #!/bin/sh
>
> echo "Please enter the IP Adress of wanted user: like 192.168.137.79 "
>
> read IP
>
> echo "Please enter dataname for export your log : like Max_Mustermann.log or
> csv"
>
> read DATANAME
>
> echo start make folder
>
> mkdir /var/log/squid3/auswertung
>
> echo make folder/var/log/squid3/auswertung! OK
>
> echo start copy logfiles
>
> cp /var/log/squid3/access* /var/log/squid3/auswertung
>
> mv /var/log/squid3/auswertung/access.log
> /var/log/squid3/auswertung/access.log.00
>
> mv /var/log/squid3/auswertung/access.log.1
> /var/log/squid3/auswertung/access.log.01
>
> echo copy logfiles to /var/log/squid3/auswertung! OK
>
> cd /var/log/squid3/auswertung
>
> echo start unzip logfiles
>
> gunzip access*.gz
>
> echo unzip log file! OK
>
> echo start translate date
>
> #cat /var/log/squid3/auswertung/access* | perl -p -e
> 's/^([0-9]*)/"".localtime($1)." "/e' > accesslogs_date.log
>
> #echo translate date! OK
>
> grep  $IP /var/log/squid3/auswertung/accesslogs_date.log > $DATANAME
>
> echo make filtering and export to $DATANAME
>
> rm /var/log/squid3/auswertung/access*
>
> echo you find the access log for $IP in /var/log/squid3/auswertung/$DATANAME
> OK
>
>
>
>
>
>
> Can i do something here in this project?
>
>
>
>
> Best wishes
>
>
>
> Sebi
>
> --
> This mailing list is for the Grase Hotspot Project http://grasehotspot.org
> ---
> You received this message because you are subscribed to the Google Groups
> "Grase Hotspot" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to gr***e@grasehotspot.org.
> To post to this group, send email to gr***t@grasehotspot.org.
> Visit this group at
> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/dccccefb-f9a7-4f8c-b944-d84b1328f23e%40grasehotspot.org.

Thread