Problems withe Only Office Documentserver, cant create Documents in Nextcloud

[transocean]

NethServer Version: 7.4 1708
Module: Only Office Documentserver

Hi Friends,

after the update from today i have problems with the Only Office Documentserver.
The service Nginx is stoped and it’s impossible to restart him.

Here is the output of /var/log/nginx/error.log:

2018/03/29 14:05:08 [emerg] 2084#0: bind() to 0.0.0.0:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to [::]:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to 0.0.0.0:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to [::]:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to 0.0.0.0:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to [::]:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to 0.0.0.0:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to [::]:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to 0.0.0.0:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: bind() to [::]:80 failed (98: Address already in use)
2018/03/29 14:05:08 [emerg] 2084#0: still could not bind()
2018/03/29 14:05:18 [notice] 26393#0: using inherited sockets from "7;8;"
2018/03/29 14:05:18 [emerg] 26393#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
nginx: [emerg] open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 14:09:54 [emerg] 1588#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:19:19 [emerg] 19562#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:19:47 [emerg] 19637#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:20:04 [emerg] 19696#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:20:30 [emerg] 19797#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:27:14 [emerg] 20369#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:29:03 [emerg] 1338#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:34:08 [emerg] 2794#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1
2018/03/29 18:34:33 [emerg] 2862#0: open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory) in /etc/nginx/conf.d/onlyoffice-documentserver.conf:1

Who can help?

Thanks in advance

Uwe

[mrmarkuz]

Hi @transocean ,

I can confirm: The actual documentserver update destroys onlyoffice.

Did you install the onlyoffice package or did you setup onlyoffice with the howto?

I am working on it. I managed to start nginx but config files are missing and I get to the default nginx page instead of the docserver. As soon as I have a solution I’ll post it.

[transocean]

Did you install the onlyoffice package or did you setup onlyoffice with the howto?

I have installed onlyoffice with your howto. That worked great. Until this morning …

Regards

Uwe

[dnutan]

If it’s of help for:

open() “/etc/nginx/includes/onlyoffice-http.conf” failed (2: No such file or directory)

File located at:

/etc/onlyoffice/documentserver/nginx/includes/onlyoffice-http.conf

For nginx service not starting, maybe:

Issue: `service nginx start` fails on centos 7

[mrmarkuz]

I have a downgrade workaround for now…thanks @transocean for raising the issue!

yum downgrade https://github.com/ONLYOFFICE/DocumentServer/releases/download/ONLYOFFICE-DocumentServer-5.0.7/onlyoffice-documentserver.x86_64.rpm

Those who installed from howto have to do the steps again from executing the configure script:

# documentserver-configure.sh

If you are using the nethserver-onlyoffice module just do

signal-event nethserver-onlyoffice-update

I had to disable and enable the onlyoffice app in Nextcloud to make it visible in the settings.

Thanks @dnutan, I put the missing file back and could only see the nginx default page. I’ll try the config file from your link.

I am going to provide a more stable package/howto without onlyoffice repo dependency but it may take some time…

[transocean]

Now Documentserver works. But after creating of a Excel table i see only this:

Regards

Uwe

[mrmarkuz]

Did you setup the onlyoffice app settings again, can you save the settings without error?

Are there errors in /var/log/onlyoffice/documentserver/nginx.error.log or in /var/log/onlyoffice/documentserver/docservice/err.log ?

Maybe restarting the onlyoffice services helps:

supervisorctl restart all

[transocean]

Hi Markus,

there are no errors in the logs. Both logs you describe are empty.

Regards

Uwe

[mrmarkuz]

Does saving the onlyoffice app settings work or do you see an error on screen?

[transocean]

I can see no error on screen.
I only see the picture I posted above.
Can you give me a step by step guide on how to uninstall the software cleanly and then reinstall it. Practically as if it had never been installed on the server before.

[mrmarkuz]

I meant in the Onlyoffice app settings in the Nextcloud admin settings, you have to login as Nextcloud admin to see it:

Are the settings correct and do you see an error if you save?

To uninstall onlyoffice and nginx with all dependencies:

yum autoremove onlyoffice-documentserver nginx msttcore-fonts-installer-2.6-1 onlyoffice-repo

Installation steps are in the howto. I’ll try to provide a working module over the weekend.

You may try to install the documentserver directly and not via repo to not have the same error again:

yum install https://github.com/ONLYOFFICE/DocumentServer/releases/download/ONLYOFFICE-DocumentServer-5.0.7/onlyoffice-documentserver.x86_64.rpm

