Print Page | Close Window

Geo IP’s

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
Printed Date: 16 July 2024 at 4:25pm

Topic: Geo IP’s
Posted By: StevenJohns
Subject: Geo IP’s
Date Posted: 17 August 2006 at 4:01am


I have found in the stats for the countries that I have a huge amount of emails comming from an unknown country ( N/A).

Who is responsible for updating the geo IP list that you use? Is there an updated list that we could periodically download?


Posted By: jemmie
Date Posted: 17 August 2006 at 9:31am

You can find your answer here: - 5743&KW=geo



Posted By: LogSat
Date Posted: 17 August 2006 at 9:56am

The latest official, full release of SpamFilter has an updated geoip database file in it. It's maintained by

Roberto Franceschetti" rel="nofollow - LogSat Software" rel="nofollow - Spam Filter ISP

Posted By: Desperado
Date Posted: 18 August 2006 at 8:57am

Here is the link I use in my script that updates the GeoDb file: -

The Desperado
Dan Seligmann.

Posted By: StevenJohns
Date Posted: 18 August 2006 at 9:11am
ahh...the link i have is at'll use this one from now on....cheers

Posted By: shubham
Date Posted: 09 September 2022 at 3:47pm

The GeoIP or" rel="nofollow - Geolocation API is a simple REST API that serves IP-to-geo mapping and reverse geocoding.
IP-to-geo mapping is the process of assigning a physical address to an IP address. Below is an example of IP-to-geo mapping.

For more detials visit here:  http://" rel="nofollow -


Posted By: Dan B
Date Posted: 31 March 2023 at 9:27am

Since Maxmind isn't supplying sqllite anymore as their database options.  Could SF be modified to use MySQL or MSSQL tables to supply the contries and ip assignments?  I have access to Maxmind and It's a lot easier to import the CSV files.  This way we can update the GeoIP info more often.


Dan B

Posted By: LogSat
Date Posted: 31 March 2023 at 5:17pm
Hi Dan,

SpamFilter is only able to use the local sqlite database. We try to update it every month but you're right - we've not been very consistent (I just forced an update a few minutes ago).

If you're able to access Maxmind's CSV files however, I can provide you with the method/script we use - it's pretty straightforward. The code is for Linux shell, but it can easily be adapted:

cd ~/GeoLite2-Country
rm -R GeoLite2-Country-CSV
curl\&license_key=<YOUR_KEY_HERE>\&suffix=zip -o
mv GeoLite2-Country-CSV_202* GeoLite2-Country-CSV
./geoip2-csv-converter -block-file=./GeoLite2-Country-CSV/GeoLite2-Country-Blocks-IPv4.csv -output-file=geoip.csv -include-integer-range
sqlite3 geoip.sqlite < geoip-import-commands.txt

The "geoip2-csv-converter" is MaxMind's own utility downloadable from" rel="nofollow - .

The file "" rel="nofollow -


Roberto Franceschetti" rel="nofollow - LogSat Software" rel="nofollow - Spam Filter ISP

Print Page | Close Window