Page MenuHomePhabricator

Poke around production to find the maxmind flatfile! [4H]
Closed, ResolvedPublicOct 20 2020

Description

If we don't hear from Brandon before we get to this (T263263), let's see if we can find the Maxmind data flatfile in production ourselves. We could ping some folks (James, Timo) to see if they have any leads for us.

Details

Due Date
Oct 20 2020, 4:00 AM

Event Timeline

Niharika triaged this task as Medium priority.Oct 7 2020, 6:57 AM
Niharika created this task.
ARamirez_WMF renamed this task from Poke around production to find the maxmind flatfile! to Poke around production to find the maxmind flatfile! [4H].Oct 7 2020, 4:13 PM
ARamirez_WMF changed the subtype of this task from "Task" to "Deadline".Oct 8 2020, 10:13 PM
ARamirez_WMF set Due Date to Oct 20 2020, 4:00 AM.

I see some stuff on stat1007 in /srv/geoip/archive/ by date; are those what you need?

Found it! It's in /usr/share/GeoIP

$ ls -lah /usr/share/GeoIP
total 276M
drwxr-xr-x   2 root root 4.0K Oct  4 03:52 .
drwxr-xr-x 170 root root 4.0K Aug  4 00:10 ..
-rw-r--r--   1 root root 127M Oct  4 03:52 GeoIP2-City.mmdb
-rw-r--r--   1 root root 3.8M Oct  4 03:52 GeoIP2-Connection-Type.mmdb
-rw-r--r--   1 root root 4.0M Oct  4 03:52 GeoIP2-Country.mmdb
-rw-r--r--   1 root root  11M Oct  4 03:52 GeoIP2-ISP.mmdb
-rw-r--r--   1 root root 3.8M Jul 12  2018 GeoIPASNum.dat
-rw-r--r--   1 root root 4.5M Jul 12  2018 GeoIPASNumv6.dat
-rw-r--r--   1 root root  49M Oct  4 03:52 GeoIPCity.dat
-rw-r--r--   1 root root 1.9M Oct  4 03:52 GeoIP.dat
-rw-r--r--   1 root root 1.1M Oct  4 03:52 GeoIPNetSpeedCell.dat
-rw-r--r--   1 root root 1.3M Oct  4 03:52 GeoIPNetSpeed.dat
-rw-r--r--   1 root root 6.7M Oct  4 03:52 GeoIPRegion.dat
-rw-r--r--   1 root root 1.4M Jul 12  2018 GeoIPv6.dat
-rw-r--r--   1 root root  31M Jul 12  2018 GeoLite2-City.mmdb
-rw-r--r--   1 root root  16M Jul 12  2018 GeoLiteCity.dat
-rw-r--r--   1 root root  16M Jul 12  2018 GeoLiteCityv6.dat
-rw-r--r--   1 root root 743K Jul 12  2018 GeoLite.dat

I'm surprised it's split up into separate files, but maybe that's not a bad thing....

dbarratt subscribed.
dbarratt unsubscribed.