Nextcloud, Office Suites and FreeNAS

Nextcloud and Office Suite Integration

Here are some equivalence terms:

Interested in hosting your own office suite like Office 365 or Google Docs?

Refer to the resources Nextcloud and OnlyOffice Integration and Nextcloud and Collabora Integration

Below is a table summarising the current editing capabilities of various mobile office offerings for Nextcloud.

N = View only

Tips, Tricks and Troubleshooting

Responses appear under this index.

1. I can’t seem to get past the login screen on the Nextcloud Android and iOS apps.
2. I can’t cut and paste between Windows and noVNC in the FreeNAS UI.
3. What version of OnlyOffice Document server am I on?
4. I can see previews of photos in Nextcloud, but not of videos.
5. I would like to mount external SMB storage from within Nextcloud. I see a message about smbclient not being installed.

Q1. I can’t seem to get past the login screen on the Nextcloud Android and iOS apps. 

Symptoms are a disc that spins forever on the Nextcloud Android and iOS apps on a login attempt, and on the desktop, you have to hit the [Enter] key twice to login on Google Chrome and Microsoft Edge (Chromium) browsers.

The solution is to add the following lines to the Nextcloud config.php.

'overwritehost' => 'cloud.mydomain.com',
'overwriteprotocol' => 'https',

For more information, refer to the thread Redirecting bug since 15.0.2

Q2. I can’t cut and paste between Windows and noVNC in the FreeNAS UI. 

The reason is described here. Do yourself a favour and install SSH on Ubuntu. Then use Putty to access a terminal window in Ubuntu that you can cut and paste into.

Q3. What version of OnlyOffice Document server am I on?

From the Ubuntu VM terminal:

Q4. I can see previews of photos in Nextcloud, but not of videos. 

The Preview Generator has to be set up (non-trivial). The following is an adaptation of these instructions for FreeNAS.

Step 1: Install the Preview Generator app in Nextcloud

Steps that follow should be executed in the Nextcloud jail.

Step 2: Install ffmpeg

pkg install ffmpeg

Step 3: Add preview providers

Append to /var/www/nextcloud/config/config.php

'enable_previews' => true,
'enabledPreviewProviders' =>
 array (
    0 => 'OC\\Preview\\TXT',
    1 => 'OC\\Preview\\MarkDown',
    2 => 'OC\\Preview\\OpenDocument',
    3 => 'OC\\Preview\\PDF',
    4 => 'OC\\Preview\\MSOffice2003',
    5 => 'OC\\Preview\\MSOfficeDoc',
    6 => 'OC\\Preview\\PDF',
    7 => 'OC\\Preview\\Image',
    8 => 'OC\\Preview\\Photoshop',
    9 => 'OC\\Preview\\TIFF',
   10 => 'OC\\Preview\\SVG',
   11 => 'OC\\Preview\\Font',
   12 => 'OC\\Preview\\MP3',
   13 => 'OC\\Preview\\Movie',
   14 => 'OC\\Preview\\MKV',
   15 => 'OC\\Preview\\MP4',
   16 => 'OC\\Preview\\AVI',
 ),

Step 4: First Run

sudo -u www php occ preview:generate-all -vvv

Step 5: Add Cron Job

crontab -u www -e

Pre-generate previews every 10 mins.

*/10 * * * * /usr/local/bin/php /usr/local/www/nextcloud/occ preview:pre-generate -vvv

To list Cron jobs:

crontab -u www -l

To check the Cron log:

cat /var/log/cron

Q5. I would like to mount external SMB storage from within Nextcloud. I see a message about smbclient not being installed.

From the Nextcloud jail:

pkg install php73-pecl-smbclient

Restart the Nextcloud jail for this to take effect.

Edit 25/5/2020: NC 18.0.4 bug External Storage – Internal Server Error

References

1. Nextcloud and OnlyOffice Integration
2. Redirecting bug since 15.0.2
3. How to copy & paste in PROXMOX terminals?
4. Nextcloud: Install Preview Generator