Giter Site home page Giter Site logo

docker-communityserver's Introduction

https://www.onlyoffice.com/


Website | ONLYOFFICE Workspace | Documentation | API | About

https://www.facebook.com/ONLYOFFICE-833032526736775/ https://twitter.com/ONLY_OFFICE https://www.youtube.com/user/onlyofficeTV https://www.instagram.com/the_onlyoffice/

http://www.apache.org/licenses/LICENSE-2.0 https://github.com/ONLYOFFICE/CommunityServer/releases

Overview

ONLYOFFICE Community Server is a free open-source collaborative system developed to manage documents, projects, customer relationship and email correspondence, all in one place.

Starting from version 11.0 Community Server, is distributed as ONLYOFFICE Groups on terms of Apache License.

Functionality

  • Cross platform solution: Linux, Windows
  • Document management
  • Integration with Google Drive, Box, Dropbox, OneDrive, OwnCloud
  • File sharing
  • Document embedding
  • Access rights management
  • Customizable CRM
  • Web-to-lead form
  • Invoicing system
  • Project Management
  • Gantt Chart
  • Milestones, task dependencies and subtasks
  • Time tracking
  • Automated reports
  • Blogs, forums, polls, wiki
  • Calendar
  • Email Aggregator
  • People module (employee database)
  • Support of more than 20 languages

Community Server (distributed as ONLYOFFICE Groups) is a part of ONLYOFFICE Workspace that also includes Document Server (distributed as ONLYOFFICE Docs), Mail Server, Talk (instant messaging app).

Control Panel for administrating ONLYOFFICE Workspace can be found in this repo.

Recommended System Requirements

  • RAM: 4 GB or more
  • CPU: dual-core 2 GHz or higher
  • Swap file: at least 2 GB
  • HDD: at least 2 GB of free space
  • Distributive: 64-bit Red Hat, CentOS or other compatible distributive with kernel version 3.8 or later, 64-bit Debian, Ubuntu or other compatible distributive with kernel version 3.8 or later
  • Docker: version 1.9.0 or later

Installing Prerequisites

Before you start ONLYOFFICE Community Server, you need to create the following folders:

  1. For MySQL server
sudo mkdir -p "/app/onlyoffice/mysql/conf.d";
sudo mkdir -p "/app/onlyoffice/mysql/data";
sudo mkdir -p "/app/onlyoffice/mysql/initdb";
  1. For Community Server data and logs
sudo mkdir -p "/app/onlyoffice/CommunityServer/data";
sudo mkdir -p "/app/onlyoffice/CommunityServer/logs";
sudo mkdir -p "/app/onlyoffice/CommunityServer/letsencrypt";
  1. For Document server data and logs
sudo mkdir -p "/app/onlyoffice/DocumentServer/data";
sudo mkdir -p "/app/onlyoffice/DocumentServer/logs";
  1. And for Mail Server data and logs
sudo mkdir -p "/app/onlyoffice/MailServer/data/certs";
sudo mkdir -p "/app/onlyoffice/MailServer/logs";
  1. For Control Panel:
sudo mkdir -p "/app/onlyoffice/ControlPanel/data";
sudo mkdir -p "/app/onlyoffice/ControlPanel/logs";

Then create the onlyoffice network:

sudo docker network create --driver bridge onlyoffice

Installing MySQL

After that you need to create MySQL server Docker container. Create the configuration file:

echo "[mysqld]
sql_mode = 'NO_ENGINE_SUBSTITUTION'
max_connections = 1000
max_allowed_packet = 1048576000
group_concat_max_len = 2048" > /app/onlyoffice/mysql/conf.d/onlyoffice.cnf

Create the SQL script which will generate the users and issue the rights to them. The onlyoffice_user is required for ONLYOFFICE Community Server, and the mail_admin is required for ONLYOFFICE Mail Server in case it is going to be installed:

echo "ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'my-secret-pw';
CREATE USER IF NOT EXISTS 'onlyoffice_user'@'%' IDENTIFIED WITH mysql_native_password BY 'onlyoffice_pass';
CREATE USER IF NOT EXISTS 'mail_admin'@'%' IDENTIFIED WITH mysql_native_password BY 'Isadmin123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'onlyoffice_user'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'mail_admin'@'%';
FLUSH PRIVILEGES;" > /app/onlyoffice/mysql/initdb/setup.sql

Please note, that the above 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.

Now you can create MySQL container setting MySQL version to 8.0.29:

sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-mysql-server \
 -v /app/onlyoffice/mysql/conf.d:/etc/mysql/conf.d \
 -v /app/onlyoffice/mysql/data:/var/lib/mysql \
 -v /app/onlyoffice/mysql/initdb:/docker-entrypoint-initdb.d \
 -e MYSQL_ROOT_PASSWORD=my-secret-pw \
 -e MYSQL_DATABASE=onlyoffice \
 mysql:8.0.29

Installing Community Server

Use this command to install ONLYOFFICE Community Server:

sudo docker run --net onlyoffice -i -t -d --privileged --restart=always --name onlyoffice-community-server -p 80:80 -p 443:443 -p 5222:5222 --cgroupns=host \
 -e MYSQL_SERVER_ROOT_PASSWORD=my-secret-pw \
 -e MYSQL_SERVER_DB_NAME=onlyoffice \
 -e MYSQL_SERVER_HOST=onlyoffice-mysql-server \
 -e MYSQL_SERVER_USER=onlyoffice_user \
 -e MYSQL_SERVER_PASS=onlyoffice_pass \
 -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
 -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
 -v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
 -v /sys/fs/cgroup:/sys/fs/cgroup:rw \
 onlyoffice/communityserver

Configuring Docker Image

Storing Data

All the data are stored in the specially-designated directories, data volumes, at the following location:

  • /var/log/onlyoffice for ONLYOFFICE Community Server logs
  • /var/www/onlyoffice/Data for ONLYOFFICE Community Server data
  • /etc/letsencrypt for information on generated certificates

To get access to your data from outside the container, you need to mount the volumes. It can be done by specifying the '-v' option in the docker run command.

sudo docker run -i -t -d -p 80:80 --cgroupns=host \
    -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
    -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
	-v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
    -v /sys/fs/cgroup:/sys/fs/cgroup:rw onlyoffice/communityserver

Storing the data on the host machine allows you to easily update ONLYOFFICE once the new version is released without losing your data.

Running ONLYOFFICE Community Server on Different Port

To change the port, use the -p command. E.g.: to make your portal accessible via port 8080 execute the following command:

sudo docker run -i -t -d --privileged -p 8080:80 --cgroupns=host \
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
-v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
-v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
-v /sys/fs/cgroup:/sys/fs/cgroup:rw onlyoffice/communityserver

Exposing Additional Ports

The container ports to be exposed for incoming connections are the folloing:

  • 80 for plain HTTP
  • 443 when HTTPS is enabled (see below)
  • 5222 for XMPP-compatible instant messaging client (for ONLYOFFICE Talk correct work)

You can expose ports by specifying the '-p' option in the docker run command.

sudo docker run -i -t -d --privileged -p 80:80 -p 443:443 -p 5222:5222 --cgroupns=host \
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
-v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
-v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
-v /sys/fs/cgroup:/sys/fs/cgroup:rw onlyoffice/communityserver

For outgoing connections you need to expose the following ports:

  • 80 for HTTP
  • 443 for HTTPS

Additional ports to be exposed for the mail client correct work:

  • 25 for SMTP
  • 465 for SMTPS
  • 143 for IMAP
  • 993 for IMAPS
  • 110 for POP3
  • 995 for POP3S

Running ONLYOFFICE Community Server using HTTPS

sudo docker run -i -t -d -p 80:80  -p 443:443 \
    -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
    -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data onlyoffice/communityserver

Access to the onlyoffice application can be secured using SSL so as to prevent unauthorized access. While a CA certified SSL certificate allows for verification of trust via the CA, a self signed certificates can also provide an equal level of trust verification as long as each client takes some additional steps to verify the identity of your website. Below the instructions on achieving this are provided.

To secure the application via SSL basically two things are needed:

  • Private key (.key)
  • SSL certificate (.crt)

So you need to create and install the following files:

    /app/onlyoffice/CommunityServer/data/certs/onlyoffice.key
    /app/onlyoffice/CommunityServer/data/certs/onlyoffice.crt

