Spam Filter ISP Forums : Geo IP’s https://www.logsat.com/spamfilter/forums/ Wed, 10 Jun 2026 20:21:22 +0000 Fri, 31 Mar 2023 17:17:21 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=5759 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Geo IP’s : Hi Dan,SpamFilter is only able...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14963&title=geo-ips#14963 Author: LogSat
Subject: 5759
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
rm GeoLite-Country-CSV.zip
curl https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-Country-CSV\&license_key=<YOUR_KEY_HERE>\&suffix=zip -o GeoLite-Country-CSV.zip
unzip GeoLite-Country-CSV.zip
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 https://github.com/maxmind/geoip2-csv-converter.

The file "geoip-import-commands.txt" has the commands necessary to import the data into the sqlite DB.

Roberto
]]> Fri, 31 Mar 2023 17:17:21 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14963&title=geo-ips#14963 <![CDATA[Geo IP’s : Roberto,Since Maxmind isn&#039;t...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14962&title=geo-ips#14962 Author: Dan B
Subject: 5759
Posted: 31 March 2023 at 9:27am

Roberto,

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.

Thanks,
Dan

]]> Fri, 31 Mar 2023 09:27:33 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14962&title=geo-ips#14962 <![CDATA[Geo IP’s : The GeoIP or Geolocation API...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14961&title=geo-ips#14961 Author: shubham
Subject: 5759
Posted: 09 September 2022 at 3:47pm


The GeoIP or 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: https://ipstack.com/documentation


Edited by shubham - 09 September 2022 at 3:49pm]]> Fri, 09 Sep 2022 15:47:42 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=14961&title=geo-ips#14961 <![CDATA[Geo IP’s : ahh...the link i have is at logsat.com.....I&#039;ll...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8773&title=geo-ips#8773 Author: StevenJohns
Subject: 5759
Posted: 18 August 2006 at 9:11am

ahh...the link i have is at logsat.com.....I'll use this one from now on....cheers]]> Fri, 18 Aug 2006 09:11:39 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8773&title=geo-ips#8773 <![CDATA[Geo IP’s : Here is the link I use in my script...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8770&title=geo-ips#8770 Author: Desperado
Subject: 5759
Posted: 18 August 2006 at 8:57am

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

http://www.maxmind.com/download/geoip/database/GeoIP.dat.gz

]]> Fri, 18 Aug 2006 08:57:53 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8770&title=geo-ips#8770 <![CDATA[Geo IP’s : StevenJohns,The latest official,...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8761&title=geo-ips#8761 Author: LogSat
Subject: 5759
Posted: 17 August 2006 at 9:56am

StevenJohns,

The latest official, full release of SpamFilter has an updated geoip database file in it. It's maintained by Maxmind.com
]]> Thu, 17 Aug 2006 09:56:17 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8761&title=geo-ips#8761 <![CDATA[Geo IP’s : You can find your answer here: ...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8759&title=geo-ips#8759 Author: jemmie
Subject: 5759
Posted: 17 August 2006 at 9:31am

You can find your answer here:

http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID= 5743&KW=geo

jemmie

 

]]> Thu, 17 Aug 2006 09:31:54 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8759&title=geo-ips#8759 <![CDATA[Geo IP’s : Roberto, I have found in the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8756&title=geo-ips#8756 Author: StevenJohns
Subject: 5759
Posted: 17 August 2006 at 4:01am

Roberto,

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?

Cheers

]]> Thu, 17 Aug 2006 04:01:49 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759&PID=8756&title=geo-ips#8756