Collabora - Nextcloud: Wopi problem

Support apps
, ,
1

What app is this about, and its version: Nextcloud 32.0.6, Collabora 25.04.9.1~ynh2
What YunoHost version are you running: 12.1.39
What type of hardware are you using: Old laptop or computer

Describe your issue

After the last Collabora+Nextcloud update I get:
Unauthorised WOPI host. Please try again later and report to your administrator if the issue persists, whenever I try to open a document from within Nextcloud.

I have put ::1 into the Wopi access list in Nextcloud as one older forum post suggested but no dice.

Thanks for any help.

Share relevant logs or error messages

Error:
Unauthorised WOPI host. Please try again later and report to your administrator if the issue persists.

Nextcloud logs say:

DbalException An exception occurred while executing a query: SQLSTATE\[01000\]: Warning: 1265 Data truncated for column 'version' at row 1
2

Hello

Can you try with your full IPv6 address instead of ::1 ?

3

I tried: 0:0:0:0:0:0:0:1

Didn’t work.

4

no, put your 2001:0000:xxxx ipv6

5

I tried my proper ipv6 for the server 2a02.xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxx

Didn’t work either

6

and if you put your ipv4 address?

7

Unfortunaltely no. Global and local ipv4 do not work.

8

Try without wopi hosts in the list, then restart coolwsd and clear browser cookies.
Let us know…

10

Alright, got it sorted. It wasn’t collabora it was nextcloud. The last update apparently did mess up the database a bit. The Nextcloud log showed:
nextcloud log: DbalException An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘version’ at row 1
Uncaught error: An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘version’ at row 1

So the he database is operating in strict mode and has rejected an entry because the data exceeds the defined length of the version column.
To fix that you have to enter Mysql. You get the user+password from nextcloud’s config.php file.

Login: mysql -u nextcloud -p nextcloud

Find the correct table:
SELECT TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = ‘version’
AND TABLE_SCHEMA = DATABASE();

Check data type:
DESCRIBE oc_richdocuments_wopi;

Backup:
CREATE TABLE oc_richdocuments_wopi_bak AS SELECT * FROM oc_richdocuments_wopi;

Modify:
ALTER TABLE oc_richdocuments_wopi MODIFY version varchar(255) DEFAULT NULL;

Confirm:
DESCRIBE oc_richdocuments_wopi;

Exit Mysql and restart:
sudo systemctl restart nginx
sudo systemctl restart coolwsd

11

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.