search

ONLYOFFICE / onlyoffice-nextcloud

The app which enables the users to edit office documents from Nextcloud using ONLYOFFICE Document Server, allows multiple users to collaborate in real time and to save back those changes to Nextcloud
GNU Affero General Public License v3.0
558 stars 157 forks source link

Not able to connect with Document Server #166

Open ejgutierrez74 opened 4 years ago

ejgutierrez74 commented 4 years ago

Related to #161

Ive been working in a different approach...Bjut stills doesnt work... Two different virtual machines in my local computer, ubuntu 18.4. ping between machines works ok. Both using virtualbox on bridge mode. Document Server 5.4.1 Nextcloud 16.0.4 and now 17.0.1 Both machines using nginx in Ubuntu 18.04

One virtual mahine with Nextcloud 16.0.4 and now updated to 17.0.1, both failing... Nextcloud works ok, installed and enable Onlyoffice integration app. Error: Log level 0 of nextcloud:

eduardo@eduardo-VirtualBox:~$ sudo tail -30 /var/log/nextcloud16.log [sudo] contraseña para eduardo: 

{"reqId":"JJ5jdXRw7A4gHJfUNMLT","level":0,"time":"November 17, 2019 16:45:11","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.1.39\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"JJ5jdXRw7A4gHJfUNMLT","level":3,"time":"November 17, 2019 16:45:11","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":1,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":1,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/192.168.1.51\/localhost\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":1,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: http:\/\/onlyoffice.eduardo.com\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":1,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":1,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":0,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.1.39\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"aL6MBJzRJ1ANlDS0QcHH","level":3,"time":"November 17, 2019 16:45:14","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":1,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":1,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/192.168.1.51\/l\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":1,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: http:\/\/onlyoffice.eduardo.com\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":1,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":1,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":0,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.1.39\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"6MNibMB8cHF7OaAMg2Ga","level":3,"time":"November 17, 2019 16:45:24","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":1,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":1,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/192.168.1.51\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":1,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: http:\/\/onlyoffice.eduardo.com\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":1,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":1,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":0,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.1.39\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"uT6zzmuYTksST1c8AAYU","level":3,"time":"November 17, 2019 16:45:25","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":1,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":1,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/192.168.1.51\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":1,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":1,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":1,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":0,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.1.39\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}
{"reqId":"lAJtgpKx1anQSXDFRYLM","level":3,"time":"November 17, 2019 16:50:22","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/index.php\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:70.0) Gecko\/20100101 Firefox\/70.0","version":"17.0.1.1"}

Then i have another virtual machine with Document Server runnig ok, with http and https in localhost self-signed SSL using openssl imagen

Here many logs on Document Server: https://pastebin.com/qnT1u5eL

I also configured the config.php with 'onlyoffice' => array ( 'verify_peer_off' => true )

Any help would be apreciated. I ideally would like to have both Document server and nextcloud in same virtual machine as declared in #611

alexanderonlyoffice commented 4 years ago

@ejgutierrez74, according to the logs Document Server cannot connect to PostgreSQL database:

[2019-11-17T17:50:22.199] [ERROR] nodeJS - sqlQuery error sqlCommand: INSERT INTO task_result (id, status, status_info, : error: permission denied for relation task_result

The reason is in lack of permissions. Please specify the installation guide you used to deploy Document Server.

ejgutierrez74 commented 4 years ago

@alexanderonlyoffice I suppose it wouldnt run and give an error in Document server, and as you can see it works without problems.

I have tested and i have postgres, rabbit and redis active and running....

eduardo@eduardo-VirtualBox:~$ sudo systemctl status rabbitmq-server.service 

[sudo] contraseña para eduardo: 
● rabbitmq-server.service - RabbitMQ Messaging Server
   Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor 
   Active: active (running) since Mon 2019-11-18 10:24:57 CET; 6min ago
  Process: 1257 ExecStartPost=/usr/lib/rabbitmq/bin/rabbitmq-server-wait (code=e
 Main PID: 1256 (rabbitmq-server)
    Tasks: 92 (limit: 4680)
   CGroup: /system.slice/rabbitmq-server.service
           ├─1256 /bin/sh /usr/sbin/rabbitmq-server
           ├─1380 /bin/sh /usr/lib/rabbitmq/bin/rabbitmq-server
           ├─1738 /usr/lib/erlang/erts-9.2/bin/epmd -daemon
           ├─2297 /usr/lib/erlang/erts-9.2/bin/beam.smp -W w -A 64 -P 1048576 -t
           ├─2456 erl_child_setup 65536
           ├─4818 inet_gethost 4
           └─4821 inet_gethost 4

nov 18 10:24:41 eduardo-VirtualBox systemd[1]: Starting RabbitMQ Messaging Serve
nov 18 10:24:49 eduardo-VirtualBox rabbitmq[1257]: Waiting for 'rabbit@eduardo-V
nov 18 10:24:49 eduardo-VirtualBox rabbitmq[1257]: pid is 1380
nov 18 10:24:57 eduardo-VirtualBox systemd[1]: Started RabbitMQ Messaging Server
eduardo@eduardo-VirtualBox:~$ sudo systemctl status redis
● redis-server.service - Advanced key-value store
   Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor pre
   Active: active (running) since Mon 2019-11-18 10:24:42 CET; 6min ago
     Docs: http://redis.io/documentation,
           man:redis-server(1)
  Process: 1254 ExecStart=/usr/bin/redis-server /etc/redis/redis.conf (code=exit
 Main PID: 1370 (redis-server)
    Tasks: 4 (limit: 4680)
   CGroup: /system.slice/redis-server.service
           └─1370 /usr/bin/redis-server 127.0.0.1:6379

nov 18 10:24:41 eduardo-VirtualBox systemd[1]: Starting Advanced key-value store
nov 18 10:24:42 eduardo-VirtualBox systemd[1]: redis-server.service: Can't open 
nov 18 10:24:42 eduardo-VirtualBox systemd[1]: Started Advanced key-value store.
eduardo@eduardo-VirtualBox:~$ sudo systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese
   Active: active (exited) since Mon 2019-11-18 10:24:46 CET; 6min ago
  Process: 2383 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
 Main PID: 2383 (code=exited, status=0/SUCCESS)

nov 18 10:24:46 eduardo-VirtualBox systemd[1]: Starting PostgreSQL RDBMS...
nov 18 10:24:46 eduardo-VirtualBox systemd[1]: Started PostgreSQL RDBMS.

I hva followed the official tutorial on onlyoffice: https://helpcenter.onlyoffice.com/server/linux/document/linux-installation.aspx till Rebuilding spellchecker (Ubuntu 18.04) that i couldnt get it and ive opened an issue.... I didnt change the port, as im in other machine.

Also make self-signed cerftificate using openssl and this guide adpated to ubuntu 18.04: https://helpcenter.onlyoffice.com/server/linux/document/switch-to-https.aspx I must add that i thi

ejgutierrez74 commented 4 years ago

orry but actually the github issue is https://github.com/ONLYOFFICE/onlyoffice-nextcloud/issues/166

as my first idea was putting all in the same server, i didnt get it to work, so i decided to put NC in one machine and DS in other machine. Just in case to make it clearier i attach a schema/draw:

Here more configs ( nginx of both machines) Summarizing: in ds, both http and https works with nginx ok, and get in browser the welcome message In NC i redirect all the address to https://nextcloud.eduardo.com -> nextcloud works well -> install onlyoffice-nextcloud app -> try to make the connection .> connection fails.

You would find plenty of information of logs in that issue.... any extra things you need....we can continue in that issue if you agree.

This is my last post where they told me the problem is in document server side.

Obvious i have shut down and boot many times both virtual machines.

Wget https://nextcloud.eduardo.com 😉 ( from DS virtual machine who has 192.168.1.51 to NC virtual machine who has 192.168.1.52

eduardo@eduardo-VirtualBox:~$ wget https://nextcloud.eduardo.com
--2019-12-13 10:24:51--  https://nextcloud.eduardo.com/
Resolviendo nextcloud.eduardo.com (nextcloud.eduardo.com)... 192.168.1.52
Conectando con nextcloud.eduardo.com (nextcloud.eduardo.com)[192.168.1.52]:443... conectado.
ERROR: no se puede verificar el certificado de nextcloud.eduardo.com, emitido por “emailAddress=edufissure@msn.com,CN=192.168.1.52,OU=Informatica,O=Almata,L=Balaguer,ST=Lleida,C=ES”:
  Se encontró un certificado autofirmado.
    ERROR: el nombre común “192.168.1.52” del certificado no encaja con el nombre de equipo “nextcloud.eduardo.com” solicitado.
Para conectar inseguramente a nextcloud.eduardo.com, use `--no-check-certificate'.

Wget https://onlyoffice.eduardo.com 😉 ( from NC virtual machine who has 192.168.1.52 to DS virtual machine who has 192.168.1.51

eduardo@eduardo-VirtualBox:~$ wget https://onlyoffice.eduardo.com
--2019-12-13 10:26:54--  https://onlyoffice.eduardo.com/
Resolviendo onlyoffice.eduardo.com (onlyoffice.eduardo.com)... 192.168.1.51
Conectando con onlyoffice.eduardo.com (onlyoffice.eduardo.com)[192.168.1.51]:443... conectado.
ERROR: no se puede verificar el certificado de onlyoffice.eduardo.com, emitido por “emailAddress=edufissure@msn.com,CN=192.168.1.51,OU=Informatica,O=Almata,L=Balaguer,ST=Lleida,C=ES”:
  Se encontró un certificado autofirmado.
    ERROR: el nombre común “192.168.1.51” del certificado no encaja con el nombre de equipo “onlyoffice.eduardo.com” solicitado.
Para conectar inseguramente a onlyoffice.eduardo.com, use `--no-check-certificate'.

Wget https://onlyoffice.eduardo.com 😉 ( from NC virtual machine who has 192.168.1.52 to DS virtual machine who has 192.168.1.51 avoid check certificate

eduardo@eduardo-VirtualBox:~$ wget https://onlyoffice.eduardo.com --no-check-certificate
--2019-12-13 10:27:23--  https://onlyoffice.eduardo.com/
Resolviendo onlyoffice.eduardo.com (onlyoffice.eduardo.com)... 192.168.1.51
Conectando con onlyoffice.eduardo.com (onlyoffice.eduardo.com)[192.168.1.51]:443... conectado.
AVISO: no se puede verificar el certificado de onlyoffice.eduardo.com, emitido por “emailAddress=edufissure@msn.com,CN=192.168.1.51,OU=Informatica,O=Almata,L=Balaguer,ST=Lleida,C=ES”:
  Se encontró un certificado autofirmado.
    AVISO: el nombre común “192.168.1.51” del certificado no encaja con el nombre de equipo “onlyoffice.eduardo.com” solicitado.
Petición HTTP enviada, esperando respuesta... 302 Moved Temporarily
Ubicación: https://onlyoffice.eduardo.com/welcome/ [siguiente]
--2019-12-13 10:27:23--  https://onlyoffice.eduardo.com/welcome/
Reutilizando la conexión con onlyoffice.eduardo.com:443.
Petición HTTP enviada, esperando respuesta... 200 OK
Longitud: 4592 (4,5K) [text/html]
Guardando como: “index.html.5”

index.html.5    100%[=====>]   4,48K  --.-KB/s    en 0s      

2019-12-13 10:27:23 (602 MB/s) - “index.html.5” guardado [4592/4592]

Finally my nextcloud.log when trying to connect using onlyoffice app to document server ( tried both 192.168.1.51 and https://onlyoffice.eduardo.com

{"reqId":"eLnEy23zVVgedDB5TQQN","level":0,"time":"December 13, 2019 10:19:35","remoteAddr":"192.168.1.51","user":"--","app":"core","method":"GET","url":"\/ocs\/v2.php\/core\/navigation\/apps?absolute=true&format=json","message":{"Exception":"OC\\AppFramework\\Middleware\\Security\\Exceptions\\NotLoggedInException","Message":"Current user is not logged in","Code":401,"Trace":[{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Middleware\/MiddlewareDispatcher.php","line":95,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\Security\\SecurityMiddleware","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":98,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\MiddlewareDispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/App.php","line":126,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\NavigationController","getAppsNavigation",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"file":"\/usr\/share\/nginx\/nextcloud16\/ocs\/v1.php","line":82,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/ocsapp\/core\/navigation\/apps"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/ocs\/v2.php","line":24,"args":["\/usr\/share\/nginx\/nextcloud16\/ocs\/v1.php"],"function":"require_once"}],"File":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Middleware\/Security\/SecurityMiddleware.php","Line":143,"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (Linux) mirall\/2.6.1git (Nextcloud)","version":"16.0.6.1"}
{"reqId":"pKYkTmftuI0bo4mKkH26","level":0,"time":"December 13, 2019 10:19:35","remoteAddr":"192.168.1.51","user":"--","app":"core","method":"GET","url":"\/ocs\/v2.php\/core\/navigation\/apps?absolute=true&format=json","message":{"Exception":"OC\\AppFramework\\Middleware\\Security\\Exceptions\\NotLoggedInException","Message":"Current user is not logged in","Code":401,"Trace":[{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Middleware\/MiddlewareDispatcher.php","line":95,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\Security\\SecurityMiddleware","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":98,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\MiddlewareDispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/App.php","line":126,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\NavigationController"},"getAppsNavigation"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\NavigationController","getAppsNavigation",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"file":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"ocs.core.Navigation.getAppsNavigation"}]},{"file":"\/usr\/share\/nginx\/nextcloud16\/ocs\/v1.php","line":82,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/ocsapp\/core\/navigation\/apps"]},{"file":"\/usr\/share\/nginx\/nextcloud16\/ocs\/v2.php","line":24,"args":["\/usr\/share\/nginx\/nextcloud16\/ocs\/v1.php"],"function":"require_once"}],"File":"\/usr\/share\/nginx\/nextcloud16\/lib\/private\/AppFramework\/Middleware\/Security\/SecurityMiddleware.php","Line":143,"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (Linux) mirall\/2.6.1git (Nextcloud)","version":"16.0.6.1"}
{"reqId":"cIgXca3iGVmRQHDOx3v5","level":0,"time":"December 13, 2019 10:32:02","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OC\\Log\\Rotate job with ID 20","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"cIgXca3iGVmRQHDOx3v5","level":0,"time":"December 13, 2019 10:32:02","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OC\\Log\\Rotate job with ID 20 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"C9pVkLaMqbLGv0ly3evk","level":0,"time":"December 13, 2019 10:32:08","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OC\\Preview\\BackgroundCleanupJob job with ID 21","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"C9pVkLaMqbLGv0ly3evk","level":0,"time":"December 13, 2019 10:32:08","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OC\\Preview\\BackgroundCleanupJob job with ID 21 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"RnQ1nNMH6SyI7GaD8bRC","level":0,"time":"December 13, 2019 10:32:15","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OCA\\Federation\\SyncJob job with ID 1","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"RnQ1nNMH6SyI7GaD8bRC","level":0,"time":"December 13, 2019 10:32:15","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OCA\\Federation\\SyncJob job with ID 1 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"7auiIgAUBnfFuasr1mgj","level":0,"time":"December 13, 2019 10:32:25","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OCA\\NextcloudAnnouncements\\Cron\\Crawler job with ID 3","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"7auiIgAUBnfFuasr1mgj","level":0,"time":"December 13, 2019 10:32:26","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OCA\\NextcloudAnnouncements\\Cron\\Crawler job with ID 3 in 1 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"hV46YqCPnHjAFpQi8vXH","level":0,"time":"December 13, 2019 10:32:29","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OCA\\UpdateNotification\\Notification\\BackgroundJob job with ID 4","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"hV46YqCPnHjAFpQi8vXH","level":0,"time":"December 13, 2019 10:32:30","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OCA\\UpdateNotification\\Notification\\BackgroundJob job with ID 4 in 1 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":1,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":1,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/192.168.1.51\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":1,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":1,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":1,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":0,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.2.46\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"kPXNjavxhuASfbKS12OY","level":3,"time":"December 13, 2019 10:32:34","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":1,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":1,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/onlyoffice.eduardo.com\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":1,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":1,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":1,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":0,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.2.46\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"H4cmvfrFDDwlKRkA1wZP","level":3,"time":"December 13, 2019 10:33:06","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":1,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Select demo: false","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":1,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerUrl: https:\/\/onlyoffice.eduardo.com\/","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":1,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetDocumentServerInternalUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":1,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"Clear secret key","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":1,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"SetStorageUrl: ","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":0,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"CommandRequest on check: {\"error\":0,\"version\":\"5.4.2.46\"}","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"qhBHzvEuGY27SQPjXDGB","level":3,"time":"December 13, 2019 10:33:09","remoteAddr":"127.0.0.1","user":"nextcloudadmin","app":"onlyoffice","method":"PUT","url":"\/apps\/onlyoffice\/ajax\/settings\/address","message":"GetConvertedUri on check error: Se ha producido un error en el servicio de documentos: Unknown error","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"YealrdZobDPq2ArWFYyh","level":0,"time":"December 13, 2019 10:33:25","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OCA\\Files_Sharing\\DeleteOrphanedSharesJob job with ID 5","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"YealrdZobDPq2ArWFYyh","level":0,"time":"December 13, 2019 10:33:25","remoteAddr":"127.0.0.1","user":"--","app":"DeleteOrphanedSharesJob","method":"GET","url":"\/cron.php","message":"0 orphaned share(s) deleted","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}
{"reqId":"YealrdZobDPq2ArWFYyh","level":0,"time":"December 13, 2019 10:33:25","remoteAddr":"127.0.0.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OCA\\Files_Sharing\\DeleteOrphanedSharesJob job with ID 5 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko\/20100101 Firefox\/71.0","version":"16.0.6.1"}

I upload in the issue of github 166

Thanks

alexanderonlyoffice commented 4 years ago

@ejgutierrez74, please send us all logs of the Document Server, as I do not see them attached to any of your emails to support@onlyoffice.com. The logs are in folder:

For Windows installation: C:\Program Files\ONLYOFFICE\DocumentServer\Logs For Docker installation: /app/onlyoffice/DocumentServer/logs/documentserver/ For DEB/RPM installation: /var/log/onlyoffice/documentserver/logs

ejgutierrez74 commented 4 years ago

Sorry for de delay ive been very busy these days....would you prefer to continue in the github issue page or here ?

Note i hope you would notice, but you can read the path to the file in the terminal. For example: eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/converter$ cat out.log-20191226 Im writing the file out.log-20191226 in /var/log/onlyoffice/documentserver/converter

Answer to logs:

eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/converter$ cat out.log-20191226
[2019-12-14T14:27:22.421] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T14:27:22.427] [WARN] nodeJS - worker 21403 started.
[2019-12-14T14:27:22.428] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T16:57:45.747] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T16:57:45.752] [WARN] nodeJS - worker 2767 started.
[2019-12-14T16:57:45.752] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T16:57:47.295] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1128:14)
[2019-12-26T17:50:29.252] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:50:29.268] [WARN] nodeJS - worker 3668 started.
[2019-12-26T17:50:29.268] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:50:35.144] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:36.148] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:37.150] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:38.151] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:39.155] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:40.156] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:41.158] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:42.160] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:43.162] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:44.163] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:45.164] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:46.165] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:47.167] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:48.174] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:49.177] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/docservice$ cat out.log
[2019-12-26T17:55:11.949] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
[2019-12-26T17:55:11.959] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:55:11.967] [WARN] nodeJS - worker 14410 started.
[2019-12-26T17:55:11.967] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:55:12.362] [WARN] nodeJS - Express server starting...
[2019-12-26T17:55:12.808] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode
[2019-12-26T18:04:18.916] [ERROR] nodeJS - sqlQuery error sqlCommand: INSERT INTO task_result (id, status, status_info, :
error: permission denied for relation task_result
    at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:606:11)
    at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:403:19)
    at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:123:22)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:601:20)
