Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Geo IP’s
  FAQ FAQ  Forum Search   Register Register  Login Login

Geo IP’s

 Post Reply Post Reply
Author
StevenJohns View Drop Down
Senior Member
Senior Member


Joined: 03 August 2006
Status: Offline
Points: 119
Post Options Post Options   Thanks (0) Thanks(0)   Quote StevenJohns Quote  Post ReplyReply Direct Link To This Post Topic: Geo IP’s
    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

Back to Top
jemmie View Drop Down
Newbie
Newbie
Avatar

Joined: 27 May 2006
Location: Netherlands
Status: Offline
Points: 18
Post Options Post Options   Thanks (0) Thanks(0)   Quote jemmie Quote  Post ReplyReply Direct Link To This Post Posted: 17 August 2006 at 9:31am
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

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

Back to Top
StevenJohns View Drop Down
Senior Member
Senior Member


Joined: 03 August 2006
Status: Offline
Points: 119
Post Options Post Options   Thanks (0) Thanks(0)   Quote StevenJohns Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
shubham View Drop Down
Newbie
Newbie
Avatar

Joined: 09 September 2022
Location: INDIA
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote shubham Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.273 seconds.