Red Square for local storage

marlissmatic · November 29, 2019, 1:27am

So i’m trying to either add a folder, or extend one of the current folders (documents/movies/photos) to add 2TB of storage for owncloud. I used this as a reference, and built this:

When I go to add the local folder from the drop down, I get a Red Square instead of the green circle and that folder is not accessible. I’ve been up and down the web for this, and nobody seems to have a straight answer. The perms on that folder are r/w/x, and I assume the VirtualBox appliance is using ‘root’ to run the actual instance, because there are no other users on that box. from where i’m sitting it should be up and ready to go, but it isn’t. Does anyone have any experience with this?

Steps to reproduce

add a 2TB mount on RHEL
adjust the config.php for the local storage option
attempt to create a local storage folder

Expected behaviour

Local Storage should be available.

Actual behaviour

Red Square next to the storage option, and it’s unavailable

Server configuration

RHEL:

ownCloud Version = 10.2.1.4

The is the owncloud appliace for VirtualBox:

<?php
$CONFIG = array (
  'apps_paths' =>
  array (
    0 =>
    array (
      'path' => '/var/www/owncloud/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 =>
    array (
      'path' => '/var/www/owncloud/custom',
      'url' => '/custom',
      'writable' => true,
    ),
  ),
  'trusted_domains' =>
  array (
    0 => 'localhost',
  ),
  'datadirectory' => '/var/lib/univention-appcenter/apps/owncloud/data/files',
  'dbtype' => 'mysql',
  'dbhost' => '172.17.42.1',
  'dbname' => 'owncloud',
  'dbuser' => 'owncloud',
  'dbpassword' =>
  'dbtableprefix' => 'oc_',
  'log_type' => 'owncloud',
  'supportedDatabases' =>
  array (
    0 => 'sqlite',
    1 => 'mysql',
    2 => 'pgsql',
  ),
  'files_external_allow_create_new_local' => 'true',
  'upgrade.disable-web' => true,
  'default_language' => 'en',
  'overwrite.cli.url' => ,
  'htaccess.RewriteBase' => '/owncloud',
  'logfile' => '/var/lib/univention-appcenter/apps/owncloud/data/files/owncloud.log',
  'loglevel' => '3',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'mysql.utf8mb4' => true,
  'filelocking.enabled' => true,
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => 'redis',
    'port' => '6379',
  ),
  'passwordsalt' => '
  'secret' => 
  'version' => '10.2.1.4',
  'logtimezone' => 'UTC',
  'installed' => true,
  'instanceid' => 
  'ldapIgnoreNamingRules' => false,
  'log_rotate_size' => 104857600,
  'onlyoffice' => array ('verify_peer_off' => TRUE),
);

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.


**local storage** .

**Are you using encryption:** no

**Are you using an external user-backend, if yes which one:** no.

Client configuration

chrome:

windows 10

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

