Problems withe Only Office Documentserver, cant create Documents in Nextcloud

transocean · March 29, 2018, 4:42pm

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 · March 29, 2018, 5:17pm

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 · March 29, 2018, 6:17pm

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

Regards

Uwe

dnutan · March 29, 2018, 6:25pm

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:

mrmarkuz · March 29, 2018, 6:44pm

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 · March 29, 2018, 7:10pm

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

Regards

Uwe

mrmarkuz · March 29, 2018, 7:21pm

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 · March 30, 2018, 9:44am

Hi Markus,

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

Regards

Uwe

mrmarkuz · March 30, 2018, 10:50am

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

transocean · March 30, 2018, 11:48am

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 · March 30, 2018, 12:15pm

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 · March 30, 2018, 3:50pm

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

transocean · March 30, 2018, 4:28pm

When i save the setting this error message is coming up

mrmarkuz · March 30, 2018, 4:49pm

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

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

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 · March 30, 2018, 5:39pm

It is simply not possible to remove the package.

Unbenannt

Running transaction and nothing will go on.

dnutan · March 30, 2018, 5:46pm

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 · March 30, 2018, 5:58pm

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

Source:

https://www.cyberciti.biz/faq/rhel-centos-fedora-redhat-yum-running-transaction-test-error/

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 · March 31, 2018, 9:22am

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 · March 31, 2018, 10:40am

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 · March 31, 2018, 10:58am

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

grafik

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