instead of

yum -y install onlyoffice-documentserver

[transocean]

Remove onlyoffice and nginx stoped with the warning RPMDB altered outside of yum.

[transocean]

Are the settings correct and do you see an error if you save?

When i save the setting this error message is coming up

[mrmarkuz]

What I found you can ignore the “RPMDB altered” warning:

https://www.centos.org/forums/viewtopic.php?t=636#p201029

How to fix the warning: "RPMDB altered outside of yum"?

I assume the packages are removed, you may run the “yum autoremove” again to check it.

If you took the screenshot after removing onlyoffice, the error is clear.

[transocean]

It is simply not possible to remove the package.

Running transaction and nothing will go on.

[dnutan]

I’ll try the config file from your link.

Sorry, no need to. The file is templated. AFAIK all problems came from onlyoffice package.

OnlyOffice Document Server Update warnings:

warning: /etc/onlyoffice/documentserver/default.json saved as /etc/onlyoffice/documentserver/default.json.rpmsave
find: ‘/etc/onlyoffice/documentserver-example/supervisor/’: No such file or directory
warning: /etc/nginx/conf.d/onlyoffice-documentserver.conf.template saved as /etc/nginx/conf.d/onlyoffice-documentserver.conf.template.rpmsave
warning: /etc/nginx/conf.d/onlyoffice-documentserver-ssl.conf.template saved as /etc/nginx/conf.d/onlyoffice-documentserver-ssl.conf.template.rpmsave

Relevant OnlyOffice Document Server update changes:

new directory : /etc/onlyoffice/documentserver/nginx
	number of new files		 : 7
new directory : /etc/onlyoffice/documentserver/supervisor
	number of new files		 : 6

deleted file : /etc/nginx/conf.d/onlyoffice-documentserver-ssl.conf.template
deleted file : /etc/nginx/conf.d/onlyoffice-documentserver.conf.template

deleted file : /etc/nginx/includes/onlyoffice-documentserver-common.conf
deleted file : /etc/nginx/includes/onlyoffice-documentserver-docservice.conf
deleted file : /etc/nginx/includes/onlyoffice-documentserver-spellchecker.conf
deleted file : /etc/nginx/includes/onlyoffice-http.conf

deleted file : /etc/supervisord.d/onlyoffice-documentserver-converter.ini
deleted file : /etc/supervisord.d/onlyoffice-documentserver-docservice.ini
deleted file : /etc/supervisord.d/onlyoffice-documentserver-gc.ini
deleted file : /etc/supervisord.d/onlyoffice-documentserver-metrics.ini
deleted file : /etc/supervisord.d/onlyoffice-documentserver-spellchecker.ini
deleted file : /etc/supervisord.d/onlyoffice-documentserver.ini

changed symbolic_link : /etc/nginx/conf.d/onlyoffice-documentserver.conf
    lrwxrwxrwx root root /etc/nginx/conf.d/onlyoffice-documentserver.conf -> /etc/onlyoffice/documentserver/nginx/onlyoffice-documentserver.conf.template

changed file : /usr/bin/documentserver-configure.sh

Relevant available directories:

/etc/onlyoffice/documentserver/nginx/
/etc/onlyoffice/documentserver/nginx/includes/
/etc/onlyoffice/documentserver/supervisor/

Tried to restore functionality by symlinks and also by putting files in place but no dice. I think it’s better to wait for upstream to release a new minor version, or track their open issues.
If you want me to do some tests just tell me (only running it on test server so no hurry on my side).

[mrmarkuz]

Please try to reboot(maybe a yum process hangs) and if this doesn’t work try rebuilding yum db:

Yum rpmdb failed

Source:

yum Command Hangs on Running Transaction Test Message Error and Solution -...

EDIT:

I got similar issue after playing with install/remove, some post install script seems to be the problem, the following worked for me:

yum-complete-transaction --cleanup-only
yum --setopt=tsflags=noscripts remove onlyoffice-documentserver

[transocean]

After rebooting the server, it is no longer accessible. I am 500 KM away from home and in a week back home. Either I get him back to the start, or he flies out of the window.

Regards Uwe

[mrmarkuz]

Oh no! No SSH, no web UI, no VPN, no other possibility like remote software or virtualization management or something else? My VPS once took an hour to reboot, maybe try later…I hope you can bring it up again!

[fausp]

I did an update of my nextcloud/onlyoffice-Server… the nextcloud looks like:

How can I analyze the situation and is there a workaround or fix ?