{"reqId":"QuI7BMRMusWQtrrdzfQN","level":3,"time":"2019-11-28T03:20:27+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"--","url":"--","message":"User backend OC\\User\\Database is returning home: \/var\/lib\/univention-appcenter\/apps\/owncloud\/data\/files\/owncloud for user: owncloud which differs from existing value: "}
{"reqId":"ZXzgkNOotpoWOUAsShx6","level":3,"time":"2019-11-28T03:21:04+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"OCP\\\\AppFramework\\\\QueryException\",\"Message\":\"Could not resolve OCA\\\\User_LDAP\\\\Jobs\\\\UpdateGroups! Class OCA\\\\User_LDAP\\\\Jobs\\\\UpdateGroups does not exist\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Utility\\\/SimpleContainer.php(110): OC\\\\AppFramework\\\\Utility\\\\SimpleContainer->resolve('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/ServerContainer.php(86): OC\\\\AppFramework\\\\Utility\\\\SimpleContainer->query('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/JobList.php(253): OC\\\\ServerContainer->query('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/JobList.php(209): OC\\\\BackgroundJob\\\\JobList->buildJob(Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/cron.php(114): OC\\\\BackgroundJob\\\\JobList->getNext()\\n#5 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Utility\\\/SimpleContainer.php\",\"Line\":96}"}
{"reqId":"lfrSP2y1fOSO3IdO66p0","level":3,"time":"2019-11-28T03:44:35+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"no app in context","method":"POST","url":"\/owncloud\/settings\/users\/users","message":"User backend OC\\User\\Database is returning home: \/var\/lib\/univention-appcenter\/apps\/owncloud\/data\/files\/tmarlette for user: tmarlette which differs from existing value: "}
{"reqId":"lfrSP2y1fOSO3IdO66p0","level":3,"time":"2019-11-28T03:44:35+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"settings","method":"POST","url":"\/owncloud\/settings\/users\/users","message":"Can't send new user mail to dyermakerii@gmail.com: Expected response code 220 but got an empty response"}
{"reqId":"Sc1TSMzEbqwpwOrjhZGf","level":3,"time":"2019-11-28T03:56:58+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"POST","url":"\/owncloud\/apps\/files_external\/globalstorages","message":"stat(): stat failed for \/data\/sda\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"QJcB6tZjGYgXoAzhmqat","level":3,"time":"2019-11-28T03:57:10+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"PUT","url":"\/owncloud\/apps\/files_external\/globalstorages\/1","message":"stat(): stat failed for \/data\/sda-ownclloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"LPliysW7kVO40EVBI4ZS","level":3,"time":"2019-11-28T03:57:12+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"PUT","url":"\/owncloud\/apps\/files_external\/globalstorages\/1","message":"stat(): stat failed for \/data\/sda-ownclloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"wUYQllbmni5AXyDLQevZ","level":3,"time":"2019-11-28T03:57:14+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"PUT","url":"\/owncloud\/apps\/files_external\/globalstorages\/1","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"4IMYFxknAjvPuYWmjlHL","level":3,"time":"2019-11-28T03:57:29+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/files_external\/userglobalstorages\/1?testOnly=false","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"RxHyGHkgv95vmLqlemKd","level":3,"time":"2019-11-28T03:57:32+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"GET","url":"\/owncloud\/apps\/files_external\/globalstorages\/1?testOnly=true","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"jsgRZ7YxVNBc2b460ti9","level":3,"time":"2019-11-28T04:07:51+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/files_external\/userglobalstorages\/1?testOnly=false","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"KrouLtP7fIdzrRth64ea","level":3,"time":"2019-11-28T23:54:02+00:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"OCP\\\\AppFramework\\\\QueryException\",\"Message\":\"Could not resolve OCA\\\\User_LDAP\\\\Jobs\\\\UpdateGroups! Class OCA\\\\User_LDAP\\\\Jobs\\\\UpdateGroups does not exist\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Utility\\\/SimpleContainer.php(110): OC\\\\AppFramework\\\\Utility\\\\SimpleContainer->resolve('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#1 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/ServerContainer.php(86): OC\\\\AppFramework\\\\Utility\\\\SimpleContainer->query('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#2 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/JobList.php(253): OC\\\\ServerContainer->query('OCA\\\\\\\\User_LDAP\\\\\\\\J...')\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/BackgroundJob\\\/JobList.php(209): OC\\\\BackgroundJob\\\\JobList->buildJob(Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/cron.php(114): OC\\\\BackgroundJob\\\\JobList->getNext()\\n#5 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Utility\\\/SimpleContainer.php\",\"Line\":96}"}
{"reqId":"CFu6aE1s8aax1GoXLgkb","level":3,"time":"2019-11-28T23:57:08+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/files_external\/userglobalstorages\/1?testOnly=false","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}
{"reqId":"gjDmq3EBHshJlYBKJyTO","level":3,"time":"2019-11-28T23:57:31+00:00","remoteAddr":"172.17.42.1","user":"Administrator","app":"PHP","method":"GET","url":"\/owncloud\/apps\/files_external\/globalstorages\/1?testOnly=true","message":"stat(): stat failed for \/data\/sda-owncloud\/ at \/var\/www\/owncloud\/lib\/private\/Files\/Storage\/Local.php#135"}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

eneubauer · November 29, 2019, 9:48am

I’m confused, RHEL or Appliance? One or the other, because the appliance is based on Univention Corporate Server (UCS).

I’m not an appliance expert, but I know that ownCloud is running in docker inside there. So you would have to find the docker configuration in the UCS and add your locally mounted filesystem to the container.
Not sure where exactly you would find this, perhaps the appliance experts could chime in here. @dmitry ?

marlissmatic · November 30, 2019, 12:55am

It is the appliance, I just tried to use RHEL underneath. Pretty sure the appliance undid it for me though and used debian with docker.

tom42 · December 1, 2019, 12:36pm

Hey,

this sounds to me like some permission problems where the user running ownCloud isn’t allowed to access the external storage / mount point.