[Support] AMJidovu - OnlyOffice Community Server


Recommended Posts

 

Applications Names:

  • onlyoffice-mysql-server
  • onlyoffice-document-server
  • onlyoffice-mail-server
  • onlyoffice-community-server

 

Before starting any container create the onlyoffice network ( it is a custom bridged network to group them up ) :

sudo docker network create --driver bridge onlyoffice

onlyoffice-community-server -- Local Installation ( stand alone or paired with onlyoffice-document-server )

 

  • onlyoffice-community-server can be started alone, although it should be paired with onlyoffice-document-server

If it is paired with onlyoffice-document-server you need to add back the following variable to:

  • Value: onlyoffice-document-server
  • Default Value: onlyoffice-document-server

Found in " Onlyoffice Document Server - Read Description for Changes ----> : "

The only downside using this installation is that you have to dump your database each time you upgrade Only Office.

 

onlyoffice-community-server -- External Installation (Community Server, Document Server, Mail Server, MySQL Server) integrated

 

  • onlyoffice-mysql-server -- initialization

 

The mysql server gets installed first and it will require some folders/ files to be created on the appdata share ( the files and folders will be created in the /mnt/user/appdata/onlyoffice/mysql ).

Copy and paste the following commands inside Unraid terminal:

sudo mkdir -p "/mnt/user/appdata/onlyoffice/mysql/conf.d"; \
sudo mkdir -p "/mnt/user/appdata/onlyoffice/mysql/data"; \
sudo mkdir -p "/mnt/user/appdata/onlyoffice/mysql/initdb"; \
sudo mkdir -p "/mnt/user/appdata/onlyoffice/mysql/logs"; \
chown 999:999 /mnt/user/appdata/onlyoffice/mysql/logs;

Change the passwords for 'root' , 'onlyoffice_user' , 'mail_admin' and do not forget to change the passwords in the templates of each container ( 'onlyoffice-mail-server' , 'onlyoffice-community-server' , 'onlyoffice-mysql-server' )

'onlyoffice-document-server' uses postgresql database and is hosted by that container.

Please note, that the bellow script will set permissions to access SQL server from any domains (%). If you want to limit the access, you can specify hosts which will have access to SQL server.

Copy and paste the following commands inside Unraid terminal:

echo "[mysqld]
sql_mode = 'NO_ENGINE_SUBSTITUTION'
max_connections = 1000
max_allowed_packet = 1048576000
group_concat_max_len = 2048
log-error = /var/log/mysql/error.log" > /mnt/user/appdata/onlyoffice/mysql/conf.d/onlyoffice.cnf
sudo chmod 0644 /mnt/user/appdata/onlyoffice/mysql/conf.d/onlyoffice.cnf

echo "CREATE USER 'onlyoffice_user'@'localhost' IDENTIFIED BY 'onlyoffice_pass';
CREATE USER 'mail_admin'@'localhost' IDENTIFIED BY 'Isadmin123';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY 'my-secret-pw';
GRANT ALL PRIVILEGES ON * . * TO 'onlyoffice_user'@'%' IDENTIFIED BY 'onlyoffice_pass';
GRANT ALL PRIVILEGES ON * . * TO 'mail_admin'@'%' IDENTIFIED BY 'Isadmin123';
FLUSH PRIVILEGES;" > /mnt/user/appdata/onlyoffice/mysql/initdb/setup.sql

 

  • onlyoffice-mail-server -- instalation

 

Your domain that will be used for maintaining correspondence must be valid and configured for this machine (i.e. it should have the appropriate A record in the DNS settings that points your domain name to the IP address of the machine where Mail Server is installed).

The "-h yourdomain.com" parameter must be understood as a service domain for Mail Server. It is usually specified in the MX record of the domain that will be used for maintaining correspondence. As a rule, the "yourdomain.com" looks like mx1.onlyoffice.com. To change the 'yourdomain.com' with your domain name switch from 'BASIC VIEW' to 'ADVANCED VIEW' in the container template and look in 'Extra Parameters'.

 

