By user just "real people" and maybe his IP. By Surf Last -> only when a user is loading the page I need the report in real-time but maybe one user surfed many days ago, but I need to save this track. I use Squid 3.0 Stable1. What daemon can I use to make this ? Thanks a lot for your answer !! On Sat, Jan 21, 2012 at 1:23 AM, Amos Jeffries <squid3@xxxxxxxxxxxxx> wrote: > On 21/01/2012 5:06 a.m., Carlos Manuel Trepeu Pupo wrote: >> >> Hello ! I need to know when my users surf last time, so I need to know >> if there is any way to have this information and save to an sql >> database. > > > The Squid log files are text data. So the answer is yes. > > Please explain "user". Only real people? or any machine which connects to > Squid? > > Please explain "surf last". Only when a user is loading the page? or even > when their machine is doing something automatically by itself? > > Please explain under what conditions you are wantign the information back. > monthly report? weekly? daily? hourly? real-time? > > > Current Squid releases support logging daemons which can send log data > anywhere and translate it to any form. Squid-3.2 bundles with a DB > (database) daemon which is also available from SourceForge for squid-2.7 > > Older Squid need log file reader daemons. Like squidtaild, and logger2sql. > > Amos >