All files invisibe using the App

hosting

#1

Hi all,

I am having issues with my OwnCloud instance:
I can see all the files fine via browser, and very unreliably when using the app.

  • Browsers work fine
  • iOS and Android Apps show empty folders (very very often)
  • Official Android and forked Android App show this behaviour
  • All shares are affected

Using the exact same devices, but using the built-in browser instead of the app everything works fine.

  • The OwnCloud instance runs on 10.0.6 and is hosted on a Debian 8.7 Server
  • The users authenticate agains a Windows Active Directory
  • Files are accessed by using an external share

What could be causing this?

Here are two excerpts from the log file:
Excerpt 1

{"reqId":"NF3Hqw9VfKcchFb90Bxq","remoteAddr":"ext_ip_server","app":"webdav",
"message":"Exception: {\"Message\":\"HTTP\\\/1.1 503 Storage not available\",
\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\ServiceUnavailable\",\"Code\":0,\"Trace\":\"#0
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(903): 
 OCA\\\\DAV\\\\Connector\\\\Sabre\\\\ObjectTree->getNodeForPath('Folder_Name')\\n#1 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(334): 
 Sabre\\\\DAV\\\\Server->getPropertiesForPath('Folder_Name', Array, 1)\\n#2
 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#3
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#4
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:PROPFIND', Array)\\n#5
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#6
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(57): Sabre\\\\DAV\\\\Server->exec()\\n#7
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/remote.php(164): require_once('\\\/var\\\/www\\\/ownclo...')\\n#8
 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/ObjectTree.php\",\"Line\":159,\"User\":\"administrator\"}","level":4,"time":"2017-03-01T13:29:36+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/Folder_Name","user":"administrator"}

Excerpt 2

 {"reqId":"CErBtgN5rUCYiBfWoROs","remoteAddr":"ext_ip_server","app":"files_external",
 "message":"Exception: {\"Exception\":\"OCP\\\\Files\\\\StorageNotAvailableException\",\"Message\":\"Invalid login\",\"Code\":0,\"Trace\":\"#0
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/Lib\\\/Storage\\\/SMB.php(279): OCA\\\\Files_External\\\\Lib\\\\Storage\\\\SMB->getFileInfo('')\\n#1
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(436): OCA\\\\Files_External\\\\Lib\\\\Storage\\\\SMB->stat('')\\n#2
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/Lib\\\/Storage\\\/SMB.php(616): OC\\\\Files\\\\Storage\\\\Common->test()\\n#3
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/config.php(231): OCA\\\\Files_External\\\\Lib\\\\Storage\\\\SMB->test(false, false)\\n#4
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/Controller\\\/StoragesController.php(255): OC_Mount_Config::getBackendStatus('\\\\\\\\OCA\\\\\\\\Files_Exte...', Array, false, false)\\n#5
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/Controller\\\/UserGlobalStoragesController.php(119): OCA\\\\Files_External\\\\Controller\\\\StoragesController->updateStorageStatus(Object(OCA\\\\Files_External\\\\Lib\\\\StorageConfig), false)\\n#6
 [internal function]: OCA\\\\Files_External\\\\Controller\\\\UserGlobalStoragesController->show(1, false)\\n#7
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(159): call_user_func_array(Array, Array)\\n#8
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(89): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_External\\\\Controller\\\\UserGlobalStoragesController), 'show')\\n#9
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/AppFramework\\\/App.php(99): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_External\\\\Controller\\\\UserGlobalStoragesController), 'show')\\n#10
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(46): OC\\\\AppFramework\\\\App::main('UserGlobalStora...', 'show', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#11
 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#12
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/private\\\/Route\\\/Router.php(280): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#13
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/lib\\\/base.php(891): OC\\\\Route\\\\Router->match('\\\/apps\\\/files_ext...')\\n#14
 \\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/index.php(54): OC::handleRequest()\\n#15
 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud.instance.tld\\\/htdocs\\\/apps\\\/files_external\\\/lib\\\/Lib\\\/Storage\\\/SMB.php\",\"Line\":172}","level":3,"time":"2017-03-01T13:29:44+00:00","method":"GET","url":"\/index.php\/apps\/files_external\/userglobalstorages\/1?testOnly=false","user":"administrator"}