It is recommended that you select a name like mx.yourdomain.com for the A record of your mail server computer. This means that the A record in your Domain Name System (DNS) must point to the IP address of the computer where Mail Server will be installed and the Pointer (PTR) record on this computer must resolve the computer IP address to a fully-qualified domain name (FQDN) as an opposite to what A record does.

 

To verify the correctness of the settings for the A record the following command is used ( command used inside the mail server docker ) :

dig -t A mx.yourdomain.com

If everything is correct you should see the output which contains lines like these among the others:

...
;; ANSWER SECTION:
mx.yourdomain.com.  IN  A   {your IP address}
...

Instead of {your IP address} the real IP address of the server will be shown ( command used inside the mail server docker ).

dig -x {your IP address}

It should return the output which contains lines like these among the others:

...
;; ANSWER SECTION:
{your IP address}   IN  PTR mx.yourdomain.com.
...

After you install Mail Server, you will also need to add an MX record to yourdomain.com so that it pointed to mx.yourdomain.com. This is required for mail to reach @yourdomain.com addresses.

 

Get the IP address for Mail Server using the command ( run it in unraid terminal ) :

docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' onlyoffice-mail-server

The additional parameters for mail server are available here.

 

The following ports are mapped in the 'Extra Parameters' setting found by switching from 'BASIC VIEW' to 'ADVANCED VIEW' in the container template:

25 for SMTP , 465 for SMTPS , 143 for IMAP , 993 for IMAPS , 110 for POP3 , 995 for POP3S , 8081 for Mail API , 4190 for ManageSieve Protocol

 

The following link is how to configure email in the Only Office Community web portal

 

The self-signed certificates for your domain will be created by default while running the docker container. If you want to use CA sertified certificates, you will need to rename them and copy into the /mnt/user/appdata/onlyoffice/MailServer/data/certs directory before running the image. The following files are required:

/mnt/user/appdata/onlyoffice/MailServer/data/certs/mail.onlyoffice.key 
/mnt/user/appdata/onlyoffice/MailServer/data/certs/mail.onlyoffice.crt 
/mnt/user/appdata/onlyoffice/MailServer/data/certs/mail.onlyoffice.ca-bundle

You can copy the SSL certificates into the /mnt/user/appdata/onlyoffice/MailServer/data/certs directory after running the image. But in this case you will need to restart the docker container.

 

Commands for creation of self signed SSL certificate

 

When using CA certified certificates, the Private key (.key) and SSL certificate (.crt) are provided to you by the CA. When using self-signed certificates you need to generate these files yourself.

Self signed certificate creation for 'onlyoffice-document-server' and 'onlyoffice-community-server' if https is going to be used ( if you install 'onlyoffice-mail-server' https will be required ).

mkdir -p /mnt/user/appdata/onlyoffice/certs
cd /mnt/user/appdata/onlyoffice/certs

openssl genrsa -out onlyoffice.key 2048
openssl req -new -key onlyoffice.key -out onlyoffice.csr
openssl x509 -req -days 365 -in onlyoffice.csr -signkey onlyoffice.key -out onlyoffice.crt
openssl dhparam -out dhparam.pem 2048

#Document Server cert folder:

mkdir -p /mnt/user/appdata/onlyoffice/DocumentServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/onlyoffice.key /mnt/user/appdata/onlyoffice/DocumentServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/onlyoffice.crt /mnt/user/appdata/onlyoffice/DocumentServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/dhparam.pem /mnt/user/appdata/onlyoffice/DocumentServer/data/certs/
chmod 400 /mnt/user/appdata/onlyoffice/DocumentServer/data/certs/onlyoffice.key

#Community Server cert folder:

