OnlyOffice Community Edition without 20 connections limitation

I just installed Nextcloud 18 on a Debian Linux Server.
I can detect no PHP OnlyOffice server on there under /var/www/nextcloud. Where will it be?
I ticked the box marked

Connect to demo ONLYOFFICE Document Server
This is a public test server, please do not use it for private sensitive data. The server will be available during a 30-day period.

and I can edit OnlyOffice documents. Has the PHP version of Nextcloud been discontinued, or is the “public test server” thing a lie, or what?

You have to install the “Community Document Server” app and disable the public test server. The test server is only for testing. When you have installed the document server the files I mentioned in my previous post are in nextcloud/apps/documentserver_community/ .

Seems to me that Nextcloud are plain wrong when they say that OO is bundled with NC18. What they actually mean is that the Document Connection App called Only Office is bundled - exactly the same app as was available in 17 and if you upgrade 17->18 it is still there as an app to install. The only change with NC18 vanilla install is that you get the option to include the connection app when installing, rather than having to find it in Apps afterwards. Blah.

There is no document server bundled so if you just install NC expecting to find OO included you are going to be disappointed.

There seem to be two things you can then do - install the Community Document Server (which at the moment is failing to install from the admin interface for me with curl timeouts).
This uses make to extract core stuff from the OO github to do the heavy lifting, but the licence restriction is moved to a PHP file where it can be edited as above.

The other alternative is to download OO from github, edit the licence restriction and recompile if you can find some working instructions as to how to do that…possibly here
or there is a version that @autoize has precompiled here

Which leaves me with two questions and a local problem:

  1. What is the new connection limit in the @autoize compiled version?
  2. What features are missing from the “Community Document Server” edition?

(and my local problem is that the whole shebang seems to demand SSL connections which since I’m installing for private use on a local network behind a firewall is an unnecessary hassle - but that’s just me)

2 Likes

brilliant, thank you @kesselb and @Semjel for speedy responses

It seems there are some limitations in the Community Document Server

  • no conversion service

  • no command service (only ‘version’ command)

  • no spellchecking

  • issues with adding fonts

  • no document chat

  • occasional x2t failures

(whats a x2t failure? or doesn’t it matter if I don’t know?)
Since the official OO defaults to USenglish for new docs and most users forget to change it the loss of squiggly red lines is not a showstopper - and we’ve never found a use for document chat…,

I’ve spend two nights trying to get it running on 18.04, but without success. Decided to install on 16.04, and compiling from source following this: https://autoize.com/building-onlyoffice-document-server-from-source/ and have everything running without any problems. I had some trouble with SSL NGINX config cause I have own certs (not using certbot), but after some tries I did it.

I also managed to run that 3 processes automatically on system start. So if anybody need it, here is how:

  1. Create services files

sudo nano /etc/systemd/system/onlyoffice-docservice.service

[Unit]
Description=Onlyoffice documentserver
After=network.target

[Service]
User=onlyoffice
Type=simple
Environment="NODE_ENV=production-linux" "NODE_CONFIG_DIR=/etc/onlyoffice/documentserver"
ExecStart=/usr/bin/node /var/www/onlyoffice/documentserver/server/DocService/sources/server.js
WorkingDirectory=/etc/onlyoffice/documentserver
LimitNOFILE=1048576
LimitNPROC=64
PrivateTmp=true
PrivateDevices=true
ProtectHome=true

[Install]
WantedBy=multi-user.target

sudo nano /etc/systemd/system/onlyoffice-spellchecker.service

[Unit]
Description=Onlyoffice documentserver
After=network.target

[Service]
User=onlyoffice
Type=simple
Environment="NODE_ENV=production-linux" "NODE_CONFIG_DIR=/etc/onlyoffice/documentserver"
ExecStart=/usr/bin/node /var/www/onlyoffice/documentserver/server/SpellChecker/sources/server.js
WorkingDirectory=/etc/onlyoffice/documentserver
LimitNOFILE=1048576
LimitNPROC=64
PrivateTmp=true
PrivateDevices=true
ProtectHome=true

