Document & Community Server https?

[landowark]

I've installed the Docker versions of the document, mail and community servers. Everything works great using http and the Community server works fine using https, however whenever I try to edit a document I receive the following message.

Spectacle.J19967.png (23.2 KiB) Viewed 1376 times

I've followed the setup on the github (ie. https://github.com/ONLYOFFICE/Docker-CommunityServer), generated certificates and placed them in /app/onlyoffice/DocumentServer/data/certs and /app/onlyoffice/CommunityServer/data/certs, tried the setup both by specifying the ssl parameters in env.lists and not with the same results. I've looked all over the place and can't find anyone who is having this specific problem. The only clue I have is when looking in the documentserver's logs I find this in /app/onlyoffice/DocumentServer/logs/documentserver/gc/out.log

events.js:160
throw er; // Unhandled 'error' event
^

error: the database system is starting up
at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:554:11)
at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:381:17)
at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:117:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:548:20)
events.js:160
throw er; // Unhandled 'error' event

Repeats. This confirmed in app/onlyoffice/DocumentServer/logs/documentserver/docservice/out.log

[2016-12-02 20:20:10.032] [WARN] nodeJS - Express server starting...
[2016-12-02 20:20:10.085] [ERROR] nodeJS - Fri, 02 Dec 2016 20:20:10 GMT uncaughtException: the database system is starting up
[2016-12-02 20:20:10.088] [ERROR] nodeJS - error: the database system is starting up
at Connection.parseE (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:554:11)
at Connection.parseMessage (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:381:17)
at Socket.<anonymous> (/var/www/onlyoffice/documentserver/server/DocService/node_modules/pg/lib/connection.js:117:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:548:20)
[2016-12-02 20:20:10.096] [WARN] nodeJS - worker 507 died.
[2016-12-02 20:20:10.099] [WARN] nodeJS - worker 547 started.

This also repeats.
I feel like I'm missing something that the tutorials just assume I know.
Does anyone have suggestions for a solution, or better yet a (non-mystical) way they've gotten ssl to work for both the Community and Document server?

[Maxim]

Hello!
1. Check Document Server - make a request to Document Server "http(s)://your_server's_ip_address/OfficeWeb/apps/api/documents/api.js" (for example http(s)://144.12.35.5/OfficeWeb/apps/api/documents/api.js) you must see the page with code if it's not it means that there is a problem with the access to the Document Server. Does Document Server work correctly without SSL? If yes than you should check ssl certificates.
2. What OS you use on your server? In case if it's CentOS there is a problem with security and system doesn't allow Document Sever to work properly. You should turn off firewall.
3. Your SSL certificates were given with domain name so try to change Settings=>Document Service "Community Server Address" to your domain name.
4. See here maybe it will help you.

Feel free to contact us!

[landowark]

When I try to connect to the document server I get "The page isn't redirecting properly" so that's definitely the problem, but I'm unsure of how to go about fixing it.

Trying to change any of the settings of the document server results in "Api rul: service is not defined". The default Document Editing Service Address that shows up is "/OfficeWeb/apps/api/documents/api.js" with no domain name or port. What I'm thinking is that for whatever reason the docker container of the document server is not being created with the expected settings. Not sure why. Where you're supposed to specify "-e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server" I've tried getting the ip within the docker onlyoffice network using "docker network inspect onlyoffice", but changing that didn't help matters.

I'm running Ubuntu server 16.04 with kernel 4.4 which is a fresh install. Though I had the same problem with 14.04. I created the certificates with the domain name I'm using to access OnlyOffice and I've gone over the link you provided in my previous troubleshooting attempts.

I'll try sending emails with the support people in the future. At least I know the email is 'support@onlyoffice.com'

[Maxim]

Hello!
Ubuntu 16.04 works fine with onlyoffice docker version, try to delete all current onlyoffice containers, update

Code: Select all

sudo apt-get update

and following this instruction install OnlyOffice with provided script. I'm sure you will get absolutely working correctly OnlyOffice server.

[landowark]

Okay, thanks a whole lot for your help!

I thought this would end up being something stupid I had just missed, and I guess it turned out to be close enough.

I put certificates in for both the community and document servers, which was what turned out to be causing my problem. Once I removed the document server certs everything went through correctly.

Thanks again.

[Maxim]

Hello!
So, as i understand, you removed your ssl certificates and Document server works fine now? What about Community Server? Does it run with ssl certs? What kind of certificates did you use, self signed certificates or not?