mkdir -p /mnt/user/appdata/onlyoffice/CommunityServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/onlyoffice.key /mnt/user/appdata/onlyoffice/CommunityServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/onlyoffice.crt /mnt/user/appdata/onlyoffice/CommunityServer/data/certs/
cp /mnt/user/appdata/onlyoffice/certs/dhparam.pem /mnt/user/appdata/onlyoffice/CommunityServer/data/certs/
chmod 400 /mnt/user/appdata/onlyoffice/CommunityServer/data/certs/onlyoffice.key

And restart Docker containers.

 

Once you are done with this you can start the dockers in this order :

  1.     onlyoffice-mysql-server
  2.     onlyoffice-document-server
  3.     onlyoffice-mail-server 
  4.     onlyoffice-community-server
  • To link the the Only Office dockers you need to go to the "Integration" tab in your Only Office Community portal.
  • Note: Do not forget to change the passwords to match and/or anything else you may have changed in the scripts that you run above inside the containers templates ( 'onlyoffice-mysql-server' , 'onlyoffice-mail-server' , 'onlyoffice-community-server' ). Also "Read Description for Changes ----> : " inside the containers templates are there for the necessary changes needed if you are going to do the external installation.
  • One last note: Untick  'I agree to send anonymous usage data to improve ONLYOFFICE' in the community server web install if you are using onlyoffice offline after install and tick only the box with the agreement.
  • Switching to HTTPS from HTTP ( onlyoffice-document-server and onlyoffice-community-server ).

To make the Web UI to open HTTPS instead of HTTP then go and edit the container and change from BASIC VIEW to ADVANCED VIEW and change on the Web UI tab e.g :

 http://[IP]:[PORT:8082] to https://[IP]:[PORT:4432] for onlyoffice-document-server and https://[IP]:[PORT:4431] for onlyoffice-community-server.

Edited by Jidovu Marius Adrian
  • Thanks 1
Link to comment

Installing Nextcloud-ONLYOFFICE integration app

 

All the changes are done inside the Nextcloud docker by opening its console.

 

The Nextcloud administrator can install the integration app from the in-built application market. For that go to the user name and select Apps. After that find ONLYOFFICE in the list of available applications and install it.

If the server with the Nextcloud installed does not have an Internet access, or if you need it for some other reason, the administrator can install the application manually. To start using ONLYOFFICE Document Server with Nextcloud, the following steps must be performed:

 

  • 1. Go to the Nextcloud server apps/ directory (or some other directory used to connect applications, in our case we open the console for the  Nextcloud docker ) :
cd apps/
  • 2. Get the Nextcloud ONLYOFFICE integration app. There are several ways to do that:

a. Download the latest signed version from the official store for Nextcloud.

b. Or you can download the latest signed version from the application release page on GitHub.

c. Or you can clone the application source code and compile it yourself:

git clone https://github.com/ONLYOFFICE/onlyoffice-nextcloud.git onlyoffice
  • 3. Change the owner to update the application right from Nextcloud web interface:
chown -R www-data:www-data onlyoffice
  • 4. In Nextcloud open the ~/index.php/settings/apps?category=disabled page with Not enabled apps by administrator and click Enable for the ONLYOFFICE application.

Configuring Nextcloud-ONLYOFFICE integration app

 

In Nextcloud open the ~/index.php/settings/admin/onlyoffice page with administrative settings for ONLYOFFICE section. Enter the following address to connect ONLYOFFICE Document Server:

https://<documentserver>/

Where the documentserver is the name of the server with the ONLYOFFICE Document Server installed. The address must be accessible for the user browser and from the Nextcloud server. The Nextcloud server address must also be accessible from ONLYOFFICE Document Server for correct work.

 

Sometimes your network configuration might not allow the requests between installed Nextcloud and ONLYOFFICE Document Server using the public addresses. The Advanced server settings allows to set the ONLYOFFICE Document Server address for internal requests from Nextcloud server and the returning Nextcloud address for the internal requests from ONLYOFFICE Document Server. You need to enter them in the appropriate fields.

 

