Country and City Unknown

  • Hi there, I was trouble shooting why country and city are not displayed under top and recent visitors, but couldn’t get to the bottom of it. I manually updated the GeoIP country and city databases in the externals settings, and it says “GeoIP Database updated successfully!” When I check on the file system, I only see the City .mmdb file updated, not the other one:

    $ ls -lth wp-content/uploads/wp-statistics/
    total 70M
    -rw-r–r– 1 litespeed litespeed 65M Apr 27 16:37 GeoLite2-City.mmdb
    -rw-r–r– 1 litespeed litespeed 5.3M Dec 12 11:55 GeoLite2-Country.mmdb

    Any ideas if that could be the reason or what else I might be missing here? Already checked WordPress debug log, there’s no errors while updating the GeoIP database.

    Here’s a screenshot. Also I just disabled hasing of IP addresses, although I’d prefer to keep that enabled in order to enhance privacy.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Mostafa Soufi

    (@mostafas1990)

    Hi,

    Thank you for initiating the conversation and providing an explanation of the issue.

    Based on the information you provided, it appears that there may have been a misconfiguration during a manual update, as there are checks in place for file consistency and last update time.

    However, to address this issue, I suggest going to Statistics → Settings → Externals and verifying that the GeoIP Collection and GeoIP City options are enabled.

    After ensuring that they are enabled, try updating the databases by clicking on the “Update Database” option.

    I hope this solution resolves the issue you’re facing. If you have any further questions or concerns, feel free to let me know.

    I too had this problem, and did as you suggested, it made no difference.

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Have you checked the error logs?

    Thread Starter Nick Weisser

    (@openstream)

    Yes, I did. I enabled debug mode a couple days ago, but there are no PHP errors, neither when I trigger the manual GeoIP database updates. What’s weird is that the timestamp of wp-content/uploads/wp-statistics/GeoLite2-Country.mmdb is Dec 12, 2022 as if the manual update does not do anything even though no error is thrown. But even with an old database it should show countries names instead of “unkown”, shouldn’t it? See my linked screenshot in the first post.

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Weird Indeed, let’s disable GeoIP from Settings page, then delete the GeoIP DB files from the server.

    Then try to enable it again.

    Thread Starter Nick Weisser

    (@openstream)

    The hosting provider had change a setting so that the backend webserver will receive the visitor IP address from the load balancer. Now I see the country names, the city names are still missing, though.

    I have “Anonymize IP Addresses” and “Hash IP Addresses” enabled, not sure if this might be the reason for the city names not being “resolved”?

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Sounds great!

    Not really since the plugin get the city from the actual IP before anonymize it.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Country and City Unknown’ is closed to new replies.