Having database problems with tt-rss installation

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
Tehlanie
Bear Rating Trainee
Bear Rating Trainee
Posts: 18
Joined: 26 Jun 2013, 04:49

Having database problems with tt-rss installation

Postby Tehlanie » 22 Aug 2015, 05:06


JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Having database problems with tt-rss installation

Postby JustAMacUser » 22 Aug 2015, 05:28

Does this help?


Tehlanie
Bear Rating Trainee
Bear Rating Trainee
Posts: 18
Joined: 26 Jun 2013, 04:49

Re: Having database problems with tt-rss installation

Postby Tehlanie » 22 Aug 2015, 05:34

No,unfortunately, it doesn't. I had tried this method to using both local and hos like so:
local ttrssdb postgres md5
host ttrssdb postgres md5

I also tried all instead of ttrssdb.

After restarting postgresql, I still get the same checking configuration errors, in my original post. I also tried creating a ttrss user, and adding the same lines above with the user as ttrss instead of postgres. Still is not working. I still receive the following message:

Unable to connect to database using specified parameters.

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Having database problems with tt-rss installation

Postby JustAMacUser » 22 Aug 2015, 05:49

PostgreSQL is a little different with privileges than something like MySQL. I don't have a lot of experience with it (PostgreSQL) but the log you originally posted is basically telling you: You're trying to connect to ttrssdb as the user www-data but I'm only allowing user postgres to access it.

If you read through that link I sent you, and the following (Next) page, it explains how to gives users access or re-map usernames.

At the end of the day, the default setup for PostgreSQL is to give access to system users (e.g. root, postgres, www-data, etc.). So you create your database with its owner being www-data if you want the web server to have access to it. Or, you can map users (e.g. you could map the user www-data to postgres). Or, you can go with password-based authentication.

The key with the pg_hba.conf file is that the order the line items appear in is very important. Once a match is found, it stops looking. Make sure you're putting the password line items first.

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: Having database problems with tt-rss installation

Postby AngryChris » 22 Aug 2015, 10:09

Also note that you must restart the database whenever you make changes to pg_hba.conf to make those changes effective.

Tehlanie
Bear Rating Trainee
Bear Rating Trainee
Posts: 18
Joined: 26 Jun 2013, 04:49

Re: Having database problems with tt-rss installation

Postby Tehlanie » 23 Aug 2015, 23:16


User avatar
pahles
Bear Rating Disaster
Bear Rating Disaster
Posts: 50
Joined: 20 Mar 2013, 17:02

Re: Having database problems with tt-rss installation

Postby pahles » 24 Aug 2015, 00:26

I use Ubuntu 14.04 and Postgresql 9.3, using a dedicated user for the tt-rss database. I have local all all md5 in pg_hba.conf. I have not touched pg_ident.conf.

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Having database problems with tt-rss installation

Postby JustAMacUser » 24 Aug 2015, 01:00


User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Having database problems with tt-rss installation

Postby sleeper_service » 24 Aug 2015, 01:47

http://www.postgresql.org/message-id/20 ... anford.edu

http://www.postgresql.org/docs/devel/st ... -maps.html

the map=ttrss looks to be on target.

or use trust instead of peer
what's your DB_USER and DB_HOST and DB_NAME ?


Return to “Support”

Who is online

Users browsing this forum: No registered users and 13 guests