Re: [Fase-developer] Example log

[<ev...@ly...>]

Looks like a good solution. I've got some questions.

1. Could you read from the httpd.conf file so it parses every logfile=20
listed in the
2 . Could you make it work so the statistics would be inserted in a=20
database like this:

Virtual_Hosts
	- id
	- host

Totals
	- vhost_id
	- user_agents
	- platforms
	- days
	- hits
	- visits
	- pages
	- kb
	- hosts
	- domains
	- tlds
	- unique_pages
	- unique_pages_entrances
	- unique_referers_hosts
	- unique_referers_domains
	- hits_from_bookmarks
	- busiest_hour_week
	- busiest_day_week
	- denied_requests
	- denied_unique_requests

Browsers
	- vhost_id
	- browser
	- hits
	- visits

Domains
	- vhost_id
	- domain
	- hits
	- visits
=09
Hours_average
	- vhost_id
	- hour
	- hits
	- visits
=09
Days_average (this month)
	- vhost_id
	- day (format, 01, 02, 03, ..., etc)
	- hits
	- visits
=09
OS
	- vhost_id
	- os
	- hits
	- visits
=09
Pages
	- vhost_id
	- page
	- hits
	- visits
=09
Referers
	- vhost_id
	- referer
	- hits
	- 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:	errortype,errorcount
>
> table:  filehit
> fields:	filename,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=20
>>>> 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=20
>>>>> 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:	ev...@ly...
>>>> Tlf.:		917 70 994
>>>>
>>>> E-mail:	fir...@ly...
>>>> Webside:	http://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>