I have some errors in logs red: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "groups" does not exist LINE 1: SELECT "groups"."id", "groups"."name" FROM "groups" WHERE yellow Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "groups" does not exist LINE 1: MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-City.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-City.mmdb MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-ASN.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-ASN.mmdb

You may wish to search for the maxmind issue.

I do not find an authoritative answer on searching for the issue. Can someone who knows link it here? Are these MaxMindDB warnings to be ignored? Rebuilding doesn’t seem to fix the issue. I have been getting them for months.

[תמונה] k4rtik: I do not find an authoritative answer on searching for the issue. Now you can! Configure MAXMIND for reverse IP lookups

We are using Discourse behind a reverse proxy, so all users have the same IP, and we would need the GeoIP lookup - I do not see the option to disable the IP lookup altogether, instead of going through the registration process and obtaining a license for something that we are not needed, only in order to eliminate the errors from the logs… Do I miss a setting, on how to disable this?

[תמונה] dichter: Discourse behind a reverse proxy, so all users have the same IP, You should fix that. I think topics like How to set up Discourse on a server with existing Apache sites might have the instructions for that. I think that if you just don’t set the maxmind key you’ll get a warning when you rebuild but it won’t hurt anything.

Wouldn’t it be reasonable to hide and skip the GeoIP lookup from user admin settings, if no license key was configured? Or instead show an info/placeholder that GeoIP lookup would be possible by setting a license key following Configure MAXMIND for reverse IP lookups? Looping through error logs to monitor system operation is good practice, and it’s annoying to spend time on investigating errors, just to find out that they are expected because an operation is attempted which is expected to fail by default and which could be skipped easily by checking a single setting :wink:. I can try open a PR on GitHub, if you basically agree. But probably I’m overlooking something and it isn’t that easy or has downsides I’m not seeing.

[תמונה] MichaIng: Or instead show an info/placeholder that GeoIP lookup would be possible by setting a license key following Configure MAXMIND for reverse IP lookups? Sounds good, would be happy with a PR

PR up, but I need some help to apply tests, in code and how to test on running Discourse instance: UX: Show if MaxMind key is missing on IP lookup by MichaIng · Pull Request #18993 · discourse/discourse · GitHub

I’ve been ignoring these: MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-ASN.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-ASN.mmdb MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-City.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-City.mmdb …but just came looking for a way to suppress them. I could just configure MaxMind, but I don’t really need it. The PR above was merged 2023-11-23 – should I not be seeing these errors?

[תמונה] ToddZ: The PR above was merged 2023-11-23 – should I not be seeing these errors? It was reverted again since it was too complicated to adjust automated tests for them. An attempt was made, but those re-added the warnings, breaking the purpose of my PR in the first place: https://github.com/discourse/discourse/pull/24534 Hence both reverted: https://github.com/discourse/discourse/pull/24538 The problem most likely was to make reading the database depending of the existence of a MaxMind key. The database however can be added other ways. On our own instance, in the meantime we add free DB-IP databases, which do not require an account. So my own PR would have broken the way we do it now. The same caused failing tests which I fixed in my PR. But on the main branch and/or in certain plugins this likely caused other issues. A better solution, if someone wants to approach this again, would be to check whether the database files exist, before attempting to load them, instead of whether the license key is defined. So here: lib/discourse_ip_info.rb main def open_db(path) @loc_mmdb = mmdb_load(File.join(path, "GeoLite2-City.mmdb")) @asn_mmdb = mmdb_load(File.join(path, "GeoLite2-ASN.mmdb")) @cache = LruRedux::ThreadSafeCache.new(2000) end Only if File.join(path, "GeoLite2-City.mmdb") exists, mmdb_load it. The adjusted GUI output might have been an issue as well for some tests, but it should be possible to add it without breaking tests, as a fallback only if no location is available and then the respective flag is true (the one I set with ret[:no_license] = true in my PR). But should be renamed to no_db or so to indicate that it is not about whether a MaxMind license key has been defined, but whether the actual database files exist or not. That way, unit tests can inject a location to test the output without requiring an actual database, and no license key anyway.

MaxMindDB not found error

תמיכה התקנה

pfaffman (Jay Pfaffman) 5 בינואר,‏ 2021,‏ 8:59pm 4

Now you can! Configure MAXMIND for reverse IP lookups

נושא		תגובות	צפיות
GeoLite2 on the MaxmindDB site Self-hosting maxmind	4	472	17 ביוני,‏ 2024
MaxMindDB error in log Product Support maxmind	2	746	18 בדצמבר,‏ 2020
MaxMindDB problems Product Support	6	309	24 באוקטובר,‏ 2024
MaxMindDB GeoLite2-City.mmdb Not Found Error in Logs Product Support	5	366	18 במרץ,‏ 2025
解决错误日志中MaxMindDB警告 General	0	154	22 באפריל,‏ 2026

MaxMindDB not found error

נושאים קשורים