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
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5759
Printed Date: 26 December 2024 at 7:42am


Topic: Geo IP’s
Posted By: StevenJohns
Subject: Geo IP’s
Date 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


Replies:
Posted By: jemmie
Date 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 - http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID= 5743&KW=geo

jemmie

 

Posted By: LogSat
Date 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


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" 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:

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



-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: StevenJohns
Date 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

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

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


-------------
Apilayer

Posted By: Dan B
Date 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



-------------
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
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" rel="nofollow - https://github.com/maxmind/geoip2-csv-converter .

The file " https://logsat.com/pub/geoip-import-commands.txt" rel="nofollow -

Roberto


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window