I have the first part of that which works only with the country database. I tried same in the case for the city & region DBs and it was seizing Apache, but I figured out why that was happening so all is good.
$ENV{'GEOIP_REGION_NAME'} = California
$ENV{'GEOIP_COUNTRY_CODE3'} = USA
$ENV{'GEOIP_LATITUDE'} = 32.797699
$ENV{'GEOIP_COUNTRY_CODE'} = US
$ENV{'GEOIP_COUNTRY_NAME'} = United States
$ENV{'GEOIP_CONTINENT_CODE'} = NA
$ENV{'GEOIP_DMA_CODE'} = 825
$ENV{'GEOIP_CITY'} = San Diego
$ENV{'GEOIP_AREA_CODE'} = 619
$ENV{'GEOIP_REGION'} = CA
$ENV{'GEOIP_LONGITUDE'} = -117.132202
$ENV{'GEOIP_TIME_ZONE_NAME'} = America/Los_Angeles
Monday, Jan 10, 2011 9:00 PM PST
Tuesday, Jan 11, 2011 05:00:44 UTC
Even though the Region db uses a different struct (*giregion), I'm assuming it has the same stuff since it spits out a county code as well. That was where the crashing was coming from. There's no giregion->country_code3 and the way I was trying to obtain it (like in the country db) was problematic. Duh me!
Of course, I never plan to buy a region db so I'll never be able to test it. So I guess the only question left is, does it show the right city info and if so, the right time zone?
http://www.apachehaus.net/Is it showing the proper time for you there on the left side?