When using CA certified certificates (e.g. Let's Encrypt, these files are provided to you by the CA. When using self-signed certificates you need to generate these files yourself.

Using the automatically generated Let's Encrypt SSL Certificates

sudo docker exec -it onlyoffice-community-server bash
bash /var/www/onlyoffice/Tools/letsencrypt.sh yourdomain.com subdomain1.yourdomain.com subdomain2.yourdomain.com

Where yourdomain.com is the address of the domain where your ONLYOFFICE Workspace is installed, and subdomain1.yourdomain.com and subdomain2.yourdomain.com (and any other subdomains separated with a space) are the subdomains for the main domain which you use.

The script will automatically create and install the letsencrypt.org CA-signed certificate to your server and restart the NGINX service for the changes to take effect.

Now your portal should be available using the https:// address.

Generation of Self Signed Certificates

Generation of self-signed SSL certificates involves a simple 3 step procedure.

STEP 1: Create the server private key

openssl genrsa -out onlyoffice.key 2048

STEP 2: Create the certificate signing request (CSR)

openssl req -new -key onlyoffice.key -out onlyoffice.csr

STEP 3: Sign the certificate using the private key and CSR

openssl x509 -req -days 365 -in onlyoffice.csr -signkey onlyoffice.key -out onlyoffice.crt

You have now generated an SSL certificate that's valid for 365 days.

Strengthening the server security

This section provides you with instructions to strengthen your server security. To achieve this you need to generate stronger DHE parameters.

openssl dhparam -out dhparam.pem 2048

Installation of the SSL Certificates

Out of the four files generated above, you need to install the onlyoffice.key, onlyoffice.crt and dhparam.pem files at the onlyoffice server. The CSR file is not needed, but do make sure you safely backup the file (in case you ever need it again).

The default path that the onlyoffice application is configured to look for the SSL certificates is at /var/www/onlyoffice/Data/certs, this can however be changed using the SSL_KEY_PATH, SSL_CERTIFICATE_PATH and SSL_DHPARAM_PATH configuration options.

The /var/www/onlyoffice/Data/ path is the path of the data store, which means that you have to create a folder named certs inside /app/onlyoffice/CommunityServer/data/ and copy the files into it and as a measure of security you will update the permission on the onlyoffice.key file to only be readable by the owner.

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

You are now just one step away from having our application secured.

Available Configuration Parameters

Please refer the docker run command options for the --env-file flag where you can specify all required environment variables in a single file. This will save you from writing a potentially long docker run command.

Below is the complete list of parameters that can be set using environment variables.

  • ONLYOFFICE_HTTPS_HSTS_ENABLED: Advanced configuration option for turning off the HSTS configuration. Applicable only when SSL is in use. Defaults to true.
  • ONLYOFFICE_HTTPS_HSTS_MAXAGE: Advanced configuration option for setting the HSTS max-age in the onlyoffice nginx vHost configuration. Applicable only when SSL is in use. Defaults to 31536000.
  • SSL_CERTIFICATE_PATH: The path to the SSL certificate to use. Defaults to /var/www/onlyoffice/Data/certs/onlyoffice.crt.
  • SSL_KEY_PATH: The path to the SSL certificate's private key. Defaults to /var/www/onlyoffice/Data/certs/onlyoffice.key.
  • SSL_DHPARAM_PATH: The path to the Diffie-Hellman parameter. Defaults to /var/www/onlyoffice/Data/certs/dhparam.pem.
  • SSL_VERIFY_CLIENT: Enable verification of client certificates using the CA_CERTIFICATES_PATH file. Defaults to false
  • MYSQL_SERVER_HOST: The IP address or the name of the host where the server is running.
  • MYSQL_SERVER_PORT: The port number.
  • MYSQL_SERVER_DB_NAME: The name of a MySQL database to be created on image startup.
  • MYSQL_SERVER_USER: The new user name with superuser permissions for the MySQL account.
  • MYSQL_SERVER_PASS: The password set for the MySQL account.

Installing ONLYOFFICE Workspace

ONLYOFFICE Community Server is a part of ONLYOFFICE Community Edition that comprises also Document Server and Mail Server. To install them, follow these easy steps:

STEP 1: Create the onlyoffice network.

docker network create --driver bridge onlyoffice

Then launch containers on it using the 'docker run --net onlyoffice' option:

STEP 2: Install MySQL.

Follow these steps to install MySQL server.

STEP 3: Generate JWT Secret

JWT secret defines the secret key to validate the JSON Web Token in the request to the ONLYOFFICE Document Server. You can specify it yourself or easily get it using the command:

JWT_SECRET=$(cat /dev/urandom | tr -dc A-Za-z0-9 | head -c 32);

STEP 4: Install ONLYOFFICE Document Server.

sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-document-server \
 -e JWT_ENABLED=true \
 -e JWT_SECRET=${JWT_SECRET} \
 -e JWT_HEADER=AuthorizationJwt \
 -v /app/onlyoffice/DocumentServer/logs:/var/log/onlyoffice  \
 -v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/Data  \
 -v /app/onlyoffice/DocumentServer/fonts:/usr/share/fonts/truetype/custom \
 -v /app/onlyoffice/DocumentServer/forgotten:/var/lib/onlyoffice/documentserver/App_Data/cache/files/forgotten \
 onlyoffice/documentserver

To learn more, refer to the ONLYOFFICE Document Server documentation.

STEP 5: Install ONLYOFFICE Mail Server.

For the mail server correct work you need to specify its hostname 'yourdomain.com'. To learn more, refer to the ONLYOFFICE Mail Server documentation.

sudo docker run --init --net onlyoffice --privileged -i -t -d --restart=always --name onlyoffice-mail-server -p 25:25 -p 143:143 -p 587:587 \
 -e MYSQL_SERVER=onlyoffice-mysql-server \
 -e MYSQL_SERVER_PORT=3306 \
 -e MYSQL_ROOT_USER=root \
 -e MYSQL_ROOT_PASSWD=my-secret-pw \
 -e MYSQL_SERVER_DB_NAME=onlyoffice_mailserver \
 -v /app/onlyoffice/MailServer/data:/var/vmail \
 -v /app/onlyoffice/MailServer/data/certs:/etc/pki/tls/mailserver \
 -v /app/onlyoffice/MailServer/logs:/var/log \
 -h yourdomain.com \
 onlyoffice/mailserver

The additional parameters for mail server are available here.

STEP 6: Install ONLYOFFICE Control Panel

docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-control-panel \
-v /var/run/docker.sock:/var/run/docker.sock \
-v /app/onlyoffice/CommunityServer/data:/app/onlyoffice/CommunityServer/data \
-v /app/onlyoffice/ControlPanel/data:/var/www/onlyoffice/Data \
-v /app/onlyoffice/ControlPanel/logs:/var/log/onlyoffice onlyoffice/controlpanel

STEP 7: Install ONLYOFFICE Community Server

sudo docker run --net onlyoffice -i -t -d --privileged --restart=always --name onlyoffice-community-server -p 80:80 -p 443:443 -p 5222:5222 --cgroupns=host \
 -e MYSQL_SERVER_ROOT_PASSWORD=my-secret-pw \
 -e MYSQL_SERVER_DB_NAME=onlyoffice \
 -e MYSQL_SERVER_HOST=onlyoffice-mysql-server \
 -e MYSQL_SERVER_USER=onlyoffice_user \
 -e MYSQL_SERVER_PASS=onlyoffice_pass \
 -e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server \
 -e DOCUMENT_SERVER_JWT_ENABLED=true \
 -e DOCUMENT_SERVER_JWT_SECRET=${JWT_SECRET} \
 -e DOCUMENT_SERVER_JWT_HEADER=AuthorizationJwt \
 -e MAIL_SERVER_API_HOST=${MAIL_SERVER_IP} \
 -e MAIL_SERVER_DB_HOST=onlyoffice-mysql-server \
 -e MAIL_SERVER_DB_NAME=onlyoffice_mailserver \
 -e MAIL_SERVER_DB_PORT=3306 \
 -e MAIL_SERVER_DB_USER=root \
 -e MAIL_SERVER_DB_PASS=my-secret-pw \
 -e CONTROL_PANEL_PORT_80_TCP=80 \
 -e CONTROL_PANEL_PORT_80_TCP_ADDR=onlyoffice-control-panel \
 -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
 -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
 -v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
 -v /sys/fs/cgroup:/sys/fs/cgroup:rw \
 onlyoffice/communityserver

Where ${MAIL_SERVER_IP} is the IP address for ONLYOFFICE Mail Server. You can easily get it using the command:

MAIL_SERVER_IP=$(docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' onlyoffice-mail-server)

Alternatively, you can use an automatic installation script to install ONLYOFFICE Workspace at once. For the mail server correct work you need to specify its hostname 'yourdomain.com'.

STEP 1: Download the ONLYOFFICE Workspace Docker script file

wget https://download.onlyoffice.com/install/workspace-install.sh

STEP 2: Install ONLYOFFICE Workspace executing the following command:

workspace-install.sh -md yourdomain.com

Or use docker-compose.

First you need to clone this GitHub repository:

git clone https://github.com/ONLYOFFICE/Docker-CommunityServer

After that switch to the repository folder:

cd Docker-CommunityServer

For the mail server correct work, open one of the files depending on the product you use:

For working on Ubuntu 22.04 and Debian 11 or later, you need to use docker-compose versions v2.16.0 or later and uncomment the cgroup line in the yml file

Then replace the ${MAIL_SERVER_HOSTNAME} variable with your own hostname for the Mail Server. After that, assuming you have docker-compose installed, execute the following command:

cd link-to-your-modified-docker-compose
docker-compose up -d

Upgrading ONLYOFFICE Community Server

To upgrade to a newer release, please follow these easy steps:

STEP 1: Make sure that all the container volumes are mounted following the Storing Data section instructions:

sudo docker inspect --format='{{range $p,$conf:=.HostConfig.Binds}}{{$conf}};{{end}}' {{COMMUNITY_SERVER_ID}} 

where {{COMMUNITY_SERVER_ID}} stands for a container name or ID

STEP 2 Remove the current container sudo docker rm -f {{COMMUNITY_SERVER_ID}}

STEP 3 Remove the current image sudo docker rmi -f $(sudo docker images | grep onlyoffice/communityserver | awk '{ print $3 }')

STEP 4 Run the new image with the same map paths

sudo docker run -i -t -d --privileged -p 80:80 --cgroupns=host \
-e MYSQL_SERVER_ROOT_PASSWORD=my-secret-pw \
-e MYSQL_SERVER_DB_NAME=onlyoffice \
-e MYSQL_SERVER_HOST=onlyoffice-mysql-server \
-e MYSQL_SERVER_USER=onlyoffice_user \
-e MYSQL_SERVER_PASS=onlyoffice_pass \
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice  \
-v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
-v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt \
-v /sys/fs/cgroup:/sys/fs/cgroup:rw onlyoffice/communityserver

This will update Community Server container only and will not connect Document Server and Mail Server to it. You will need to use the additional parameters (like those used during installation) to connect them.

Or you can use ONLYOFFICE Workspace script file to upgrade your current installation:

bash workspace-install.sh -u true

It will update all the installed components automatically. If you want to update Community Server only, use the following command:

bash workspace-install.sh -u true -cv 9.1.0.393 -ids false -ims false

Where 9.1.0.393 is the number of Community Server version which you are going to update to.

Connecting Your Own Modules

You can now create your own modules and connect them to ONLYOFFICE Community Server. See this instruction for more details.

Project Information

Official website: https://www.onlyoffice.com

Code repository: https://github.com/ONLYOFFICE/CommunityServer

License: Apache 2.0

ONLYOFFICE Workspace: https://www.onlyoffice.com/workspace.aspx

User feedback and support

If you have any problems with or questions about this image, please visit our official forum to find answers to your questions: dev.onlyoffice.org or you can ask and answer ONLYOFFICE development questions on Stack Overflow.

docker-communityserver's People

Contributors

agolybev avatar aleksandrkharitonov avatar alexeybannov avatar alexeysafronov avatar andreysavihin avatar bengtfredh avatar carazyda avatar danilapog avatar elshirak avatar evgeniy-antonyuk avatar hellonadya avatar ivanovnikolay avatar jcgruenhage avatar linneys avatar pavelbannov avatar sk81biz avatar vyacheslavsemin avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

docker-communityserver's Issues

RancherOS installation freeze

Hello,
I'm facing à little issue.
I'm currently trying to test Onlyoffice community server, i wiil use community and document server.
We are using rancher OS to quickly deploy our application.
So i've tried to write a docker compose and rancher compose, to easily create a "onlyoffice" stack.
But when trying to reach the plateform throught web browser, the server stuck on install page (i quit after 45 minutes)

image

here are booth files:
docker compose:
`
version: '2'
volumes:
community_data: {}
document_data: {}
mail_log: {}
document_log: {}
mail_certs: {}
mail_data: {}
community_log: {}
services:

LB-onlyoffice:
image: rancher/lb-service-haproxy:v0.7.9
ports:
- 8084:8084/tcp
labels:
io.rancher.container.agent.role: environmentAdmin
io.rancher.container.create_agent: 'true'

onlyoffice-document-server:
image: onlyoffice/documentserver:latest
stdin_open: true
tty: true
restart: always
volumes:
- document_data:/var/www/onlyoffice/Data
- document_fonts:/usr/share/fonts/truetype/custom
- document_log:/var/log/onlyoffice
tty: true
expose:
- '80'
- '443'

onlyoffice-mysql-server:
container_name: onlyoffice-mysql-server
image: mysql:5.7
environment:
- MYSQL_ROOT_PASSWORD=my-secret-pw
- MYSQL_DATABASE=onlyoffice
- MYSQL_USER=onlyoffice_user
- MYSQL_PASSWORD=onlyoffice_pass
networks:
- onlyoffice
stdin_open: true
tty: true
restart: always
volumes:
- /config/mysql/conf.d:/etc/mysql/conf.d
- mysql_data:/var/lib/mysql

onlyoffice-community-server:
container_name: onlyoffice-community-server
image: onlyoffice/communityserver:latest
depends_on:
- onlyoffice-mysql-server
- onlyoffice-document-server
environment:
- DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
- MYSQL_SERVER_ROOT_PASSWORD=my-secret-pw
- MYSQL_SERVER_DB_NAME=onlyoffice
- MYSQL_SERVER_HOST=onlyoffice-mysql-server
- MYSQL_SERVER_USER=onlyoffice_user
- MYSQL_SERVER_PASS=onlyoffice_pass
- MAIL_SERVER_API_PORT=8081
- MAIL_SERVER_API_HOST=onlyoffice-mail-server
- MAIL_SERVER_DB_HOST=onlyoffice-mysql-server
- MAIL_SERVER_DB_PORT=3306
- MAIL_SERVER_DB_NAME=onlyoffice_mailserver
- MAIL_SERVER_DB_USER=root
- MAIL_SERVER_DB_PASS=my-secret-pw
networks:
- onlyoffice
expose:
- '80'
- '5222'
stdin_open: true
tty: true
restart: always
volumes:
- community_data:/var/www/onlyoffice/Data
- community_log:/var/log/onlyoffice
- document_data:/var/www/onlyoffice/DocumentServerData
`

And rancher compose.

version: '2' services: LB-onlyoffice: scale: 1 start_on_create: true lb_config: certs: [] port_rules: - hostname: '' priority: 1 protocol: http service: onlyoffice-community-server source_port: 8084 target_port: 80 health_check: healthy_threshold: 2 response_timeout: 2000 port: 42 unhealthy_threshold: 3 initializing_timeout: 60000 interval: 2000 reinitializing_timeout: 60000 onlyoffice-document-server: scale: 1 start_on_create: true onlyoffice-mysql-server: scale: 1 start_on_create: true onlyoffice-community-server: scale: 1 start_on_create: true

Sorry if i made huge mistakes, i'm relatively new to docker and rancher.
Thanks a lot for the help.

No port on invitation email

I have run CommunityServer on port 8888, so the portal address is 192.168.2.100:8888. 

When i invite new people by "Import People - Manually", the link on the invitation email that user
received does not contain port 8888, so click the "Click here to join the portal" button can not
access the system. The portal address displayed as 192.168.2.100.
If i add new people by "Create - User", nothing wrong happend.

High Memory Usage and constant cpu usage when idle

I got only office working ok with mail, documents, and the other apps working fine but it seems to use an excessive amount of memory. The memory requirements for community server are sometimes said to be 2GB but out of the box I get this in docker:

de94b8b31d2c        onlyoffice_onlyoffice-community-server_1   42.01%              7.388GiB / 15.66GiB   47.18%              3.22MB / 40.7MB     441MB / 3.52MB      587

Without doing anything in the portal the cpu usage shows 42%. in the logs I see what looks like bash debugging with set -x and a lot of lines being thrown in there. Is that normal?

It also takes a long time to warm up. From spinning up the docker compose file to getting a log in screen can take more than a minute.

Document editing not working behind HTTPS reverse proxy

In my setup I use two containers for Community and Document servers. Everything worked fine. My docker-compose.yml file is as follows:

version: '2'
services:

  community:
    restart: always
    image: onlyoffice/communityserver
    depends_on:
      - document
    networks:
      default:
      proxy:
    volumes:
      - ./CommunityServer/data:/var/www/onlyoffice/Data
      - ./CommunityServer/mysql:/var/lib/mysql
      - ./CommunityServer/logs:/var/log/onlyoffice
      - ./DocumentServer/data:/var/www/onlyoffice/DocumentServerData
    environment:
      VIRTUAL_HOST: office.mydomain.com
      LETSENCRYPT_HOST: office.mydomain.com
      LETSENCRYPT_EMAIL: [email protected]
      DOCUMENT_SERVER_PORT_80_TCP_ADDR: document
    stdin_open: true
    tty: true

  document:
    restart: always
    image: onlyoffice/documentserver
    volumes:
      - ./DocumentServer/data:/var/www/onlyoffice/Data
      - ./DocumentServer/logs:/var/log/onlyoffice
    stdin_open: true
    tty: true

networks:
  proxy:
    external:
      name: nginxproxy_backend

I use nginx as a reverse proxy for my services. Recently I've set up HTTPS for all my services with Let's Encrypt so config for each service looks like this:

upstream office.mydomain.com {
                ## Can be connect with "nginxproxy_backend" network
            # onlyoffice_community_1
            server 172.19.0.7:80;
}
server {
    server_name office.mydomain.com;
    listen 80 ;
    access_log /var/log/nginx/access.log vhost;
    return 301 https://$host$request_uri;
}
server {
    server_name office.mydomain.com;
    listen 443 ssl http2 ;
    access_log /var/log/nginx/access.log vhost;
    ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
    ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA;
    ssl_prefer_server_ciphers on;
    ssl_session_timeout 5m;
    ssl_session_cache shared:SSL:50m;
    ssl_certificate /etc/nginx/certs/office.mydomain.com.crt;
    ssl_certificate_key /etc/nginx/certs/office.mydomain.com.key;
    ssl_dhparam /etc/nginx/certs/office.mydomain.com.dhparam.pem;
    add_header Strict-Transport-Security "max-age=31536000";
    include /etc/nginx/vhost.d/default;
    location / {
        proxy_pass http://office.mydomain.com;
    }
}

The problem I'm encountering is:

  1. open document for editing
  2. new tab appears and editor interface loaded
  3. content of document doesn't load, loading banner spins forever
  4. in address bar there is warning about mixed content
  5. if i click "disable protection for now" page reloads and i immediately get "Unknown error" banner

Not getting activation mails

I installed the only office by using the below command :


docker run --net onlyoffice --name onlyoffice-document-server onlyoffice/documentserver

docker run --net onlyoffice --privileged -i -t -d --name onlyoffice-mail-server -p 25:25 -p 143:143 -p 587:587 -h 10.0.2.37 onlyoffice/mailserver

docker run --net onlyoffice -i -t -d --name onlyoffice-community-server -p 80:80 -p 5222:5222 -p 443:443 --link onlyoffice-mail-server:mail_server --link onlyoffice-document-server:document_server onlyoffice/communityserver


and here are the logs of the mail server :


[root@V37 ~]# docker logs 051df1fda9d6
[ INFO ] Checking configuration file: /usr/src/iRedMail/config ... [FOUND]
[ INFO ] Import installation process status from file: /usr/src/iRedMail/runtime/install.status.


  • Start iRedMail Configurations

[ INFO ] Create required system accounts: vmail, iredapd.
[ INFO ] Configure Apache web server and PHP.
[ INFO ] Configure PHP.
[ INFO ] Configure MySQL database server.
[ INFO ] Configure Postfix (Message Transfer Agent).
[ INFO ] Configure Cluebringer (postfix policy server).
[ INFO ] Configure Dovecot (pop3/imap/managesieve server).
[ INFO ] Configure ClamAV (anti-virus toolkit).
[ INFO ] Configure Amavisd-new (interface between MTA and content checkers).
[ INFO ] Configure SpamAssassin (content-based spam filter).
[ INFO ] Configure OpenDkim.
[ INFO ] Configure Fail2ban (authentication failure monitor).
[ INFO ] Configure Server API.
[ INFO ] Configure SpamTrainer.
[ INFO ] Configure Awstats (logfile analyzer for mail and web server).
[ INFO ] Create self-signed SSL certification files (2048 bits).
[ INFO ] Generate a strong, unique Diffie Hellman Group with openssl, please wait.


  • iRedMail-0.9.2 installation and configuration complete.

[ INFO ] Disable SELinux in /etc/selinux/config.
[ INFO ] Removing package(s): sendmail
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package sendmail.x86_64 0:8.14.4-9.el6_8.1 will be erased
--> Processing Dependency: sendmail = 8.14.4-9.el6_8.1 for package: sendmail-devel-8.14.4-9.el6_8.1.x86_64
--> Running transaction check
---> Package sendmail-devel.x86_64 0:8.14.4-9.el6_8.1 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size

Removing:
sendmail x86_64 8.14.4-9.el6_8.1 @base 1.5 M
Removing for dependencies:
sendmail-devel x86_64 8.14.4-9.el6_8.1 @base 254 k

Transaction Summary

Remove 2 Package(s)

Installed size: 1.8 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Erasing : sendmail-devel-8.14.4-9.el6_8.1.x86_64 1/2
Erasing : sendmail-8.14.4-9.el6_8.1.x86_64 2/2
Verifying : sendmail-devel-8.14.4-9.el6_8.1.x86_64 1/2
Verifying : sendmail-8.14.4-9.el6_8.1.x86_64 2/2

Removed:
sendmail.x86_64 0:8.14.4-9.el6_8.1

Dependency Removed:
sendmail-devel.x86_64 0:8.14.4-9.el6_8.1

Complete!
grep: /etc/ssh/sshd_config: No such file or directory
[ INFO ] Copy firewall sample rules: /etc/sysconfig/iptables.
[ INFO ] Restarting firewall ...
[ INFO ] Copy MySQL sample file: /etc/my.cnf.
[ INFO ] Enable SSL support for MySQL server.



  • Congratulations, mail server setup completed successfully. Please
  • read below file for more information:
    • /usr/src/iRedMail/iRedMail.tips
  • And it's sent to your mail account [email protected].

********************* WARNING **************************************
*

  • Rebooting your system is required to enable mail services.

mkdir: cannot create directory /var/log/httpd': File exists rm: cannot remove /var/run/syslogd.pid': No such file or directory
rm: cannot remove /var/run/cbpolicyd.pid': No such file or directory rm: cannot remove /var/run/opendkim/opendkim.pid': No such file or directory
Waiting for external MySql response
/usr/src/iRedMail/functions/mysql.sh: line 33: ECHO_INFO: command not found
/usr/src/iRedMail/functions/mysql.sh: line 36: ECHO_DEBUG: command not found
Starting crond: [ OK ]
Starting Dovecot Imap: [ OK ]
Starting system logger: [ OK ]
Starting amavisd: [ OK ]

Starting postfix: [FAILED]
Starting cbpolicyd: [ OK ]
Starting Clam AntiVirus Daemon: LibClamAV Warning: **************************************************
LibClamAV Warning: *** The virus database is older than 7 days! ***
LibClamAV Warning: *** Please update it as soon as possible. ***
LibClamAV Warning: **************************************************
[ OK ]
Starting clamd.amavisd: LibClamAV Warning: **************************************************
LibClamAV Warning: *** The virus database is older than 7 days! ***
LibClamAV Warning: *** Please update it as soon as possible. ***
LibClamAV Warning: **************************************************
[ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using 10.0.2.37 for ServerName
[ OK ]
Generating default DKIM keys: [ OK ]
Default DKIM keys for 0.2.37 created in /usr/local/etc/opendkim/keys.
Starting OpenDKIM Milter: [ OK ]
Starting spamd: [ OK ]
Starting fail2ban: [ OK ]
Starting server
[root@V37 ~]#


here are the logs of document server :

[root@V37 ~]# docker logs 58ad58aa5d46

  • SERVER_HOST=
  • ONLYOFFICE_DIR=/var/www/onlyoffice
  • ONLYOFFICE_DATA_DIR=/var/www/onlyoffice/Data
  • ONLYOFFICE_SERVICES_DIR=/var/www/onlyoffice/Services
  • ONLYOFFICE_SQL_DIR=/var/www/onlyoffice/Sql
  • ONLYOFFICE_ROOT_DIR=/var/www/onlyoffice/WebStudio
  • ONLYOFFICE_APISYSTEM_DIR=/var/www/onlyoffice/ApiSystem
  • ONLYOFFICE_MONOSERVER_PATH=/etc/init.d/monoserve
  • ONLYOFFICE_HYPERFASTCGI_PATH=/etc/hyperfastcgi/onlyoffice
  • ONLYOFFICE_MONOSERVE_COUNT=1
  • ONLYOFFICE_MODE=SERVER
  • ONLYOFFICE_GOD_DIR=/etc/god/conf.d
  • ONLYOFFICE_CRON_DIR=/etc/cron.d
  • ONLYOFFICE_CRON_PATH=/etc/cron.d/onlyoffice
    ++ ip -o -f inet addr show
    ++ awk '/scope global/ {print $4}'
    ++ head -1
  • DOCKER_ONLYOFFICE_SUBNET=172.18.0.3/16
    ++ awk '/inet / {gsub(//.*/,"",$2); print $2}'
    ++ head -1
    ++ ip addr show eth0
  • DOCKER_CONTAINER_IP=172.18.0.3
  • DOCKER_ENABLED=true
    +++ dirname /app/onlyoffice/run-community-server.sh
    ++ cd /app/onlyoffice
    ++ pwd
  • DIR=/app/onlyoffice
  • NGINX_CONF_DIR=/etc/nginx/sites-enabled
    ++ grep processor /proc/cpuinfo
    ++ wc -l
  • NGINX_WORKER_PROCESSES=1
    ++ ulimit -n
  • NGINX_WORKER_CONNECTIONS=1048576
  • SERVICE_SSO_AUTH_HOST_ADDR=
  • '[' '!' -d /etc/nginx/sites-enabled ']'
  • '[' '!' -d /var/www/onlyoffice/DocumentServerData ']'
  • NGINX_ROOT_DIR=/etc/nginx
  • VALID_IP_ADDRESS_REGEX='^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]).){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$'
  • LOG_DEBUG=DEBUG
  • LOG_DIR=/var/log/onlyoffice/
  • ONLYOFFICE_HTTPS=false
  • SSL_CERTIFICATES_DIR=/var/www/onlyoffice/Data/certs
  • SSL_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.crt
  • SSL_KEY_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.key
  • SSL_DHPARAM_PATH=/var/www/onlyoffice/Data/certs/dhparam.pem
  • SSL_VERIFY_CLIENT=off
  • SSL_OCSP_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/stapling.trusted.crt
  • CA_CERTIFICATES_PATH=/var/www/onlyoffice/Data/certs/ca.crt
  • ONLYOFFICE_HTTPS_HSTS_ENABLED=true
  • ONLYOFFICE_HTTPS_HSTS_MAXAGE=63072000
  • SYSCONF_TEMPLATES_DIR=/app/onlyoffice/config
  • mkdir -p /app/onlyoffice/config/nginx
  • SYSCONF_TOOLS_DIR=/app/onlyoffice/assets/tools
  • ONLYOFFICE_SERVICES_INTERNAL_HOST=
  • ONLYOFFICE_SERVICES_EXTERNAL=false
  • DOCUMENT_SERVER_ENABLED=false
  • DOCUMENT_SERVER_HOST=
  • DOCUMENT_SERVER_PROTOCOL=http
  • DOCUMENT_SERVER_API_URL='/web-apps/apps/api/documents/api.js'
  • DOCUMENT_SERVER_HOST_IP=
  • CONTROL_PANEL_ENABLED=false
  • MAIL_SERVER_ENABLED=false
    ++ dig +short myip.opendns.com @resolver1.opendns.com
  • EXTERNAL_IP=106.51.226.51
  • MYSQL_SERVER_ROOT_PASSWORD=
  • MYSQL_SERVER_HOST=localhost
  • MYSQL_SERVER_PORT=3306
  • MYSQL_SERVER_DB_NAME=onlyoffice
  • MYSQL_SERVER_USER=root
  • MYSQL_SERVER_PASS=
  • MYSQL_SERVER_EXTERNAL=false
  • mkdir -p /var/www/onlyoffice/Data/certs/.well-known/acme-challenge
  • check_partnerdata
  • PARTNER_DATA_FILE=/var/www/onlyoffice/Data/json-data.txt
  • '[' -f /var/www/onlyoffice/Data/json-data.txt ']'
  • re='^[0-9]+$'
  • [[ 1 =~ ^[0-9]+$ ]]
  • cp /etc/nginx/includes/onlyoffice-communityserver-nginx.conf.template /etc/nginx/nginx.conf
  • sed 's/^worker_processes.*/worker_processes 1;/' -i /etc/nginx/nginx.conf
  • sed 's/worker_connections.*/worker_connections 1048576;/' -i /etc/nginx/nginx.conf
  • cp /etc/nginx/includes/onlyoffice-communityserver-common-init.conf.template /etc/nginx/sites-enabled/onlyoffice
  • rm -f /etc/nginx/conf.d/default.conf
  • rsyslogd
  • service nginx restart
  • Restarting nginx nginx start-stop-daemon: warning: failed to kill 26240: No such process
    [ OK ]
  • '[' ']'
  • '[' ']'
  • '[' ']'
  • '[' false ']'
  • '[' 172.18.0.3/16 ']'
  • '[' -z '' ']'
    ++ dig +short
  • DOCUMENT_SERVER_HOST_IP='k.root-servers.net.
    f.root-servers.net.
    l.root-servers.net.
    g.root-servers.net.
    j.root-servers.net.
    h.root-servers.net.
    m.root-servers.net.
    i.root-servers.net.
    d.root-servers.net.
    b.root-servers.net.
    c.root-servers.net.
    e.root-servers.net.
    a.root-servers.net.'
  • check_ip_is_internal 172.18.0.3/16 k.root-servers.net. f.root-servers.net. l.root-servers.net. g.root-servers.net. j.root-servers.net. h.root-servers.net. m.root-servers.net. i.root-servers.net. d.root-servers.net. b.root-servers.net. c.root-servers.net. e.root-servers.net. a.root-servers.net.
  • local 'IPRE=([0-9]+).([0-9]+).([0-9]+).([0-9]+)'
  • IP=($(echo "$1" | sed -ne 's:^'"$IPRE"'/.$:\1 \2 \3 \4:p'))
    ++ echo 172.18.0.3/16
    ++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)/.
    $:\1 \2 \3 \4:p'
  • local IP
  • MASK=($(echo "$1" | sed -ne 's:^[^/]/'"$IPRE"'$:\1 \2 \3 \4:p'))
    ++ sed -ne 's:^[^/]
    /([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
    ++ echo 172.18.0.3/16
  • local MASK
  • '[' 0 -ne 4 ']'
  • BITCNT=($(echo "$1" | sed -ne 's:^[^/]/([0-9]+)$:\1:p'))
    ++ echo 172.18.0.3/16
    ++ sed -ne 's:^[^/]
    /([0-9]+)$:\1:p'
  • local BITCNT
  • BITCNT=4294901760
  • (( I=0 ))
  • (( I<4 ))
  • MASK[$I]=255
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=255
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • NETWORK=()
  • local NETWORK
  • (( I=0 ))
  • (( I<4 ))
  • NETWORK[$I]=172
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=18
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • INIP=($(echo "$2" | sed -ne 's:^'"$IPRE"'$:\1 \2 \3 \4:p'))
    ++ echo k.root-servers.net.
    ++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
  • local INIP
  • (( I=0 ))
  • (( I<4 ))
    /app/onlyoffice/run-community-server.sh: line 110: & 255 : syntax error: operand expected (error token is "& 255 ")
  • '[' localhost '!=' localhost ']'
  • '[' ']'
  • '[' ']'
  • MAIL_SERVER_API_PORT=8081
  • MAIL_SERVER_API_HOST=
  • MAIL_SERVER_DB_HOST=
  • MAIL_SERVER_DB_PORT=3306
  • MAIL_SERVER_DB_NAME=onlyoffice_mailserver
  • MAIL_SERVER_DB_USER=mail_admin
  • MAIL_SERVER_DB_PASS=Isadmin123
  • '[' ']'
  • '[' ']'
  • REDIS_SERVER_HOST=
  • REDIS_SERVER_CACHEPORT=6379
  • REDIS_SERVER_PASSWORD=
  • REDIS_SERVER_SSL=false
  • REDIS_SERVER_DATABASE=0
  • REDIS_SERVER_CONNECT_TIMEOUT=5000
  • REDIS_SERVER_EXTERNAL=false
  • '[' ']'
  • '[' false == false ']'
  • chown -R mysql:mysql /var/lib/mysql/
  • chmod -R 755 /var/lib/mysql/
  • '[' '!' -f /var/lib/mysql/ibdata1 ']'
  • '[' DEBUG ']'
  • log_debug 'Fix docker bug volume mapping for mysql'
  • echo 'onlyoffice: [Debug] Fix docker bug volume mapping for mysql'
    onlyoffice: [Debug] Fix docker bug volume mapping for mysql
  • myisamchk -q -r /var/lib/mysql/mysql/proc
  • check record delete-chain
  • recovering (with sort) MyISAM-table '/var/lib/mysql/mysql/proc'
    Data records: 11
  • Fixing index 1
  • service mysql start
  • Starting MySQL database server mysqld [ OK ]
  • Checking for tables which need an upgrade, are corrupt or were
    not closed cleanly.
  • '[' '!' -f /var/lib/mysql/mysql_upgrade_info ']'

  • '[' -n '' ']'
    ++ grep password /etc/mysql/debian.cnf
    ++ head -1
    ++ sed 's/password\s*=\s*//'
    ++ tr -d '[[:space:]]'

  • DEBIAN_SYS_MAINT_PASS=U6TOvfe0EpzTxJ08

  • mysql_scalar_exec 'GRANT ALL PRIVILEGES ON . TO '''debian-sys-maint'''@'''localhost''' IDENTIFIED BY '''U6TOvfe0EpzTxJ08''''

  • local queryResult=

  • '[' '' == opt_ignore_db_name ']'
    ++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice -e 'GRANT ALL PRIVILEGES ON . TO '''debian-sys-maint'''@'''localhost''' IDENTIFIED BY '''U6TOvfe0EpzTxJ08''''

  • queryResult=

  • echo

  • mysql_check_connection

  • '[' DEBUG ']'

  • log_debug 'Mysql check connection for localhost'

  • echo 'onlyoffice: [Debug] Mysql check connection for localhost'
    onlyoffice: [Debug] Mysql check connection for localhost

  • mysqladmin ping -h localhost -P 3306 -u root --password= --silent
    mysqld is alive
    ++ mysql_scalar_exec 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=onlyoffice
    ++ echo onlyoffice

  • DB_IS_EXIST=onlyoffice
    ++ mysql_list_exec 'SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=utf8
    ++ read -ra vars
    ++ for i in '"${vars[0][@]}"'
    ++ echo utf8

  • DB_CHARACTER_SET_NAME=utf8
    ++ mysql_list_exec 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=utf8_general_ci
    ++ read -ra vars
    ++ for i in '"${vars[0][@]}"'
    ++ echo utf8_general_ci

  • DB_COLLATION_NAME=utf8_general_ci
    ++ mysql_scalar_exec 'SELECT COUNT() FROM information_schema.tables WHERE table_schema='''onlyoffice''''
    ++ local queryResult=
    ++ '[' '' == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice -e 'SELECT COUNT(
    ) FROM information_schema.tables WHERE table_schema='''onlyoffice''''
    ++ queryResult=191
    ++ echo 191

  • DB_TABLES_COUNT=191

  • '[' -z onlyoffice ']'

  • '[' utf8 '!=' utf8 ']'

  • '[' 191 -eq 0 ']'

  • change_connections default /var/www/onlyoffice/WebStudio/web.connections.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/WebStudio/web.connections.config

  • change_connections teamlabsite /var/www/onlyoffice/WebStudio/web.connections.config

  • sed '/teamlabsite/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/WebStudio/web.connections.config

  • change_connections default /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • change_connections default /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config

  • change_connections default /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config

  • change_connections default /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config

  • change_connections default /var/www/onlyoffice/ApiSystem/Web.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/ApiSystem/Web.config

  • sed 's!(sql_host\s*=\s*)\S*!\1localhost!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_pass\s*=\s*)\S*!\1!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_user\s*=\s*)\S*!\1root!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_db\s*=\s*)\S*!\1onlyoffice!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_port\s*=\s*)\S*!\13306!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in
    ++ ls /var/www/onlyoffice/Sql/onlyoffice.upgrade80.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade81.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade85.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade86.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade87.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade88.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade892.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade89.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade90.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade91.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade.resources.sql

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade80.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade81.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade85.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade86.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade87.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade88.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade892.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade89.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade90.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade91.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade.resources.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • '[' -f /var/www/onlyoffice/Data/certs/onlyoffice.crt -a -f /var/www/onlyoffice/Data/certs/onlyoffice.key ']'

  • cp /etc/nginx/includes/onlyoffice-communityserver-common.conf.template /app/onlyoffice/config/nginx/prepare-onlyoffice

  • sed -i 1d /etc/logrotate.d/nginx

  • sed '1 i/var/log/nginx/.log /var/log/onlyoffice/nginx..log {' -i /etc/logrotate.d/nginx

  • '[' 172.18.0.3/16 ']'

  • sed 's,{{DOCKER_ONLYOFFICE_SUBNET}},172.18.0.3/16,' -i /app/onlyoffice/config/nginx/prepare-onlyoffice

  • '[' ']'

  • echo Start=No

  • grep -q 'name="textindex"' /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • sed -i 's/.<add\sname="default"\sconnectionString=./&\n<add name="textindex" connectionString="Server=localhost;Port=9306;Pooling=True;Character Set=utf8;AutoEnlist=false" providerName="MySql.Data.MySqlClient"/>/' /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • '[' false == true ']'

  • '[' false == true ']'

  • '[' false == true ']'

  • '[' SERVER == SERVER ']'
    ++ seq 1 1

  • for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'

  • '[' 1 == 1 ']'

  • sed '/web.warmup.count/s/value="\S*"/value="1"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config

  • sed '/web.warmup.domain/s/value="\S*"/value="localhost/warmup"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config

  • continue

  • sed 's/{{ONLYOFFICE_NIGNX_KEEPLIVE}}/32/g' -i /app/onlyoffice/config/nginx/prepare-onlyoffice

  • bash -c 'echo "onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service" | (EDITOR="tee -a" visudo)'
    onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service

  • '[' false == true ']'

  • service redis-server start
    redis-server: unrecognized service

  • '[' false == true ']'

  • '[' SERVER == SERVICES ']'

  • '[' DEBUG ']'

  • echo 'fix docker bug volume mapping for onlyoffice'
    fix docker bug volume mapping for onlyoffice

  • chown -R onlyoffice:onlyoffice /var/log/onlyoffice

  • chown -R onlyoffice:onlyoffice /var/www/onlyoffice/DocumentServerData
    ++ ls -alhd /var/www/onlyoffice/Data
    ++ awk '{ print $3 }'

  • '[' onlyoffice '!=' onlyoffice ']'
    ++ seq 1 1

  • for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'

  • index=1

  • '[' 1 == 1 ']'

  • index=

  • service monoserve restart
    Starting monoserve... OK

  • service monoserveApiSystem restart

  • ping_onlyoffice http://localhost/warmup/auth.aspx

  • timeout=6

  • interval=1

  • '[' 1 -le 6 ']'

  • interval=2
    ++ curl -LI http://localhost/warmup/auth.aspx -o /dev/null -w '%{http_code}\n' -s
    Starting monoserveApiSystem... OK

  • '[' false == true ']'

  • service onlyofficeFeed restart

  • status_code=502

  • echo 'ping monoserve get status_code: 502'
    ping monoserve get status_code: 502

  • '[' 502 == 200 ']'

  • sleep 5s
    Starting onlyofficeFeed... OK

  • service onlyofficeIndex restart

  • '[' 2 -le 6 ']'

  • interval=3
    ++ curl -LI http://localhost/warmup/auth.aspx -o /dev/null -w '%{http_code}\n' -s
    Starting onlyofficeIndex... OK

  • service onlyofficeJabber restart
    Starting onlyofficeJabber... OK

  • service onlyofficeMailAggregator restart
    Starting onlyofficeMailAggregator... OK

  • service onlyofficeMailWatchdog restart
    Starting onlyofficeMailWatchdog... OK

  • service onlyofficeNotify restart
    Starting onlyofficeNotify... OK

  • service onlyofficeBackup restart
    Starting onlyofficeBackup... OK

  • service onlyofficeSignalR stop
    onlyofficeSignalR is not running

  • service onlyofficeAutoreply stop
    onlyofficeAutoreply is not running

  • service onlyofficeHealthCheck stop
    onlyofficeHealthCheck: unrecognized service

  • service god restart
    Restarting god... The server is not available (or you do not have permissions to access it)
    OK

  • '[' SERVER == SERVER ']'

  • wait

  • status_code=200

  • echo 'ping monoserve get status_code: 200'
    ping monoserve get status_code: 200

  • '[' 200 == 200 ']'

  • wget -qO- --retry-connrefused --no-check-certificate --waitretry=15 -t 0 --continue http://localhost/warmup/auth.aspx

  • break

  • mv /app/onlyoffice/config/nginx/prepare-onlyoffice /etc/nginx/sites-enabled/onlyoffice

  • service nginx reload

  • Reloading nginx nginx [ OK ]
  • log_debug 'reload nginx config'
  • echo 'onlyoffice: [Debug] reload nginx config'
    onlyoffice: [Debug] reload nginx config
  • log_debug FINISH
  • echo 'onlyoffice: [Debug] FINISH'
    onlyoffice: [Debug] FINISH
    ++ grep -v grep
    ++ awk '{print $2}'
    ++ grep cron
    ++ ps auxf
  • PID=
  • '[' -n '' ']'
  • cron
  • '[' true == true ']'
  • exec tail -f /dev/null
    [root@V37 ~]#

here are the logs of the community server :

[root@V37 ~]# docker logs 58ad58aa5d46

  • SERVER_HOST=
  • ONLYOFFICE_DIR=/var/www/onlyoffice
  • ONLYOFFICE_DATA_DIR=/var/www/onlyoffice/Data
  • ONLYOFFICE_SERVICES_DIR=/var/www/onlyoffice/Services
  • ONLYOFFICE_SQL_DIR=/var/www/onlyoffice/Sql
  • ONLYOFFICE_ROOT_DIR=/var/www/onlyoffice/WebStudio
  • ONLYOFFICE_APISYSTEM_DIR=/var/www/onlyoffice/ApiSystem
  • ONLYOFFICE_MONOSERVER_PATH=/etc/init.d/monoserve
  • ONLYOFFICE_HYPERFASTCGI_PATH=/etc/hyperfastcgi/onlyoffice
  • ONLYOFFICE_MONOSERVE_COUNT=1
  • ONLYOFFICE_MODE=SERVER
  • ONLYOFFICE_GOD_DIR=/etc/god/conf.d
  • ONLYOFFICE_CRON_DIR=/etc/cron.d
  • ONLYOFFICE_CRON_PATH=/etc/cron.d/onlyoffice
    ++ ip -o -f inet addr show
    ++ awk '/scope global/ {print $4}'
    ++ head -1
  • DOCKER_ONLYOFFICE_SUBNET=172.18.0.3/16
    ++ awk '/inet / {gsub(//.*/,"",$2); print $2}'
    ++ head -1
    ++ ip addr show eth0
  • DOCKER_CONTAINER_IP=172.18.0.3
  • DOCKER_ENABLED=true
    +++ dirname /app/onlyoffice/run-community-server.sh
    ++ cd /app/onlyoffice
    ++ pwd
  • DIR=/app/onlyoffice
  • NGINX_CONF_DIR=/etc/nginx/sites-enabled
    ++ grep processor /proc/cpuinfo
    ++ wc -l
  • NGINX_WORKER_PROCESSES=1
    ++ ulimit -n
  • NGINX_WORKER_CONNECTIONS=1048576
  • SERVICE_SSO_AUTH_HOST_ADDR=
  • '[' '!' -d /etc/nginx/sites-enabled ']'
  • '[' '!' -d /var/www/onlyoffice/DocumentServerData ']'
  • NGINX_ROOT_DIR=/etc/nginx
  • VALID_IP_ADDRESS_REGEX='^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]).){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$'
  • LOG_DEBUG=DEBUG
  • LOG_DIR=/var/log/onlyoffice/
  • ONLYOFFICE_HTTPS=false
  • SSL_CERTIFICATES_DIR=/var/www/onlyoffice/Data/certs
  • SSL_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.crt
  • SSL_KEY_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.key
  • SSL_DHPARAM_PATH=/var/www/onlyoffice/Data/certs/dhparam.pem
  • SSL_VERIFY_CLIENT=off
  • SSL_OCSP_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/stapling.trusted.crt
  • CA_CERTIFICATES_PATH=/var/www/onlyoffice/Data/certs/ca.crt
  • ONLYOFFICE_HTTPS_HSTS_ENABLED=true
  • ONLYOFFICE_HTTPS_HSTS_MAXAGE=63072000
  • SYSCONF_TEMPLATES_DIR=/app/onlyoffice/config
  • mkdir -p /app/onlyoffice/config/nginx
  • SYSCONF_TOOLS_DIR=/app/onlyoffice/assets/tools
  • ONLYOFFICE_SERVICES_INTERNAL_HOST=
  • ONLYOFFICE_SERVICES_EXTERNAL=false
  • DOCUMENT_SERVER_ENABLED=false
  • DOCUMENT_SERVER_HOST=
  • DOCUMENT_SERVER_PROTOCOL=http
  • DOCUMENT_SERVER_API_URL='/web-apps/apps/api/documents/api.js'
  • DOCUMENT_SERVER_HOST_IP=
  • CONTROL_PANEL_ENABLED=false
  • MAIL_SERVER_ENABLED=false
    ++ dig +short myip.opendns.com @resolver1.opendns.com
  • EXTERNAL_IP=106.51.226.51
  • MYSQL_SERVER_ROOT_PASSWORD=
  • MYSQL_SERVER_HOST=localhost
  • MYSQL_SERVER_PORT=3306
  • MYSQL_SERVER_DB_NAME=onlyoffice
  • MYSQL_SERVER_USER=root
  • MYSQL_SERVER_PASS=
  • MYSQL_SERVER_EXTERNAL=false
  • mkdir -p /var/www/onlyoffice/Data/certs/.well-known/acme-challenge
  • check_partnerdata
  • PARTNER_DATA_FILE=/var/www/onlyoffice/Data/json-data.txt
  • '[' -f /var/www/onlyoffice/Data/json-data.txt ']'
  • re='^[0-9]+$'
  • [[ 1 =~ ^[0-9]+$ ]]
  • cp /etc/nginx/includes/onlyoffice-communityserver-nginx.conf.template /etc/nginx/nginx.conf
  • sed 's/^worker_processes.*/worker_processes 1;/' -i /etc/nginx/nginx.conf
  • sed 's/worker_connections.*/worker_connections 1048576;/' -i /etc/nginx/nginx.conf
  • cp /etc/nginx/includes/onlyoffice-communityserver-common-init.conf.template /etc/nginx/sites-enabled/onlyoffice
  • rm -f /etc/nginx/conf.d/default.conf
  • rsyslogd
  • service nginx restart
  • Restarting nginx nginx start-stop-daemon: warning: failed to kill 26240: No such process
    [ OK ]
  • '[' ']'
  • '[' ']'
  • '[' ']'
  • '[' false ']'
  • '[' 172.18.0.3/16 ']'
  • '[' -z '' ']'
    ++ dig +short
  • DOCUMENT_SERVER_HOST_IP='k.root-servers.net.
    f.root-servers.net.
    l.root-servers.net.
    g.root-servers.net.
    j.root-servers.net.
    h.root-servers.net.
    m.root-servers.net.
    i.root-servers.net.
    d.root-servers.net.
    b.root-servers.net.
    c.root-servers.net.
    e.root-servers.net.
    a.root-servers.net.'
  • check_ip_is_internal 172.18.0.3/16 k.root-servers.net. f.root-servers.net. l.root-servers.net. g.root-servers.net. j.root-servers.net. h.root-servers.net. m.root-servers.net. i.root-servers.net. d.root-servers.net. b.root-servers.net. c.root-servers.net. e.root-servers.net. a.root-servers.net.
  • local 'IPRE=([0-9]+).([0-9]+).([0-9]+).([0-9]+)'
  • IP=($(echo "$1" | sed -ne 's:^'"$IPRE"'/.$:\1 \2 \3 \4:p'))
    ++ echo 172.18.0.3/16
    ++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)/.
    $:\1 \2 \3 \4:p'
  • local IP
  • MASK=($(echo "$1" | sed -ne 's:^[^/]/'"$IPRE"'$:\1 \2 \3 \4:p'))
    ++ sed -ne 's:^[^/]
    /([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
    ++ echo 172.18.0.3/16
  • local MASK
  • '[' 0 -ne 4 ']'
  • BITCNT=($(echo "$1" | sed -ne 's:^[^/]/([0-9]+)$:\1:p'))
    ++ echo 172.18.0.3/16
    ++ sed -ne 's:^[^/]
    /([0-9]+)$:\1:p'
  • local BITCNT
  • BITCNT=4294901760
  • (( I=0 ))
  • (( I<4 ))
  • MASK[$I]=255
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=255
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • MASK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • NETWORK=()
  • local NETWORK
  • (( I=0 ))
  • (( I<4 ))
  • NETWORK[$I]=172
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=18
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • NETWORK[$I]=0
  • (( I++ ))
  • (( I<4 ))
  • INIP=($(echo "$2" | sed -ne 's:^'"$IPRE"'$:\1 \2 \3 \4:p'))
    ++ echo k.root-servers.net.
    ++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
  • local INIP
  • (( I=0 ))
  • (( I<4 ))
    /app/onlyoffice/run-community-server.sh: line 110: & 255 : syntax error: operand expected (error token is "& 255 ")
  • '[' localhost '!=' localhost ']'
  • '[' ']'
  • '[' ']'
  • MAIL_SERVER_API_PORT=8081
  • MAIL_SERVER_API_HOST=
  • MAIL_SERVER_DB_HOST=
  • MAIL_SERVER_DB_PORT=3306
  • MAIL_SERVER_DB_NAME=onlyoffice_mailserver
  • MAIL_SERVER_DB_USER=mail_admin
  • MAIL_SERVER_DB_PASS=Isadmin123
  • '[' ']'
  • '[' ']'
  • REDIS_SERVER_HOST=
  • REDIS_SERVER_CACHEPORT=6379
  • REDIS_SERVER_PASSWORD=
  • REDIS_SERVER_SSL=false
  • REDIS_SERVER_DATABASE=0
  • REDIS_SERVER_CONNECT_TIMEOUT=5000
  • REDIS_SERVER_EXTERNAL=false
  • '[' ']'
  • '[' false == false ']'
  • chown -R mysql:mysql /var/lib/mysql/
  • chmod -R 755 /var/lib/mysql/
  • '[' '!' -f /var/lib/mysql/ibdata1 ']'
  • '[' DEBUG ']'
  • log_debug 'Fix docker bug volume mapping for mysql'
  • echo 'onlyoffice: [Debug] Fix docker bug volume mapping for mysql'
    onlyoffice: [Debug] Fix docker bug volume mapping for mysql
  • myisamchk -q -r /var/lib/mysql/mysql/proc
  • check record delete-chain
  • recovering (with sort) MyISAM-table '/var/lib/mysql/mysql/proc'
    Data records: 11
  • Fixing index 1
  • service mysql start
  • Starting MySQL database server mysqld [ OK ]
  • Checking for tables which need an upgrade, are corrupt or were
    not closed cleanly.
  • '[' '!' -f /var/lib/mysql/mysql_upgrade_info ']'

  • '[' -n '' ']'
    ++ grep password /etc/mysql/debian.cnf
    ++ head -1
    ++ sed 's/password\s*=\s*//'
    ++ tr -d '[[:space:]]'

  • DEBIAN_SYS_MAINT_PASS=U6TOvfe0EpzTxJ08

  • mysql_scalar_exec 'GRANT ALL PRIVILEGES ON . TO '''debian-sys-maint'''@'''localhost''' IDENTIFIED BY '''U6TOvfe0EpzTxJ08''''

  • local queryResult=

  • '[' '' == opt_ignore_db_name ']'
    ++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice -e 'GRANT ALL PRIVILEGES ON . TO '''debian-sys-maint'''@'''localhost''' IDENTIFIED BY '''U6TOvfe0EpzTxJ08''''

  • queryResult=

  • echo

  • mysql_check_connection

  • '[' DEBUG ']'

  • log_debug 'Mysql check connection for localhost'

  • echo 'onlyoffice: [Debug] Mysql check connection for localhost'
    onlyoffice: [Debug] Mysql check connection for localhost

  • mysqladmin ping -h localhost -P 3306 -u root --password= --silent
    mysqld is alive
    ++ mysql_scalar_exec 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=onlyoffice
    ++ echo onlyoffice

  • DB_IS_EXIST=onlyoffice
    ++ mysql_list_exec 'SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=utf8
    ++ read -ra vars
    ++ for i in '"${vars[0][@]}"'
    ++ echo utf8

  • DB_CHARACTER_SET_NAME=utf8
    ++ mysql_list_exec 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice'''' opt_ignore_db_name
    ++ local queryResult=
    ++ '[' opt_ignore_db_name == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -e 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='''onlyoffice''''
    ++ queryResult=utf8_general_ci
    ++ read -ra vars
    ++ for i in '"${vars[0][@]}"'
    ++ echo utf8_general_ci

  • DB_COLLATION_NAME=utf8_general_ci
    ++ mysql_scalar_exec 'SELECT COUNT() FROM information_schema.tables WHERE table_schema='''onlyoffice''''
    ++ local queryResult=
    ++ '[' '' == opt_ignore_db_name ']'
    +++ mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice -e 'SELECT COUNT(
    ) FROM information_schema.tables WHERE table_schema='''onlyoffice''''
    ++ queryResult=191
    ++ echo 191

  • DB_TABLES_COUNT=191

  • '[' -z onlyoffice ']'

  • '[' utf8 '!=' utf8 ']'

  • '[' 191 -eq 0 ']'

  • change_connections default /var/www/onlyoffice/WebStudio/web.connections.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/WebStudio/web.connections.config

  • change_connections teamlabsite /var/www/onlyoffice/WebStudio/web.connections.config

  • sed '/teamlabsite/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/WebStudio/web.connections.config

  • change_connections default /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • change_connections default /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config

  • change_connections default /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config

  • change_connections default /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config

  • change_connections default /var/www/onlyoffice/ApiSystem/Web.config

  • sed '/default/s/(connectionString\s*=\s*")[^\"]*"/\1Server=localhost;Port=3306;Database=onlyoffice;User ID=root;Password=;Pooling=true;Character Set=utf8;AutoEnlist=false"/' -i /var/www/onlyoffice/ApiSystem/Web.config

  • sed 's!(sql_host\s*=\s*)\S*!\1localhost!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_pass\s*=\s*)\S*!\1!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_user\s*=\s*)\S*!\1root!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_db\s*=\s*)\S*!\1onlyoffice!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in

  • sed 's!(sql_port\s*=\s*)\S*!\13306!' -i /var/www/onlyoffice/Services/TeamLabSvc/sphinx-min.conf.in
    ++ ls /var/www/onlyoffice/Sql/onlyoffice.upgrade80.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade81.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade85.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade86.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade87.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade88.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade892.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade89.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade90.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade91.sql /var/www/onlyoffice/Sql/onlyoffice.upgrade.resources.sql

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade80.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade81.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade85.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade86.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade87.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade88.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade892.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade89.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade90.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade91.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • for i in '$(ls ${ONLYOFFICE_SQL_DIR}/onlyoffice.upgrade*)'

  • mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.upgrade.resources.sql

  • mysql --silent --skip-column-names -h localhost -P 3306 -u root --password= -D onlyoffice

  • '[' -f /var/www/onlyoffice/Data/certs/onlyoffice.crt -a -f /var/www/onlyoffice/Data/certs/onlyoffice.key ']'

  • cp /etc/nginx/includes/onlyoffice-communityserver-common.conf.template /app/onlyoffice/config/nginx/prepare-onlyoffice

  • sed -i 1d /etc/logrotate.d/nginx

  • sed '1 i/var/log/nginx/.log /var/log/onlyoffice/nginx..log {' -i /etc/logrotate.d/nginx

  • '[' 172.18.0.3/16 ']'

  • sed 's,{{DOCKER_ONLYOFFICE_SUBNET}},172.18.0.3/16,' -i /app/onlyoffice/config/nginx/prepare-onlyoffice

  • '[' ']'

  • echo Start=No

  • grep -q 'name="textindex"' /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • sed -i 's/.<add\sname="default"\sconnectionString=./&\n<add name="textindex" connectionString="Server=localhost;Port=9306;Pooling=True;Character Set=utf8;AutoEnlist=false" providerName="MySql.Data.MySqlClient"/>/' /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config

  • '[' false == true ']'

  • '[' false == true ']'

  • '[' false == true ']'

  • '[' SERVER == SERVER ']'
    ++ seq 1 1

  • for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'

  • '[' 1 == 1 ']'

  • sed '/web.warmup.count/s/value="\S*"/value="1"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config

  • sed '/web.warmup.domain/s/value="\S*"/value="localhost/warmup"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config

  • continue

  • sed 's/{{ONLYOFFICE_NIGNX_KEEPLIVE}}/32/g' -i /app/onlyoffice/config/nginx/prepare-onlyoffice

  • bash -c 'echo "onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service" | (EDITOR="tee -a" visudo)'
    onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service

  • '[' false == true ']'

  • service redis-server start
    redis-server: unrecognized service

  • '[' false == true ']'

  • '[' SERVER == SERVICES ']'

  • '[' DEBUG ']'

  • echo 'fix docker bug volume mapping for onlyoffice'
    fix docker bug volume mapping for onlyoffice

  • chown -R onlyoffice:onlyoffice /var/log/onlyoffice

  • chown -R onlyoffice:onlyoffice /var/www/onlyoffice/DocumentServerData
    ++ ls -alhd /var/www/onlyoffice/Data
    ++ awk '{ print $3 }'

  • '[' onlyoffice '!=' onlyoffice ']'
    ++ seq 1 1

  • for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'

  • index=1

  • '[' 1 == 1 ']'

  • index=

  • service monoserve restart
    Starting monoserve... OK

  • service monoserveApiSystem restart

  • ping_onlyoffice http://localhost/warmup/auth.aspx

  • timeout=6

  • interval=1

  • '[' 1 -le 6 ']'

  • interval=2
    ++ curl -LI http://localhost/warmup/auth.aspx -o /dev/null -w '%{http_code}\n' -s
    Starting monoserveApiSystem... OK

  • '[' false == true ']'

  • service onlyofficeFeed restart

  • status_code=502

  • echo 'ping monoserve get status_code: 502'
    ping monoserve get status_code: 502

  • '[' 502 == 200 ']'

  • sleep 5s
    Starting onlyofficeFeed... OK

  • service onlyofficeIndex restart

  • '[' 2 -le 6 ']'

  • interval=3
    ++ curl -LI http://localhost/warmup/auth.aspx -o /dev/null -w '%{http_code}\n' -s
    Starting onlyofficeIndex... OK

  • service onlyofficeJabber restart
    Starting onlyofficeJabber... OK

  • service onlyofficeMailAggregator restart
    Starting onlyofficeMailAggregator... OK

  • service onlyofficeMailWatchdog restart
    Starting onlyofficeMailWatchdog... OK

  • service onlyofficeNotify restart
    Starting onlyofficeNotify... OK

  • service onlyofficeBackup restart
    Starting onlyofficeBackup... OK

  • service onlyofficeSignalR stop
    onlyofficeSignalR is not running

  • service onlyofficeAutoreply stop
    onlyofficeAutoreply is not running

  • service onlyofficeHealthCheck stop
    onlyofficeHealthCheck: unrecognized service

  • service god restart
    Restarting god... The server is not available (or you do not have permissions to access it)
    OK

  • '[' SERVER == SERVER ']'

  • wait

  • status_code=200

  • echo 'ping monoserve get status_code: 200'
    ping monoserve get status_code: 200

  • '[' 200 == 200 ']'

  • wget -qO- --retry-connrefused --no-check-certificate --waitretry=15 -t 0 --continue http://localhost/warmup/auth.aspx

  • break

  • mv /app/onlyoffice/config/nginx/prepare-onlyoffice /etc/nginx/sites-enabled/onlyoffice

  • service nginx reload

  • Reloading nginx nginx [ OK ]
  • log_debug 'reload nginx config'
  • echo 'onlyoffice: [Debug] reload nginx config'
    onlyoffice: [Debug] reload nginx config
  • log_debug FINISH
  • echo 'onlyoffice: [Debug] FINISH'
    onlyoffice: [Debug] FINISH
    ++ grep -v grep
    ++ awk '{print $2}'
    ++ grep cron
    ++ ps auxf
  • PID=
  • '[' -n '' ']'
  • cron
  • '[' true == true ']'
  • exec tail -f /dev/null
    [root@V37 ~]#

i have a VM with 2gb of RAM and 2gb of swap and 100 gb of storage,
since i am not geting the confirmation mail to my mail id, i am not able to access the fetures in the gui.
help in this....

External access to XMPP actually not available?

While Talk works fine within the browser, I can't seem to get the external port 5222 to accept any XMPP client connections.

So far I though this is a problem with my docker setup, but then I read (I think) on of the OO staff saying this is only available in the enterprise edition?

Is that true and if so, could you please mention it in the Docker readme?

Thanks!

Community Server does not start correctly ?

Hi,

I have just started playing with onlyoffice because I would like to test it in docker environments before buying a licence.

It seems I can not really start the community edition container since it does not serve the WebUI.

Context:

  • I am running the Docker installation with simply mysql + community edition.
  • Docker Version 18.06.1-ce
  • MacBook Pro 2018; 16 Gb RAM; 2,2 GHz Intel Core i7

I did follow step by step the docker setup (network creation, mysql start and community edition start) without adding or changing any environmental variables.

First I noticed that community edition container always take a while to start (around 6-8 minutes) because of the several mysql updates. But at the end, it reaches the tail -f /dev/null and the container just waits (what it suppose to do due to the run-community-server.sh). Find below the logs -f:

+ '[' -f /var/www/onlyoffice/Data/certs/onlyoffice.crt -a -f /var/www/onlyoffice/Data/certs/onlyoffice.key ']'
+ cp /etc/nginx/includes/onlyoffice-communityserver-common.conf.template /app/onlyoffice/config/nginx/prepare-onlyoffice
+ sed -i 1d /etc/logrotate.d/nginx
+ sed '1 i\/var/log/nginx/*.log /var/log/onlyoffice/nginx.*.log {' -i /etc/logrotate.d/nginx
+ '[' 192.168.80.3/20 ']'
+ sed 's,{{DOCKER_ONLYOFFICE_SUBNET}},192.168.80.3/20,' -i /app/onlyoffice/config/nginx/prepare-onlyoffice
+ '[' ']'
+ echo Start=No
+ grep -q 'name="textindex"' /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config
+ '[' false == true ']'
+ '[' false == true ']'
+ '[' false == true ']'
+ '[' SERVER == SERVER ']'
++ seq 1 1
+ for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'
+ '[' 1 == 1 ']'
+ sed '/web.warmup.count/s/value=\"\S*\"/value=\"1\"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config
+ sed '/web.warmup.domain/s/value=\"\S*\"/value=\"localhost\/warmup\"/g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config
+ sed '/core.machinekey/s!value=".*"!value="Vskoproizvolny Salt par Chivreski"!g' -i /var/www/onlyoffice/WebStudio/web.appsettings.config
+ sed '/core.machinekey/s!value=".*"!value="Vskoproizvolny Salt par Chivreski"!g' -i /var/www/onlyoffice/ApiSystem/Web.config
+ sed '/core.machinekey/s!value=".*"!value="Vskoproizvolny Salt par Chivreski"!g' -i /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config
+ sed '/core\.machinekey/s!"core\.machinekey".*!"core\.machinekey":"Vskoproizvolny Salt par Chivreski",!' -i /var/www/onlyoffice/Services/ASC.Socket.IO/config/config.json
+ sed '/core.machinekey/s!value=".*"!value="Vskoproizvolny Salt par Chivreski"!g' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config
+ sed '/core.machinekey/s!value=".*"!value="Vskoproizvolny Salt par Chivreski"!g' -i /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config
+ continue
+ sed 's/{{ONLYOFFICE_NIGNX_KEEPLIVE}}/32/g' -i /app/onlyoffice/config/nginx/prepare-onlyoffice
+ bash -c 'echo "onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service" | (EDITOR="tee -a" visudo)'
onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service
+ '[' false == true ']'
+ service redis-server start
redis-server: unrecognized service
+ '[' true == true ']'
+ rm -f /etc/god/conf.d/mysql.god
+ '[' SERVER == SERVICES ']'
+ '[' DEBUG ']'
+ echo 'fix docker bug volume mapping for onlyoffice'
fix docker bug volume mapping for onlyoffice
+ chown -R onlyoffice:onlyoffice /var/log/onlyoffice
+ chown -R onlyoffice:onlyoffice /var/www/onlyoffice/DocumentServerData
++ ls -alhd /var/www/onlyoffice/Data
++ awk '{ print $3 }'
+ '[' onlyoffice '!=' onlyoffice ']'
++ seq 1 1
+ for serverID in '$(seq 1 ${ONLYOFFICE_MONOSERVE_COUNT})'
+ index=1
+ '[' 1 == 1 ']'
+ index=
+ service monoserve restart
Starting monoserve... OK
+ service monoserveApiSystem restart
Starting monoserveApiSystem... OK
+ '[' false == true ']'
+ service onlyofficeSocketIO restart
Starting onlyofficeSocketIO... OK
+ service onlyofficeFeed restart
Starting onlyofficeFeed... OK
+ service onlyofficeIndex restart
Starting onlyofficeIndex... OK
+ service onlyofficeJabber restart
Starting onlyofficeJabber... OK
+ service onlyofficeMailAggregator restart
Starting onlyofficeMailAggregator... OK
+ service onlyofficeMailWatchdog restart
Starting onlyofficeMailWatchdog... OK
+ service onlyofficeNotify restart
Starting onlyofficeNotify... OK
+ service onlyofficeBackup restart
Starting onlyofficeBackup... OK
+ service onlyofficeAutoreply stop
onlyofficeAutoreply is not running
+ service onlyofficeHealthCheck stop
onlyofficeHealthCheck: unrecognized service
+ service god restart
Restarting god... The server is not available (or you do not have permissions to access it)
OK
+ '[' SERVER == SERVER ']'
+ mv /app/onlyoffice/config/nginx/prepare-onlyoffice /etc/nginx/sites-enabled/onlyoffice
+ service nginx reload
 * Reloading nginx nginx                                                 [ OK ]
+ log_debug 'reload nginx config'
+ echo 'onlyoffice: [Debug] reload nginx config'
onlyoffice: [Debug] reload nginx config
+ log_debug FINISH
+ echo 'onlyoffice: [Debug] FINISH'
onlyoffice: [Debug] FINISH
++ ps auxf
++ grep cron
++ awk '{print $2}'
++ grep -v grep
+ PID=
+ '[' -n '' ']'
+ cron
+ '[' true == true ']'
+ exec tail -f /dev/null

Notice that some serviced have not been restarted, for instance onlyofficeHealthCheck, god. I do not know the impact of this in the container start.

On the other hand, meanwhile the community container runs it is possible to visit the WebUI atlocalhost:80, but I receive 502 in loop due to a HTTP GET /api/2.0/capabilities.json

head -n10 /var/log/nginx/access.log
192.168.48.1 - - [16/Sep/2018:11:40:24 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 502 173 "http://localhost/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13;
 rv:62.0) Gecko/20100101 Firefox/62.0" "-"
192.168.48.1 - - [16/Sep/2018:11:40:29 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 502 173 "http://localhost/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13;
 rv:62.0) Gecko/20100101 Firefox/62.0" "-"

I have checked the nginx error logs:

head -n10 /var/log/nginx/error.log
2018/09/16 11:40:23 [alert] 59#59: worker process 65 exited on signal 9
2018/09/16 11:40:24 [crit] 100#100: *1 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (2: No such file or directory) while connecting to upstream,
 client: 192.168.48.1, server: , request: "GET /api/2.0/capabilities.json HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:", host: "loc
alhost", referrer: "http://localhost/"
2018/09/16 11:40:25 [alert] 59#59: worker process 100 exited on signal 9
2018/09/16 11:40:25 [alert] 59#59: worker process 66 exited on signal 9

In addition, these calls stop in the very moment the community server container stalls in exec tail -f /dev/null.

I am not sure yet of what is going on under the hoods, but it can be a great help to start the service to really understand =]

Any ideas on how I can continue and avoid this issue?
Thank you !

can't start

I installed onlyoffice by docker-compose, default config, and it always shows 500.

and in community server logs

2017/09/04 15:39:07 [error] 55#55: *269 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (111: Connection refused) while connecting to upstream, client: 43.241.225.30, server: , request: "GET /api/2.0/warmup/progress.json HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:", host: "118.31.212.123", referrer: "http://118.31.212.123/"                                                                                                                                                                  

this unix sock is not exists.

during install, there is many sql error.

nlyoffice-community-server    | + mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.sql
onlyoffice-community-server    | + mysql --silent --skip-column-names -h onlyoffice-mysql-server -P 3306 -u onlyoffice_user --password=onlyoffice_pass -D onlyoffice
onlyoffice-community-server    | ERROR 1067 (42000) at line 2042: Invalid default value for 'creationDate'
onlyoffice-community-server    | + mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.data.sql
onlyoffice-community-server    | + mysql --silent --skip-column-names -h onlyoffice-mysql-server -P 3306 -u onlyoffice_user --password=onlyoffice_pass -D onlyoffice
onlyoffice-community-server    | ERROR 1146 (42S02) at line 1814: Table 'onlyoffice.tenants_tenants' doesn't exist
onlyoffice-community-server    | + mysql_batch_exec /var/www/onlyoffice/Sql/onlyoffice.resources.sql

➜  git docker -v
Docker version 17.06.1-ce, build 874a737
➜  git docker-compose -v
docker-compose version 1.15.0, build e12f3b9

CommunityServer does not start if DocumentServer started earlier

Hi,
great product anyway, but I run into a problem when the DocumentServer container is started before CommunityServer. The latter then claims a PID is already used:

[ OK ]
,+ '[' ']'
,+ '[' ']'
,+ '[' onlyoffice-document-server ']'
,+ DOCUMENT_SERVER_ENABLED=true
,+ DOCUMENT_SERVER_HOST=onlyoffice-document-server
,+ DOCUMENT_SERVER_HOST_PROXY='localhost/ds-vpath'
,+ DOCUMENT_SERVER_API_URL='/ds-vpath'
,+ '[' true == true ']'
,+ '[' 10.200.0.2/16 ']'
,+ '[' -z '' ']'
,++ dig +short onlyoffice-document-server
,+ DOCUMENT_SERVER_HOST_IP=10.17.18.4
,+ check_ip_is_internal 10.200.0.2/16 10.17.18.4
,+ local 'IPRE=([0-9]+).([0-9]+).([0-9]+).([0-9]+)'
,+ IP=($(echo "$1" | sed -ne 's:^'"$IPRE"'/.$:\1 \2 \3 \4:p'))
,++ echo 10.200.0.2/16
,++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)/.
$:\1 \2 \3 \4:p'
,+ local IP
,+ MASK=($(echo "$1" | sed -ne 's:^[^/]/'"$IPRE"'$:\1 \2 \3 \4:p'))
,++ echo 10.200.0.2/16
,++ sed -ne 's:^[^/]
/([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
,+ local MASK
,+ '[' 0 -ne 4 ']'
,+ BITCNT=($(echo "$1" | sed -ne 's:^[^/]/([0-9]+)$:\1:p'))
,++ echo 10.200.0.2/16
,++ sed -ne 's:^[^/]
/([0-9]+)$:\1:p'
,+ local BITCNT
,+ BITCNT=4294901760
,+ (( I=0 ))
,+ (( I<4 ))
,+ MASK[$I]=255
,+ (( I++ ))
,+ (( I<4 ))
,+ MASK[$I]=255
,+ (( I++ ))
,+ (( I<4 ))
,+ MASK[$I]=0
,+ (( I++ ))
,+ (( I<4 ))
,+ MASK[$I]=0
,+ (( I++ ))
,+ (( I<4 ))
,+ NETWORK=()
,+ local NETWORK
,+ (( I=0 ))
,+ (( I<4 ))
,+ NETWORK[$I]=10
,+ (( I++ ))
,+ (( I<4 ))
,+ NETWORK[$I]=200
,+ (( I++ ))
,+ (( I<4 ))
,+ NETWORK[$I]=0
,+ (( I++ ))
,+ (( I<4 ))
,+ NETWORK[$I]=0
,+ (( I++ ))
,+ (( I<4 ))
,+ INIP=($(echo "$2" | sed -ne 's:^'"$IPRE"'$:\1 \2 \3 \4:p'))
,++ echo 10.17.18.4
,++ sed -ne 's:^([0-9]+).([0-9]+).([0-9]+).([0-9]+)$:\1 \2 \3 \4:p'
,+ local INIP
,+ (( I=0 ))
,+ (( I<4 ))
,+ [[ 10 -ne 10 ]]
,+ (( I++ ))
,+ (( I<4 ))
,+ [[ 17 -ne 200 ]]
,+ exit 0
,+ SERVER_HOST=
,+ ONLYOFFICE_DIR=/var/www/onlyoffice
,+ ONLYOFFICE_DATA_DIR=/var/www/onlyoffice/Data
,+ ONLYOFFICE_PRIVATE_DATA_DIR=/var/www/onlyoffice/Data/.private
,+ ONLYOFFICE_SERVICES_DIR=/var/www/onlyoffice/Services
,+ ONLYOFFICE_SQL_DIR=/var/www/onlyoffice/Sql
,+ ONLYOFFICE_ROOT_DIR=/var/www/onlyoffice/WebStudio
,+ ONLYOFFICE_APISYSTEM_DIR=/var/www/onlyoffice/ApiSystem
,+ ONLYOFFICE_MONOSERVER_PATH=/etc/init.d/monoserve
,+ ONLYOFFICE_HYPERFASTCGI_PATH=/etc/hyperfastcgi/onlyoffice
,+ ONLYOFFICE_MONOSERVE_COUNT=1
,+ ONLYOFFICE_MODE=SERVER
,+ ONLYOFFICE_GOD_DIR=/etc/god/conf.d
,+ ONLYOFFICE_CRON_DIR=/etc/cron.d
,+ ONLYOFFICE_CRON_PATH=/etc/cron.d/onlyoffice
,++ ip -o -f inet addr show
,++ awk '/scope global/ {print $4}'
,++ head -1
,+ DOCKER_ONLYOFFICE_SUBNET=10.200.0.2/16
,++ ip addr show eth0
,++ awk '/inet / {gsub(//./,"",$2); print $2}'
,++ head -1
,+ DOCKER_CONTAINER_IP=10.200.0.2
,+ DOCKER_CONTAINER_NAME=onlyoffice-community-server
,+ DOCKER_ENABLED=true
,+++ dirname /app/onlyoffice/run-community-server.sh
,++ cd /app/onlyoffice
,++ pwd
,+ DIR=/app/onlyoffice
,+ NGINX_CONF_DIR=/etc/nginx/sites-enabled
,++ grep processor /proc/cpuinfo
,++ wc -l
,+ NGINX_WORKER_PROCESSES=4
,++ ulimit -n
,+ NGINX_WORKER_CONNECTIONS=65536
,+ SERVICE_SSO_AUTH_HOST_ADDR=
,++ sudo sed -n '/"core.machinekey"/s!.value\s=\s
"([^"])".!\1!p' /var/www/onlyoffice/WebStudio/web.appsettings.config
,+ DEFAULT_ONLYOFFICE_CORE_MACHINEKEY='Vskoproizvolny Salt par Chivreski'
,+ ONLYOFFICE_CORE_MACHINEKEY='Vskoproizvolny Salt par Chivreski'
,+ '[' '!' -d /var/www/onlyoffice/Data/.private ']'
,+ echo 'Vskoproizvolny Salt par Chivreski'
,+ chmod -R 444 /var/www/onlyoffice/Data/.private
,+ cat /proc/1/cgroup
,+ grep -qE 'docker|lxc'
,+ DOCKER_ENABLED=true
,+ '[' '!' -d /etc/nginx/sites-enabled ']'
,+ '[' '!' -d /var/www/onlyoffice/DocumentServerData ']'
,+ NGINX_ROOT_DIR=/etc/nginx
,+ VALID_IP_ADDRESS_REGEX='^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]).){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$'
,+ LOG_DEBUG=DEBUG
,+ LOG_DIR=/var/log/onlyoffice/
,+ ONLYOFFICE_HTTPS=false
,+ SSL_CERTIFICATES_DIR=/var/www/onlyoffice/Data/certs
,+ SSL_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.crt
,+ SSL_KEY_PATH=/var/www/onlyoffice/Data/certs/onlyoffice.key
,+ SSL_CERTIFICATE_PATH_PFX=/var/www/onlyoffice/Data/certs/onlyoffice.pfx
,+ SSL_CERTIFICATE_PATH_PFX_PWD=onlyoffice
,+ SSL_DHPARAM_PATH=/var/www/onlyoffice/Data/certs/dhparam.pem
,+ SSL_VERIFY_CLIENT=off
,+ SSL_OCSP_CERTIFICATE_PATH=/var/www/onlyoffice/Data/certs/stapling.trusted.crt
,+ CA_CERTIFICATES_PATH=/var/www/onlyoffice/Data/certs/ca.crt
,+ ONLYOFFICE_HTTPS_HSTS_ENABLED=true
,+ ONLYOFFICE_HTTPS_HSTS_MAXAGE=63072000
,+ SYSCONF_TEMPLATES_DIR=/app/onlyoffice/config
,+ mkdir -p /app/onlyoffice/config/nginx
,+ SYSCONF_TOOLS_DIR=/app/onlyoffice/assets/tools
,+ ONLYOFFICE_SERVICES_INTERNAL_HOST=
,+ ONLYOFFICE_SERVICES_EXTERNAL=false
,+ DOCUMENT_SERVER_ENABLED=false
,+ DOCUMENT_SERVER_JWT_ENABLED=false
,+ DOCUMENT_SERVER_JWT_SECRET=
,+ DOCUMENT_SERVER_JWT_HEADER=
,+ DOCUMENT_SERVER_HOST=
,+ DOCUMENT_SERVER_HOST_PROXY=
,+ DOCUMENT_SERVER_PROTOCOL=http
,+ DOCUMENT_SERVER_API_URL=
,+ DOCUMENT_SERVER_HOST_IP=
,+ CONTROL_PANEL_ENABLED=false
,+ MAIL_SERVER_ENABLED=false
,+ MYSQL_SERVER_ROOT_PASSWORD=
,+ MYSQL_SERVER_HOST=localhost
,+ MYSQL_SERVER_PORT=3306
,+ MYSQL_SERVER_DB_NAME=onlyoffice
,+ MYSQL_SERVER_USER=root
,+ MYSQL_SERVER_PASS=
,+ MYSQL_SERVER_EXTERNAL=false
,+ mkdir -p /var/www/onlyoffice/Data/certs/.well-known/acme-challenge
,+ check_partnerdata
,+ PARTNER_DATA_FILE=/var/www/onlyoffice/Data/json-data.txt
,+ '[' -f /var/www/onlyoffice/Data/json-data.txt ']'
,+ re='^[0-9]+$'
,+ [[ 1 =~ ^[0-9]+$ ]]
,+ cp /etc/nginx/includes/onlyoffice-communityserver-nginx.conf.template /etc/nginx/nginx.conf
,+ sed 's/^worker_processes./worker_processes 4;/' -i /etc/nginx/nginx.conf
,+ sed 's/worker_connections.
/worker_connections 65536;/' -i /etc/nginx/nginx.conf
,+ cp /etc/nginx/includes/onlyoffice-communityserver-common-init.conf.template /etc/nginx/sites-enabled/onlyoffice
,+ rm -f '/etc/nginx/conf.d/*.conf'
,+ rsyslogd
,Pidfile (and pid) already exist.
,

The last message Pidfile (and pid) already exist. seems to be the problem.

I do not use Docker Compose which allows to define dependencies - shouldn't the container be able to start anyway?

switch menu too slow

i have installed onlyoffce-communityserver with docker contailer, i find it is too slow when i swith menu like as "from CRM to MAIL"。
i use chrome browser with develop mode, when i swich the menu , i find that the communityserver url want to load this URL "http://www.googletagmanager.com/gtm.js?id=GTM-5NW47TX:2260", unfortunately, my internet net can not view the google website, how can i solve the problem。THS!!!

Error I can not solve help !!!

After a good few hours of searching I found this guide https://www.linuxbabe.com/linux-server/install-onlyoffice-ubuntu-16-04
And after I managed to install it on ubuntu 18.04.1
So I tried to connect it to my Nextcloud (that was the whole point)
Then I get the following error
And the strange thing that it appears to me is also in the onlyoffice itself and it was not like that in the default documents (I deleted them already)

That's why I'm asking for help here and not in nextcloud

I searched the Internet and the only thing I found did not help or I simply did not understand how to "put it in for installation
My"
Here's what I found: ONLYOFFICE/Docker-DocumentServer#80

Please help me I do not know what to do!

If you need more information or some settings just say. I did not add because I did not know what was needed (:

"/discbundle/common" assets are not served

The /discbundle/common/css/... and /discbundle/common/javascript/... URLs are not served: I get a 404 which breaks the UI.

Others URLs are OK:

  • /wizard.aspx
  • /skins/default/images/...
  • /clientscript/...

Nginx logs in /var/log/onlyoffice stays empty.

Steps to reproduce:

mkdir /opt/onlyoffice/logs/{data,logs,mysql}
docker run -i -t -d \
    --name onlyoffice-document-server \
    onlyoffice/documentserver
docker run -i -t -d \
    --name onlyoffice-community-server \
    --restart=always \
    -p 127.0.0.1:6000:80 \
    --link onlyoffice-document-server:document_server \
    -v /opt/onlyoffice/logs:/var/log/onlyoffice \
    -v /opt/onlyoffice/data:/var/www/onlyoffice/Data \
    -v /opt/onlyoffice/mysql:/var/lib/mysql \
    onlyoffice/communityserver

Version:

  • Debian 8.4
  • Kernel 3.16.0-4-amd64
  • Docker 1.11.0, build 4dc5990

Running CommunityServer with DocumentServer on different port

Hi,

we try to setup the Community Server together with the Document Server on a different port.
This is our docker-compose.yml:

version: '3.0'
services:
    onlyoffice-community-server:
        container_name: onlyoffice-community-server
        image: onlyoffice/communityserver:latest
        depends_on:
         - onlyoffice-document-server
        environment:
         - DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
        networks:
         - onlyoffice
        ports:
         - '8080:80'
         - '444:443'
         - '5222:5222'
        stdin_open: true
        tty: true
        restart: always
        volumes:
         - ./community_mysql:/var/lib/mysql
         - ./community_data:/var/www/onlyoffice/Data
         - ./community_log:/var/log/onlyoffice
         - ./document_data:/var/www/onlyoffice/DocumentServerData
         - ./certs:/var/www/onlyoffice/Data/certs
    onlyoffice-document-server:
        container_name: onlyoffice-document-server
        image: onlyoffice/documentserver:latest
        stdin_open: true
        tty: true
        restart: always
        networks:
            - onlyoffice
        expose:
            - '80'
            - '443'
        volumes:
             - ./document_data:/var/www/onlyoffice/Data
             - ./document_fonts:/usr/share/fonts/truetype/custom
             - ./document_log:/var/log/onlyoffice
networks:
    onlyoffice:
        driver: 'bridge'

After executing docker-compose up the server are starting, we can insert our password and chosen language and timezone. But when we try to open a document we get a connection refused from:
/2017-06-09-10-21/web-apps/apps/spreadsheeteditor/main/index.html?_dc=2017-06-09-10-21&lang=en-US&customer=ONLYOFFICE&frameEditorId=iframeEditor which is forwarded from
:8080/2017-06-09-10-21/web-apps/apps/spreadsheeteditor/main/index.html?_dc=2017-06-09-10-21&lang=en-US&customer=ONLYOFFICE&frameEditorId=iframeEditor (different port).

Is using another port not supported yet or do we miss anything?

Unauthorized Access

Whenever I try to set up a new CommunityServer instance for my domain I get an error message: "Unauthorized Access". This error message appears when I register on the portal. And when I try again, I get another error message: "Wizard passed". Can you explain me why do I get these errors ?
I tried different installation types (the bash script, docker-compose and docker directly).

Issues with 'bash opensource-install.sh -u true' script (trying to expose both containers on 80 port)

I need to move my Onlyoffice from one server to another

Steps to reproduce.

  1. Copy /app folder from server A to /app folder on server B
  2. On server B start bash opensource-install.sh -u true

Expected result.
Running 3 containers:

CONTAINER ID        IMAGE                               COMMAND                  CREATED              STATUS              PORTS                                      NAMES

6cbc2496795a        mysql:5.5                           "docker-entrypoint..."   31 seconds ago       Up 28 seconds       3306/tcp                                   onlyoffice-mysql-server

38fb09135080        onlyoffice/documentserver:4.4.3.7   "/bin/sh -c 'bash ..."   About a minute ago   Up About a minute   80->80/tcp, 0.0.0.0:443->443/tcp   onlyoffice-document-server

3c32d2d0878a        onlyoffice/communityserver:9.1.0.418   "/usr/bin/dumb-ini..."   52 seconds ago      Up 50 seconds       0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp, 3306/tcp, 5280/tcp, 9865-9866/tcp, 9871/tcp, 9882/tcp, 0.0.0.0:5222->5222/tcp, 9888/tcp   onlyoffice-community-server

Actual result.
Running only 2 containers:

CONTAINER ID        IMAGE                               COMMAND                  CREATED              STATUS              PORTS                                      NAMES
6cbc2496795a        mysql:5.5                           "docker-entrypoint..."   31 seconds ago       Up 28 seconds       3306/tcp                                   onlyoffice-mysql-server

3c32d2d0878a        onlyoffice/communityserver:9.1.0.418   "/usr/bin/dumb-ini..."   52 seconds ago      Up 50 seconds       0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp, 3306/tcp, 5280/tcp, 9865-9866/tcp, 9871/tcp, 9882/tcp, 0.0.0.0:5222->5222/tcp, 9888/tcp   onlyoffice-community-server

Notes
After trying to install onlyoffice-document-server manually by
bash opensource-install.sh -ics false -ids true -ims false -es true
I've got an error The following ports must be open: 80

sudo netstat -lnp | grep ':80' tcp6 0 0 :::80 :::* LISTEN 1317/docker-proxy

It seems to me that bash opensource-install.sh -u true install and configure communityserver and document-server containers on the same 80 tcp port.

On my A server containers running with following exposed ports
0.0.0.0:80->80/tcp for communityserver
80->80/tcp for document server

On server B docker trying to exposed ports
0.0.0.0:80->80/tcp for communityserver
0.0.0.0:80->80/tcp for document server

More information here
http://dev.onlyoffice.org/ru/viewtopic.php?p=22482&sid=a26f78db713b90fba3b757ca43ea939f#p22482

nginx log files not rotated by logrotate, they grow unlimited in size.

nginx log files not rotated by logrotate, they grow unlimited in size.

/etc/logrotate.d/nginx only watch nginx files by mask /var/log/nginx/*.log
but actually ONLYOFFICE nginx log files located in dir /var/log/onlyoffice,
nginx.access.log, nginx.error.log, nginx.apisystem.access.log, nginx.apisystem.error.log

you should move nginx log files to currently empty dir /var/log/onlyoffice/nginx
and add mask /var/log/onlyoffice/nginx/*.log to file /etc/logrotate.d/nginx:

# diff -u /etc/logrotate.d/nginx.old /etc/logrotate.d/nginx
--- /etc/logrotate.d/nginx.old  2016-12-27 14:45:35.000000000 +0000
+++ /etc/logrotate.d/nginx      2017-03-22 18:58:19.054000000 +0000
@@ -1,4 +1,4 @@
-/var/log/nginx/*.log {
+/var/log/nginx/*.log /var/log/onlyoffice/nginx/*.log {
         daily
         missingok
         rotate 52

hope this help, and you can reproduce and fix this BUG with unlimited size of nginx log files?

Invalid arguments System.ArgumentNullException: Value cannot be null. Parameter name: mxRecord

Anyone can help this?

I'm trying to upgrade to new one... that have mysql separated container...

Everything is fine except when I try to invite someone to the portal, and they register with that, email activation not send to their email...

2019-08-29 05:28:11,843 ERROR [60] ASC.Api - method error: https://172.18.0.5/api/2.0/mailserver/domains/add.json?__=559160 - Invalid arguments System.ArgumentNullException: Value cannot be null.
Parameter name: mxRecord
  at ASC.Common.Utils.DnsLookup.IsDomainMxRecordExists (System.String domainName, System.String mxRecord) [0x00021] in <ea3f357eccf54f1b8bd29463a22fc042>:0
  at ASC.Mail.Extensions.ServerDomainDnsExtensions.CheckDnsStatus (ASC.Mail.Data.Contracts.ServerDomainDnsData dnsData, System.String domain) [0x0001d] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Mail.Core.Engine.ServerDomainEngine.AddDomain (System.String domain, System.Int32 dnsId) [0x000ed] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Api.MailServer.MailServerApi.AddDomain (System.String name, System.Int32 id_dns) [0x0000b] in <3a0ee5ef79024c3485755e2a95094945>:0
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <15c986724bdc480293909469513cfdb3>:0
2019-08-29 05:28:19,804 ERROR [57] ASC.Api - method error: https://172.18.0.5/api/2.0/mailserver/domains/add.json?__=763243 - Invalid arguments System.ArgumentNullException: Value cannot be null.
Parameter name: mxRecord
  at ASC.Common.Utils.DnsLookup.IsDomainMxRecordExists (System.String domainName, System.String mxRecord) [0x00021] in <ea3f357eccf54f1b8bd29463a22fc042>:0
  at ASC.Mail.Extensions.ServerDomainDnsExtensions.CheckDnsStatus (ASC.Mail.Data.Contracts.ServerDomainDnsData dnsData, System.String domain) [0x0001d] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Mail.Core.Engine.ServerDomainEngine.AddDomain (System.String domain, System.Int32 dnsId) [0x000ed] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Api.MailServer.MailServerApi.AddDomain (System.String name, System.Int32 id_dns) [0x0000b] in <3a0ee5ef79024c3485755e2a95094945>:0
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <15c986724bdc480293909469513cfdb3>:0
2019-08-29 05:28:44,496 ERROR [58] ASC.Api - method error: https://172.18.0.5/api/2.0/mailserver/domains/add.json?__=564530 - Invalid arguments System.ArgumentNullException: Value cannot be null.
Parameter name: mxRecord
  at ASC.Common.Utils.DnsLookup.IsDomainMxRecordExists (System.String domainName, System.String mxRecord) [0x00021] in <ea3f357eccf54f1b8bd29463a22fc042>:0
  at ASC.Mail.Extensions.ServerDomainDnsExtensions.CheckDnsStatus (ASC.Mail.Data.Contracts.ServerDomainDnsData dnsData, System.String domain) [0x0001d] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Mail.Core.Engine.ServerDomainEngine.AddDomain (System.String domain, System.Int32 dnsId) [0x000ed] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Api.MailServer.MailServerApi.AddDomain (System.String name, System.Int32 id_dns) [0x0000b] in <3a0ee5ef79024c3485755e2a95094945>:0
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <15c986724bdc480293909469513cfdb3>:0
2019-08-29 05:29:32,011 ERROR [59] ASC.Api - method error: https://172.18.0.5/api/2.0/mailserver/domains/add.json?__=978615 - Invalid arguments System.ArgumentNullException: Value cannot be null.
Parameter name: mxRecord
  at ASC.Common.Utils.DnsLookup.IsDomainMxRecordExists (System.String domainName, System.String mxRecord) [0x00021] in <ea3f357eccf54f1b8bd29463a22fc042>:0
  at ASC.Mail.Extensions.ServerDomainDnsExtensions.CheckDnsStatus (ASC.Mail.Data.Contracts.ServerDomainDnsData dnsData, System.String domain) [0x0001d] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Mail.Core.Engine.ServerDomainEngine.AddDomain (System.String domain, System.Int32 dnsId) [0x000ed] in <cccb961aec6b431b8a3e4a337a39ea4a>:0
  at ASC.Api.MailServer.MailServerApi.AddDomain (System.String name, System.Int32 id_dns) [0x0000b] in <3a0ee5ef79024c3485755e2a95094945>:0
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <15c986724bdc480293909469513cfdb3>:0

Installation issues

Hello,

I am trying to install on Ubuntu 16.04.02 and having several issues.

  1. I am using docker option since I could not succeed in any other method.
    with the following commands I can make the onlyoffice work in community however no mail server is possible

Document server
sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-document-server -v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/Data
-v /app/onlyoffice/DocumentServer/logs:/var/log/onlyoffice onlyoffice/documentserver

OK

Mail server
sudo docker run --net onlyoffice --privileged -i -t -d --restart=always --name onlyoffice-mail-server -p 25:25 -p 143:143 -p 587:587
-v /app/onlyoffice/MailServer/data:/var/vmail -v /app/onlyoffice/MailServer/data/certs:/etc/pki/tls/mailserver -v /app/onlyoffice/MailServer/logs:/var/log
-v /app/onlyoffice/MailServer/mysql:/var/lib/mysql -h my_private_ip onlyoffice/mailserver

OK

sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-community-server
-p 80:80 -p 5222:5222 -p 443:443 -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data
-v /app/onlyoffice/CommunityServer/mysql:/var/lib/mysql
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice
-v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/DocumentServerData
-e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
-e MAIL_SERVER_DB_HOST=onlyoffice-mail-server onlyoffice/communityserver

Not OK .. impossible to access the community server

sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-community-server
-p 80:80 -p 5222:5222 -p 443:443 -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data
-v /app/onlyoffice/CommunityServer/mysql:/var/lib/mysql
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice
-v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/DocumentServerData
-e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
onlyoffice/communityserver

OK however I cannot see the possibility to create own domain name, basically the mail functionality will be limited to client mail not a mail server.

  1. Oneclick install does not work form me at all. Although I enabled the SSH port 22 through my firewall , I can see request coming but later I get an error and does not proceed.

Could someone help me on the mail issue (point 1)

Server not found after login

I have recently installed Onlyoffice community server according to this guide.
The installation run smoothly and docker containers are up and running, but this is what I get right after, as I try to enter the community server:
screen shot 2017-05-10 at 17 54 23

Additional info:

  • docker installed under CentOS
  • selinux and firewall are disabled in the docker host
  • nginx is running in the container
  • this is the error log
2017/05/10 15:58:29 [crit] 51#51: *1 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (2: No such file or directory) while connecting to upstream, client: 127.0.0.1, server: , request: "HEAD /warmup/auth.aspx HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:", host: "localhost"

2017/05/10 15:58:31 [crit] 51#51: *3 connect() to unix:/var/run/onlyoffice/onlyoffice2.socket failed (2: No such file or directory) while connecting to upstream, client: 127.0.0.1, server: , request: "HEAD /warmup2/auth.aspx HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice2.socket:", host: "localhost"

2017/05/10 15:59:21 [warn] 49#49: duplicate MIME type "text/html" in /etc/nginx/includes/onlyoffice-communityserver-common.conf:19
  • files /var/run/onlyoffice/onlyoffice.socket and /var/run/onlyoffice/onlyoffice2.socket exist in the container

Can anyone help me?

503 Service Unavailable error

I installed onlyoffice community server using docker on an ubuntu 18.04 instance. I set up an apache proxy (apache is also running in a container) and added the necessary onlyoffice.conf file to the sites-available directory. Other applications are working fine but I am having an error with onlyoffice. Since apache2 is already using port 80, I configured onlyoffice container port 80 to point to port 8081 within the host machine.
Could anyone please point me to what I have not done right here.

Use names instead of host ports?

"ONLYOFFICE COMMUNITY SERVER uses ports: 80, 443, 5222, 5280, 9865, 9888, 9866, 9871, 9882
please, make sure that the ports are free."

Can you make it optional to switch between ports and hostnames?

Alternatively, the ports are currently hard coded. Can you make it so they're configurable?

It's somewhat defeating the point of docker to use system ports as each container already comes with its own network stack and can be reached/resolved by container name in a standard setup.

Public port mappings would normally be exposed on demand (configurable) or alternatively the host would manage for example being able to route to the docker bridge being used.

Calendar notifications not abiding by timezone

I'm having an issue where my reminder notifications are set to email me 15 minutes before a scheduled item. However, they are coming 45 minutes after the event (so it seems the timezone is off by an hour). The server timezone is set to America/Denver, and when I click to edit a specific calendar to define the timezone, it is also set to America/Denver. I even went into each of the three containers (community server, doc server, and mysql server) and made sure the /etc/timezone files matched the same timezone. I rebooted the server and this is still happening.

Any idea what is happening here? Thanks!

Alfresco Integration OnlyOffice

Dear,
perform the procedure to install onlyoffice using docker, with mail server. Everything worked perfect, then install the onlyoffice module in alfresco for the integration, add the configuration lines in alfresco-global.properties, but even so, when wanting to edit a document with onlyoffice, the tab remains blank and does nothing.

Alfresco Community v5.2.0

/var/run/docker.sock: no such file or directory.

Hi.

Tried to run

sudo docker run -i -t -d -p 80:80 onlyoffice/communityserver

Which resulted in:

Post http:///var/run/docker.sock/v1.20/containers/create: dial unix /var/run/docker.sock: no such file or directory.
* Are you trying to connect to a TLS-enabled daemon without TLS?
* Is your docker daemon up and running?

Trying this on Ubuntu 14.04 LTS

Docker install alonside existing apache server

Hi all,

I've spent the day trying to find out how to use the docker install alongside an existing apache and mysql server. If I use the info on https://helpcenter.onlyoffice.com/server/docker/community/docker-installation.aspx, changing the port for mysql with -p 3307:3306 and for onlyoffice using -p 90:80 I get errors about tables not existing:

docker logs for the onlyoffice container:
dig: couldn't get address for 'resolver1.opendns.com': failure mysq check connection for onlyoffice-mysql-server mysqld is alive DB_IS_EXIST: onlyoffice DB_CHARACTER_SET_NAME: utf8 DB_COLLATION_NAME: utf8_general_ci DB_TABLES_COUNT: 170 change connections for default then /var/www/onlyoffice/WebStudio/web.connections.config change connections for teamlabsite then /var/www/onlyoffice/WebStudio/web.connections.config change connections for default then /var/www/onlyoffice/Services/TeamLabSvc/TeamLabSvc.exe.Config change connections for default then /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe.config change connections for default then /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.EmlDownloader.exe.config change connections for default then /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.exe.config change connections for core then /var/www/onlyoffice/ApiSystem/Web.config ERROR 1146 (42S02) at line 224: Table 'onlyoffice.wiki_pages' doesn't exist ERROR 1146 (42S02) at line 78: Table 'onlyoffice.tenants_quota' doesn't exist ERROR 1146 (42S02) at line 31: Table 'onlyoffice.tenants_partners' doesn't exist ERROR 1146 (42S02) at line 40: Table 'onlyoffice.tenants_quota' doesn't exist ERROR 1146 (42S02) at line 89: Table 'onlyoffice.res_files' doesn't exist ERROR 1146 (42S02) at line 3: Table 'onlyoffice.res_files' doesn't exist onlyoffice ALL=(ALL) NOPASSWD: /usr/sbin/service Starting redis-server: redis-server. fix docker bug volume mapping for onlyoffice Starting monoserve... OK Stopping monoserve... OK Starting monoserve... OK Starting monoserve2... OK Stopping monoserve2... OK Starting monoserve2... OK Starting monoserveApiSystem... OK Stopping monoserveApiSystem... OK Starting monoserveApiSystem... OK Starting onlyofficeFeed... OK Starting onlyofficeIndex... OK Starting onlyofficeJabber... OK Starting onlyofficeMailAggregator... OK Starting onlyofficeMailWatchdog... OK Starting onlyofficeNotify... OK Starting onlyofficeBackup... OK Starting god... OK

docker logs for the mysql container:
2019-11-25 18:11:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started. 2019-11-25 18:11:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2019-11-25 18:11:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started. 2019-11-25T18:11:43.230518Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-11-25T18:11:43.232040Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 1 ... 2019-11-25T18:11:43.235321Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-11-25T18:11:43.235341Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-25T18:11:43.235346Z 0 [Note] InnoDB: Uses event mutexes 2019-11-25T18:11:43.235351Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-11-25T18:11:43.235356Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-11-25T18:11:43.235360Z 0 [Note] InnoDB: Using Linux native AIO 2019-11-25T18:11:43.235608Z 0 [Note] InnoDB: Number of pools: 1 2019-11-25T18:11:43.235712Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-11-25T18:11:43.237504Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-11-25T18:11:43.246136Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-25T18:11:43.248086Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-25T18:11:43.259818Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-11-25T18:11:43.311184Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-25T18:11:43.311275Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-25T18:11:43.429737Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-25T18:11:43.431702Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-11-25T18:11:43.431727Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-11-25T18:11:43.432282Z 0 [Note] InnoDB: Waiting for purge to start 2019-11-25T18:11:43.482504Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 82970339 2019-11-25T18:11:43.482918Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-25T18:11:43.483153Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-11-25T18:11:43.540742Z 0 [Note] InnoDB: Buffer pool(s) load completed at 191125 18:11:43 2019-11-25T18:11:43.565945Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-11-25T18:11:43.565966Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-11-25T18:11:43.566621Z 0 [Warning] CA certificate ca.pem is self signed. 2019-11-25T18:11:43.566658Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2019-11-25T18:11:43.567117Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2019-11-25T18:11:43.567151Z 0 [Note] IPv6 is available. 2019-11-25T18:11:43.567164Z 0 [Note] - '::' resolves to '::'; 2019-11-25T18:11:43.567185Z 0 [Note] Server socket created on IP: '::'. 2019-11-25T18:11:43.569824Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2019-11-25T18:11:43.831619Z 0 [Note] Event Scheduler: Loaded 0 events 2019-11-25T18:11:43.831807Z 0 [Note] mysqld: ready for connections. Version: '5.7.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2019-11-25T18:12:29.627347Z 24 [Note] Aborted connection 24 to db: 'onlyoffice' user: 'onlyoffice_user' host: 'onlyoffice-community-server.onlyoffice' (Got an error reading communication packets) ... snip

And I can't seem to find a way to use the opensource-install.sh with different ports.

So the question is: Is this set-up possible and if yes PLEASE tell me how.

Thanks,

Jouke

Docker-DocumentServer Connection with Docker-Community Server Api url: Service is not defined

Can any one help me fixing this issue?
I'm using docker version using this https://helpcenter.onlyoffice.com/server/docker/community/install-integrated.aspx,

It's successfull,

then I restore my backup data and mysqldump (onlyoffice and onlyoffice_mailserver),

then I can't access is, mybe it's related to this : docs
https://helpcenter.onlyoffice.com/server/linux/community/connect-document-server.aspx
https://helpcenter.onlyoffice.com/server/windows/community/connect-document-server.aspx

But I'm not sure, not finding the correct 'ID' in 'webstudio_settings' table in onlyoffice database

Facebook Links in the code?

Hi there. I was setting up the community server today using the install scripts for docker.
After installing, I logged in with Firefox. I have Firefox Facebook containers installed. This means that whenever there's some link to FB, it'll display a graphic icon.

I was a bit surprised to see the fence icon hiding in the upper left corner of the screen (this icon appears on almost all apps).

If I inspect the page I see that there are references to FB.

Why is this needed? What is the purpose? Can anyone help me with an answer?

Selection_004

From Chrome:
Selection_003

SAML SSO not working - 404 Page (Docker Enterprise)

ISSUE:

I have installed docker enterprise edition - for testing our saml,
using https://download.onlyoffice.com/install/enterprise-install.sh, as described at https://helpcenter.onlyoffice.com/server/docker/enterprise/enterprise-script-installation.aspx

Then installed trail license.

I could see all options SSO via control panel, I am able to fill idp data and save too.

But when I try to download SP metadata, It takes out to 404 page.
Also if you copy SP metadata url and try via browser, that also results in 404 page

Please look into this.

Community Server - Docker Compose not creating MySQL properly.

I've followed these steps to the letter, or more precisely, the docker-compose file (literally as is). https://github.com/ONLYOFFICE/Docker-CommunityServer

Now, I get to the "please wait, this will take some time" window, and nothing changes. Actually refreshing or trying again later comes back with many errors, usually MySQL.

First, the user wasn't created, so I did that manually. Then I refreshed, and it said that it couldn't find the database. A restart sorted that out.

But now, the tenants table cannot be found, and there is nothing in the files alluding to them being created. I've been trying to sort this out all month, and I'm not getting anywhere.

docker-compose stack install failure

Hi everyone,

I wanted to give a try to onlyoffice using docker-compose to see quickly its features as I was unable to create a 30 days trial session on a remote cloud instance.
I first tried with a custom docker-compose.yml file with my own naming/infos. I faced an error while building the stack so I tried to reuse the example file given in this repo, but I end up with the same error.
Does someone succeed to have a functional environment using docker-compose method?

Error while building the stack:
docker-compose up -d

Creating volume "compose_mail_data" with default driver
Creating volume "compose_mail_certs" with default driver
Creating volume "compose_mail_log" with default driver
Creating volume "compose_document_data" with default driver
Creating volume "compose_document_log" with default driver
Creating volume "compose_document_forgotten" with default driver
Creating volume "compose_community_data" with default driver
Creating volume "compose_community_log" with default driver
Creating volume "compose_mysql_data" with default driver
Creating onlyoffice-mysql-server    ... error
Creating onlyoffice-document-server ...

ERROR: for onlyoffice-mysql-server  Cannot start service onlyoffice-mysql-server: OCI runtime create failed: container_linux.go:348: starting container process caused "process_linux.go:402: container init caCreating onlyoffice-document-server ... error

ERROR: for onlyoffice-document-server  Cannot start service onlyoffice-document-server: OCI runtime create failed: container_linux.go:348: starting container process caused "process_linux.go:402: container init caused \"could not create session key: function not implemented\"": unknown

ERROR: for onlyoffice-mysql-server  Cannot start service onlyoffice-mysql-server: OCI runtime create failed: container_linux.go:348: starting container process caused "process_linux.go:402: container init caused \"could not create session key: function not implemented\"": unknown

ERROR: for onlyoffice-document-server  Cannot start service onlyoffice-document-server: OCI runtime create failed: container_linux.go:348: starting container process caused "process_linux.go:402: container init caused \"could not create session key: function not implemented\"": unknown
ERROR: Encountered errors while bringing up the project.

lsb_release -a

No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 9.4 (stretch)
Release:        9.4
Codename:       stretch

docker version

Client:
 Version:      18.03.1-ce
 API version:  1.37
 Go version:   go1.9.5
 Git commit:   9ee9f40
 Built:        Thu Apr 26 07:17:14 2018
 OS/Arch:      linux/amd64
 Experimental: false
 Orchestrator: swarm

Server:
 Engine:
  Version:      18.03.1-ce
  API version:  1.37 (minimum version 1.12)
  Go version:   go1.9.5
  Git commit:   9ee9f40
  Built:        Thu Apr 26 07:15:24 2018
  OS/Arch:      linux/amd64
  Experimental: false

docker-compose version

docker-compose version 1.21.2, build a133471
docker-py version: 3.3.0
CPython version: 3.6.5
OpenSSL version: OpenSSL 1.0.1t  3 May 2016

Upload and export/download not working

I cannot upload document from my computer to ONLYOFFICE: I do get to select the file I want to upload (browser's job) and the background upload popup (in lower right corner). But upload seems to never start nor finish: progress bar stays at 0%.

I also cannot export a document from ONLYOFFICE (either to Office format, CSV, HTML, etc.).
I do get to choose my export format but nothing happens: no browser download prompt.

As a workaround: is there a way to retrieve files from data dir on the server?

I run container with:

docker run -i -t -d \
     --name onlyoffice-document-server \
     onlyoffice/documentserver
 docker run -i -t -d \
     --name onlyoffice-community-server \
     --restart=always \
     -p 8080:80 \
     --link onlyoffice-document-server:document_server \
     -v /opt/onlyoffice/logs:/var/log/onlyoffice \
     -v /opt/onlyoffice/data:/var/www/onlyoffice/Data \
     -v /opt/onlyoffice/mysql:/var/lib/mysql \
     onlyoffice/communityserver

Port error message is misleading...

When trying to install I receive this message:

"The following ports must be open: 80"

In my case the error message should have been:

"The following ports must be available: 80/tcp"

(or usable)

A port being open means at the least that the port is not blocked by the firewall.

Generally though it most often means in the context of the test your performing that it is possible to successfully connect to the port. To say the port must be open implies the opposite of what is really meant. For example if I tried to connect to port 80 locally and the connection succeeded then I would say that the port is open. It like saying the following port must be in use.

Mailer uses outdated version of TLS and set of ciphers

With "Use SSL" flag enabled in SMTP settings test mail yields error: "The authentication or decryption has failed."

Postfix server gives those log lines:

postfix/smtpd[2077]: warning: TLS library problem: error:1408A0C1:SSL routines:SSL3_GET_CLIENT_HELLO:no shared cipher
postfix/smtpd[2077]: lost connection after STARTTLS from unknown[172.22.0.1]
postfix/smtpd[2077]: disconnect from unknown[172.22.0.1]

This is part of captured TLS handshake:

Secure Sockets Layer
    SSL Record Layer: Handshake Protocol: Client Hello
        Content Type: Handshake (22)
>>> Version: TLS 1.0 (0x0301) <<<
        Length: 83
        Handshake Protocol: Client Hello
            Handshake Type: Client Hello (1)
            Length: 79
        >>> Version: TLS 1.0 (0x0301) <<<
            Random
                GMT Unix Time: Aug 17, 2016 15:38:08.000000000 MSK
                Random Bytes: 3b3eacf5148967dd14a7d9c8878d518c5ff5ce0453e12272...
            Session ID Length: 0
            Cipher Suites Length: 12
            Cipher Suites (6 suites)
                Cipher Suite: TLS_RSA_WITH_AES_256_CBC_SHA (0x0035)
                Cipher Suite: TLS_RSA_WITH_AES_128_CBC_SHA (0x002f)
                Cipher Suite: TLS_RSA_WITH_3DES_EDE_CBC_SHA (0x000a)
                Cipher Suite: TLS_RSA_WITH_RC4_128_SHA (0x0005)
                Cipher Suite: TLS_RSA_WITH_RC4_128_MD5 (0x0004)
                Cipher Suite: TLS_RSA_WITH_DES_CBC_SHA (0x0009)

TLS v1.0 is considered to be insecure and deprecated. Modern mail servers configured with security best practices in mind will reject connections from OO-Mailer.

Please, consider upgrading TLS to version 1.2.

wrong cpu processor count!

hi,

i'm discovered on /app/onlyoffice/run-community-server.sh CPU_PROCESSOR_COUNT wrong value returned.

my manually set file and mount bind container. solved my elasticsearch service allways failback problems.
onlyoffice-community-server-docker-not-onemli

slow response from private network

Hi,

I have an annoying behavior for a community server 8.5, docker setup. As long as i keep this instance connected to the internet, everything is going smoothly. After the server is no longer connected to the internet, all apps begin to respond slowly, about 10 seconds between choosing to change the context (seems to be a timeout), from 'documents' section to 'mail' section, for example. During the installation I'm using a public ip address for the host server and when I disconnect i'm using a private class of ip addresses.

MySQL can't connect....

When trying to install I receive this:

ERROR [Threadpool worker] ASC.Web.Studio.Utility.WhiteLabelHelper - Authentication to host 'onlyoffice-mysql-server' for user 'onlyoffice_user' using method 'mysql_native_password' failed with message: Access denied for user 'onlyoffice_user'@'onlyoffice-community-server.onlyoffice' (using password: YES)

Mysql Server Connection is sleeping

Hi,

I´ve installed onlyoffice communityserver on debian 9 and created an own mariadb database on the same server (running at localhost). The docker log of the community server is showing the following:

+ log_debug 'Mysql check connection for 127.0.0.1'
+ echo 'onlyoffice: [Debug] Mysql check connection for 127.0.0.1'
onlyoffice: [Debug] Mysql check connection for 127.0.0.1
+ mysqladmin ping -h 127.0.0.1 -P 3306 -u onlyoffice --password=xyz --silent
+ sleep 1

I don´t know, what I´m doing wrong? I´ve created an empty database and the user onlyoffice has all rights on this database.

This is my startup command:

docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-community-server -p 127.0.0.1:8090:80 \
 -e MYSQL_SERVER_HOST=127.0.0.1 \
 -e MYSQL_SERVER_PORT="3306"\
 -e MYSQL_SERVER_DB_NAME=onlyoffice \
 -e MYSQL_SERVER_USER=onlyoffice \
 -e MYSQL_SERVER_PASS=xyz \
 -e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server \
 -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
 -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
 onlyoffice/communityserver

I´ve created the docker network bridge and the document server runs. Has anyone a hint, why the mysql connection is sleeping?

Unknown database 'onlyoffice_mailserver'

Installation command under Debian 8:

bash opensource-install.sh -md domain --mysqlrootpassword "custom-password" --mysqluser custom-username --mysqlpassword "another-custom-password" --mysqlmailuser another-custom-username --mysqlmailpassword "a-third-custom-password"

Is this an unsupported configuration? Are there limits on the permissible characters in passwords? I was not comfortable with the idea of letting the installation script use a set of simple, publicly-available usernames and passwords.

The whole stack did install, but attempts to work with the mail server fail, and typing "docker container logs onlyoffice-community-server" returns a lot of:

ERROR 1049 (42000): Unknown database 'onlyoffice_mailserver'

Unfortunately the installation appeared to work correctly, and no notification was raised anywhere about failing to create this database. "docker container logs onlyoffice-community-server" does not contain any message about the database not being created.

It seems that there are two problems:

a) We have some kind of circumstance where the onlyoffice_mailserver does not get created
b) When the above error occurs, it is buried

opensource-install.sh simply followed the Docker process with "Thank you for installing ONLYOFFICE.
In case you have any questions ..." and the in-browser first-run initialisation seemed to complete without error.

Issue 32 covered a situation when the database did not get created, but that was closed in November last year, and I would figure that a fresh installation at this point in time would no longer have that problem. There is a help page "Connecting Mail Server to Community Server on Linux" but this itself assumes that the database already exists.

Cookie too large error

Bug report.

User filters and page settings appear to be saved in cookies, so users with many settings can receive a 400 - Request Header or Cookie Too Large error when browsing the community server site. The cookie that caused this particular error is 8,220 bytes. By default, nginx is configured to limit cookies to 8 kilobytes, so this cookie is slightly larger than the default limit.

An easy fix would be to add large_client_header_buffers 4 16k; to the nginx server block, but that will be reset if the container is restarted.

Community Server 9.1.0.418, installed via Docker.

Import contacts from files failed

Env: Chrome 75.0.3770.142 64bit
I have import contacts by chrome via CSV file. When i choose the csv file, the chrome console display some error and can not parse this CSV file successfully.

Error message
Uncaught SyntaxError: Unexpected token < in JSON at position 582 at JSON.parse (<anonymous>) at AjaxUpload.hr (qljsuwDEgatlb_odUGL-ZQ2.js?ver=10.0.1.897:89) at HTMLIFrameElement.<anonymous> (qljsuwDEgatlb_odUGL-ZQ2.js?ver=10.0.1.897:34)

When i see json content: {"Columns":"[{\"Key\":\"FirstName\",\"Value\":\"First Name\"},{\"Key\":\"LastName\",\"Value\":\"Last Name\"},{\"Key\":\"Email\",\"Value\":\"Email\"}]","Success":true,"Data":null,"Message":"[{\"Item1\":[\"First Name\",\"Last Name\",\"Email\"],\"Item2\":[\"First Name\",\"Last Name\",\"Email\"]},{\"Item1\":[\"First Name\",\"Last Name\",\"Email\"],\"Item2\":[\"san\",\"zhang\",\"[email protected]\"]},{\"Item1\":[\"First Name\",\"Last Name\",\"Email\"],\"Item2\":[\"si\",\"li\",\"[email protected]\"]},{\"Item1\":[\"First Name\",\"Last Name\",\"Email\"],\"Item2\":[\"��\",\"��\",\"[email protected]\"]}]"}<audio controls="controls" style="display: none;"></audio>

I think the audio content maybe the key point that why json is pars failed. please fix it.

This also happed on Firefox Quantum 68.0
Works well on IE

Nginx with HTTP/2 support

Hi,

Will the docker image of OnlyOffice DocumentServer use Nginx (>= 19.x instead of the current 1.4.6) with HTTP/2 support soon , to solve the very painful slow loading of onlyoffice docker documentserver over internet...

Thanks

docker container restart fail

OS: CentOS Linux release 7.3.1611 (Core)
community server container restart fail.
docker continously print "Restarting nginx" from command "docker logs -f "

  • Reloading nginx nginx [ OK ]
    reload nginx config
    FINISH
  • Restarting nginx nginx start-stop-daemon: warning: failed to kill 39: No such process
    [ OK ]
    MAIL_SERVER_API_HOST is empty
  • Restarting nginx nginx start-stop-daemon: warning: failed to kill 39: No such process
    [ OK ]

docker ps command:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
3d0a03117f31 onlyoffice/communityserver "/bin/sh -c 'exec ..." 6 weeks ago Restarting (246) 16 seconds ago onlyoffice-community-server

how i can reset password if my mail-server is not working ?

hello, I upgrade from onlyoffice community edition from 9 to 9.5, but I don't restore the mail-server data in my docker container, only from "community" edition, so I can't reset the password because the email is never sent.

what can i do to reset the password ?

Can't change "Document Editing Service Address" - got error "Api url: Service is not defined"

I install ONLYOFFICE Community Server integrated with Document and Mail Servers as it described on page https://github.com/ONLYOFFICE/Docker-CommunityServer#installing-onlyoffice-community-server-integrated-with-document-and-mail-servers

But I can't edit documents online - I got error "ONLYOFFICE™ is not available. Please contact us at [email protected]", HTML page contains link <script language="javascript" type="text/javascript" src="/OfficeWeb/apps/api/documents/api.js"></script> but uri /OfficeWeb/apps/api/documents/api.js not exists, Firefox return error The page isn’t redirecting properly. Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

Next I go to settings page "Document Service Location" and try to fix "Document Editing Service Address". Old value is "/OfficeWeb/apps/api/documents/api.js", I try to enter https://onlyoffice-document-server/web-apps/apps/api/documents/api.js because onlyoffice-document-server is hostname of DocumentServer docker container and https://onlyoffice-document-server/web-apps/apps/api/documents/api.js is valid url - this url contains javascript without 301 redirects. Document Server container is up and running.

But I can't change "Document Editing Service Address" - I got error "Api url: Service is not defined" when pressing "Save" button is "Document Service Location" settings page.

What I am doing wrong, and how I can install ONLYOFFICE Community Server integrated with Document and Mail Servers as Docker containers? I do all install by instruction https://github.com/ONLYOFFICE/Docker-CommunityServer#installing-onlyoffice-community-server-integrated-with-document-and-mail-servers but I can't got working integration between community server and document server...

Or this is obsoleted instruction and installation/integration should be done in other way?

onlyoffice3.socket failed

I have this error with nginx, so few static files are'nt loaded (css, js, ...) so it's not possible to use onlyoffice.

2016/02/24 17:26:53 [error] 710#0: *150 connect() to unix:/var/run/onlyoffice/onlyoffice3.socket failed (111: Connection refused) while connecting to upstream, client: 81.56.75.62, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice3.socket:", host: "domain.com:8080"

2016/02/24 17:27:06 [error] 710#0: *152 connect() to unix:/var/run/onlyoffice/onlyoffice3.socket failed (111: Connection refused) while connecting to upstream, client: 81.56.75.62, server: , request: "GET /discbundle/common/css/rZI8GL7qC28F1Yh_W2NrZg2.css?ver=264 HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice3.socket:", host: "erp.atosium.com:8080", referrer: "http://domain.com:8080/"

I checked in /var/run/onlyoffice and I have'nt onlyoffice3.socket

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.