OnlyOffice compiled with Mobile Edit Back

quentingrap · August 7, 2020, 8:29am

Hello !

I have the same issue at the moment… also have this “Cannot GET /”
I’m no good at handling docker container so I may have made some mistakes.

Here is my config at the moment

With docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
47945a52b387 nemskiller007/officeunleashed “bash /entrypoint.sh” 17 minutes ago Up 15 minutes 0.0.0.0:8000->80/tcp exciting_bassi

And my nginx conf with letsencrypt :

nginx conf

upstream docservice {
server MYDOMAIN:8000;
}

map $http_host $this_host {
“” $host;
default $http_host;
}

map $http_x_forwarded_proto $the_scheme {
default $http_x_forwarded_proto;
“” $scheme;
}

map $http_x_forwarded_host $the_host {
default $http_x_forwarded_host;
“” $this_host;
}

map $http_upgrade $proxy_connection {
default upgrade;
“” close;
}

proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection $proxy_connection;
proxy_set_header X-Forwarded-Host $the_host;
proxy_set_header X-Forwarded-Proto $the_scheme;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

server {
server_tokens off;
server_name MYDOMAIN;
location / {
proxy_pass http://docservice;
proxy_http_version 1.1;
}

listen 0.0.0.0:80;
listen [::]:80;
server_name MYDOMAIN;

listen [::]:443 ssl ipv6only=on; # managed by Certbot
listen 443 ssl; # managed by Certbot
ssl_certificate /etc/letsencrypt/live/MYDOMAIN/fullchain.pem; # managed by Certbot
ssl_certificate_key /etc/letsencrypt/live/MYDOMAIN/privkey.pem; # managed by Certbot
include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

}

Thanks for any help and thank you for the work already done !

dev0 · August 7, 2020, 9:11am

what is the result of docker logs <containerid> ?

quentingrap · August 7, 2020, 9:16am

Here is the docker logs : https://framabin.org/p/?a8d0215323a027fb#R1doVvK4JD/6OKggk8ljOKVcZ05oTw9+/A+/+uOPT4s=

Just the errors here :

Starting PostgreSQL 10 database server * Removed stale pid file.
Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start -D /var/lib/postgresql/10/main -l /var/log/postgresql/postgresql-10-main.log -s -o -c config_file="/etc/postgresql/10/main/postgresql.conf" exited with status 1:
2020-08-07 08:04:46.242 UTC [31] LOG: listening on IPv4 address “127.0.0.1”, port 5432
2020-08-07 08:04:46.242 UTC [31] LOG: could not bind IPv6 address “::1”: Cannot assign requested address
2020-08-07 08:04:46.242 UTC [31] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2020-08-07 08:04:46.330 UTC [31] LOG: listening on Unix socket “/var/run/postgresql/.s.PGSQL.5432”
2020-08-07 08:04:46.500 UTC [32] LOG: database system was interrupted; last known up at 2020-07-08 08:10:22 UTC
pg_ctl: server did not start in time
[fail]
Starting RabbitMQ Messaging Server rabbitmq-server [ OK ]
Starting nginx nginx [ OK ]
ERROR: database “onlyoffice” already exists
ERROR: role “onlyoffice” already exists
GRANT
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:20: NOTICE: relation “doc_changes” already exists, skipping
CREATE TABLE
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:36: NOTICE: relation “task_result” already exists, skipping
CREATE TABLE
CREATE FUNCTION
mkdir: cannot create directory ‘fonts’: File exists
Starting PostgreSQL 10 database server [ OK ]
Starting RabbitMQ Messaging Server rabbitmq-server [ OK ]
Starting nginx nginx [ OK ]
ERROR: database “onlyoffice” already exists
ERROR: role “onlyoffice” already exists
GRANT
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:20: NOTICE: relation “doc_changes” already exists, skipping
CREATE TABLE
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:36: NOTICE: relation “task_result” already exists, skipping
CREATE TABLE
CREATE FUNCTION
mkdir: cannot create directory ‘fonts’: File exists

and

Starting PostgreSQL 10 database server [ OK ]
Starting RabbitMQ Messaging Server rabbitmq-server [ OK ]
Starting nginx nginx [ OK ]
ERROR: database “onlyoffice” already exists
ERROR: role “onlyoffice” already exists
GRANT
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:20: NOTICE: relation “doc_changes” already exists, skipping
CREATE TABLE
psql:/out/linux_64/onlyoffice/documentserver/server/schema/postgresql/createdb.sql:36: NOTICE: relation “task_result” already exists, skipping
CREATE TABLE
CREATE FUNCTION
mkdir: cannot create directory ‘fonts’: File exists
root@47945a52b387:/out/linux_64/onlyoffice/documentserver/server/DocService# [2020-08-07T08:42:45.991] [WARN] nodeJS - start cluster with 1 workers

