Converting GeoLite2 data for use with xtables geoip
My apologies if this has been covered here or elsewhere. I read the postings back to 2016.
My debian system stopped updating the xtables geoip database. On investigation it developed that this is because Maxmind dropped support for legacy GeoIP databases. I have got as far as installing and configuring Maxmind's geoipupdate program for the GeoLite2 database and scheduling it weekly in crontab.
At this point I am stumped. geoipupdate returns a .mmdb database. This is not usable by the debian-supplied scripts which convert .CSV files to the country code files in /usr/share/xt_geoip/LE and /usr/share/xt_geoip/BE.
The debian package xtables-addons has not been updated to deal with this situation.
Assistance or a pointer to a solution will be gratefully received. At present I am still using the last valid database which is now getting to be over six months old.
geoip maxmind
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
add a comment |
My apologies if this has been covered here or elsewhere. I read the postings back to 2016.
My debian system stopped updating the xtables geoip database. On investigation it developed that this is because Maxmind dropped support for legacy GeoIP databases. I have got as far as installing and configuring Maxmind's geoipupdate program for the GeoLite2 database and scheduling it weekly in crontab.
At this point I am stumped. geoipupdate returns a .mmdb database. This is not usable by the debian-supplied scripts which convert .CSV files to the country code files in /usr/share/xt_geoip/LE and /usr/share/xt_geoip/BE.
The debian package xtables-addons has not been updated to deal with this situation.
Assistance or a pointer to a solution will be gratefully received. At present I am still using the last valid database which is now getting to be over six months old.
geoip maxmind
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
add a comment |
My apologies if this has been covered here or elsewhere. I read the postings back to 2016.
My debian system stopped updating the xtables geoip database. On investigation it developed that this is because Maxmind dropped support for legacy GeoIP databases. I have got as far as installing and configuring Maxmind's geoipupdate program for the GeoLite2 database and scheduling it weekly in crontab.
At this point I am stumped. geoipupdate returns a .mmdb database. This is not usable by the debian-supplied scripts which convert .CSV files to the country code files in /usr/share/xt_geoip/LE and /usr/share/xt_geoip/BE.
The debian package xtables-addons has not been updated to deal with this situation.
Assistance or a pointer to a solution will be gratefully received. At present I am still using the last valid database which is now getting to be over six months old.
geoip maxmind
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
My apologies if this has been covered here or elsewhere. I read the postings back to 2016.
My debian system stopped updating the xtables geoip database. On investigation it developed that this is because Maxmind dropped support for legacy GeoIP databases. I have got as far as installing and configuring Maxmind's geoipupdate program for the GeoLite2 database and scheduling it weekly in crontab.
At this point I am stumped. geoipupdate returns a .mmdb database. This is not usable by the debian-supplied scripts which convert .CSV files to the country code files in /usr/share/xt_geoip/LE and /usr/share/xt_geoip/BE.
The debian package xtables-addons has not been updated to deal with this situation.
Assistance or a pointer to a solution will be gratefully received. At present I am still using the last valid database which is now getting to be over six months old.
geoip maxmind
geoip maxmind
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
asked Jan 20 at 15:24
GoGoCrashGoGoCrash
283
283
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Have a look at GeoLite2xtables :-
https://github.com/mschmitt/GeoLite2xtables
You can download a zip (or git clone).
It has example workflow (shell commands) for legacy GeoLite CSV (which is probably what you have which stopped working in early Jan 2019) and GeoLite2 CSV (which you can use instead).
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54277943%2fconverting-geolite2-data-for-use-with-xtables-geoip%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Have a look at GeoLite2xtables :-
https://github.com/mschmitt/GeoLite2xtables
You can download a zip (or git clone).
It has example workflow (shell commands) for legacy GeoLite CSV (which is probably what you have which stopped working in early Jan 2019) and GeoLite2 CSV (which you can use instead).
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
add a comment |
Have a look at GeoLite2xtables :-
https://github.com/mschmitt/GeoLite2xtables
You can download a zip (or git clone).
It has example workflow (shell commands) for legacy GeoLite CSV (which is probably what you have which stopped working in early Jan 2019) and GeoLite2 CSV (which you can use instead).
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
add a comment |
Have a look at GeoLite2xtables :-
https://github.com/mschmitt/GeoLite2xtables
You can download a zip (or git clone).
It has example workflow (shell commands) for legacy GeoLite CSV (which is probably what you have which stopped working in early Jan 2019) and GeoLite2 CSV (which you can use instead).
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
Have a look at GeoLite2xtables :-
https://github.com/mschmitt/GeoLite2xtables
You can download a zip (or git clone).
It has example workflow (shell commands) for legacy GeoLite CSV (which is probably what you have which stopped working in early Jan 2019) and GeoLite2 CSV (which you can use instead).
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
answered Jan 24 at 0:57
David KeegelDavid Keegel
513
513
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
add a comment |
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
That looks like it should do the job. Surprising that this issue has not been called out in many, many other places as I have to believe that xtables geoip is in use at a lot of sites.
– GoGoCrash
Jan 24 at 16:50
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54277943%2fconverting-geolite2-data-for-use-with-xtables-geoip%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
