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
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
The config file (geoip.rc) wasn't read because of permission. It was 644 but it must be 600 - sought help from the hosting.
I finally managed to create the geoip.gb file with the total size of 510,100,144 (someone posted this size too) so I think the db is complete. I say this because when I ran the --fetch command, there was no success message when it ended:
In the create example you provided a dsn, which worked. When you ran it again you didn't so the program has no idea where to look (you didn't tell it, and haven't got an entry in your config file), and once again, the default is Pg. Just add the dsn to your config file.