[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
Re: [tor-bugs] #21277 [Internal Services/Tor Sysadmin Team]: Please set up a new PostgreSQL database called webstats on meronense
#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
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs