Collabora Office only working for admin user (ldap related?)

ℹ️ Support 📄 Collabora
1

Hi there,
I just installed Collabora/code as detailed in the Nextcloud manual (and also detailed on linuxbabe.com). Everything seemed to be working perfectly from the first moment, but apparently it doesn’t work if you use it as one of the ‘regular users’. It’s working for the admin user.

Probably related: my users are LDAP users. Could this be the cause?

Nextcloud log:
Exception:
{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An
exception occurred while executing 'INSERT INTO
"oc_richdocuments_wopi” (“owner_uid”, “editor_uid”, “fileid”,
“version”, “path”, “canwrite”, “server_host”, “token”,
“expiry”)\n\t\t\tVALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params
[“admin”, “vvanhoutte”, “3300”, “0”,
"\/Club\/ComEvent\/20161001 -
Gouverneursbier\/bestelformulier_v3.odt", false,
“https:\/\/cloud..be”,
“tlZxrOwfqlr1f0t8wkWHsxwed2QTIoHH”, 1478772707]:\n\nSQLSTATE[22P02]:
Invalid text representation: 7 ERROR: invalid input syntax for type
boolean: “”",“Code”:0,“Trace”:"#0
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116):

Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver->convertException('An
 exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 
\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(175):
 
Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver),
 Object(Doctrine\\DBAL\\Driver\\PDOException), 'INSERT INTO \"oc...', 
Array)\n#2 \/var\/www\/nextcloud\/apps\/richdocuments\/lib\/db.php(202):
 Doctrine\\DBAL\\Statement->execute(Array)\n#3 
\/var\/www\/nextcloud\/apps\/richdocuments\/lib\/db.php(37): 
OCA\\Richdocuments\\Db->execute('INSERT INTO `*P...')\n#4 
\/var\/www\/nextcloud\/apps\/richdocuments\/lib\/db\/wopi.php(88): 
OCA\\Richdocuments\\Db->insert()\n#5 
\/var\/www\/nextcloud\/apps\/richdocuments\/controller\/documentcontroller.php(507):
 OCA\\Richdocuments\\Db\\Wopi->generateFileToken('3300', '0', false, 
'https:\/\/cloud.l...')\n#6 [internal function]: 
OCA\\Richdocuments\\Controller\\DocumentController->wopiGetToken('3300')\n#7
 
\/var\/www\/nextcloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(160):
 call_user_func_array(Array, Array)\n#8 
\/var\/www\/nextcloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(90):
 
OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\Richdocuments\\Controller\\DocumentController),
 'wopiGetToken')\n#9 
\/var\/www\/nextcloud\/lib\/private\/AppFramework\/App.php(111): 
OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\Richdocuments\\Controller\\DocumentController),
 'wopiGetToken')\n#10 
\/var\/www\/nextcloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47):
 OC\\AppFramework\\App::main('DocumentControl...', 'wopiGetToken', 
Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\n#11 
[internal function]: 
OC\\AppFramework\\Routing\\RouteActionHandler->__invoke(Array)\n#12 
\/var\/www\/nextcloud\/lib\/private\/Route\/Router.php(293): 
call_user_func(Object(OC\\AppFramework\\Routing\\RouteActionHandler), 
Array)\n#13 \/var\/www\/nextcloud\/lib\/base.php(983): 
OC\\Route\\Router->match('\/apps\/richdocum...')\n#14 
\/var\/www\/nextcloud\/index.php(48): OC::handleRequest()\n#15 
{main}","File":"\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractPostgreSQLDriver.php","Line":91}
2

I noticed that I did not describe the issue itself: I get to see all documents, but when I click one to open, the application opens, but the icon keeps spinning forever and the document never opens.