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:
user@myhost ~]$ geoip --fetch --DB=dbi:SQLite:dbname=geoip.db
2020-06-22 19:16:39 4689345 GeoLite2-ASN-CSV.zip
304 2020-06-22 19:16:39 4689345 GeoLite2-ASN-CSV.zip
2020-06-16 11:13:32 1805947 GeoLite2-Country-CSV.zip
304 2020-06-16 11:13:32 1805947 GeoLite2-Country-CSV.zip
2020-06-16 11:19:50 41827687 GeoLite2-City-CSV.zip
304 2020-06-16 11:19:50 41827687 GeoLite2-City-CSV.zip
Reading City info ...
Reading City IPv4 info ..
user@myhost ~]$
So I thought I should be able to run the command below now that the geoip.db is set up:
[user@myhost ~]$ geoip -w 103.2.106.33
FATAL: no pg_hba.conf entry for host "[local]", user "user", database
+ "geoip", SSL off
Cannot continue without a working database
What am I still missing?
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|