Re: [squid-users] Collecting squid logs to DB

2018-05-15 Thread Eliezer Croitoru
Email: elie...@ngtech.co.il From: Alex K Sent: Sunday, May 13, 2018 14:23 To: Eliezer Croitoru Cc: squid-users@lists.squid-cache.org Subject: Re: [squid-users] Collecting squid logs to DB Thanx Eliezer and Amos for the feedback. I just saw the logformat directive and will experiment wit

Re: [squid-users] Collecting squid logs to DB

2018-05-13 Thread Amos Jeffries
On 13/05/18 23:22, Alex K wrote: > Thanx Eliezer and Amos for the feedback. I just saw the logformat > directive and will experiment with that. > Yes, I have a small group of users (up to 30 - 40 devices) but the > hardware is a relatively small appliance (4G RAM, 4 cores 2GHz, SSD). > That shoul

Re: [squid-users] Collecting squid logs to DB

2018-05-13 Thread Alex K
oitoru > Linux System Administrator > Mobile: +972-5-28704261 > Email: elie...@ngtech.co.il > > > > *From:* Alex K > *Sent:* Sunday, May 13, 2018 01:56 > *To:* Eliezer Croitoru > *Cc:* squid-users@lists.squid-cache.org > *Subject:* Re: [squid-users] Collecting squid logs to DB

Re: [squid-users] Collecting squid logs to DB

2018-05-13 Thread Eliezer Croitoru
.co.il From: Alex K Sent: Sunday, May 13, 2018 01:56 To: Eliezer Croitoru Cc: squid-users@lists.squid-cache.org Subject: Re: [squid-users] Collecting squid logs to DB +++ Including list +++ Hi Eliezer, I have used the following lines to instruct squid to log at mariadb: logfile_daemon /u

Re: [squid-users] Collecting squid logs to DB

2018-05-13 Thread Amos Jeffries
On 13/05/18 10:55, Alex K wrote: > > Is there a way I format the log and pipe to DB only some interesting > fields in order to lessen the stress to DB? > You can use the logformat directive to define a format of your choice and log that instead of the default Squid format.

Re: [squid-users] Collecting squid logs to DB

2018-05-12 Thread Eliezer Croitoru
ct: Re: [squid-users] Collecting squid logs to DB +++ Including list +++ Hi Eliezer, I have used the following lines to instruct squid to log at mariadb: logfile_daemon /usr/lib/squid/log_db_daemon access_log daemon:/127.0.0.1/squid_log/access_log/squid/squid <http://127.0.0.1/squid_log/a

Re: [squid-users] Collecting squid logs to DB

2018-05-12 Thread Eliezer Croitoru
squid-users@lists.squid-cache.org Subject: Re: [squid-users] Collecting squid logs to DB +++ Including list +++ Hi Eliezer, I have used the following lines to instruct squid to log at mariadb: logfile_daemon /usr/lib/squid/log_db_daemon access_log daemon:/127.0.0.1/squid_log/access_log

Re: [squid-users] Collecting squid logs to DB

2018-05-12 Thread Alex K
itoru > Linux System Administrator > Mobile: +972-5-28704261 > Email: elie...@ngtech.co.il > > > > *From:* squid-users *On > Behalf Of *Alex K > *Sent:* Saturday, May 5, 2018 01:20 > *To:* squid-users@lists.squid-cache.org > *Subject:* [squid-users] Collecting squid

Re: [squid-users] Collecting squid logs to DB

2018-05-12 Thread Eliezer Croitoru
Linux System Administrator Mobile: +972-5-28704261 Email: elie...@ngtech.co.il From: squid-users On Behalf Of Alex K Sent: Saturday, May 5, 2018 01:20 To: squid-users@lists.squid-cache.org Subject: [squid-users] Collecting squid logs to DB Hi all, I had a previous setup on Debian 7 with

Re: [squid-users] Collecting squid logs to DB

2018-05-06 Thread Michael Pelletier
Check out Logstash *https://www.elastic.co/products/logstash * On Sat, May 5, 2018 at 2:25 AM, Amos Jeffries wrote: > On 05/05/18 17:19, Amos Jeffries wrote: > > On 05/05/18 10:20, Alex K wrote: > >> Hi all, > >> > >> I had a previous setup on Debian 7

Re: [squid-users] Collecting squid logs to DB

2018-05-04 Thread Amos Jeffries
On 05/05/18 17:19, Amos Jeffries wrote: > On 05/05/18 10:20, Alex K wrote: >> Hi all, >> >> I had a previous setup on Debian 7 with squid and I was using mysar to >> collect squid logs and store them to DB and provide some browsing report >> at the end of the day. >> Now at Debian 9, trying to upgr

Re: [squid-users] Collecting squid logs to DB

2018-05-04 Thread Amos Jeffries
On 05/05/18 10:20, Alex K wrote: > Hi all, > > I had a previous setup on Debian 7 with squid and I was using mysar to > collect squid logs and store them to DB and provide some browsing report > at the end of the day. > Now at Debian 9, trying to upgrade the whole setup, I see that mysar > does no

[squid-users] Collecting squid logs to DB

2018-05-04 Thread Alex K
Hi all, I had a previous setup on Debian 7 with squid and I was using mysar to collect squid logs and store them to DB and provide some browsing report at the end of the day. Now at Debian 9, trying to upgrade the whole setup, I see that mysar does not compile. Checking around I found mysar-ng bu