Ttrss-docker: setup on clean system fails

cybernoid76 · October 27, 2020, 9:31am

Hi,
I try to install the ttrss-docker stuff on a freshly installed machine, so no old containers, volumes or images present. I followed the README.md closely, .env looks like this:
POSTGRES_USER=postgres POSTGRES_PASSWORD=password OWNER_UID=1000 OWNER_GID=1000 HTTP_HOST=localhost SELF_URL_PATH=https://news.vpn.cybernoia.de/tt-rss HTTP_PORT=127.0.0.1:8280

I get only http 404 when requesting anything. During first start I see the following messages. Is that missing relation error maybe a problem? (I don’t post the full log here because I’m not allowed to attach files, but I have it available).

app_1 | cloning plugins.local/nginx_xaccel…
app_1 | Cloning into ‘/var/www/html/tt-rss/plugins.local/nginx_xaccel’… app_1 | ERROR: relation “ttrss_version” does not exist app_1 | LINE 1: select * from ttrss_version
app_1 | ^
db_1 | 2020-10-26 22:16:39.039 UTC [55] ERROR: relation “ttrss_version” does not exist at character 15
db_1 | 2020-10-26 22:16:39.039 UTC [55] STATEMENT: select * from ttrss_version
app_1 | NOTICE: table “ttrss_error_log” does not exist, skipping app_1 | NOTICE: table “ttrss_plugin_storage” does not exist, skipping

Several other tables are skipped as well.
Thanks in advance!

fox · October 27, 2020, 11:06am

if this happens on first run, no, because the database is empty and needs to be initialized. if it happens every time it might mean a database problem. this is extremely unlikely to happen though.

however, database problem would not cause a http 404 error. a misconfigured reverse proxy (or simply wrong URL) would.

accessing what exactly? also, check docker-compose logs.

cybernoid76 · October 27, 2020, 12:12pm

Well, I tried to access the SELF_URL_PATH, because that should work in any case I think?
Ok, I’m one step further as I agree there is a problem with the reverse proxy (traefik in my case), because I see absolutely nothing in the ttrss logs when requesting a page. As a quick try therefore I circumvented the reverse proxy and connected ttrss to a real port, without any SSL, the .env is now:
‘
HTTP_HOST=www.cybernoia.de
HTTP_PORT=8280
SELF_URL_PATH=http://www.cybernoia.de:8280/tt-rss
‘
The ttrss log shows now:
‘
web_1 | 27/Oct/2020:12:00:30 +0000 [ERROR 502 /tt-rss/] dial tcp: lookup app on 127.0.0.11:53: no such host
web_1 | 192.168.112.1 - - [27/Oct/2020:12:00:30 +0000] “GET /tt-rss/ HTTP/1.1” 502 16
‘

fox · October 27, 2020, 12:19pm

i have a policy of not helping people who just try things randomly until something sticks without any attempt to think or understand what’s going on.

you decided to put something in HTTP_HOST that your container can’t resolve. there was no reason to change it but you did.

anyway, good luck.

e: web container doesn’t even use HTTP_HOST. i honestly have no idea what you’re doing.

one cause for 50x error would be repository failing to clone unless you use docker hub images. see docker-compose logs.

cybernoid76 · October 27, 2020, 1:51pm

Obviously I misunderstood the meaning of HTTP_HOST then, sorry. Turning it back to localhost doesn’t change anything though, same error message on request. I saw no error messages when building/starting the containers.

fox · October 27, 2020, 2:20pm

you should see a lot of logs from the app container, is it running? docker-compose ps etc.

example:

tt-rss:ttrss-docker-demo (master):$ docker-compose ps
                  Name                                Command               State                     Ports
-----------------------------------------------------------------------------------------------------------------------------
ttrss-docker-demo_app_1_b97e1b8d484c       /bin/sh -c /startup.sh           Up      9000/tcp
ttrss-docker-demo_backups_1_8d01c3cd0e59   /dcron.sh -f                     Up      9000/tcp
ttrss-docker-demo_db_1_6ea878f4da9c        docker-entrypoint.sh postgres    Up      5432/tcp
ttrss-docker-demo_updater_1_2c494e382dbb   /updater.sh                      Up      9000/tcp
ttrss-docker-demo_web_1_295f56927c19       /bin/parent caddy --conf / ...   Up      127.0.0.1:8280->2015/tcp, 443/tcp, 80/tcp