To restrict the access to ONLYOFFICE Document Server and for security reasons and data integrity the encrypted signature is used. Specify the Secret key in the Nextcloud administrative configuration. In the ONLYOFFICE Document Server config file specify the same secret key and enable the validation.

 

Enable or disable the Open file in the same tab setting.

The Open in ONLYOFFICE action will be added to the file context menu. You can specify this action as default and it will be used when the file name is clicked for the selected file types.

 

Known issues

 

  • If the document is shared using the Federated Cloud Sharing app, the co-editing among the servers will not be avaialble. The users from one and the same server can edit the document in the co-editing mode, but the users from two (or more) different servers will not be able to collaborate on the same document in real time.
  • Adding the storage using the External storages app has issues with the co-editing in some cases. If the connection is made using the same authorization keys (the Username and password or Global credentials authentication type is selected), then the co-editing is available for the users. If different authorization keys are used (Log-in credentials, save in database or User entered, store in database authentication options), the co-editing is not available. When the Log-in credentials, save in session authentication type is used, the files cannot be opened in the editor.
  • Nextcloud provides an option to encrypt the file storage. But if the encryption with the per-user encryption keys (used by default in Nextcloud Default encryption module app) is enabled, ONLYOFFICE Document Server cannot open the encrypted files for editing and save them after the editing. The ONLYOFFICE section of the administrative settings page will display a notification about it. However if you set the encryption with the master key, ONLYOFFICE application will work as intended. The instruction on enabling master key based encryption is available in the official documentation on Nextcloud websites.
  • If you are using a self-signed certificate for your Document Server, Nextcloud will not validate such a certificate and will not allow connection to/from Document Server. This issue can be solved the following way: locate the Nextcloud config file (/nextcloud/config/config.php) and open it. Insert the following section to it:
'onlyoffice' => array ( 
	'verify_peer_off' => true 
)
  • This will disable the certificate verification and allow Nextcloud to establish connection with Document Server, but you must remember that this is a temporary insecure solution and we strongly recommend that you replace the certificate with the one issued by some CA. Once you do that, do not forget to remove the above section from Nextcloud config file. 

 

Official Nextcloud ONLYOFFICE integration app link

 

 

Edited by Jidovu Marius Adrian
Link to comment

Thanks a lot @Jidovu Marius Adrian for this docker. I was looking for a way to edit documents on my iPad without using MS Office/Word etc.

 

Your guide is excellent and I was successfull installing the docker. Opening documents by using the demo server is working well. My only remaining issue is accessing my own server rather than the demo server.

 

creating the onlyoffice network was successful

http://192.168.178.28:8082/welcome/ ist showing: Document Server is running

-rw-rw-rw- 1 root root  424 Dec  9 12:04 dhparam.pem
-rw-rw-rw- 1 root root 1298 Dec  9 12:03 onlyoffice.crt
-rw-rw-rw- 1 root root 1078 Dec  9 12:02 onlyoffice.csr
-r-------- 1 root root 1679 Dec  9 12:01 onlyoffice.key

 

https://192.168.178.28:4432/ isn't showing anything - just an error message

 

There is only one error in the log: ==> /var/log/onlyoffice/documentserver/nginx.error.log <== but when I enter the container, the file is empty.

 

Where should I look next? Thanks a lot.

Link to comment

In next cloud click settings and then go to the apps page then open the dissabled apps section, enable the onlyoffice application. ( you can click the app store button to get the connector if you do not have it)

Next open the admin page, on the basic settings tab scroll down to the onlyoffice section and copy the web address including the port of your onlyoffice document server.

Now if you click the files section and then the + button you should have the onlyoffice files there.

Do not forget to disable the test server though.

Edited by Jidovu Marius Adrian
Link to comment

That doesn't work and I can't see any log messages. I have attached the setting of my container.

 

