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


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

geoip -Ddsn dbi:SQLite:geoip -w 103.2.106.33

That's not how to specify the DSN on the command line.

$ geoip -Ddbi:SQLite:geoip -w 103.2.106.33

might get you farther but since you haven't detailed how you created the database, who can say?

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

    I have never used SQLite so I'm totally new to it. At the command line, I entered:

    $ sqlite3 geoip SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .save geoip.db Error: unknown command or invalid arguments: "save". Enter ".help" fo +r help sqlite> .quit

    The command .save doesn't work so it seems I can't create a database.

      You first said:

      I created an SQLite database named "geoip"

      and now you've said:

      The command .save doesn't work so it seems I can't create a database.

      I think you ought to spend just a little time to find out which of these statements is true because they can't both be.