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

2018-05-12 Thread Eliezer Croitoru
Hey Alex, I wrote a simple service that now run’s here locally with my server. The sources and installation instruction can be seen here: http://gogs.ngtech.co.il/elicro/squid-sql-logger Let me know if it works for you. Eliezer · I will try to write a daemon in GoLang which m

Re: [squid-users] Whitelist ONLY exception isn't working correctly

2018-05-12 Thread Alex Rousskov
On 05/12/2018 07:55 PM, Martin Hanson wrote: > # !!! THIS ISN'T WORKING !!! ubuntu.com, mojang.com still gets blocked on > these boxes. > http_access deny windows_boxes !whitelist ... > http_access deny all You have no rules that allow windows_boxes to access whitelist servers, and you have a "de

[squid-users] Whitelist ONLY exception isn't working correctly

2018-05-12 Thread Martin Hanson
Hi, I have a setup with a PF firewall that intercepts HTTP and HTTPS traffic and forwards that to Squid. Squid is setup to log all traffic and it uses a SSL bump for the HTTPS traffic. In the setup I have a whitelist of domains that doesn't get logged, the rest of the traffic gets logged and r

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

2018-05-12 Thread Eliezer Croitoru
I have a daemon written in Ruby and GoLang which can do a better job. Specifically for your scenario I think the better option is to use a tcp server such as in: https://wiki.squid-cache.org/Features/LogModules#Module:_TCP_Receiver Ubuntu and Debian use systemd and you can spawn a log daemon

Re: [squid-users] Kerberos authentication on mobile phones

2018-05-12 Thread Markus Moeller
You don't have to join a domain. You only need a Kerberos authentication server to get a ticket. You only need AD (or Samba) if you want also authorisation (PAC data) in you Kerberos ticket. As Amos said you need a Kerberos client and a Browser supporting Proxy-Negotiate. Markus "Amos Jeffrie

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

2018-05-12 Thread Alex K
+++ 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 squid Through testing it seems that sometimes squid is not logging anything. I don't

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

2018-05-12 Thread Eliezer Croitoru
Hey Alex, How did you used to log into the DB? What configuration lines have you used? Also what log format have you used? Is it important to have realtime data in the DB or a periodic parsing is also an option? Eliezer Eliezer Croitoru Linux Syst