Freegle / Iznik / 25218

73%

push

circleci

fix(fromcountry): populate messages.fromcountry on web + email posts

fromcountry (fromip geocoded to a country) drives the ModTools
"different country" warning in MessageHistory.vue, but nothing has
populated it since posting moved off V1: the Go web-submit path and the
Laravel incoming-mail path both stored fromip only.

Go (web/API posts): embed GeoLite2-Country.mmdb in the apiv2 binary and
add utils.CountryCodeForIP; SubmitMessage now stores the ISO code (NULL
when unresolved). Embedding means the lookup works on the prod DB nodes
with no separate mmdb to ship. GEOIP_MMDB_PATH overrides for a fresher db.

Laravel (email posts): the geoip2 package was never added when the mail
path moved to Laravel, so the country blocklist was a silent no-op too.
Add geoip2/geoip2 + a bundled mmdb (resources/geoip, config default),
expose SpamCheckService::lookupIPCountryCode, and store fromcountry on
the group-post insert. readGeoIPCountry now catches \Throwable so a
missing package/db degrades to NULL rather than fataling the pipeline.

The read path already expands the 2-letter code to a full name for
display, so no reader changes are needed.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01Ka6SXbZyznGYXyCyC9C86h

12748 of 16817 branches covered (75.8%)

Branch coverage included in aggregate %.

36 of 48 new or added lines in 4 files covered. (75.0%)

132893 of 184224 relevant lines covered (72.14%)

38.14 hits per line