http://192.168.178.28:8082/ is providing the welcome screen and the message, that onlyoffice is running

https://192.168.178.28:4432/ is providing an error mesage - website not accessible

http://server.com:8082/ is providing an error mesage - website not accessible

https://server.com:4432/ is providing an error mesage - website not accessible

 

 

Bildschirmfoto 2019-12-09 um 16.06.58.jpg

Link to comment

You need to configure document server to use ssl by creating the certificates and then add them in the folder:

/mnt/user/appdata/onlyoffice/DocumentServer/data/certs/

After you add them you need to restart the docker container.

 

Then change the container view from basic view to advanced view and on WebUI change http://[IP]:[PORT:8082] to https://[IP]:[PORT:8082]

 

And click apply for the container to restart with the new config.

 

Did you succeed to integrate document server into your nextcloud?

Edited by Jidovu Marius Adrian
  • Thanks 1
Link to comment
1 hour ago, Jidovu Marius Adrian said:

You need to configure document server to use ssl by creating the certificates and then add them in the folder:

/mnt/user/appdata/onlyoffice/DocumentServer/data/certs/

After you add them you need to restart the docker container.

 

Then change the container view from basic view to advanced view and on WebUI change http://[IP]:[PORT:8082] to https://[IP]:[PORT:8082]

 

And click apply for the container to restart with the new config.

 

Did you succeed to integrate document server into your nextcloud?

That is done. /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data is existing (however it is empty) but I created the /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data/certs folder which contains:

-rwxr-xr-x 1 110 114  424 Dec  9 12:04 dhparam.pem*
-rwxr-xr-x 1 110 114 1298 Dec  9 12:03 onlyoffice.crt*
-rwxr-xr-x 1 110 114 1078 Dec  9 12:02 onlyoffice.csr*
-rwxr-xr-x 1 110 114 1679 Dec  9 12:01 onlyoffice.key*

 

I changes the template towards: https://[IP]:[PORT:4432] which is now successfully showing the Welcome Screen. Other than that no success.

 

I will patiently waiting 🙂 Thank you very much!!

Link to comment
20 minutes ago, EdgarWallace said:

That is done. /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data is existing (however it is empty) but I created the /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data/certs folder which contains:

-rwxr-xr-x 1 110 114  424 Dec  9 12:04 dhparam.pem*
-rwxr-xr-x 1 110 114 1298 Dec  9 12:03 onlyoffice.crt*
-rwxr-xr-x 1 110 114 1078 Dec  9 12:02 onlyoffice.csr*
-rwxr-xr-x 1 110 114 1679 Dec  9 12:01 onlyoffice.key*

 

I changes the template towards: https://[IP]:[PORT:4432] which is now successfully showing the Welcome Screen. Other than that no success.

 

I will patiently waiting 🙂 Thank you very much!!

Go to your nextcloud docker and click it then go to the console

cd apps/ 

git clone https://github.com/ONLYOFFICE/onlyoffice-nextcloud.git onlyoffice

chown -R www-data:www-data onlyoffice

That is the connector you need for Nextcloud to function with Document Server.

And configuring it with some easy steps:

1. Access Nextcloud, open the Not enabled apps page and click the Enable button for the ONLYOFFICE application.

2. Open the Nextcloud Admin settings, go to the ONLYOFFICE section and enter the address of the server with ONLYOFFICE Document Server installed: https://<documentserver>

Edited by Jidovu Marius Adrian
Link to comment
49 minutes ago, fekhoo said:

how can you get the mail server to communicate with the community server, i have tried every possible option and i can't get it to work, can you help please. Thank you!

The domain selected for the mail server needs to be changed in the docker template from yourdomain.com.

It can be found by switching from BASIC VIEW to ADVANCED VIEW when you edit the template and is under "Extra Parameters:" tab.

 

