[Libreoffice-bugs] [Bug 126110] New: Collabora online/code docker - owncloud refused to connect cURL error 7

Wed Jun 26 12:55:38 UTC 2019

https://bugs.documentfoundation.org/show_bug.cgi?id=126110

            Bug ID: 126110
           Summary: Collabora online/code docker - owncloud refused to
                    connect cURL error 7
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: barker at bluewin.ch

Description:
First posting here. Unsure if right place but my usual OwnCloud
(https://central.owncloud.org/t/) forum has nothing relevant 

NextCloud is reporting similar error
(https://help.nextcloud.com/t/why-might-collabora-code-docker-image-not-be-responding-to-http-s/52818)
is unresolved but it doesn't seem to be concerning OC/NC rather a
collabora/CODE docker setup error.

Initially I setup collabora server as app on Ubuntu 18.04 using this guide
https://www.collaboraoffice.com/code/#getting_set_up, but couldn't get it to
accept https (owncloud server) to http (collabora).

So I setup collabora using docker instead as per above collabora instructions,
but kept getting "cURL error 7: Failed to connect to 192.168.1.106 port 9980:
Connection refused" from owncloud.

SETUP (two servers machines on LAN)
A. Owncloud https server 10.0.3 on Raspbian 4.1471-v7 with Apache/2.4.25 with
10.1.37-MariaDB-0+deb9u1 - Raspbian 9.0

B. Ubuntu 18.04.2 LibreOffice server with Docker Collabora/code:latest  and
tried 4.0.1.1

OUTPUT on collabora docker server

ab at acer:~$ docker ps
CONTAINER ID        IMAGE                    COMMAND                  CREATED  
          STATUS              PORTS                      NAMES
26e783f9cc14        collabora/code:4.0.1.1   "/bin/sh -c 'bash st…"   About an
hour ago   Up 12 seconds       127.0.0.1:9980->9980/tcp   collabora

ab at acer:~$ curl -vk https://127.0.0.1:9980 
* Rebuilt URL to: https://127.0.0.1:9980/
*   Trying 127.0.0.1...
* TCP_NODELAY set
* Connected to 127.0.0.1 (127.0.0.1) port 9980 (#0)
* ALPN, offering h2
* ALPN, offering http/1.1
* successfully set certificate verify locations:
*   CAfile: /etc/ssl/certs/ca-certificates.crt
  CApath: /etc/ssl/certs
* (304) (OUT), TLS handshake, Client hello (1):
* OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to 127.0.0.1:9980 
* Closing connection 0
curl: (35) OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to
127.0.0.1:9980 

ab at acer:~$ docker logs collabora | grep SSL
wsd-00029-00029 2019-06-26 09:48:22.063852 [ loolwsd ] INF  SSL support: SSL is
enabled.| wsd/LOOLWSD.cpp:987
wsd-00029-00029 2019-06-26 09:48:23.812395 [ loolwsd ] INF  SSL Cert file:
/etc/loolwsd/cert.pem| wsd/LOOLWSD.cpp:1169
wsd-00029-00029 2019-06-26 09:48:23.812626 [ loolwsd ] INF  SSL Key file:
/etc/loolwsd/key.pem| wsd/LOOLWSD.cpp:1172
wsd-00029-00029 2019-06-26 09:48:23.812888 [ loolwsd ] INF  SSL CA file:
/etc/loolwsd/ca-chain.cert.pem| wsd/LOOLWSD.cpp:1175
wsd-00029-00029 2019-06-26 09:48:23.813115 [ loolwsd ] INF  SSL Cipher list: |
wsd/LOOLWSD.cpp:1178
wsd-00029-00029 2019-06-26 09:52:45.055432 [ loolwsd ] INF  SSL support: SSL is
enabled.| wsd/LOOLWSD.cpp:987
wsd-00029-00029 2019-06-26 09:52:46.807582 [ loolwsd ] INF  SSL Cert file:
/etc/loolwsd/cert.pem| wsd/LOOLWSD.cpp:1169
wsd-00029-00029 2019-06-26 09:52:46.807827 [ loolwsd ] INF  SSL Key file:
/etc/loolwsd/key.pem| wsd/LOOLWSD.cpp:1172
wsd-00029-00029 2019-06-26 09:52:46.808063 [ loolwsd ] INF  SSL CA file:
/etc/loolwsd/ca-chain.cert.pem| wsd/LOOLWSD.cpp:1175
wsd-00029-00029 2019-06-26 09:52:46.808278 [ loolwsd ] INF  SSL Cipher list: |
wsd/LOOLWSD.cpp:1178
wsd-00029-00029 2019-06-26 10:51:24.188710 [ loolwsd ] INF  SSL support: SSL is
enabled.| wsd/LOOLWSD.cpp:987
wsd-00029-00029 2019-06-26 10:51:25.999395 [ loolwsd ] INF  SSL Cert file:
/etc/loolwsd/cert.pem| wsd/LOOLWSD.cpp:1169
wsd-00029-00029 2019-06-26 10:51:25.999631 [ loolwsd ] INF  SSL Key file:
/etc/loolwsd/key.pem| wsd/LOOLWSD.cpp:1172
wsd-00029-00029 2019-06-26 10:51:25.999847 [ loolwsd ] INF  SSL CA file:
/etc/loolwsd/ca-chain.cert.pem| wsd/LOOLWSD.cpp:1175
wsd-00029-00029 2019-06-26 10:51:26.000038 [ loolwsd ] INF  SSL Cipher list: |
wsd/LOOLWSD.cpp:1178

I've tried editing the Apache reverse proxy with several variants as proposed
by  collabora, adding IPs to /etc/hosts, disabling UFW, allowing docker0 onto
UFW and editing the loolwsd.xml inside the container with variants proposed in
collabora setup.

I guess I'm missing something simple but could anyone confirm if there is a
bug?
Andrew

Steps to Reproduce:
1. launch collabora docker
ab at acer:~$ docker run -t -d -p 127.0.0.1:9980:9980 -e
"domain=awsbarker.ddns.net"   --name collabora --cap-add MKNOD --restart always
collabora/code

2. Click 'office' in owncloud 
Collabora Online: Cannot connect to the host "https://192.168.1.106:9980".

Please ask your administrator to check the Collabora Online server setting. The
exact error message was: cURL error 7: Failed to connect to 192.168.1.106 port
9980: Connection refused

3. check collabora status
ab at acer:~$ curl -k https://127.0.0.1:9980 
curl: (35) OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to
127.0.0.1:9980 

Actual Results:
owncloud fails to connect to collabora server

Expected Results:
owncloud connect to collabora server

Reproducible: Always

User Profile Reset: No

Additional Info:
ii  libreoffice-common             1:6.0.7-0ubuntu0.18. all                 
office productivity suite -- arch-independent files
ii  libreoffice-core               1:6.0.7-0ubuntu0.18. amd64               
office productivity suite -- arch-dependent file

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190626/d35aa16d/attachment.html>