|Anonymous | Login | Signup for a new account||2020-09-19 06:11 UTC|
|My View | View Issues | Change Log | Roadmap | Doomseeker Issue Support Ranking | Rules | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003699||Doomseeker||IP2C||public||2019-08-19 20:51||2019-08-23 21:04|
|Priority||low||Severity||minor||Reproducibility||have not tried|
|Target Version||Fixed in Version|
|Summary||0003699: Inaccuracy in interpretation of MaxMind GeoLite's data|
|Description||This issue was detected on a specific case, therefore I will stick to the specific example: IP address 188.8.131.52 is located in Germany, however Doomseeker shows that it is located in USA. If we inspect MaxMind's IPv4 Country Blocks database we can locate the 184.108.40.206 to be under such record:|
The numbers 6252001 and 2921044 are of interest here. 6252001 is a "geoname_id" whereas 2921044 is "registered_country_geoname_id". The locations database points the first number to USA and the second to Germany. The conversion script that converts MaxMind's DB to Doomseeker's blob prefers "geoname_id" unless it's not defined, then the other value is used. It should be investigated whether that's the right course of action and whether the "registered_country_geoname_id" should be used at all times.
A fixed IP2C database blob should be uploaded to the Doomseeker's site after this is done.
|Steps To Reproduce||1. Add 220.127.116.11 as a pinned server.|
2. Notice that its location is in USA.
3. Location is reported as Germany byhttps://www.ip2location.com/demo/18.104.22.168 [^]
|Attached Files||diffblocks.txt.gz [^] (265,913 bytes) 2019-08-20 08:21|
I filtered the current MaxMind's database to extract only those records where the two geoname_id values differ and matched them to the country or continent name. This is uploaded as diffblocks.txt.gz.
I tested several of those network IPs at the ip2location page. Depending on the IP, the page sometimes gives country that matches geoname_id, and sometimes the one that matches the "registered_country_geoname_id". Given this, there's no way to deduce from MaxMind's DB alone which ID is the one that should be used.
|I might've seen this issue with NE's Zandronum servers (Complex Doom Invasion) being reported as from France in Doomseeker 1.3, where they were reported as Canada more correctly in Doomseeker 1.2.|
edited on: 2019-08-23 18:47
Quote from WHOIS for 22.214.171.124 (126.96.36.199/22)inetnum: 188.8.131.52 - 184.108.40.206 netname: ALVOTECH-US-VPS1 country: DE org: ORG-dIG4-RIPE admin-c: PBH-RIPE tech-c: PBH-RIPE status: ASSIGNED PA mnt-by: providerbox-mnt mnt-lower: providerbox-mnt mnt-routes: providerbox-mnt created: 2012-05-23T15:51:07Z last-modified: 2018-12-11T21:21:07Z source: RIPE organisation: ORG-dIG4-RIPE org-name: dogado GmbH org-type: LIR address: Saarlandstr. 25 address: 44139 address: Dortmund address: GERMANY phone: +492312866200 fax-no: +4923128662020 admin-c: PBH-RIPE tech-c: PBH-RIPE abuse-c: PBH-RIPE mnt-ref: RIPE-NCC-HM-MNT mnt-ref: providerbox-mnt mnt-by: RIPE-NCC-HM-MNT mnt-by: providerbox-mnt created: 2008-04-21T14:11:50Z last-modified: 2018-12-11T21:32:59Z source: RIPE # Filtered role: provider.BOX Hostmaster address: dogado GmbH address: Saarlandstrasse 25 address: D-44139 Dortmund abuse-mailbox: email@example.com admin-c: RTD-RIPE admin-c: TMD-RIPE tech-c: RTD-RIPE tech-c: TMD-RIPE mnt-by: providerbox-mnt nic-hdl: PBH-RIPE created: 2008-04-21T15:56:53Z last-modified: 2014-04-28T16:14:55Z source: RIPE # Filtered route: 220.127.116.11/22 origin: as21413 mnt-by: ENVIA-TEL-MNT mnt-by: providerbox-mnt created: 2018-10-08T14:27:06Z last-modified: 2018-12-11T07:11:40Z source: RIPE route: 18.104.22.168/22 origin: AS45012 mnt-by: CLOUDPIT-MNT created: 2019-04-11T15:00:18Z last-modified: 2019-07-18T16:17:59Z source: RIPE
Quote from Zalewa
Which port? Which engine?
I tried Zandronum & 22.214.171.124:10666, it was not available at this time.
|The server doesn't really need to be available and the game doesn't matter. The flag/location is resolved by the IP address alone.|
|Only registered users can voice their support. Click here to register, or here to log in.|
|Supporters:||No one explicitly supports this issue yet.|
|Opponents:||No one explicitly opposes this issue yet.|
|2019-08-19 20:51||Zalewa||New Issue|
|2019-08-20 08:21||Zalewa||File Added: diffblocks.txt.gz|
|2019-08-20 08:25||Zalewa||Note Added: 0020964|
|2019-08-23 11:11||Zalewa||Status||new => acknowledged|
|2019-08-23 17:46||WubTheCaptain||Note Added: 0020977|
|2019-08-23 18:45||WubTheCaptain||Note Added: 0020984|
|2019-08-23 18:46||WubTheCaptain||Note Added: 0020985|
|2019-08-23 18:46||WubTheCaptain||Assigned To||=> WubTheCaptain|
|2019-08-23 18:46||WubTheCaptain||Status||acknowledged => feedback|
|2019-08-23 18:47||WubTheCaptain||Note Edited: 0020984||View Revisions|
|2019-08-23 18:55||WubTheCaptain||Assigned To||WubTheCaptain =>|
|2019-08-23 18:55||WubTheCaptain||Status||feedback => acknowledged|
|2019-08-23 21:04||Zalewa||Note Added: 0020987|
Questions or other issues? Contact Us.
|Copyright © 2000 - 2020 MantisBT Team|