Order of GeoIP processing: Difference between revisions

From VoIPmonitor.org
(Fix: Replace incorrect Dashboard content with correct GeoIP processing order documentation)
(Rewrite: add GeoIP use cases intro, consolidate manual import, improve tables)
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
[[Category:Configuration]]
[[Category:Configuration]]


= Order of GeoIP Processing =
= GeoIP Processing =


This page documents the priority order in which VoIPmonitor processes GeoIP lookups to determine geographic location of IP addresses.
VoIPmonitor uses GeoIP services to determine geographic location of IP addresses for:
* '''Anti-fraud alerts''' - Detecting calls to/from unexpected countries (see [[Anti-fraud]])
* '''CDR enrichment''' - Adding country information to call records
* '''Reporting''' - Country-based statistics and filtering


== Processing Priority ==
== Processing Priority ==


VoIPmonitor uses a fallback mechanism for GeoIP lookups. The system attempts each method in order until a successful result is obtained:
The system uses a fallback mechanism, trying each method in order until successful:


<kroki lang="mermaid">
<kroki lang="mermaid">
Line 25: Line 28:


{| class="wikitable"
{| class="wikitable"
! Priority !! Method !! Description
! Priority !! Method !! Notes
|-
|-
| 1 || '''MaxMind API''' || Commercial GeoIP service with high accuracy
| 1 || '''MaxMind API''' || Commercial service, highest accuracy. Requires API key.
|-
|-
| 2 || '''IPInfoDB API''' || Alternative commercial GeoIP API
| 2 || '''IPInfoDB API''' || Alternative commercial API
|-
|-
| 3 || '''Local Database''' || Offline GeoIP database stored on the server
| 3 || '''Local Database''' || File-based (<code>GeoIPCity.dat</code>) OR MySQL tables
|-
|-
| 4 || '''Free Portals''' || Fallback to free online GeoIP services
| 4 || '''Free Portals''' || Online fallback services
|}
|}
{{Tip|For best accuracy, configure MaxMind API with a valid license key.}}


== Configuration ==
== Configuration ==


GeoIP services are configured in:
'''GUI Path:''' Settings → System Configuration → GeoIP
* '''GUI Path:''' Settings → System Configuration → GeoIP
 
=== Local Database Options ===
 
{| class="wikitable"
! Type !! Location/Table !! Description
|-
| File-based || <code>GeoIPCity.dat</code> || Legacy MaxMind format
|-
| MySQL IPv4 || <code>geoip_country</code> || Database table for IPv4
|-
| MySQL IPv6 || <code>geoipv6_country</code> || Database table for IPv6
|}
 
Version tracking is stored in the <code>system</code> table:
* <code>type='geoip_country_version'</code>
* <code>type='geoipv6_country_version'</code>
 
== Manual GeoIP Import ==
 
Use this when GUI "Update GeoIP" fails or completes partially (version shows correct but lookups fail).
 
'''Export from working server:'''
<syntaxhighlight lang="bash">
mysqldump -c voipmonitor geoip_country > gc.sql
mysqldump -c voipmonitor geoipv6_country > gc6.sql
</syntaxhighlight>
 
'''Import to affected server:'''
<syntaxhighlight lang="bash">
mysql voipmonitor < gc.sql
mysql voipmonitor < gc6.sql
</syntaxhighlight>
 
'''Update version tracking:'''
<syntaxhighlight lang="sql">
-- Replace '12' with actual version number from source
INSERT INTO system SET content='12\n', type='geoip_country_version';
INSERT INTO system SET content='12\n', type='geoipv6_country_version';
</syntaxhighlight>


{{Tip|1=For best accuracy and reliability, configure the MaxMind API with a valid license key.}}
{{Warning|1=Ensure database name matches your installation (default: <code>voipmonitor</code>).}}


== Related Pages ==
== See Also ==


