Geo IP’s |
Post Reply 
|
| Author | |
StevenJohns 
Senior Member 
Joined: 03 August 2006 Status: Offline Points: 119 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Geo IP’sPosted: 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 |
|
 |
|
|
jemmie
Newbie 
Joined: 27 May 2006 Location: Netherlands Status: Offline Points: 18 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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. Work: http://www.mags.net Personal: http://www.desperado.com |
|
|
|
|
StevenJohns
Senior Member
Joined: 03 August 2006 Status: Offline Points: 119 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
shubham
Newbie
Joined: 09 September 2022 Location: INDIA Status: Offline Points: 1 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
Apilayer
|
|
|
|
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.148 seconds.