[Install]
WantedBy=multi-user.target

sudo nano /etc/systemd/system/onlyoffice-fileconverter.service

[Unit]
Description=Onlyoffice documentserver
After=network.target

[Service]
User=onlyoffice
Type=simple
Environment="NODE_ENV=production-linux" "NODE_CONFIG_DIR=/etc/onlyoffice/documentserver"
WorkingDirectory=/var/www/onlyoffice/documentserver/server/FileConverter/sources/
ExecStart=/usr/bin/node /var/www/onlyoffice/documentserver/server/FileConverter/sources/convertermaster.js
WorkingDirectory=/etc/onlyoffice/documentserver
LimitNOFILE=1048576
LimitNPROC=64
PrivateTmp=true
PrivateDevices=true
ProtectHome=true

[Install]
WantedBy=multi-user.target
  1. Make them load automatically on startup

cd /etc/systemd/system

sudo systemctl enable onlyoffice-spellchecker.service

sudo systemctl enable onlyoffice-fileconverter.service

sudo systemctl enable onlyoffice-docservice.service

  1. To start them you have to reboot your server or type

sudo systemctl start onlyoffice-spellchecker.service

sudo systemctl start onlyoffice-fileconverter.service

sudo systemctl start onlyoffice-docservice.service

  1. To check their status type

sudo systemctl status onlyoffice-spellchecker.service

sudo systemctl status onlyoffice-fileconverter.service

sudo systemctl status onlyoffice-docservice.service

5 Likes

Thank you.
I’l try this…

EDIT:
Working great.
Thanks a lot…

Did you check against 20+ connections? Is it working? What about others? I see this as much easier solution…

Actually there is. It’s a second app you need to install.

Exactly my point. It is a separate app, not bundled with “Nextcloud Hub”
From the marketing guff at the top of every page here:

Installing a separate app is NOT built in Only Office.
The OO connector app has been available for some time (certainly in NC17 and possibly longer) - nothing has changed here.
Actually that is not quite true - when you install NC18 fresh then it gives you an option to install the connector app along with calendar, deck etc at the end of the install.

But you still have to do a completely separate install of OO in order for the connector to work. (or sign up to use OO demo version on their server for 30 days free). This is very far from “Built in ONLYOFFICE”. To me the marketing guff reads as if when I install NC18 it will also automatically provide full OO if I want it.

We have something called the Trades Description Act in this country which protects consumers against misleading marketing claims. I’m not going to report NC to Trading Standards, but NC should take down the misleading claims, which are at the very least pissing people off and damaging their reputation.

hey @rogerco

as much as i appreciate every comment here (and so do i with yours, as well) i think this is now getting a bit silly.
apparently for you it’s all about the definition of the word “built-in”…
so what MEANS built-in?
is it part of the native code?
or is it enough if you can click somewhere on your screen to have it within a moment?
or does it only mean: hey, you can have (and use) it if you want it (but maybe you’d have a bit of work ahead of using it but then it’s just a click away)?

AAAAAAND… tadaaaa… the community edition comes free of cost. so if you’re gonna sue them what do you expect getting back? you have no financial loss of it. you even can’t argue that someone forced you to use a software that you didn’t want to use.

so why not cooling down a bit instead of getting angry about such a nothing?

btw: for me “built-in” means: i could have pretty fast and easy it if i wanted it. but if i don’t want i don’t need to take it. and thus i’m pretty happy that it won’t take away a part of my small amount of storage if i don’t install it.

cheerio
jimmy

2 Likes

It is different. You click install and it self-configures without you having to set anything up. It also runs on Nextcloud instead of on another server or container. How much more built-in do you want it to be? You would rather the app be pre-installed for everyone even if they don’t want or use it? That would be a poor decision.

Yes I agree, and I’m not angry and I wasn’t going to reply although I do take a somewhat different view to you - but I got pinged twice. I will try and make this my last on the topic.

