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


in reply to Help with Geo::IP output

Quite surprised there's no easy way. I couldn't use App::geoip because of the error below:

FATAL:  no pg_hba.conf entry for host "[local]", user "xxx", database "geoip", SSL off

While I have MySQL, I have never used PostgreSQL and I'm not familiar with it.

Replies are listed 'Best First'.
Re^2: Help with Geo::IP output
by marto (Cardinal) on Jun 24, 2020 at 15:24 UTC

    There is an easy way, use SQLite, see DATABASE linked from from dsn which I linked previously. You need to read the documentation for the tool.

    Update: typo, dns/dsn. Thanks Your Mother.

      The App::geoip page doesn't explain how to use it with SQLite. Ir only says it works with SQLite.

        dsn: "If the connection works, the tables used by this tool will be created if not yet present."

        Provide a working connection, the tool does literally everything else for you.