2
Build 9007: cannot create new document as per OnlyOffice integration
Problem reported by Gabriele Maoret - SERSIS - 8/30/2024 at 12:18 PM
Not A Problem
I updated to new build 9007, but if I enable FILE STORAGE and then login/impersonate  a user, I can see the FILE STORAGE, but I cannot create a new document with OnlyOffice, the function is simply missing:




Are there other tasks/options to enable this function?

I searched the online help, but I only find this:


Gabriele Maoret - Head of SysAdmins at SERSIS
Currently manages 6 SmarterMail installations (1 in the cloud for SERSIS which provides services to a few hundred third-party email domains + 5 on-premise for customers who prefer to have their mail server in-house)

18 Replies

Reply to Thread
1
Michael Gralke Augusto Replied
Well, things are not that easy as one would expect when reading that document.

I learned today that one has actually to deploy his own OnlyOffice Docs Server and then integrate that Server into each domain on his own SmarterMail Server.

This all makes some kind of sense but is poorly explained!

I am right now deploying a new Docs Server on Vultr and hopefully will be able to integrate it with SM once the Domain saving bug is solved. 
Michael Gralke Augusto GRALKE.COM - Business Communications www.gralke.com
0
Michael Gralke Augusto Replied
Michael Gralke Augusto GRALKE.COM - Business Communications www.gralke.com
2
Gabriele Maoret - SERSIS Replied
But in the documentation I can't find any trace of a guide to integrate an external OnlyOffice server!

It only says:



Again: in the KB there's nothing more:

Where are the options that you show in your screenshot to enable OnlyOffice integration? I can't find it...
[EDIT] Found: It is found in the Options tab of each individual domain... [EDIT]

You say:


This is not, simply, "poorly explained"... it is not explained at all, it is not even mentioned with a single word anywhere!



I think SmarterTools REALLY needs to do something to create better documentation...
Gabriele Maoret - Head of SysAdmins at SERSIS Currently manages 6 SmarterMail installations (1 in the cloud for SERSIS which provides services to a few hundred third-party email domains + 5 on-premise for customers who prefer to have their mail server in-house)
0
Gabriele Maoret - SERSIS Replied
One more question: but then, will it be necessary to have a different OnlyOffice server for each domain, or will one be enough to provide the service to all the domains on a SM server (of course with the necessary licenses if you want to exceed 20 simultaneous connections...)?

...anyway: this is a really great addition to SmarterMail's features!

Keep up the good work!

...just remember to improve the documentation... 😅

Gabriele Maoret - Head of SysAdmins at SERSIS Currently manages 6 SmarterMail installations (1 in the cloud for SERSIS which provides services to a few hundred third-party email domains + 5 on-premise for customers who prefer to have their mail server in-house)
4
Zach Sylvester Replied
Employee Post
I'll talk to my team about getting some more documentation about it next week. But it's simple. 

You can use this docker.


services:
  onlyoffice-documentserver:
    image: onlyoffice/documentserver:latest
    container_name: onlyoffice-documentserver
    depends_on:
      - onlyoffice-postgresql
      - onlyoffice-rabbitmq
    environment:
      - DB_TYPE=postgres
      - DB_HOST=onlyoffice-postgresql
      - DB_PORT=5432
      - DB_NAME=onlyoffice
      - DB_USER=onlyoffice
      - AMQP_URI=amqp://guest:guest@onlyoffice-rabbitmq
      - JWT_ENABLED=true
      - JWT_SECRET=ChangeMe
      - JWT_HEADER=Authorization
      - JWT_IN_BODY=true
    ports:
      - "8000:8000"
    stdin_open: true
    restart: always
    stop_grace_period: 60s
       
  onlyoffice-rabbitmq:
    container_name: onlyoffice-rabbitmq
    image: rabbitmq
    restart: always
    ports:
      - "5672:5672"

  onlyoffice-postgresql:
    container_name: onlyoffice-postgresql
    image: postgres:12
    environment:
      - POSTGRES_DB=onlyoffice
      - POSTGRES_USER=onlyoffice
      - POSTGRES_HOST_AUTH_METHOD=trust
    restart: always
    ports:
      - "5432:5432"

Just save this as compose.yml
Then in cmd or terminal or whatever you're using do 
docker compose up -d 

This will pull everything that you need. Then you can just enter something like this 



Make sure that you change the JWT_SECRET to something more secure. Also the document server must be accessible from the outside. When you go to the URL you should see something appear. 


Hope this helps. 

Thanks, 

Zach Sylvester Software Developer SmarterTools Inc. www.smartertools.com
2
Zach Sylvester Replied
Employee Post
Regarding your question, I would recommend using a different document server for each domain and changing the port from 8000 to something else. This way, you can run multiple document servers on the same machine. However, there is no downside to reusing a document server as long as you set the max connections accordingly. For example, if you use it on two domains, then the max connections should be set to 10 on each domain. Soon we are going to work on making it so we can use OnlyOffice for read-only attachment previews but that might be a while because we need to re-design our attachments modal and think of how we should display everything. 
Zach Sylvester Software Developer SmarterTools Inc. www.smartertools.com
1
Zach Sylvester Replied
Employee Post
One final thing to note is that the collaboration features are currently not supported. Although the framework for these features exists in the code, we still need to find a way to implement file storage folder sharing between users, which is a significant task on its own. Additionally, it's not possible to view or edit files on cloud storage connections at the moment. However, these features may be added in the future.
Zach Sylvester Software Developer SmarterTools Inc. www.smartertools.com
1
Gabriele Maoret - SERSIS Replied
Thanks Zach!

