Otdfbt

Ethical issue - how can I better document what is happening?

What does $!# mean in Shell scripting?

How to respond to upset student?

Why were helmets and other body armour not commonplace in the 1800s?

Construct a word ladder

Why most published works in medical imaging try reducing false positives?

How to attach cable mounting points to a bicycle frame?

USPS Back Room - Trespassing?

How did NASA Langley end up with the first 737?

I know that there is a preselected candidate for a position to be filled at my department. What should I do?

Have 1.5% of all nuclear reactors ever built melted down?

Is the field of q-series 'dead'?

Python program to take in two strings and print the larger string

NIntegrate doesn't evaluate

How to deal with a colleague who is being aggressive?

Question in discrete mathematics about group permutations

Count rotary dial pulses in a phone number (including letters)

Why does this if-statement combining assignment and an equality check return true?

What is a Power on Reset IC?

When the Torah was almost lost and one (or several) Rabbis saved it?

Count Even Digits In Number

Efficient Algorithm for the boundary of a set of tiles

How to cut a climbing rope?

Can a person survive on blood in place of water?

MaxMind GeoIP CSV to .dat

NginX GeoIP cause extra load?php5-geoip performance issueInstalling GeoIP on CentOSMake kernel modules available that have been deactivated on FedoraHow to Split a Huge CSV File in Linux?Varnish GeoIP (vmod_geoip) + Amazon LinuxHow to test GeoIP .dat librairie in localGEOIP redirect with httpsdebian, lighttpd: GeoIP, Some variables are not workingInstalling GeoIP on Amazon EC2 Linux

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

2

3

I need to put local IP addresses into MaxMind GeoIP DB.
I've downloaded the CSV and adding new IP addresses and locations is easy.
I've found two tools that do csv to dat for MaxMind GeoIP but I can't get them work.

With python script:

./csv2dat.py -w custom_geoip.dat mmcountry working.csv 
File "./csv2dat.py", line 69
print "error: database types don't match"
SyntaxError: Missing parentheses in call to 'print'

Also, I've tried to compile cpp script (https://github.com/dankamongmen/sprezzos-world/blob/master/packaging/geoip/debian/src/geoip-csv-to-dat.cpp) but I get large strace.

I've tried with new and old MaxMind DB. is there any other tool?

Thanks

linux csv geoip

share|improve this question

asked Jun 1 '16 at 15:31

yaxyax

164

add a comment | 

2

3

I need to put local IP addresses into MaxMind GeoIP DB.
I've downloaded the CSV and adding new IP addresses and locations is easy.
I've found two tools that do csv to dat for MaxMind GeoIP but I can't get them work.

With python script:

./csv2dat.py -w custom_geoip.dat mmcountry working.csv 
File "./csv2dat.py", line 69
print "error: database types don't match"
SyntaxError: Missing parentheses in call to 'print'

Also, I've tried to compile cpp script (https://github.com/dankamongmen/sprezzos-world/blob/master/packaging/geoip/debian/src/geoip-csv-to-dat.cpp) but I get large strace.

I've tried with new and old MaxMind DB. is there any other tool?

Thanks

linux csv geoip

share|improve this question

asked Jun 1 '16 at 15:31

yaxyax

164

add a comment | 

I need to put local IP addresses into MaxMind GeoIP DB.
I've downloaded the CSV and adding new IP addresses and locations is easy.
I've found two tools that do csv to dat for MaxMind GeoIP but I can't get them work.

With python script:

./csv2dat.py -w custom_geoip.dat mmcountry working.csv 
File "./csv2dat.py", line 69
print "error: database types don't match"
SyntaxError: Missing parentheses in call to 'print'

Also, I've tried to compile cpp script (https://github.com/dankamongmen/sprezzos-world/blob/master/packaging/geoip/debian/src/geoip-csv-to-dat.cpp) but I get large strace.

I've tried with new and old MaxMind DB. is there any other tool?

Thanks

linux csv geoip

share|improve this question

asked Jun 1 '16 at 15:31

yaxyax

164

./csv2dat.py -w custom_geoip.dat mmcountry working.csv 
File "./csv2dat.py", line 69
print "error: database types don't match"
SyntaxError: Missing parentheses in call to 'print'

share|improve this question

asked Jun 1 '16 at 15:31

yaxyax

164

share|improve this question

asked Jun 1 '16 at 15:31

yaxyax

164

asked Jun 1 '16 at 15:31

yaxyax

164

asked Jun 1 '16 at 15:31

yaxyax

164

1 Answer
1

active

oldest

votes

0

geoip-csv-to-dat.cpp - is the part of geoip-bin package and could be installed from Debian or Ubuntu repository if it is your linux distributive.

apt-get install geoip-bin
/usr/lib/geoip/geoip-generator --help

UPDATE:
digging into the source uncovered that maxmind country and city csv databases got completely different formats so you have to provide different bunches of arguments to process it.

