http://qs321.pair.com?node_id=11118486


in reply to Re^12: Help with Geo::IP output
in thread Help with Geo::IP output

Ensure you have DBD::SQLite installed (cpan DBD::SQLite or cpanm DBD::SQLite), ensure your maxmind licence key is valid and listed in the config file, from the command line run:

geoip --fetch --DB=dbi:SQLite:dbname=geoip.db

The program will create a new database called geoip.db, create the required schema and populate it with the data from maxmind.

Replies are listed 'Best First'.
Re^14: Help with Geo::IP output
by Anonymous Monk on Jun 25, 2020 at 07:23 UTC

    Ok I'm getting close.

    I created a directory called "dat" (/home/user/dat) and ran the command from the "dat" directory. I got the error message:

    geoip --fetch --DB=dbi:SQLite:dbname=geoip.db No license key in config file Issuing rollback() due to DESTROY without explicit disconnect() of DBD +::SQLite::db handle dbname=geoip.db at /home/user/perl5/bin/geoip lin +e 229

    So I went to get my license key and wrote the two lines in a file and saved it as geoip.rc (as well as geoip):

    license-id : myID icense-key : MyLicenseKey

    Then I uploaded geoip.rc to "/home/" and ran the command. I got the same error message. I tried uploading "geoip" (which is the same as geoip.rc) to "/home/.config" and ran the geoip command again.

    Still the same thing. Where should I place the config file (geoip.rc) and are my two lines sufficient?

      The documentation shows you $home not /home, but to avoid confusion:

      echo $HOME /home/marto

      Copy this config file in the home directory of the user running the script.

        I made three files "geoip.rc", ".geoiprc" and "geoip" all containing the same two lines of licence ID and license key in the format prescribed and uploaded respectively to:

        /home/user/geoip.rc /home/user/.geoiprc /home/me/.config/geoip

        I'm still getting the same thing. I see geoip.db created in the "/home/user/dat" directory where I ran the geoip command. Do I have to run the geoip command at "/home/user"?

        I'm not a paid user of Maxmind - signed up as a free user. Is that why my license key is not recognised?