* [[CountryGrouping]] - Country-based filtering and anti-fraud alerts
* [[Anti-fraud]] - Country-based fraud detection using GeoIP
* [[Groups#IP_Groups|IP Groups]] - Creating IP address groups for filtering
* [[Groups#IP_Groups|IP Groups]] - Creating IP address groups for filtering


== AI Summary for RAG ==
== AI Summary for RAG ==


'''Summary:''' Documents the priority order for GeoIP processing in VoIPmonitor. The system uses a fallback mechanism: (1) MaxMind API (highest priority), (2) IPInfoDB API, (3) Local Database, (4) Free Portals (lowest priority). Each method is tried in sequence until a successful country lookup is achieved. Configuration is done via GUI Settings → System Configuration → GeoIP.
'''Summary:''' Documents GeoIP processing priority in VoIPmonitor. Uses fallback mechanism: (1) MaxMind API (commercial, highest accuracy), (2) IPInfoDB API, (3) Local Database (file-based GeoIPCity.dat OR MySQL tables geoip_country/geoipv6_country), (4) Free Portals. GeoIP is used for anti-fraud alerts, CDR country enrichment, and reporting. Configuration via GUI Settings → System Configuration → GeoIP. Version tracking in system table (geoip_country_version, geoipv6_country_version). Manual import procedure: mysqldump from working installation, import to affected server, update version in system table.


'''Keywords:''' GeoIP, MaxMind, IPInfoDB, country lookup, IP geolocation, processing order, priority, fallback, local database
'''Keywords:''' GeoIP, MaxMind, IPInfoDB, country lookup, IP geolocation, processing order, priority, fallback, local database, GeoIPCity.dat, MySQL tables, geoip_country, geoipv6_country, manual import, system table, geoip_country_version, anti-fraud, country detection


'''Key Questions:'''
'''Key Questions:'''
Line 58: Line 101:
* Which GeoIP service has highest priority?
* Which GeoIP service has highest priority?
* Where do I configure GeoIP services in VoIPmonitor?
* Where do I configure GeoIP services in VoIPmonitor?
* What happens if MaxMind API fails?
* How to manually import GeoIP data when GUI update fails?
* Does VoIPmonitor support local GeoIP database?
* What MySQL tables store GeoIP data?
* What is GeoIP used for in VoIPmonitor?

Latest revision as of 16:47, 8 January 2026


GeoIP Processing

VoIPmonitor uses GeoIP services to determine geographic location of IP addresses for:

  • Anti-fraud alerts - Detecting calls to/from unexpected countries (see Anti-fraud)
  • CDR enrichment - Adding country information to call records
  • Reporting - Country-based statistics and filtering

Processing Priority

The system uses a fallback mechanism, trying each method in order until successful:

Priority Method Notes
1 MaxMind API Commercial service, highest accuracy. Requires API key.
2 IPInfoDB API Alternative commercial API
3 Local Database File-based (GeoIPCity.dat) OR MySQL tables
4 Free Portals Online fallback services

💡 Tip: For best accuracy, configure MaxMind API with a valid license key.

Configuration

GUI Path: Settings → System Configuration → GeoIP

Local Database Options

Type Location/Table Description
File-based GeoIPCity.dat Legacy MaxMind format
MySQL IPv4 geoip_country Database table for IPv4
MySQL IPv6 geoipv6_country Database table for IPv6

Version tracking is stored in the system table:

  • type='geoip_country_version'
  • type='geoipv6_country_version'

Manual GeoIP Import

Use this when GUI "Update GeoIP" fails or completes partially (version shows correct but lookups fail).

Export from working server: 

mysqldump -c voipmonitor geoip_country > gc.sql
mysqldump -c voipmonitor geoipv6_country > gc6.sql

Import to affected server: 

mysql voipmonitor < gc.sql
mysql voipmonitor < gc6.sql

Update version tracking: 

-- Replace '12' with actual version number from source
INSERT INTO system SET content='12\n', type='geoip_country_version';
INSERT INTO system SET content='12\n', type='geoipv6_country_version';

⚠️ Warning: Ensure database name matches your installation (default: voipmonitor).

See Also

  • Anti-fraud - Country-based fraud detection using GeoIP
  • IP Groups - Creating IP address groups for filtering

AI Summary for RAG

Summary: Documents GeoIP processing priority in VoIPmonitor. Uses fallback mechanism: (1) MaxMind API (commercial, highest accuracy), (2) IPInfoDB API, (3) Local Database (file-based GeoIPCity.dat OR MySQL tables geoip_country/geoipv6_country), (4) Free Portals. GeoIP is used for anti-fraud alerts, CDR country enrichment, and reporting. Configuration via GUI Settings → System Configuration → GeoIP. Version tracking in system table (geoip_country_version, geoipv6_country_version). Manual import procedure: mysqldump from working installation, import to affected server, update version in system table.

Keywords: GeoIP, MaxMind, IPInfoDB, country lookup, IP geolocation, processing order, priority, fallback, local database, GeoIPCity.dat, MySQL tables, geoip_country, geoipv6_country, manual import, system table, geoip_country_version, anti-fraud, country detection

Key Questions:

  • What is the order of GeoIP processing in VoIPmonitor?
  • Which GeoIP service has highest priority?
  • Where do I configure GeoIP services in VoIPmonitor?
  • How to manually import GeoIP data when GUI update fails?
  • What MySQL tables store GeoIP data?
  • What is GeoIP used for in VoIPmonitor?
Retrieved from "https://www.voipmonitor.org/doc/index.php?title=Order_of_GeoIP_processing&oldid=10039"