Nemskiller · August 7, 2020, 9:28am

This answer is correct.
You should try
https://office.mydomain.tld/healthcheck
Tell me the result

quentingrap · August 7, 2020, 9:29am

This answer is true !

Nemskiller · August 7, 2020, 9:31am

Your onlyoffice docker server works.
Did you mod it like my how to ask for password ?

If yes now you can go to your Nextcloud and type https://office.mydomain.fr/ and the secret password and apply

quentingrap · August 7, 2020, 9:32am

Ok i tried to connect to my Nextcloud and it works
I just have to try to have more than 20 connections !
Edit : it woooorks

Sorry, i didn’t even try before asking…

quentingrap · August 7, 2020, 9:37am

So it’s normal not having the site “Document Server is running”
Can we know how many connections there is at the same time ?? (it tested with one open document and it written on top right but if I want to know all connections)

dev0 · August 7, 2020, 10:22am

@Nemskiller what do you think about my version with the local.json?

create a file outside with:

{
  "services": {
    "CoAuthoring": {
      "sql": {
        "type": "postgres",
        "dbHost": "localhost",
        "dbPort": "5432",
        "dbName": "onlyoffice",
        "dbUser": "onlyoffice",
        "dbPass": "onlyoffice"
      },
      "redis": {
        "host": "localhost"
      },
      "token": {
        "enable": {
          "request": {
            "inbox": true,
            "outbox": true
          },
          "browser": true
        },
        "inbox": {
          "header": "Authorization"
        },
        "outbox": {
          "header": "Authorization"
        }
      },
      "secret": {
        "inbox": {
          "string": "TOKEN"
        },
        "outbox": {
          "string": "TOKEN"
        },
        "session": {
          "string": "TOKEN"
        }
      }
    }
  },
  "rabbitmq": {
    "url": "amqp://guest:guest@localhost"
  }
}

then when you deploy the new image just do a
docker cp local.json <CID>:/out/linux_64/onlyoffice/documentserver/server/Common/config/local.json

reboot, done.

fabiobarbosa · August 7, 2020, 11:51am

I believe it is something silly. I recompiled version 5.6.0 of OO, it took about 4 hours. I made all the settings that are described on the official OO website and this message occurs.

Nemskiller · August 7, 2020, 12:17pm

They dropped the Welcome home page screen since 2 versions.
Now you get welcomed with an error message. Nice.
That why the /healthcheck URL is important

fabiobarbosa · August 7, 2020, 12:22pm

then an OO welcome screen will no longer appear? I put http: // my-ip / healthcheck and the answer was true, does it mean it’s working?
follows a server screen

fabiobarbosa · August 7, 2020, 12:34pm

To test the connections, go to nextcloud / owncloud, with the administrator and the user in the settings where you can run OO, and uncheck the option “open file in the same tab” and save. after opening files in your nextcloud / ownlcloud and see if you can open more than 20. if a message does not occur and you are still able to edit 21 or 22 open files is working.

Nemskiller · August 7, 2020, 12:34pm

Yes to all your questions.
@fabiobarbosa Be conscious that the version you compiled will have the unlimited connections (100 - 200 - 500 the number you put) but won’t have the ability to edit files if you are using :
A tablet, a smartphone or using the NextCloud app on those devices.

fabiobarbosa · August 7, 2020, 12:37pm

you are my hero. in the “thesis” managed to compile version 5.6 of OO. Now I will install the certificates and try to see if my next cloud will be accessed without further problems.

fabiobarbosa · August 7, 2020, 12:40pm

It’s ok. i really need to edit documents within the nextcloud web. I don’t need editing on mobile devices, like tablets or smartphones. I put only 150 connections that I believe is enough

Nemskiller · August 7, 2020, 12:41pm

For the SSL it’s really easier to use Proxy with Nginx or Apache.
Really simple to renew certs with letsencrypt then

fabiobarbosa · August 7, 2020, 12:45pm

would you have a link with a step by step how I can do it this way? As I am learning to deal with OO, a lot is new to me and it would be a great help if you could help me with this setup. I’ve been trying to compile for about 15 days, first I got its docker, but as I don’t have much knowledge, I couldn’t get it to work, so I decided to compile it on a pure server (I don’t know if you understood) OO and with great difficulty and I got help from everyone.

Nemskiller · August 7, 2020, 12:57pm

Re-read the first comment on this topic.
I speak about Nginx Proxy. If you use apache so you will have to google apache proxy for OnlyOffice

Nemskiller · August 7, 2020, 3:59pm

@dev0 i will look at then i will upload the upgrade to 5.6.0.
It can make the how to more quicker to follow.