I have tried both a clean install of NC18 and an upgrade from 17. In 17->18 the connector app remains the same (assuming you had updated it to the latest version). On NC18 you simply get the option to install the exact same connector app as part of the install - together with deck, calendar etc. (from memory you don’t get the option to pick one app and not the others which is a pain if you don’t want bloat that you wont use - but I might be wrong about that).

I was not aware of it doing any self configuration on the clean install that it didn’t do when I installed it on NC17. I still had to tell it where the OO server was and set up which groups could use it (shame it doesn’t have a mind reading facility to know what I want :wink:)

You still have to install OO separately - which is very far from claiming that OO is bundled with NC.

Absolutely right it would be. If the claim is that OO is part of NC then I would expect the option to install both the connector app and OO from within the install and/or from the Apps admin screen.

Clearly this is not feasible once you know what is involved, so for me the claim that OO is bundled with NC is spurious.

As @JimmyKater says it is not a big deal. Just an annoying misleading marketing claim by some possibly illiterate junior who doesn’t know what “built in” means.

The good news is that despite this digression and the previous long digression into the morality of modifying open source software, the OP has been well answered - we have not one but two solutions :smiley: :champagne: :stadium:
:rainbow: :sparkler: :fireworks: :medal_sports: :trophy:

3 Likes

When you install the document server app, it configured the connector app for you if the connector isn’t already configured to connect to another document server.

I’m not sure what you’re getting at here because going to the apps admin screen and installing both of them is literally exactly what you do. It “comes with” NC just like NC “comes with” contacts and calendars, etc.

And I disagree that it should be pre-installed. If I set up a NC instance specifically for vendors to submit bids (which I have done several times) then coming with an office suite it doesn’t need is just wasted resources.

1 Like

Hey i work at a coop too. Specifically an IT one and we use next cloud too.
So, we may be of help. Here is our mail if you want to contact us even beyond this issue in particular, we are looking to work with other coops.

info@camba.coop

1 Like

So it is entirely possible to remove the 20 connections limit in the Community Document Server (CDS).

However there seems to be a bit of a ‘gotcha’. This is my, probably incomplete, understanding of what I have observed so please do comment if you have better knowledge or experience or can see a way around it.

CDS installs as a Nextcloud (NC) app using the same OnlyOffice (OO) Connector app as full OO but with the server entry pointing to the app instead of the OO separate server.

This means that CDS is using the same resources and database as NC

The problem is that the OO engine (used by CDS) works by writing every keystroke made while editing to the database (oc_documentserver_changes in the case of CDS). Periodically the changes get written back to the file and flushed from the db.

This means that if you have 20 users all typing away there can be a massive load on the MySQL server and this may slow down everything else in NC.

With full OO you are running it as a separate process using a separate database which should mean it works slightly better even if it is on the same host. And this probably explains why they recommend installing OO on a completely separate machine.

SO although you can increase the users easily in CDS, you might not want to.

Anyone else seen this effect.

2 Likes

then wondering why nextcloud fork from owncloud ?!
and you know it’s possible to bay for support or using saas .

1 Like

A post was split to a new topic: Proprietary Enterprise version

look like need another fork :rofl::joy:

1 Like

Sorry, folks, but what a tiring discussion this is.

We developed this integration for home users. That is why we started a private cloud project back in 2010, and that is our motivation until today. We want to help people protect their privacy.

Companies are not people. They have no right to privacy. And the only reason we care about companies is because they pay us to make Nextcloud better.

We didn’t spend a year working on this feature with companies in mind. Seriously. This is a gift of Nextcloud GmbH to hundreds of thousands of home users. When our customers want ONLYOFFICE they get it from us and that’s a packaged version that scales well and works great for large numbers of users.

Now yes, some companies use Nextcloud without a subscription. That is fine, the license allows you to do anything with it. That is open source. But please don’t complain when it isn’t good enough for one reason or another. Customers pay for the right to complain, and we listen to home users who complain because we care about people. Not companies.

6 Likes