Guide for installation of [[https://nextcloud.com|Nextcloud]].

== Create database ==

Postgresql should work, but Nextcloud recommends MySQL. See [[MemberManual/Databases#Create_a_Database]]. We'll assume you name the database `${USER}_cloud`.

== Software installation ==

=== Unpack ===

Get the Nextcloud tarball from [[https://nextcloud.com/install/#instructions-server|Nextcloud]].

Pick a directory where you'll host Nextcloud, for example `$HOME/www/next.your.domain`. We'll call it `$NEXTDIR`.

Also pick a directory for data, for example `$HOME/var/nextcloud`. We'll call it `$NEXTDATA`.

Unpack the source.

{{{
unzip nextcloud-15.0.0.zip
}}}

Move the resulting `nextcloud` directory to where you decided to have the document root.

{{{
mv nextcloud $NEXTDIR
}}}

Create an empty data directory in the document root. This is necessary for the duration of the installation, we'll delete it later.

{{{
cd $NEXTDIR
mkdir data
}}}

=== Permissions ===

Adjust directory permissions:

{{{
fsr setacl . system:anyuser none
fsr sa . $USER.daemon rlk
fsr sa config $USER.daemon rlidwk
fsr sa data $USER.daemon rlidwk
fsr sa apps $USER.daemon rlidwk
}}}

=== Patch ===

Delete some lines in the file `core/Migrations/Version14000Date20180129121024.php`. This doesn't play well with the HCoop default of not granting DROP on tables. The easiest fix seems to be to manually drop these later.

{{{
@@ -49,11 +49,6 @@
                /** @var ISchemaWrapper $schema */
                $schema = $schemaClosure();

-               $schema->dropTable('admin_sections');
-               $schema->dropTable('admin_settings');
-               $schema->dropTable('personal_sections');
-               $schema->dropTable('personal_settings');
-
                return $schema;
        }
 }
}}}

=== Create real data directory ===

Create the data directory and give it correct permissions:

{{{
mkdir $NEXTDATA
cd $NEXTDATA
fsr setacl . system:anyuser none
fsr sa . $USER.daemon rlidwk
}}}


== Nextcloud installation wizard ==

Open up the web site, which should now show you the installation wizard. Fill it out like so:

{{{
Data folder: $NEXTDATA
Database: MySQL/MariaDB
Username: whatever you like
Password: likewise
DB hostname: mysql
}}}

== Post-installation database fixes ==

=== Set charset ===

In the MySQL CLI, run:

{{{
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
}}}

Add this line to `$NEXDIR/config/config.php`:

{{{
'mysql.utf8mb4' => true,
}}}

=== Update some column types ==

Run this command to convert a couple of column types that are not handled by the installer:

{{{
cd $NEXTDIR
php7.2 occ db:convert-filecache-bigint
}}}

== Domtool ==

{{{
web "cloud" where
    PhpVersion = php72;
    DocumentRoot = home "$NEXTDIR";
with
    rewriteRule "/.well-known/carddav" "/remote.php/dav" [redirectWith temp];
    rewriteRule "/.well-known/caldav" "/remote.php/dav" [redirectWith temp];
end;
}}}

'''TODO: Translate additional settings from `.htaccess` and `.user.ini`'''


== Additional configuration ==


=== Cache ===

Add this line to `$NEXDIR/config/config.php`, to enable the APCu cache:

{{{
'memcache.local' => '\OC\Memcache\APCu',
}}}

=== Cron ===

Add a [[MemberManual/UsingCron|cron job]] like this replacing the variables with your username/path:

{{{
*/5 * * * * k5start -qtUf /etc/keytabs/user.daemon/$USER -- /usr/bin/php7.2 -f $NEXTDIR/cron.php
}}}

== Login ==

You should now be able to log in and look around Nextcloud. You may want to have a look at `Settings → Overview` for any warnings. You will see a bunch of warnings like this:

{{{
Some app directories are owned by a different user than the web server one. This may be the case if apps have been installed manually. Check the permissions of the following app directories:

    /afs/hcoop.net/user/…
}}}

These can be ignored.

== Cleanup ==

Since we use a new data directory we can delete the one in the document root:

{{{
cd $NEXTDIR
rm -r data
}}}

We should drop those deprecated tables from before (this wasn't actually working for me, will look into how to drop tables in MySQL later).

{{{
mysql-fixperms
mysql -h mysql -p ${USER}_cloud

DROP TABLE admin_sections;
DROP TABLE admin_settings);
DROP TABLE personal_sections;
DROP TABLE 'personal_settings;
}}}


'''TODO: This didn't work for me, fix the instructions on dropping tables.'''

== Configuration in Nextcloud UI ==

=== cron ===

Go to ''Settings → Basic Settings'' and select the option ''Cron'' under ''Background jobs'' (since we set that up earlier).

You can check this page to ensure your cronjob is working.

=== Mail notifications ===

In ''Settings → Basic Settings, set:

Send mode: Sendmail
Sendmail mode: pipe (-t)
From address: whatever you like (under your domain).;

'''TODO: Update with instructions on using SMTP when that's working.'''