Freelance Project

We need to understand which sites are popular on our servers. We can do this by analyzing the Apache access log with an automated system.

1) Total sites which have received at lease one hit; this will give us an idea on how many active sites there were for that day.

2) Most popular sites sorted by most entries first AKA page views.

4) Top IP addresses which have accessed the server along with total number beside each IP.

5) Top referrers along with the site they are referring too.

Here is example of index:

http://tinyurl.com/nrl5bn

Here is example of day:

http://tinyurl.com/mtbwgx

The project must utilize MySQL databases and pref be coded in PHP. Other languages may be welcome.

Before project start I will give you an example of 1 day worth of logs so you can test. After you have coded the majority of the script I will give you access to my server(s).

Problems:
Access log is outside of PHP. We’d need a cronjob which tails the previous day and mv’s the output to the admin directory which has PHP access. (?).

Any questions just ask