Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Does anyone know of a tool that will analyze an Apache access log and show the location of each client that accessed the site, ideally showing city, state and country on a map in the same way that Google Analytics does ?

I've looked at Webalizer and AWStats, but they only seem to go down to country level, they only show tables of data rather than maps, and they also seem to infer the country based on the domain name of the client rather than doing a location lookup on the IP address. For example, my Webalizer setup shows the country of a .com domain as just ".com", but it will show the country of a .co.uk domain as the UK.

share|improve this question

4 Answers 4

up vote 1 down vote accepted

Although I haven't used it personally, Nihuo Web Log Analyzer seems to do what you're looking for.

There's also a 30-day free trial available.

EDIT: Oh, just realised it doesn't map the hits to a visual map...

share|improve this answer
    
Thanks, even if it doesn't plot the results on a map, this tool sounds like the best option so far. –  gareth_bowles Nov 2 '09 at 22:54

AWStats includes the needed plugin by default to get tables down to city and state, but you will need to buy access to that database from MaxMind. Getting a map out of that data would require some custom scripting it looks like though.

share|improve this answer
    
MaxMind apparently also offers a free, though less accurate, city database (maxmind.com/app/geolitecity) I wonder if AWStats could be modified to use the databases found at ipinfodb.com/ip_database.php It appears that they are based on the MaxMind databases, so it's a possibility. –  Michael Johnson Oct 31 '09 at 4:22

you could cut the ip address out and try this: http://ip2country.pauljonesdotuk.co.uk/webmaster

although it is still in alpha testing

Cheers, sprouty

share|improve this answer
    
Thanks - this is the kind of thing I'm after, although it would be nice if I could call it via an API with a list of addresses, rather than having to paste the addresses into a web page. –  gareth_bowles Nov 6 '09 at 16:46

Are you using the geolocation database with Webalizer? You can get it here. Or there's also Google Analytics.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.