The GeoLiteCity free db works and can resolve city names and other informations.
Make sure the instructions are followed regarding it's installation.
http://www.maxmind.com/app/installation?city=1
At step 2 the decompress file must be moved and renamed.
The files needs to be called GeoIPCity.dat if not the mod_geoip will not find it.