Re: [Fase-developer] Example log

[Alex <ax...@m-...>]

Yes, I'll work on that.

On Tue, 7 Jan 2003, [ISO-8859-1] Even Andr=E9 Fiskvik wrote:

> Looks like a good solution. I've got some questions.
>
> 1. Could you read from the httpd.conf file so it parses every logfile
> listed in the
> 2 . Could you make it work so the statistics would be inserted in a
> database like this:
>
> Virtual_Hosts
> =09- id
> =09- host
>
> Totals
> =09- vhost_id
> =09- user_agents
> =09- platforms
> =09- days
> =09- hits
> =09- visits
> =09- pages
> =09- kb
> =09- hosts
> =09- domains
> =09- tlds
> =09- unique_pages
> =09- unique_pages_entrances
> =09- unique_referers_hosts
> =09- unique_referers_domains
> =09- hits_from_bookmarks
> =09- busiest_hour_week
> =09- busiest_day_week
> =09- denied_requests
> =09- denied_unique_requests
>
> Browsers
> =09- vhost_id
> =09- browser
> =09- hits
> =09- visits
>
> Domains
> =09- vhost_id
> =09- domain
> =09- hits
> =09- visits
>
> Hours_average
> =09- vhost_id
> =09- hour
> =09- hits
> =09- visits
>
> Days_average (this month)
> =09- vhost_id
> =09- day (format, 01, 02, 03, ..., etc)
> =09- hits
> =09- visits
>
> OS
> =09- vhost_id
> =09- os
> =09- hits
> =09- visits
>
> Pages
> =09- vhost_id
> =09- page
> =09- hits
> =09- visits
>
> Referers
> =09- vhost_id
> =09- referer
> =09- hits
> =09- visits
>
> Now it's time for sleep, speak to you later :)
>
> - Even Andr=E9
>
> On mandag, jan 6, 2003, at 23:03 Europe/Oslo, Alex wrote:
>
> >
> > You need to setup the database and the odbc
> >
> > The database is 2 tables
> > table:  errorhit
> > fields:=09errortype,errorcount
> >
> > table:  filehit
> > fields:=09filename,hit
> >
> > On Mon, 6 Jan 2003, [ISO-8859-1] Even Andr=E9 Fiskvik wrote:
> >
> >> Could you send it over to me so I could have a look at it?
> >> If it's good enough we could upload it to the CVS (and you could get
> >> CVS access), so we can get some progress going on.
> >>
> >> - Even Andr=E9
> >>
> >> On mandag, jan 6, 2003, at 22:15 Europe/Oslo, Alex wrote:
> >>
> >>>
> >>> I got some stuff working with perls's ParseLog.pm and DBI.pm
> >>> Very rough but it works
> >>>
> >>> On Thu, 2 Jan 2003, [ISO-8859-1] Even Andr=E9 Fiskvik wrote:
> >>>
> >>>> That sounds good.
> >>>> Hopefully we can get a thing going soon then :)
> >>>> I believe this project can be something that a lot of server
> >>>> managers
> >>>> may find interesting.
> >>>>
> >>>> Even Andr=E9
> >>>>
> >>>> On torsdag, jan 2, 2003, at 01:27 Europe/Oslo, Alex wrote:
> >>>>
> >>>>> The logo looks cool. I found a perl module that basically parses a
> >>>>> httpd.conf file and resulting log files. It's called
> >>>>> Apache::ParseLog.
> >>>>> With that module and the DBI module inserting into a database
> >>>>> should
> >>>>> not
> >>>>> be a problem.
> >>>>>
> >>>>> On Thu, 2 Jan 2003, [ISO-8859-1] Even Andr=E9 Fiskvik wrote:
> >>>>>
> >>>>>> I've uploaded an example log for you to work with at:
> >>>>>> http://fase.sourceforge.net/access.log (it's about 3 mb).
> >>>>>> The log is in this format:
> >>>>>> LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\"
> >>>>>> \"%{User-Agent}i\"" combined
> >>>>>>
> >>>>>> Good luck :)
> >>>>>> Btw, I've created a logo, what do you think of it:
> >>>>>> http://fase.sourceforge.net/fase_logo.jpg
> >>>>>>
> >>>>>> EAF
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> -------------------------------------------------------
> >>>>>> This sf.net email is sponsored by:ThinkGeek
> >>>>>> Welcome to geek heaven.
> >>>>>> http://thinkgeek.com/sf
> >>>>>> _______________________________________________
> >>>>>> Fase-developer mailing list
> >>>>>> Fas...@li...
> >>>>>> https://lists.sourceforge.net/lists/listinfo/fase-developer
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> -------------------------------------------------------
> >>>>> This sf.net email is sponsored by:ThinkGeek
> >>>>> Welcome to geek heaven.
> >>>>> http://thinkgeek.com/sf
> >>>>> _______________________________________________
> >>>>> Fase-developer mailing list
> >>>>> Fas...@li...
> >>>>> https://lists.sourceforge.net/lists/listinfo/fase-developer
> >>>>>
> >>>> --
> >>>> Med vennlig hilsen,
> >>>>
> >>>> Even Andr=E9 Fiskvik
> >>>>
> >>>> Daglig leder / Webdesigner
> >>>> Lynweb Consulting ANS
> >>>> _________________________
> >>>> E-mail:=09...@ly...
> >>>> Tlf.:=09=09917 70 994
> >>>>
> >>>> E-mail:=09f...@ly...
> >>>> Webside:=09http://www.lynweb.no
> >>>> _________________________
> >>>>
> >>>>
> >>>>
> >>>> -------------------------------------------------------
> >>>> This sf.net email is sponsored by:ThinkGeek
> >>>> Welcome to geek heaven.
> >>>> http://thinkgeek.com/sf
> >>>> _______________________________________________
> >>>> Fase-developer mailing list
> >>>> Fas...@li...
> >>>> https://lists.sourceforge.net/lists/listinfo/fase-developer
> >>>>
> >>>
> >>>
> >>>
> >>> -------------------------------------------------------
> >>> This sf.net email is sponsored by:ThinkGeek
> >>> Welcome to geek heaven.
> >>> http://thinkgeek.com/sf
> >>> _______________________________________________
> >>> Fase-developer mailing list
> >>> Fas...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/fase-developer
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This sf.net email is sponsored by:ThinkGeek
> >> Welcome to geek heaven.
> >> http://thinkgeek.com/sf
> >> _______________________________________________
> >> Fase-developer mailing list
> >> Fas...@li...
> >> https://lists.sourceforge.net/lists/listinfo/fase-developer
> >>
> > <aplog.pl>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Fase-developer mailing list
> Fas...@li...
> https://lists.sourceforge.net/lists/listinfo/fase-developer
>