Page 1 of 2

Fast way to deploy ttrss on OpenShift

Posted: 17 Mar 2013, 22:10
by who_me
My weekend project is done. I wanted a fast way to deploy ttrss to OpenShift and I got it. I was inspired by this fellow and his git repo:

https://github.com/lulinqing/tiny_tiny_rss-openshift-quickstart

So here is my github hosted repo with polished deployment :)

https://github.com/who-me/ttrss-fast-deployment

Short instructions are on the page, scroll towards the bottom.

Features Tiny Tiny RSS 1.7.4 and modification to backend.php to allow people to set feed updates to 5 minutes. Enjoy.

Thanks to the nice people that spotted the workarounds to the issues with environment variables on Open Shift.

Re: Fast way to deploy ttrss on OpenShift

Posted: 17 Mar 2013, 23:52
by cautiousgiant
Thanks very much for taking the time to set this up!

I've got TTRSS up and running on Openshift, but I'm not seeing any feed updates. I've imported my OPML file and set updates to every five minutes, but so far no feeds show any content.

Do I need to do something extra to get the cron job up and running? If so, what?

Thanks!

cg

Re: Fast way to deploy ttrss on OpenShift

Posted: 18 Mar 2013, 00:09
by cautiousgiant
Ah, never mind. I see there is an hourly update script in the cron folder. Thanks!

Re: Fast way to deploy ttrss on OpenShift

Posted: 18 Mar 2013, 02:24
by who_me
It should work like this:

- if you're logged in via the web interface, feeds should update at whatever the interval is set in the prefs. The script will also run, hourly, but there should be no toe stepping :)
- if you're logged off, then the script will update the feeds hourly

Re: Fast way to deploy ttrss on OpenShift

Posted: 20 Mar 2013, 04:25
by extrem101
nice work.

but for some reason in my Cartridge (PHP 5.3) i had to change the getenv('OPENSHIFT_...') in the config file to $_ENV['OPENSHIFT_....']
Just mentioning it if someone else also has the problem that the network connection doesn't work right out of the box.

i don't know why i got this older php version? some internet sources say that getenv is definitely the new and right method to get the variables in openshift.

Re: Fast way to deploy ttrss on OpenShift

