AppSuite:Filestorages

From Open-Xchange

Common preparations

This page shows how to setup external file stores. For all of these file stores you have to install the package "open-xchange-oauth", which provides the necessary authentication mechanisms.

Moreover your setup is required to be reachable via HTTPS, since the providers expect that a call-back URL to your setup is specified. Such a call-back URL is only accepted if it contains the "https://" scheme., e.g.:

 "https://my.oxsetup.invalid/ajax/defer"

Keep HTTPS protocol

Appsuite:Grizzly#Cluster_setup shows that HTTPS communication is terminated by the Apache balancer in front of the Open-Xchange nodes. To let the Open-Xchange application know about the HTTPS protocol that is used to communicate with the Apache server:

  • Either set a special header in the SSL virtual hosts configurations in Apache to forward this information. The de facto standard for this is the "X-Forwarded-Proto" header. See Appsuite:Grizzly#X-FORWARDED-PROTO_Header for how to setup that header.
  • Or force the Open-Xchange application to assume it is reached via SSL through setting property "com.openexchange.forceHTTPS=true" in file /opt/open-xchange/etc/server.properties.

Deferrer URL

Open-Xchange application uses the deferrer URL as call-back for some of the providers, which use OAuth v2.0 authentication (such as Google).

If your OX server is reachable only via one host name, you won't have to do anything. If it is reachable by more than one host name, create or open the file /opt/openexchange/etc/groupware/deferrer.properties and set the properties therein as such:

 com.openexchange.http.deferrer.url=https://mymaindomain.invalid

Dropbox

To setup the Dropbox file store you have to install the package "open-xchange-file-storage-dropbox".

Registering your app

  • Log in to your Dropbox account here, and create your Dropbox app here
  • There are two options available creating an app, Drops-in App & Dropbox API App. Please select Dropbox API app and enter the name of your app.
  • Go to App Console and select your created app. Select settings tab to view the APP_KEY (App key) and SECRET_KEY (App secret)

Configuration

In addition you have to configure the following properties in file /opt/open-xchange/etc/dropboxoauth.properties:

  • Enable the OAuth connector to Dropbox OAuth
 com.openexchange.oauth.dropbox=true


  • Set the API key and secret
 com.openexchange.oauth.dropbox.apiKey=REPLACE_THIS_WITH_DROPBOX_APP_KEY
 com.openexchange.oauth.dropbox.apiSecret=REPLACE_THIS_WITH_DROPBOX_APP_SECRET


  • Set the redirect URL. Please ensure the following conditions are met:
    • The redirect URL specified in the Dropbox App needs to be the same as the one specified by this property.
    • The redirect URI uses "https://" as protocol
    • The redirect URI follows the pattern: "https://" + <host-name> + "/ajax/defer"
 com.openexchange.oauth.dropbox.redirectUrl=

E.g. "https://myappsuite.mydomain.invalid/ajax/defer"

  • Set the product ID of the registered Dropbox app
 com.openexchange.oauth.dropbox.productName=


You can define them system-wide or via the config cascade mechanism.

Install on OX App Suite

Debian GNU/Linux 11.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBullseye/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBullseye/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-dropbox

Debian GNU/Linux 12.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBookworm/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBookworm/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-dropbox


Google Drive

To setup the Google Drive file store you have to install the package "open-xchange-file-storage-googledrive".

Registering your app

  • Sign in to Google Developers Console using your Google account
  • Please follow these instructions to create a new project with a client ID, which is needed to call the sign-in API
  • Enable the following APIs for your project
    • BigQuery API
    • Calendar API
    • Contacts API
    • Drive API
    • Drive SDK
    • Gmail API
    • Google Cloud SQL
    • Google Cloud Storage
    • Google Cloud Storage JSON API

Configuration