Time to test the OnlyOffice integration, when I'll have free time...
Gabriele Maoret - Head of SysAdmins at SERSIS Currently manages 6 SmarterMail installations (1 in the cloud for SERSIS which provides services to a few hundred third-party email domains + 5 on-premise for customers who prefer to have their mail server in-house)
0
Michael Gralke Augusto Replied
1st Try: Installed a Docs Linux Server on Vultr, installation went smooth but when clicking on a Document inside SM only a blank window comes up. 

2nd Try: I am a Windows Guy anyhow so I deployed a new server with the latest SM and OO, again all is fine but no editors are coming up. OO should be working since it shows OK at http://208.85.22.153:8000/welcome/ but then nothing works further until I start the Example, which I believe is not relevant in a working environment.

Services are working with the exception of Examples:
Has anybody got this working?
Michael Gralke Augusto GRALKE.COM - Business Communications www.gralke.com
1
Michael Gralke Augusto Replied
This is from SM Help:

Note: As SmarterMail's OnlyOffice integration does not require an account or paid subscription, it's only possible for a domain to have a maximum of 20 OnlyOffice "sessions" open at one time. If more sessions are required, OnlyOffice offers a number of paid plans that offer many more options.

This is from the OO Editions page:

Community Editions: Simultaneous connections - up to 20 (per server).

Quite a difference!

This from Zach (above):

Regarding your question, I would recommend using a different document server for each domain and changing the port from 8000 to something else. This way, you can run multiple document servers on the same machine.

So how does this work, especially on a Windows Server.

OO is an amazing product offering generous free licenses but awfully expensive otherwise! 
Michael Gralke Augusto GRALKE.COM - Business Communications www.gralke.com
0
Joe Davis Replied
We have an existing OnlyOffice Community Server, with Documents running. It runs fine, the editor works fine.
I added the config to SM but I cannot get it to connect, when I tell SM I want to create a new file, it lets me put in a file name and it actually creates the file in my SM File Storage but the screen it comes up with for the editor (/interface/onlyoffice-editor) is blank. There are no errors in the browser's console log and the network trace in the browser doesn't show any connection to my OnlyOffice server domain.

:-(
1
Michael Gralke Augusto Replied
Thank you Joe for confirming my post.

How to you use/access your OnlyOffice Community Server, with Documents running otherwise?
Michael Gralke Augusto GRALKE.COM - Business Communications www.gralke.com
0
Joe Davis Replied
We use the OnlyOffice desktop application and the website. The Community Server has a Project Manager and CRM built in as well. We use those to some degree but they're lacking a bit of the functionality we really need.
0
Zach Sylvester Replied
Employee Post
Hey guys, 

Please go ahead and open tickets with support so we can review your configuration and point you in the right direction. If it opens a blank window that would mean that it was unable to connect to the document server. I will create a dev task to make it so it shows an error instead of a blank window.

Thanks,
Zach Sylvester Software Developer SmarterTools Inc. www.smartertools.com
2
Joe Davis Replied
I managed to get mine running. A few things about my environment. 

  1. Running OnlyOffice Community Server, which includes Documents.
  2. If not running OnlyOffice in Docker, you'll find your 'secret' in /etc/onlyoffice/documentserver/local.json. See this page for more info.
  3. If OnlyOffice is running on a different domain than your SmarterMail, which it probably is, you'll need to  remove x-frame-src header in onlyoffice server nginx config. Replace it with Content-Security-Policy frame-ancestors so you can list the domains you wanted to allow access to show onlyoffice in a frame. SM is loading the OnlyOffice Document Editor in iframe.
    1. edit /etc/nginx/sites-enabled/onlyoffice
    2. comment out line with add_header X-Frame-Options $header_x_frame_options;
    3. add this after the line commented out, add_header Content-Security-Policy "frame-ancestors 'self' https://your-smartermail-server.tld;";
  4. Need to use https://your-onlyoffice-server.tld/ds-vpath in the SM setting for the OpenOffice URL. If you're not using Community Server, you most likely don't need to do this.
0
Derek Curtis Replied
Employee Post
Sorry about this, all. Not everything got committed to the Help project prior to release. We published a new version this morning, and I had them add in some of the suggestions and clarifications made from this Thread. 
Derek Curtis COO SmarterTools Inc. www.smartertools.com
0
Joe Davis Replied
Hey Derek,
Thank you for the note. I'm sorry, but I'm not finding the updated information anywhere. The only help page about OnlyOffice is this one and it doesn't seem to be any different from the other day.
1
Derek Curtis Replied
Employee Post
Joe -- since the OnlyOffice integration is set up by the system admin, the other place the actual settings are discussed is here, on the Domain Defaults page: 

Derek Curtis COO SmarterTools Inc. www.smartertools.com

Reply to Thread