Geo IPs |
Post Reply ![]() |
Author | |
StevenJohns ![]() Senior Member ![]() Joined: 03 August 2006 Status: Offline Points: 119 |
![]() ![]() ![]() ![]() ![]() 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 |
|
![]() |
|
jemmie ![]() Newbie ![]() ![]() Joined: 27 May 2006 Location: Netherlands Status: Offline Points: 18 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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
|
|
![]() |
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.124 seconds.