For country database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat working.csv 

For city database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat -t 
GEOIP_CITY_EDITION_REV1 -l working-locations.csv working-blocks.csv 

As for csv2dat.py - looks like you are trying to execute Python 2 script with Python 3 interpreter. Try:

python2.7 csv2dat.py -w custom_geoip.dat mmcountry working.csv 

share|improve this answer

edited Nov 30 '16 at 8:02

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This looks like the perfect answer but when I run it I get /usr/lib/geoip/geoip-generator:GeoLite2-City-Blocks-IPv4.csv:2: Wrong number of fields. Any ideas what the fields should be for this to work? The fields I have are 'network geoname_id, registered_country_geoname_id, represented_country_geoname_id, is_anonymous_proxy, is_satellite_provider, postal_code, latitude, longitude, accuracy_radius' as per the latest geolite city download.
  
  – H2ONOCK
  Jan 19 at 9:27
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f780316%2fmaxmind-geoip-csv-to-dat%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

geoip-csv-to-dat.cpp - is the part of geoip-bin package and could be installed from Debian or Ubuntu repository if it is your linux distributive.

apt-get install geoip-bin
/usr/lib/geoip/geoip-generator --help

UPDATE:
digging into the source uncovered that maxmind country and city csv databases got completely different formats so you have to provide different bunches of arguments to process it.

For country database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat working.csv 

For city database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat -t 
GEOIP_CITY_EDITION_REV1 -l working-locations.csv working-blocks.csv 

As for csv2dat.py - looks like you are trying to execute Python 2 script with Python 3 interpreter. Try:

python2.7 csv2dat.py -w custom_geoip.dat mmcountry working.csv 

share|improve this answer

edited Nov 30 '16 at 8:02

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This looks like the perfect answer but when I run it I get /usr/lib/geoip/geoip-generator:GeoLite2-City-Blocks-IPv4.csv:2: Wrong number of fields. Any ideas what the fields should be for this to work? The fields I have are 'network geoname_id, registered_country_geoname_id, represented_country_geoname_id, is_anonymous_proxy, is_satellite_provider, postal_code, latitude, longitude, accuracy_radius' as per the latest geolite city download.
  
  – H2ONOCK
  Jan 19 at 9:27
  

  
  
  
  

add a comment | 

0

geoip-csv-to-dat.cpp - is the part of geoip-bin package and could be installed from Debian or Ubuntu repository if it is your linux distributive.

apt-get install geoip-bin
/usr/lib/geoip/geoip-generator --help

UPDATE:
digging into the source uncovered that maxmind country and city csv databases got completely different formats so you have to provide different bunches of arguments to process it.

For country database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat working.csv 

For city database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat -t 
GEOIP_CITY_EDITION_REV1 -l working-locations.csv working-blocks.csv 

As for csv2dat.py - looks like you are trying to execute Python 2 script with Python 3 interpreter. Try:

python2.7 csv2dat.py -w custom_geoip.dat mmcountry working.csv 

share|improve this answer

edited Nov 30 '16 at 8:02

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This looks like the perfect answer but when I run it I get /usr/lib/geoip/geoip-generator:GeoLite2-City-Blocks-IPv4.csv:2: Wrong number of fields. Any ideas what the fields should be for this to work? The fields I have are 'network geoname_id, registered_country_geoname_id, represented_country_geoname_id, is_anonymous_proxy, is_satellite_provider, postal_code, latitude, longitude, accuracy_radius' as per the latest geolite city download.
  
  – H2ONOCK
  Jan 19 at 9:27
  

  
  
  
  

add a comment | 

geoip-csv-to-dat.cpp - is the part of geoip-bin package and could be installed from Debian or Ubuntu repository if it is your linux distributive.

apt-get install geoip-bin
/usr/lib/geoip/geoip-generator --help

UPDATE:
digging into the source uncovered that maxmind country and city csv databases got completely different formats so you have to provide different bunches of arguments to process it.

For country database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat working.csv 

For city database:

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat -t 
GEOIP_CITY_EDITION_REV1 -l working-locations.csv working-blocks.csv 

As for csv2dat.py - looks like you are trying to execute Python 2 script with Python 3 interpreter. Try:

python2.7 csv2dat.py -w custom_geoip.dat mmcountry working.csv 

share|improve this answer

edited Nov 30 '16 at 8:02

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

apt-get install geoip-bin
/usr/lib/geoip/geoip-generator --help

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat working.csv 

/usr/lib/geoip/geoip-generator -v -o custom_geoip.dat -t 
GEOIP_CITY_EDITION_REV1 -l working-locations.csv working-blocks.csv 

python2.7 csv2dat.py -w custom_geoip.dat mmcountry working.csv 

share|improve this answer

edited Nov 30 '16 at 8:02

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365

answered Nov 29 '16 at 13:33

Alexander KlimenkoAlexander Klimenko

1365