[2019-12-26T18:04:18.917] [ERROR] nodeJS - Error convert: docId = conv_check_2057939995_docx
error: permission denied for relation task_result
    at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:606:11)
    at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:403:19)
    at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:123:22)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/docservice$ cat out.log-20191226
[2019-12-14T14:27:22.348] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
[2019-12-14T14:27:22.376] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T14:27:22.389] [WARN] nodeJS - worker 21390 started.
[2019-12-14T14:27:22.389] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T14:27:22.694] [WARN] nodeJS - Express server starting...
[2019-12-14T14:27:23.096] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode
[2019-12-14T16:57:45.657] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
[2019-12-14T16:57:45.849] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T16:57:45.853] [WARN] nodeJS - worker 2777 started.
[2019-12-14T16:57:45.853] [WARN] nodeJS - update cluster with 1 workers
[2019-12-14T16:57:46.121] [WARN] nodeJS - Express server starting...
[2019-12-14T16:57:47.411] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1128:14)
[2019-12-14T16:57:48.603] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode
[2019-12-26T17:50:29.126] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
[2019-12-26T17:50:29.184] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:50:29.264] [WARN] nodeJS - worker 3660 started.
[2019-12-26T17:50:29.264] [WARN] nodeJS - update cluster with 1 workers
[2019-12-26T17:50:30.064] [WARN] nodeJS - Express server starting...
[2019-12-26T17:50:35.882] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:36.885] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:37.887] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:38.890] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:39.891] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:40.895] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:41.912] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:42.913] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:43.914] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:44.916] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:45.924] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:46.926] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:47.927] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:48.928] [ERROR] nodeJS - [AMQP] Error: connect ECONNREFUSED 127.0.0.1:5672
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1191:14)
[2019-12-26T17:50:50.125] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode

eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/gc$ cat out.log
[2019-12-26T18:00:00.136] [ERROR] nodeJS - sqlQuery error sqlCommand: SELECT * FROM task_result WHERE last_open_date <= :
error: permission denied for relation task_result
    at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:606:11)
    at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:403:19)
    at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:123:22)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:601:20)
[2019-12-26T18:00:00.138] [ERROR] nodeJS - checkFileExpire error:
error: permission denied for relation task_result
    at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:606:11)
    at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:403:19)
    at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:123:22)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:601:20)
eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver/metrics$ cat out.log-20191226
14 Dec 14:27:22 - [21340] reading config file: ../../config/config.js
14 Dec 14:27:22 - server is up INFO
Flushing stats at  Sat Dec 14 2019 14:30:36 GMT+0100 (GMT+01:00)
{
  counters: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  timers: {},
  gauges: {},
  timer_data: {},
  counter_rates: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  sets: {},
  pctThreshold: [ 90 ]
}
14 Dec 16:57:43 - [1989] reading config file: ../../config/config.js
14 Dec 16:57:43 - server is up INFO
Flushing stats at  Sat Dec 14 2019 17:07:43 GMT+0100 (GMT+01:00)
{
  counters: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  timers: {},
  gauges: {},
  timer_data: {},
  counter_rates: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  sets: {},
  pctThreshold: [ 90 ]
}
Flushing stats at  Sat Dec 14 2019 17:17:43 GMT+0100 (GMT+01:00)
{
  counters: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  timers: {},
  gauges: { 'statsd.timestamp_lag': 0 },
  timer_data: {},
  counter_rates: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  sets: {},
  pctThreshold: [ 90 ]
}
Flushing stats at  Sat Dec 14 2019 17:27:43 GMT+0100 (GMT+01:00)
{
  counters: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  timers: {},
  gauges: { 'statsd.timestamp_lag': 0 },
  timer_data: {},
  counter_rates: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  sets: {},
  pctThreshold: [ 90 ]
}
Flushing stats at  Sat Dec 14 2019 17:36:02 GMT+0100 (GMT+01:00)
{
  counters: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  timers: {},
  gauges: { 'statsd.timestamp_lag': -101 },
  timer_data: {},
  counter_rates: {
    'statsd.bad_lines_seen': 0,
    'statsd.packets_received': 0,
    'statsd.metrics_received': 0
  },
  sets: {},
  pctThreshold: [ 90 ]
}
26 Dec 17:50:21 - [2174] reading config file: ../../config/config.js
26 Dec 17:50:21 - server is up INFO
Flushing stats at  Thu Dec 26 2019 17:55:10 GMT+0100 (CET)
{ counters:
   { 'statsd.bad_lines_seen': 0,
     'statsd.packets_received': 0,
     'statsd.metrics_received': 0 },
  timers: {},
  gauges: {},
  timer_data: {},
  counter_rates:
   { 'statsd.bad_lines_seen': 0,
     'statsd.packets_received': 0,
     'statsd.metrics_received': 0 },
  sets: {},
  pctThreshold: [ 90 ] }