Posted: 20 Mar 2013, 14:37
by who_me
Yeah, seems to be an issue with how some of their "nodes" are configured. During the time I was testing my repo (haven't used git before) I created and then deleted at least 10 applications. All of the worked out of the box with files pulled from that git repo. I'm thinking I'll just write a script to generate config.php on the fly. That way I don't have to mess with php config weirdness.

Re: Fast way to deploy ttrss on OpenShift

Posted: 20 Mar 2013, 19:01
by dimon222
Auto-update is not working even with opened browser, even with hourly cron script.
What could be problem in? I changed update options in prefs, but still nothing. It works manually though.
Can it be related to existing some red (error) feeds?

Re: Fast way to deploy ttrss on OpenShift

Posted: 21 Mar 2013, 04:02
by dimon222
viewtopic.php?p=5805#p5805 - Solution for problem with cron updates.

Re: Fast way to deploy ttrss on OpenShift

Posted: 28 Mar 2013, 13:58
by flyingben
Hi whoe_me, thanks a lot for your effort!
But I followed those steps and got "Unable to connect to database (as to , database ttrss):" when I tried to visit my ttrss. Do you have any idea about this ?

Re: Fast way to deploy ttrss on OpenShift

Posted: 30 Mar 2013, 06:46
by jicama
flyingben wrote:But I followed those steps and got "Unable to connect to database (as to , database ttrss):" when I tried to visit my ttrss. Do you have any idea about this ?


Try doing 'rhc app start'.

Re: Fast way to deploy ttrss on OpenShift

Posted: 01 Apr 2013, 11:08
by gasche
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.

Re: Fast way to deploy ttrss on OpenShift

Posted: 01 Apr 2013, 19:10
by nathan
gasche wrote: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 ~/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.

Thanks for your help. However, I also got this problem, and the exact same error as you. However, the command you provided gave me this error when I tried to use it with PuTTY.

Code: Select all

psql: FATAL:  database "/var/lib/openshift/51573a35e0b8cd1e1a000059//app-root/repo/php/" does not exist


For some reason, this happens even if I browse directly to the directory listed and try executing the command (Without the directory of course) and still getting the message. Even when I can see the database is physically there. Anyone here with the same problem? Or help? This worked before, but now it won't while I'm setting up a second instance for a friend.

By the way, If I navigate to the directory, it gives me this error:

Code: Select all

psql: FATAL:  database "ttrss_schema_pgsql.sql" does not exist


Even though LS proves otherwise.

Code: Select all

[ttrss-nathanm.rhcloud.com schema]\> ls
ttrss_schema_mysql.sql  ttrss_schema_pgsql.sql  versions

Re: Fast way to deploy ttrss on OpenShift

Posted: 02 Apr 2013, 08:11
by dzl
I manually edited the config.php file and commited/pushed the changes with git, and that looks to have kicked off some git-commit-hooks that fixed my database problems.

Code: Select all

$ git commit -m "manual db config"
[master 33c663e] manual db config
 1 files changed, 10 insertions(+), 5 deletions(-)
[[email protected] php]$ git push
Counting objects: 7, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (4/4), done.
Writing objects: 100% (4/4), 481 bytes, done.
Total 4 (delta 3), reused 0 (delta 0)
remote: restart_on_add=false
remote: Waiting for stop to finish
remote: Done
remote: restart_on_add=false
remote: Running .openshift/action_hooks/pre_build
remote: Running .openshift/action_hooks/build
remote: Running .openshift/action_hooks/deploy
remote: hot_deploy_added=false
remote: PostgreSQL server instance already running
remote: Done
remote: Running .openshift/action_hooks/post_deploy
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:1: NOTICE:  table "ttrss_plugin_storage" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:2: NOTICE:  table "ttrss_linked_feeds" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:3: NOTICE:  table "ttrss_linked_instances" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:4: NOTICE:  table "ttrss_access_keys" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:5: NOTICE:  table "ttrss_user_labels2" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:6: NOTICE:  table "ttrss_labels2" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:7: NOTICE:  table "ttrss_feedbrowser_cache" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:8: NOTICE:  table "ttrss_version" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:9: NOTICE:  table "ttrss_labels" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:10: NOTICE:  table "ttrss_filters2_rules" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:11: NOTICE:  table "ttrss_filters2_actions" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:12: NOTICE:  table "ttrss_filters2" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:13: NOTICE:  table "ttrss_filters" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:14: NOTICE:  table "ttrss_filter_types" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:15: NOTICE:  table "ttrss_filter_actions" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:16: NOTICE:  table "ttrss_user_prefs" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:17: NOTICE:  table "ttrss_prefs" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:18: NOTICE:  table "ttrss_prefs_types" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:19: NOTICE:  table "ttrss_prefs_sections" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:20: NOTICE:  table "ttrss_tags" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:21: NOTICE:  table "ttrss_enclosures" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:22: NOTICE:  table "ttrss_settings_profiles" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:23: NOTICE:  table "ttrss_entry_comments" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:24: NOTICE:  table "ttrss_user_entries" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:25: NOTICE:  table "ttrss_entries" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:26: NOTICE:  table "ttrss_scheduled_updates" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:27: NOTICE:  table "ttrss_counters_cache" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:28: NOTICE:  table "ttrss_cat_counters_cache" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:29: NOTICE:  table "ttrss_archived_feeds" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:30: NOTICE:  table "ttrss_feeds" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:31: NOTICE:  table "ttrss_feed_categories" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:32: NOTICE:  table "ttrss_users" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:33: NOTICE:  table "ttrss_themes" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:34: NOTICE:  table "ttrss_sessions" does not exist, skipping
remote: DROP TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:35: NOTICE:  function substring_for_date(pg_catalog.timestamp,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
remote: DROP FUNCTION
remote: BEGIN
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:51: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_users_id_seq" for serial column "ttrss_users.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:51: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_users_pkey" for table "ttrss_users"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:51: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_users_login_key" for table "ttrss_users"
remote: CREATE TABLE
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:61: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_feed_categories_id_seq" for serial column "ttrss_feed_categories.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:61: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_feed_categories_pkey" for table "ttrss_feed_categories"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:93: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_feeds_id_seq" for serial column "ttrss_feeds.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:93: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_feeds_pkey" for table "ttrss_feeds"
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: INSERT 0 1
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:108: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_archived_feeds_pkey" for table "ttrss_archived_feeds"
remote: CREATE TABLE
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE TABLE
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:142: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_entries_id_seq" for serial column "ttrss_entries.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:142: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_entries_pkey" for table "ttrss_entries"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:142: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_entries_guid_key" for table "ttrss_entries"
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:163: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_user_entries_int_id_seq" for serial column "ttrss_user_entries.int_id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:163: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_user_entries_pkey" for table "ttrss_user_entries"
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:175: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_entry_comments_id_seq" for serial column "ttrss_entry_comments.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:175: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_entry_comments_pkey" for table "ttrss_entry_comments"
remote: CREATE TABLE
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:182: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filter_types_pkey" for table "ttrss_filter_types"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:182: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_filter_types_name_key" for table "ttrss_filter_types"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:182: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_filter_types_description_key" for table "ttrss_filter_types"
remote: CREATE TABLE
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:197: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filter_actions_pkey" for table "ttrss_filter_actions"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:197: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_filter_actions_name_key" for table "ttrss_filter_actions"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:197: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_filter_actions_description_key" for table "ttrss_filter_actions"
remote: CREATE TABLE
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:231: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_filters_id_seq" for serial column "ttrss_filters.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:231: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filters_pkey" for table "ttrss_filters"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:236: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_filters2_id_seq" for serial column "ttrss_filters2.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:236: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filters2_pkey" for table "ttrss_filters2"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:244: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_filters2_rules_id_seq" for serial column "ttrss_filters2_rules.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:244: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filters2_rules_pkey" for table "ttrss_filters2_rules"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:249: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_filters2_actions_id_seq" for serial column "ttrss_filters2_actions.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:249: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_filters2_actions_pkey" for table "ttrss_filters2_actions"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:254: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_tags_id_seq" for serial column "ttrss_tags.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:254: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_tags_pkey" for table "ttrss_tags"
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: CREATE TABLE
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:268: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_enclosures_id_seq" for serial column "ttrss_enclosures.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:268: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_enclosures_pkey" for table "ttrss_enclosures"
remote: CREATE TABLE
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:274: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_settings_profiles_id_seq" for serial column "ttrss_settings_profiles.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:274: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_settings_profiles_pkey" for table "ttrss_settings_profiles"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:277: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_prefs_types_pkey" for table "ttrss_prefs_types"
remote: CREATE TABLE
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:285: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_prefs_sections_pkey" for table "ttrss_prefs_sections"
remote: CREATE TABLE
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:298: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_prefs_pkey" for table "ttrss_prefs"
remote: CREATE TABLE
remote: CREATE INDEX
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: INSERT 0 1
remote: UPDATE 8
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE INDEX
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:422: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_sessions_pkey" for table "ttrss_sessions"
remote: CREATE TABLE
remote: CREATE INDEX
remote: CREATE FUNCTION
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:432: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_feedbrowser_cache_pkey" for table "ttrss_feedbrowser_cache"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:439: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_labels2_id_seq" for serial column "ttrss_labels2.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:439: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_labels2_pkey" for table "ttrss_labels2"
remote: CREATE TABLE
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:450: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_access_keys_id_seq" for serial column "ttrss_access_keys.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:450: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_access_keys_pkey" for table "ttrss_access_keys"
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:457: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_linked_instances_id_seq" for serial column "ttrss_linked_instances.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:457: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_linked_instances_pkey" for table "ttrss_linked_instances"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:457: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "ttrss_linked_instances_access_key_key" for table "ttrss_linked_instances"
remote: CREATE TABLE
remote: CREATE TABLE
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:472: NOTICE:  CREATE TABLE will create implicit sequence "ttrss_plugin_storage_id_seq" for serial column "ttrss_plugin_storage.id"
remote: psql:/var/lib/openshift/515a551e5973ca89e3000181/app-root/runtime/repo/php/schema/ttrss_schema_pgsql.sql:472: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ttrss_plugin_storage_pkey" for table "ttrss_plugin_storage"
remote: CREATE TABLE
remote: COMMIT
To ssh://[email protected]/~/git/tinytinyrss.git/
   c1817fa..33c663e  HEAD -> master

Re: Fast way to deploy ttrss on OpenShift

Posted: 02 Apr 2013, 16:28
by gasche
nathan > my mistake! the correct command-line was not

Code: Select all

psql ~/app-root/repo/php/schema/ttrss_schema_pgsql.sql


but

Code: Select all

psql -f ~/app-root/repo/php/schema/ttrss_schema_pgsql.sql


passing the `-f` option means that the argument is a file to interpret, not the database to use (the installation script correctly set the default database in my case).

Sorry for the typo, that's the problem when you reconstruct instructions from memory *after* having used them. I edited my first message to avoid leading other readers astray.

Re: Fast way to deploy ttrss on OpenShift

Posted: 05 Apr 2013, 03:42
by nathan
Thanks for the reply. However, the updater plugin will not work. I enabled it via config.php, but I''m just getting a blank window when I'm trying to update. Has anyone here had success with the updater plugin working?