[tor-bugs] #21277 [Internal Services/Tor Sysadmin Team]: Please set up a new PostgreSQL database called webstats on meronense

[Tor Bug Tracker & Wiki]

#21277: Please set up a new PostgreSQL database called webstats on meronense
-------------------------------------------------+-------------------------
 Reporter:  karsten                              |          Owner:  tpa
     Type:  task                                 |         Status:
                                                 |  reopened
 Priority:  Medium                               |      Milestone:
Component:  Internal Services/Tor Sysadmin Team  |        Version:
 Severity:  Normal                               |     Resolution:
 Keywords:                                       |  Actual Points:
Parent ID:                                       |         Points:
 Reviewer:                                       |        Sponsor:
-------------------------------------------------+-------------------------
Changes (by karsten):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 Hmm, I see the database and can connect to it using `psql`, but connecting
 via JDBC doesn't work.  Apparently, the issue is that JDBC connections
 always happen via TCP/IP, not Unix-domain sockets.

 Can you update `pg_hba.conf` and put in a line like this (please triple-
 check -- untested)?

 {{{
 host all metrics 127.0.0.1/32 ident
 }}}

 Here's some context what we're using this database for: twice per day,
 we're fetching new logs from `webstats.torproject.org`, importing them
 into the database, extracting statistics from the database, and storing
 those statistics to a local `.csv` file.

 We're ''not'' accessing the database via some web server running under the
 `metrics` user.  It's just used locally.  (This is the case for all
 database on this host, which is why I wrote `all` in the line above.)

 Hope that helps for risk assessment.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/21277#comment:2>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online