eduardo@eduardo-VirtualBox:/var/log/onlyoffice/documentserver$ cat nginx.error.log-20191226
2019/12/14 17:51:10 [error] 1585#1585: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.1.52, server: , request: "GET /healthcheck HTTP/1.1", upstream: "http://127.0.0.1:8000/healthcheck", host: "onlyoffice.eduardo.com"
2019/12/14 17:51:17 [error] 1585#1585: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.1.52, server: , request: "GET /healthcheck HTTP/1.1", upstream: "http://127.0.0.1:8000/healthcheck", host: "onlyoffice.eduardo.com"
2019/12/14 17:55:40 [error] 1585#1585: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.1.52, server: , request: "GET /healthcheck HTTP/1.1", upstream: "http://127.0.0.1:8000/healthcheck", host: "onlyoffice.eduardo.com"
2019/12/14 17:55:46 [error] 1585#1585: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.1.52, server: , request: "GET /healthcheck HTTP/1.1", upstream: "http://127.0.0.1:8000/healthcheck", host: "onlyoffice.eduardo.com"

If you need any more logs just tell me

alexanderonlyoffice commented 4 years ago

@ejgutierrez74, we checked the logs from the very beginning once again. There is a problem of connection between your Document Server and its database - PostgreSQL, there are also problems with RabbitMQ service.

I would recommend you to do the full re-installation of the Document Server on clean machine. It is better to use Docker installation, as all the prerequisites are preinstalled inside the container. Please find the installation guide here.

There is also a possibility to use Docker compose file for deploying ONLYOFFICE Document Server + Nextcloud without HTTPS on one server using Docker. Please follow this link to find more information.

ejgutierrez74 commented 4 years ago

Well if you need more information....its possible that other people would have similar problems in Ubuntu 18.04. My Postgres works well. Also tried to install latest version of RabbitMq Service...I can also upload the VM just to make tests....