New user here: I tried to find an opensource-friendly solution for leaving Google Reader, and am trying this OpenShift setup.
I had the problem reported above: "Unable to connect to database (as to , database ttrss):"
I connected in SSH to the app instance, and using
Code: Select all
cat ~/postgresql-8.4/data/pg_log/postgresql-*.log
I had output like
Code: Select all
ERROR: relation "ttrss_feeds" does not exist at character 183
STATEMENT: SELECT ttrss_feeds.feed_url,ttrss_feeds.id, ttrss_feeds.owner_uid,
SUBSTRING_FOR_DATE(ttrss_feeds.last_updated,1,19) AS last_updated,
ttrss_feeds.update_interval
FROM
...
which indicates that the database setup did not work properly.
The workaround I found is, still in the SSH session, to run
Code: Select all
psql -f ~/app-root/repo/php/schema/ttrss_schema_pgsql.sql
Which will setup the database. The app now appears to work fine (haven't tried to import my feeds yet, but at least I can access the website).
I'm not sure why this setup step wasn't performed automatically during the setup / first start process.