In addition you have to configure the following properties in file /opt/open-xchange/etc/googleoauth.properties:

  • Enable the OAuth connector to Google OAuth
 com.openexchange.oauth.google=true


  • Set the API key and secret, which is Client ID and Client Secret to call the sign-in API (Select your project, select API manager from upper left burger menu, select credentials in left side bar, select Client ID for Web application)
 com.openexchange.oauth.google.apiKey=REPLACE_THIS_WITH_YOUR_CLIENT_ID
 com.openexchange.oauth.google.apiSecret=REPLACE_THIS_WITH_YOUR_CLIENT_SECRET


  • Set the redirect URL. Please ensure the following conditions are met:
    • The redirect URL specified in the Google App needs to be the same as the one specified by this property.
    • The redirect URI uses "https://" as protocol
    • The redirect URI follows the pattern: "https://" + <host-name> + "/ajax/defer"
 com.openexchange.oauth.google.redirectUrl=

E.g. "https://myappsuite.mydomain.invalid/ajax/defer"

  • Set the product ID of the registered Google app
 com.openexchange.oauth.google.productName=


You can define them system-wide or via the config cascade mechanism.

Install on OX App Suite

Debian GNU/Linux 11.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBullseye/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBullseye/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-googledrive

Debian GNU/Linux 12.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBookworm/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBookworm/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-googledrive


Microsoft Onedrive

To setup the Microsoft OneDrive file store you have to install the package "open-xchange-file-storage-onedrive".

Registering your app

  • Please follow this guide to create/register your app

Configuration

In addition you have to configure the following properties in file /opt/open-xchange/etc/msliveconntectoauth.properties:

  • Enable the OAuth connector
 com.openexchange.oauth.msliveconnect=true


  • Set the API key and secret
 com.openexchange.oauth.msliveconnect.apiKey=REPLACE_THIS_WITH_YOUR_MS_LIVE_CONNECT_CLIENT_KEY
 com.openexchange.oauth.msliveconnect.apiSecret=REPLACE_THIS_WITH_YOUR_MS_LIVE_CONNECT_CLIENT_SECRET


  • Set the redirect URL
 com.openexchange.oauth.msliveconnect.redirectUrl=REPLACE_THIS_WITH_YOUR_MS_LIVE_CONNECT_REDIRECT_URL


You can define them system-wide or via the config cascade mechanism.

Install on OX App Suite

Debian GNU/Linux 11.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBullseye/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBullseye/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-onedrive

Debian GNU/Linux 12.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBookworm/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBookworm/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-onedrive


Box.com

To setup the Box.com file store you have to install the package "open-xchange-file-storage-boxcom".

Registering your app

  • Sign in to box Developers
  • Select Create a Box Application
  • Select Box Content
  • Hit Configure your application
  • Enter redirect_uri' (the deferrer URL; e.g. "https://my.oxsetup.invalid/ajax/defer")
  • Enable Read and write all files and folders

Configuration

In addition you have to configure the following properties in file /opt/open-xchange/etc/boxcomoauth.properties:

  • Enable the OAuth connector
 com.openexchange.oauth.boxcom=true


  • Set the API key and secret
 com.openexchange.oauth.boxcom.apiKey=REPLACE_THIS_WITH_YOUR_BOX_CLIENT_KEY
 com.openexchange.oauth.boxcom.apiSecret=REPLACE_THIS_WITH_YOUR_BOX_CLIENT_SECRET


  • Set the redirect URL
 com.openexchange.oauth.boxcom.redirectUrl=REPLACE_THIS_WITH_YOUR_BOX_REDIRECT_URL


You can define them system-wide or via the config cascade mechanism.

Install on OX App Suite

Debian GNU/Linux 11.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBullseye/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBullseye/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-boxcom

Debian GNU/Linux 12.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present:

deb https://software.open-xchange.com/products/appsuite/stable/backend/DebianBookworm/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/appsuite/stable/backend/updates/DebianBookworm/ /

and run

$ apt-get update
$ apt-get install open-xchange-file-storage-boxcom