Skip to content

Nextcloud

Manage Nextcloud using the helper script

Nextcloud can be set up (parameter -i) and removed (parameter -p) with the helper script included with mailcow. In order to install Nextcloud simply navigate to your mailcow-dockerized root folder and run the helper script as follows:

./helper-scripts/nextcloud.sh -i

In case you have forgotten the password (e.g. for admin) and can't request a new one via the password reset link on the login screen calling the helper script with -r as parameter allows you to set a new password. Only use this option if your Nextcloud isn't configured to use mailcow for authentication as described in the next section.

In order for mailcow to generate a a certificate for the nextcloud domain you need to add "nextcloud.domain.tld" to ADDITIONAL_SAN in mailcow.conf and runthe following to apply:

docker compose up -d
docker-compose up -d

For more informaton refer to: Advanced SSL.

Background jobs

To use the recommended setting (cron) to execute the background jobs following lines need to be added to the docker-compose.override.yml:

version: '2.1'
services:
  php-fpm-mailcow:
    labels:
      ofelia.enabled: "true"
      ofelia.job-exec.nextcloud-cron.schedule: "@every 5m"
      ofelia.job-exec.nextcloud-cron.command: "su www-data -s /bin/bash -c \"/usr/local/bin/php -f /web/nextcloud/cron.php\""

In addition, a specific function must be activated for the php-fpm worker. Do this by editing the file data/conf/phpfpm/php-fpm.d/pools.conf and removing shell_exec from all items including the ,.

After the two steps have been completed, the following command must be executed to provide the Docker image with the corresponding labels and restart the stack.

After adding these lines the following command must be executed to update the docker image:

docker compose up -d
docker-compose up -d

And also the docker scheduler image must be restarted to pick up the new job definition by executing:

docker compose restart ofelia-mailcow
docker-compose restart ofelia-mailcow

To check if the job was successfully picked up by ofelia the command:

docker compose logs ofelia-mailcow
docker-compose logs ofelia-mailcow

It should contain a line similar to New job registered "nextcloud-cron" - ....

By adding these lines the background jobs will be executed every 5 minutes. To verify that the execution works correctly, the only way is to see it in the basic settings when logged in as an admin in Nextcloud. If everything is correct the first scheduled execution will change the background jobs processing setting to (X) Cron and the timestamp after Last job ran will be updated every 5 minutes.

Configure Nextcloud to use mailcow for authentication

The following describes how set up authentication via mailcow using the OAuth2 protocol. We will only assume that you have already set up Nextcloud at cloud.example.com and that your mailcow is running at mail.example.com. It does not matter if your Nextcloud is running on a different server, you can still use mailcow for authentication.

1. Log into mailcow as administrator.

2. Click Configuration in the drop-down menu (top right).

3. Then, in the "Access" tab, select the OAuth2 drop-down item.

4. Scroll down and click the Add OAuth2 client button. Specify the redirect URI as https://cloud.example.com/index.php/apps/sociallogin/custom_oauth2/mailcow and click Add. Save the client ID and secret for later.

Info

Some installations, including those setup using the helper script of mailcow, need to remove index.php/ from the URL to get a successful redirect: https://cloud.example.com/apps/sociallogin/custom_oauth2/mailcow

5. Log into Nextcloud as administrator.

6. Click the button in the top right corner and select Apps. Click the search button in the toolbar, search for the Social Login plugin and click Download and enable next to it.

7. Click the button in the top right corner and select Settings. Scroll down to the Administration section on the left and click Social login.

8. Uncheck the following items:

  • "Disable auto create new users"
  • "Allow users to connect social logins with their accounts"
  • "Do not prune not available user groups on login"
  • "Automatically create groups if they do not exists"
  • "Restrict login for users without mapped groups"

7. Check the following items:

  • "Prevent creating an account if the email address exists in another account"
  • "Update user profile every login"
  • "Disable notify admins about new users"

Click the Save button.

8. Scroll down to Custom OAuth2 and click the + button. 9. Configure the parameters as follows:

  • Internal name: mailcow
  • Title: mailcow
  • API Base URL: https://mail.example.com
  • Authorize URL: https://mail.example.com/oauth/authorize
  • Token URL: https://mail.example.com/oauth/token
  • Profile URL: https://mail.example.com/oauth/profile
  • Logout URL: (leave blank)
  • Client ID: (what you obtained in step 1)
  • Client Secret: (what you obtained in step 1)
  • Scope: profile

Click the Save button at the very bottom of the page.


If you have previously used Nextcloud with mailcow authentication via user_external/IMAP, you need to perform some additional steps to link your existing user accounts with OAuth2.

1. Click the button in the top right corner and select Apps. Scroll down to the External user authentication app and click Remove next to it. 2. Run the following queries in your Nextcloud database (if you set up Nextcloud with the script from mailcow, you can use the following command to get into the container):

source mailcow.conf && docker compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME
source mailcow.conf && docker-compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME
INSERT INTO oc_users (uid, uid_lower) SELECT DISTINCT uid, LOWER(uid) FROM oc_users_external;
INSERT INTO oc_sociallogin_connect (uid, identifier) SELECT DISTINCT uid, CONCAT("mailcow-", uid) FROM oc_users_external;

If you have previously used Nextcloud without mailcow authentication, but with the same usernames as mailcow, you can also link your existing user accounts with OAuth2.

1. Run the following queries in your Nextcloud database (if you set up Nextcloud with the script from mailcow, you can use the following command to get into the container):

source mailcow.conf && docker compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME
source mailcow.conf && docker-compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME
INSERT INTO oc_sociallogin_connect (uid, identifier) SELECT DISTINCT uid, CONCAT("mailcow-", uid) FROM oc_users;

Update

The Nextcloud instance can be updated easily with the web update mechanism. In the case of larger updates, there may be further changes to be made after the update. After the Nextcloud instance has been checked, problems are shown. This can be e.g. missing indices in the DB or similar. It shows which commands have to be executed, these have to be placed in the php-fpm-mailcow container.

As an an example run the following command to add the missing indices. docker exec -it -u www-data $(docker ps -f name=php-fpm-mailcow -q) bash -c "php /web/nextcloud/occ db:add-missing-indices"

The update can also been done by CLI with the following command:

docker exec -it -u www-data $(docker ps -f name=php-fpm-mailcow -q) bash -c "php /web/nextcloud/updater/updater.phar"

This can also been done in an non interactive way (e.g. CRON) with this command:

Danger

We do not recommend this! Serios damage can be caused or the update process brakes over time.
USE AT OWN RISK!!

docker exec -it -u www-data $(docker ps -f name=php-fpm-mailcow -q) bash -c "php /web/nextcloud/updater/updater.phar --no-interaction"


Debugging & Troubleshooting

It may happen that you cannot reach the Nextcloud instance from your network. This may be due to the fact that the entry of your subnet in the array 'trusted_proxies' is missing. You can make changes in the Nextcloud config.php in data/web/nextcloud/config/*.

'trusted_proxies' =>
  array (
    0 => 'fd4d:6169:6c63:6f77::/64',
    1 => '172.22.1.0/24',
    2 => 'NewSubnet/24',
  ),

After the changes have been made, the nginx container must be restarted.

docker compose restart nginx-mailcow
docker-compose restart nginx-mailcow