Fast way to deploy ttrss on OpenShift

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
who_me
Bear Rating Trainee
Bear Rating Trainee
Posts: 10
Joined: 14 Mar 2013, 21:47

Fast way to deploy ttrss on OpenShift

Postby who_me » 17 Mar 2013, 22:10

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.

cautiousgiant
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 17 Mar 2013, 23:50

Re: Fast way to deploy ttrss on OpenShift

Postby cautiousgiant » 17 Mar 2013, 23:52

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

cautiousgiant
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 17 Mar 2013, 23:50

Re: Fast way to deploy ttrss on OpenShift

Postby cautiousgiant » 18 Mar 2013, 00:09

Ah, never mind. I see there is an hourly update script in the cron folder. Thanks!

who_me
Bear Rating Trainee
Bear Rating Trainee
Posts: 10
Joined: 14 Mar 2013, 21:47

Re: Fast way to deploy ttrss on OpenShift

Postby who_me » 18 Mar 2013, 02:24

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

extrem101
Bear Rating Trainee
Bear Rating Trainee
Posts: 4
Joined: 20 Mar 2013, 04:20

Re: Fast way to deploy ttrss on OpenShift

Postby extrem101 » 20 Mar 2013, 04:25

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.

who_me
Bear Rating Trainee
Bear Rating Trainee
Posts: 10
Joined: 14 Mar 2013, 21:47

Re: Fast way to deploy ttrss on OpenShift

Postby who_me » 20 Mar 2013, 14:37

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.

dimon222
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 20 Mar 2013, 18:54

Re: Fast way to deploy ttrss on OpenShift

Postby dimon222 » 20 Mar 2013, 19:01

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?

dimon222
Bear Rating Trainee
Bear Rating Trainee
Posts: 9
Joined: 20 Mar 2013, 18:54

Re: Fast way to deploy ttrss on OpenShift

Postby dimon222 » 21 Mar 2013, 04:02

viewtopic.php?p=5805#p5805 - Solution for problem with cron updates.

flyingben
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 28 Mar 2013, 13:49

Re: Fast way to deploy ttrss on OpenShift

Postby flyingben » 28 Mar 2013, 13:58

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 ?

jicama
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 30 Mar 2013, 06:44

Re: Fast way to deploy ttrss on OpenShift

Postby jicama » 30 Mar 2013, 06:46

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'.

gasche
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 01 Apr 2013, 11:01

Re: Fast way to deploy ttrss on OpenShift

Postby gasche » 01 Apr 2013, 11:08

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.
Last edited by gasche on 02 Apr 2013, 16:26, edited 1 time in total.

nathan
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 01 Apr 2013, 18:59

Re: Fast way to deploy ttrss on OpenShift

Postby nathan » 01 Apr 2013, 19:10

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

dzl
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 02 Apr 2013, 08:08

Re: Fast way to deploy ttrss on OpenShift

Postby dzl » 02 Apr 2013, 08:11

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(-)
[ddcphilg@flyingdog 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://515a551e5973ca89e3000181@tinytinyrss-xxxxxxxxxx.rhcloud.com/~/git/tinytinyrss.git/
   c1817fa..33c663e  HEAD -> master

gasche
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 01 Apr 2013, 11:01

Re: Fast way to deploy ttrss on OpenShift

Postby gasche » 02 Apr 2013, 16:28

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.

nathan
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 01 Apr 2013, 18:59

Re: Fast way to deploy ttrss on OpenShift

Postby nathan » 05 Apr 2013, 03:42

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?


Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 1 guest