It is recommended that you select a name like mx.yourdomain.com for the A record of your mail server computer. This means that the A record in your Domain Name System (DNS) must point to the IP address of the computer where Mail Server will be installed and the Pointer (PTR) record on this computer must resolve the computer IP address to a fully-qualified domain name (FQDN) as an opposite to what A record does.

 

To verify the correctness of the settings for the A record the following command is used ( command used inside the mail server docker ) :

dig -t A mx.yourdomain.com

If everything is correct you should see the output which contains lines like these among the others:

...
;; ANSWER SECTION:
mx.yourdomain.com.  IN  A   {your IP address}
...

Instead of {your IP address} the real IP address of the server will be shown ( command used inside the mail server docker ).

dig -x {your IP address}

It should return the output which contains lines like these among the others:

...
;; ANSWER SECTION:
{your IP address}   IN  PTR mx.yourdomain.com.
...

After you install Mail Server, you will also need to add an MX record to yourdomain.com so that it pointed to mx.yourdomain.com. This is required for mail to reach @yourdomain.com addresses.

 

To get the IP address for the mail server docker use the following command ( command used in unraid terminal ) :

docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' onlyoffice-mail-server

Where ${MAIL_SERVER_IP} is the IP address for Mail Server.

 

To link the the Only Office dockers you need to go to the "Integration" tab in your Only Office Community portal like in the example pictures:

 

step1.png

 

step2.png

 

step3.png

Edited by Jidovu Marius Adrian
Link to comment
  • 3 weeks later...

Hello, Can you help me answer 4 critical questions to decide whether to install this mail server?

 

1. Can I register >1 domains on mail server, such as example1.com, example2.com and example3.com?

2. Does the mail server come with a (web-based) mail client? (or is assumption I should use mine like iMail, Thunderbird etc...)

3. Is it possible to import existing mail content (e.g. example@gmail.com) from .mbox file format? (intent is migration of all emails from GMAIL to my own mail server)

4. Is it possible to, using email account on my own example1.com domain, set up POP that will connect to GMAIL account, and retrieve all emails (intent is again migration of all emails from GMAIL to my own mail server)

 

Thanks.

Edited by emod
Link to comment
5 hours ago, emod said:

Hello, Can you help me answer 4 critical questions to decide whether to install this mail server?

 

1. Can I register >1 domains on mail server, such as example1.com, example2.com and example3.com?

2. Does the mail server come with a (web-based) mail client? (or is assumption I should use mine like iMail, Thunderbird etc...)

3. Is it possible to import existing mail content (e.g. example@gmail.com) from .mbox file format? (intent is migration of all emails from GMAIL to my own mail server)

4. Is it possible to, using email account on my own example1.com domain, set up POP that will connect to GMAIL account, and retrieve all emails (intent is again migration of all emails from GMAIL to my own mail server)

 

Thanks.

1. Only Office does not register domains, for that you need to register a domain with a domain register and update the dns accordingly to your server.

2. The server does come with a web based mail client and you can also configure windows mail or any other program you may want to use for your mails.

3. It is possible import accounts and other data from MS Exchange.

4. You can probably achieve this by creating your own mail in Only Office and add it to windows mail and add the gmail account separately then move mails between them. You can also setup a mail with other mail providers in Only Office as well.

Edited by Jidovu Marius Adrian
Link to comment
  • 3 weeks later...
  • 1 month later...
On 12/9/2019 at 6:16 PM, EdgarWallace said:

That is done. /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data is existing (however it is empty) but I created the /mnt/user/system/docker/appdata/onlyoffice/DocumentServer/data/certs folder which contains:

-rwxr-xr-x 1 110 114  424 Dec  9 12:04 dhparam.pem*
-rwxr-xr-x 1 110 114 1298 Dec  9 12:03 onlyoffice.crt*
-rwxr-xr-x 1 110 114 1078 Dec  9 12:02 onlyoffice.csr*
-rwxr-xr-x 1 110 114 1679 Dec  9 12:01 onlyoffice.key*

 

