Howto install Onlyoffice document server as Nextcloud app

[mrmarkuz (Markus Neuberger)]

Released the update to fix future documentserver update problems.

[hector (Héctor Pérez)]

Ok mrmarkuz it’s working thank for de port 8082 I put it and is working now.

[oneitonitram (Martin)]

@mrmarkuz

Module instructions/download: https://wiki.nethserver.org/doku.php?id=onlyoffice

is this the better method of installing than

@mrmarkuz

We start with installing packages and preparing postgres:

# install packages
yum -y install nethserver-nextcloud nethserver-postgresql nethserver-redis rabbitmq-server nano

# customize postgres pg_hba.conf
mkdir -p /etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf
echo -e "host all all 127.0.0.1/32 trust\nhost all all ::1/128 trust" > /etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf/15onlyoffice
signal-event nethserver-postgresql-update

# create postgres db and user
sudo -u postgres psql -c "CREATE DATABASE onlyoffice;"
sudo -u postgres psql -c "CREATE USER onlyoffice WITH password 'onlyoffice';"
sudo -u postgres psql -c "GRANT ALL privileges ON DATABASE onlyoffice TO onlyoffice;"

# start and enable redis and rabbitmq
systemctl enable redis --now
systemctl enable rabbitmq-server --now

# install fonts and documentserver
yum -y install https://downloads.sourceforge.net/project/mscorefonts2/rpms/msttcore-fonts-installer-2.6-1.noarch.rpm
yum -y install https://github.com/ONLYOFFICE/DocumentServer/releases/download/ONLYOFFICE-DocumentServer-5.0.7/onlyoffice-documentserver.x86_64.rpm

# stop httpd and start and enable supervisord and nginx
systemctl stop httpd
systemctl enable supervisord --now
systemctl enable nginx --now

# change documentserver http port from 80 to 8081 to have no conflict
export DS_PORT=8081
documentserver-configure.sh

Now we have to go through the documentserver-configure script. Accept the defaults here. Set the password for Postgres user to “onlyoffice” and the password for RabbitMQ user to “guest”.

than this method.

[mrmarkuz (Markus Neuberger)]

The module is the better method as it eases installation a lot and preconfigures onlyoffice.

[oneitonitram (Martin)]

Thank you,

and whats the difference between the quick install, and the installation in the documentation.

do I have to run write both, or only chose one

[mrmarkuz (Markus Neuberger)]

Choose one. First we make a howto and then we make the module out of the howto. So the module integrates the howto.

[oneitonitram (Martin)]

when I install the module with the instruction, will it install on sub.doamin.tld/onlyoffice or do I need to point a subdomain like https://onlyoffice.domin.tld

[mrmarkuz (Markus Neuberger)]

The module integrates itself in nextcloud so it depends on nextcloud.

[oneitonitram (Martin)]

@mrmarkuz

The module integrates itself in nextcloud

does that mean I do not have to go and add theh onlyoffcie erver in the nextcloud settings?

[oneitonitram (Martin)]

thank you

[kizotux (Zoran Ramač)]

Hi everyone,

Yesterday i made a clean install Nethserver + Nextcloud (from Software center) + OnlyOffice + DocumentServer 5.1.4 as per instructions (onlyoffice Wiki).

Despite this, I have always received an error (when I press the Save button in Nextcloud - ONLYOFFICE):
“Command Request on check error: Error while downloading the document file to be converted.”

I spent the whole day trying to solve the problem.

I found a solution this morning. In file default.json (/etc/onlyoffice/documentserver/) I made a simple change (true to false):

“requestDefaults”: {
“headers”: {
“userAgent”: “Node.js/6.13”
},
“rejectUnauthorized”: false
},

I know the problem is in the certificates, but only in this way have I managed to make Onlyoffice to work.

I am a little confused

[mrmarkuz (Markus Neuberger)]

Hi Zoran,

@kizotux

I know the problem is in the certificates, but only in this way have I managed to make Onlyoffice to work.

Yes, you need a valid trusted cert like letsencrypt and you probably need to port forward 8082 from your router to your Nethserver. You have to set your domain too.

@kizotux

I found a solution this morning.

Thanks for sharing, this is great for using onlyoffice without valid cert but I am afraid it’s not the best for security.

[kizotux (Zoran Ramač)]

Thanks Markus,

now I will try to implement the certificates.

[flatspin (Ralf Jeckel)]

Hi Markus @mrmarkuz ,

I installed a new NS instance with NC-13.0.6 and only-office 5.0.7 (selfsigned certs).
I had to install librabbitmq and librabbitmq-tools from puias-unsupported.

I did:
wget http://springdale.math.ias.edu/data/puias/unsupported/7/x86_64//librabbitmq-0.5.2-1.sdl7.x86_64.rpm
and
wget http://springdale.math.ias.edu/data/puias/unsupported/7/x86_64//librabbitmq-tools-0.5.2-1.sdl7.x86_64.rpm

and then

yum localinstall -y librabbitmq-0.5.2-1.sdl7.x86_64.rpm
yum localinstall -y librabbitmq-tools-0.5.2-1.sdl7.x86_64.rpm

Now onlyoffice in NC 13 on NS 7.5 is running fine:

Maybe you want to update your Howto.

[mrmarkuz (Markus Neuberger)]

IIRC it’s only a problem with old documentserver needed for self-signed certs, newer documentserver version should just work. It’s because epel changed rabbitmq packages.
Thanx, I’ll update the wiki entry asap.

EDIT: updated.

[flatspin (Ralf Jeckel)]

I found a workaround to install onlyoffice 5.1.x with selfsigned certs.
It’s only a workaround, because it breaks SSL security due to allow connections to unauthorized ssl servers, but it works.

Set services.CoAuthoring.requestDefaults.rejectUnauthorized=false in /etc/onlyoffice/documentserver/defaults.json file and restart documentserver serviceis with supervisorctl restart all .

Got it from: https://github.com/ONLYOFFICE/Docker-DocumentServer/issues/96

[mrmarkuz (Markus Neuberger)]

I updated the module. Please test it so I can put it to the repo!

• self-signed certificate possible - thanks to @kizotux and @flatspin
• works with ONLYOFFICE-documentserver 5.1.5

To update an existing installation (for a full install follow the wiki except of these two lines):

yum -y install https://github.com/ONLYOFFICE/DocumentServer/releases/download/ONLYOFFICE-DocumentServer-5.1.5/onlyoffice-documentserver.x86_64.rpm
yum -y install https://nethserver.globalcortex.net/mirror/devtest/nethserver-onlyoffice-0.0.1-4.ns7.noarch.rpm

It seems the formats were extended too:

mrmarkuz/nethserver-onlyoffice

[flatspin (Ralf Jeckel)]

@kizotux

“rejectUnauthorized”: false

Just saw, that I posted the same solution as you did before. Sorry
I didn’t read this topic exactly enough.
I could have saved half a day of searching if I had done…