Roll Your Own Google Docs with OnlyOffice On ownCloud 🌱

Installing OnlyOffice Office

  1. Log into the Linux device
  2. Run the following commands in a terminal:
    # check for an install software updates
    sudo apt update
    sudo apt upgrade
    # install postgreSQL
    sudo apt install postgresql
    # create the OnlyOffice database, user and grant permissions
    sudo -i -u postgres psql -c "CREATE DATABASE onlyoffice;"
    sudo -i -u postgres psql -c "CREATE USER onlyoffice WITH password '0nly0ff1c3';"
    sudo -i -u postgres psql -c "GRANT ALL privileges ON DATABASE onlyoffice TO onlyoffice;"
    # install redis and rabbitmq
    sudo apt install redis-server rabbitmq-server
    # if running on the same server as owncloud, stop apache
    sudo systemctl stop apache2
    # install nginx extras
    sudo apt-get install nginx-extras
    # set the onlyoffice port, using port 1440 here
    echo onlyoffice-documentserver onlyoffice/ds-port select 1440 | sudo debconf-set-selections
    # add the onlyoffice document server apt repository
    sudo apt-key adv --keyserver hkp:// --recv-keys CB2DE8E5
    sudo echo "deb squeeze main" | sudo tee /etc/apt/sources.list.d/onlyoffice.list
    sudo apt update
    # install onlyoffice document server
    sudo apt-get install onlyoffice-documentserver
  3. Paste the onlyoffice database password from above when prompted
  4. Continue the setup by running the following command in terminal
    # modify the default nginx port
    sudo nano /etc/nginx/sites-available/default
  5. Change the port from :80 to :801
  6. Press CTRL+O, Enter, CTRL+X to write the changes to default and close it
  7. Continue the configuration by running the following commands in terminal:
    # edit ownCloud configuration file
    sudo nano /var/www/owncloud/config/config.php
  8. Find the trusted_domains array and add the DNS entry for the OnlyOffice host
  9. Add the following line inside the array

    'allow_local_remote_servers' => true

  10. Press CTRL+O, Enter, CTRL+X
  11. Continue with the following in terminal
    # restart nginx
    sudo systemctl restart nginx
    # start apache2
    sudo systemctl start apache2
  12. Open a web browser and navigate to http://DNSorIP:1440 to verify OnlyOffice Document Server is up and running

Adding OnlyOffice to ownCloud

  1. Log into ownCloud with an administrative user
  2. Click the hamburger menu in the top left corner > Market
  3. Click Integration under the Categories heading
  4. Find and click on OnlyOffice
  5. Click the Install button
  6. Once the installation completes, click the username dropdown > Settings
  7. Select Admin > Additional from the left navigation menu
  8. Enter the DNS name for the OnlyOffice server URL
  9. Click Apply