I changes the template towards: https://[IP]:[PORT:4432] which is now successfully showing the Welcome Screen. Other than that no success.

 

I will patiently waiting 🙂 Thank you very much!!

With the new Nextcloud version 18 I was hoping to enable and use the internal Onlyoffice but with the LSIO docker it seems to be an issue.

I am back using your docker @Jidovu Marius Adrian

I again performed all steps and have the docker running but currently only by adding https://192.168.178.28:4432/ into the Onlyoffice server address. As soon as I am trying to use  https://myaddress.com/apps/onlyoffice I am getting this error:

HealthcheckRequest on check error: Client error: `GET https://myaddress.com/apps/onlyoffice/healthcheck` resulted in a `401 Unauthorized` response: {"message":"Current user is not logged in"}

 

Link to comment
On 3/3/2020 at 12:30 PM, EdgarWallace said:

With the new Nextcloud version 18 I was hoping to enable and use the internal Onlyoffice but with the LSIO docker it seems to be an issue.

I am back using your docker @Jidovu Marius Adrian

I again performed all steps and have the docker running but currently only by adding https://192.168.178.28:4432/ into the Onlyoffice server address. As soon as I am trying to use https://myaddress.com/apps/onlyoffice I am getting this error:


HealthcheckRequest on check error: Client error: `GET https://myaddress.com/apps/onlyoffice/healthcheck` resulted in a `401 Unauthorized` response: {"message":"Current user is not logged in"}

 

Clear the browser cache and login again, probably you mistyped the credentials.

The 401 error is a client side error.

Edited by Jidovu Marius Adrian
Link to comment
  • 4 months later...
On 1/15/2020 at 4:02 AM, cirialkilr said:

The mail server will start get to the point below and then the container shuts itself off.

 

 

@cirialkilr  did you manage to resolve this ...?

i get the same error however when the cgheck the logs on the SQL server i see the below error


Aborted connection 50 to db: 'onlyoffice_mailserver' user: 'mail_admin' host: 'onlyoffice-mail-server.onlyoffice' (Got an error reading communication packets

 

@Jidovu Marius Adrian  can you please help.

Edited by Satyam
Link to comment
5 hours ago, Satyam said:

@cirialkilr  did you manage to resolve this ...?

i get the same error however when the cgheck the logs on the SQL server i see the below error


Aborted connection 50 to db: 'onlyoffice_mailserver' user: 'mail_admin' host: 'onlyoffice-mail-server.onlyoffice' (Got an error reading communication packets

 

@Jidovu Marius Adrian  can you please help.

As of right now i can not try to replicate your issue and find a solution because i am on a laptop and i have some problems in the real life.

You may want to have a look here for the reasons you get the aborted connection error : Communication Errors and Aborted Connections

Link to comment
  • 4 months later...

I just cant get the onlyoffice document server running through https:// rather than http://... I have tried everything suggested in the OP. My webui is defaulted to http://[IP]:[PORT:80] my ports are assigned to 8092 - 80 and 4435 - 443. 

 

It is working with the above UI as is. but nothing else works to get it working with https://... I have tried https://[IP]:[PORT:443], https://[IP]:[PORT:4435] I have also tried changing the ports to those shown in the OP but still nothing im afraid. 

Link to comment
  • 2 months later...
On 7/25/2020 at 6:24 PM, Satyam said:

@cirialkilr  did you manage to resolve this ...?

i get the same error however when the cgheck the logs on the SQL server i see the below error


Aborted connection 50 to db: 'onlyoffice_mailserver' user: 'mail_admin' host: 'onlyoffice-mail-server.onlyoffice' (Got an error reading communication packets

 

@Jidovu Marius Adrian  can you please help.

This error reproduces because of  [Note] Access denied for user 'mail_admin'@'onlyoffice-mail-server' (using password: NO) even when using everything default!

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.