#2

Hi,

it looks like owncloud has issues accessing the external storage. What kind of storage are you using and how is it configured?


#3

Hi,

I am using a Windows W2K12R2 fileserver that hosts the shares.

OwnCloud is configured as follows (I try to explain it as detailed but short as I can)

  • SMB / CIFS
  • Authenfication by username and password
  • IP and Sharename(s) of the remote fileserver

The shares are mounted by an dedicated user, one for each share respectively:

  • Share 1 is mounted by user owncloud_1
  • Share 2 is mounted by user owncloud_2
  • Share 3 is mounted by user owncloud_3
    ..

and so on and so forth.

  • The Shares are made accessible for a user group defined in OwnCloud
  • The OwnCloud groups are populated with users from the ActiveDirectory

One share however is configured unlke the others:
We provide the users that log onto the OwnCloud their personal share , which the same fileserver provides
Here the configuration is as follows:

  • Foldername: Homes
  • SMB / CIFS
  • Store credentials in session
  • IP of the fileserver /$user

This share is (according to the customer) the ONLY directory that does not have the issues of not displaying files.
All of the other shares do have this issue.

I hope I could make clear, what my coniguration looks like.

Regards


#4

Hi,
in the meantime I found out, that when I disable the crontab entry added by OwnCloud everything is smooth and works as it should.

So I presume that one of these entries in the oc_jobs table is causing the errors the end users experience.

  • How can I disable jobs in this table?
  • Which of these jobs may cause my errors?
  • How can I delete jobs in that table?

    mysql> SELECT * FROM oc_jobs;
    +-----+---------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+------------+--------------+-------------+--------------------+
    | id | class | argument | last_run | last_checked | reserved_at | execution_duration |
    +-----+---------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+------------+--------------+-------------+--------------------+
    | 1 | OCA\UpdateNotification\Notification\BackgroundJob | null | 1520969403 | 1521027904 | 0 | 6 |
    | 2 | OCA\Activity\BackgroundJob\EmailNotification | null | 1517220003 | 1520990103 | 1520990103 | 0 |
    | 3 | OCA\Activity\BackgroundJob\ExpireActivities | null | 1517135401 | 1520991902 | 1520991902 | 0 |
    | 4 | OCA\Files\BackgroundJob\ScanFiles | null | 1521027902 | 1521027902 | 0 | 2 |
    | 5 | OCA\Files\BackgroundJob\DeleteOrphanedItems | null | 1521027004 | 1521027904 | 0 | 0 |
    | 6 | OCA\Files\BackgroundJob\CleanupFileLocks | null | 1521027904 | 1521027904 | 0 | 0 |
    | 7 | OCA\Files_Trashbin\BackgroundJob\ExpireTrash | null | 1521027904 | 1521027904 | 0 | 0 |
    | 8 | OCA\Files_Sharing\DeleteOrphanedSharesJob | null | 1521027004 | 1521027904 | 0 | 0 |
    | 9 | OCA\Files_Sharing\ExpireSharesJob | null | 1520982904 | 1521027904 | 0 | 0 |
    | 10 | OCA\DAV\CardDAV\SyncJob | null | 1520982904 | 1521027904 | 0 | 0 |
    | 11 | OCA\Files_Versions\BackgroundJob\ExpireVersions | null | 1521027904 | 1521027904 | 0 | 0 |
    | 12 | OCA\Federation\SyncJob | null | 1520983804 | 1521027904 | 0 | 0 |
    | 13 | \OC\Authentication\Token\DefaultTokenCleanupJob | null | 1521027904 | 1521027904 | 0 | 0 |
    | 18 | OCA\User_LDAP\Jobs\UpdateGroups | null | 1521027004 | 1521027904 | 0 | 0 |
    | 19 | OCA\User_LDAP\Jobs\CleanUp | null | 1505204902 | 1521021603 | 1521021603 | -1 |
    | 158 | OCA\UpdateNotification\ResetTokenBackgroundJob | null | 1521027904 | 1521027904 | 0 | 0 |
    | 611 | OCA\Market\CheckUpdateBackgroundJob | null | 1520983804 | 1521027904 | 0 | 30 |

Thanks for any input / insight on this matter.
Regards