cybernoid76 · October 27, 2020, 3:10pm

According to docker-compose ps it is running and I also see it’s normal startup messages in the log, but on request it remains silent. Just the two lines from the web container, nothing else.
ttrss- /bin/sh -c Up 9000/tcp docker_app_1 /startup.sh

fox · October 27, 2020, 3:53pm

i dunno, problem with docker networking? try entering shell in one container, pinging another, stuff like that. those should all be accessible by name.

cybernoid76 · October 31, 2020, 1:59pm

Yes! Indeed, docker networking contained a typo so the containers couldn’t see each other. I fixed the typo, removed all containers/images/volumes because obviously sth. during initialization already went wrong because of my misconfiguration and then I could finally log in. On the way I also fixed my proxy problem, so I have access over SSL now as it should be. Many thanks so far!

The next problem is that the Android client doesn’t want to connect. API access is enabled for the user. On the server, there is only the http 405 error from the web container, nothing at all from the app container. Here is the Android app’s log:

10-31 14:51:32.192 29165 29165 D setupWidgetUpdates: interval= 900000
10-31 14:51:32.189 29165 29165 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@3e67360
10-31 14:51:32.153 29165 29165 I Surface : opservice is null false
10-31 14:51:30.399 29165 29165 V FlingOptimizerScroller: FlingOptimizerOverScroller Init
10-31 14:51:22.225 29165 29165 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:51:22.194 29165 29182 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@80a36ec[PreferencesActivity]
10-31 14:51:22.185 29165 29165 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:51:22.157 29165 29165 D setupWidgetUpdates: interval= 900000
10-31 14:51:22.156 29165 29165 D PreferencesActivity: setting theme to: THEME_FOLLOW_DEVICE
10-31 14:51:22.154 29165 29165 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@b40e26e
10-31 14:51:20.094 29165 29203 D ApiCommon: HTTP response code: 405
10-31 14:51:19.980 29165 29165 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:51:19.978 29165 29165 D OnlineActivity: license apk found
10-31 14:51:19.954 29165 29193 D : Successfully load libgui-plugin.so, this=0x7421e2f050
10-31 14:51:19.949 29165 29193 W Gralloc3: mapper 3.x is not supported
10-31 14:51:19.939 29165 29193 I AdrenoGLES: PFP: 0x016ee187, ME: 0x00000000
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Build Config : S P 8.0.8 AArch64
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Reconstruct Branch : NOTHING
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Remote Branch : NONE
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Remote Branch : refs/tags/AU_LINUX_ANDROID_LA.UM.8.1.R1.09.00.00.529.074
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Local Branch :
10-31 14:51:19.937 29165 29193 I AdrenoGLES: OpenGL ES Shader Compiler Version: EV031.27.02.00
10-31 14:51:19.937 29165 29193 I AdrenoGLES: Build Date : 08/28/19
10-31 14:51:19.937 29165 29193 I AdrenoGLES: QUALCOMM build : bc92c36, I9e73322269
10-31 14:51:19.936 29165 29182 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@41b53bd[OnlineActivity]
10-31 14:51:19.928 29165 29203 D NetworkSecurityConfig: Using Network Security Config from resource network_security_config debugBuild: false
10-31 14:51:19.928 29165 29165 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:51:19.919 29165 29165 D OnlineActivity: intent action=null
10-31 14:51:19.915 29165 29165 D OnlineActivity: m_isOffline=false
10-31 14:51:19.894 29165 29165 D setupWidgetUpdates: interval= 900000
10-31 14:51:19.893 29165 29165 D OnlineActivity: setting theme to: THEME_FOLLOW_DEVICE
10-31 14:51:19.890 29165 29165 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@40094f0
10-31 14:51:19.885 29165 29192 E Perf : getFolderSize() : Exception_1 = java.lang.NullPointerException: Attempt to get length of null array
10-31 14:51:19.885 29165 29192 E Perf : Fail to get file list oat
10-31 14:51:19.885 29165 29192 E Perf : getFolderSize() : Exception_1 = java.lang.NullPointerException: Attempt to get length of null array
10-31 14:51:19.885 29165 29192 E Perf : Fail to get file list org.fox.ttrss
10-31 14:51:19.885 29165 29192 E Perf : getFolderSize() : Exception_1 = java.lang.NullPointerException: Attempt to get length of null array
10-31 14:51:19.885 29165 29192 E Perf : Fail to get file list org.fox.ttrss
10-31 14:51:19.856 29165 29165 V Font : Default family:android.graphics.Typeface@6d2038de
10-31 14:51:19.856 29165 29165 V Font : Change font:1
10-31 14:51:19.855 29165 29165 I org.fox.ttrss: [GL_OOM] ClampGrowthLimit 268435456
10-31 14:51:19.854 29165 29165 I Perf : Connecting to perf service.
10-31 14:51:19.821 29165 29165 E org.fox.ttrss: Not starting debugger since process cannot load the jdwp agent.
10-31 14:51:07.135 27505 27505 D PreferencesActivity: onTrimMemory called
10-31 14:51:07.135 27505 27505 D OnlineActivity: onTrimMemory called
10-31 14:51:03.653 27505 27525 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@7472342[PreferencesActivity]
10-31 14:50:41.529 27505 27505 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:50:41.517 27505 27525 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@364c318[LogcatActivity]
10-31 14:50:41.509 27505 27505 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:50:41.415 27505 27505 D setupWidgetUpdates: interval= 900000
10-31 14:50:41.412 27505 27505 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@4e8d9f6
10-31 14:50:39.757 27505 27505 I Surface : opservice is null false
10-31 14:50:39.347 27505 27505 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:50:39.331 27505 27582 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@7472342[PreferencesActivity]
10-31 14:50:39.323 27505 27505 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:50:39.298 27505 27505 D setupWidgetUpdates: interval= 900000
10-31 14:50:39.294 27505 27505 D PreferencesActivity: setting theme to: THEME_FOLLOW_DEVICE
10-31 14:50:39.291 27505 27505 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@68f001b
10-31 14:50:37.718 27505 27540 D ApiCommon: HTTP response code: 405
10-31 14:50:37.584 27505 27582 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@41b53bd[OnlineActivity]
10-31 14:50:37.559 27505 27505 I Surface : opservice is null false
10-31 14:50:36.015 27505 27582 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@db7ecf5[PreferencesActivity]
10-31 14:50:35.996 27505 27530 D OpenGLRenderer: endAllActiveAnimators on 0x738e6e7600 (RippleDrawable) with handle 0x738e9fd1c0
10-31 14:50:33.712 27505 27505 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:50:33.705 27505 27582 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@ffcf9d1[PreferencesActivity]
10-31 14:50:33.688 27505 27505 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:50:28.673 27505 27505 W Choreographer: Already have a pending vsync event. There should only be one at a time.
10-31 14:50:28.648 27505 27582 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@db7ecf5[PreferencesActivity]
10-31 14:50:28.641 27505 27505 V ViewRootImpl: The specified message queue synchronization barrier token has not been posted or has already been removed
10-31 14:50:28.616 27505 27505 D setupWidgetUpdates: interval= 900000
10-31 14:50:28.616 27505 27505 D PreferencesActivity: setting theme to: THEME_FOLLOW_DEVICE
10-31 14:50:28.614 27505 27505 W ActivityThread: handleWindowVisibility: no activity for token android.os.BinderProxy@1981d0c
10-31 14:50:27.190 27505 27540 D ApiCommon: HTTP response code: 405
10-31 14:50:27.056 27505 27522 D DecorView: onWindowFocusChangedFromViewRoot hasFocus: true, DecorView@41b53bd[OnlineActivity]
10-31 14:48:41.448 27505 28110 W System : A resource failed to call response.body().close().
--------- beginning of main